Home » Applications » Oracle Fusion Apps & E-Business Suite » Where is the default item receiving subinventory stored? Which table? (Oracle Applications 11.5.9)
Where is the default item receiving subinventory stored? Which table? [message #287849] Thu, 13 December 2007 15:43 Go to next message
Ericle
Messages: 44
Registered: April 2006
Location: United States of America ...
Member
The field I'm talking about is found on the Receiving tab of the Organization Items form and it's called Receiving Subinventory. I just need to know exactly where that value is stored so I can pull it into a report.

Report message to a moderator

Re: Where is the default item receiving subinventory stored? Which table? [message #287994 is a reply to message #287849] Fri, 14 December 2007 04:47 Go to previous messageGo to next message
brightraj
Messages: 8
Registered: November 2007
Junior Member
Hi,

All the receiving information is stored in RCV_transactions table. u will find the sub-inv which received it also.

Report message to a moderator

Re: Where is the default item receiving subinventory stored? Which table? [message #562154 is a reply to message #287849] Sun, 29 July 2012 23:31 Go to previous message
zwhtony
Messages: 2
Registered: April 2007
Junior Member
select * from MTL_ITEM_SUB_DEFAULTS where default_type=2

Report message to a moderator

Previous Topic: Reopening a closed PO
Next Topic: Difference between multiple databases, multiple instances, and multiple installations?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 17:25:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.