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.
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.
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
Previous Topic: Reopening a closed PO
Next Topic: Difference between multiple databases, multiple instances, and multiple installations?
Goto Forum:
  


Current Time: Fri Nov 28 10:29:00 CST 2014

Total time taken to generate the page: 0.10264 seconds