This content has been marked as final. Show 4 replies
You may find what you need in inv_tsf_item_ld_dm and/or inv_rcpts_item_ld_dm. (Using the RDW 13.1 datamodel on Oracle Support as a reference.)1 person found this helpful
The reserved quantity I would skip as a candidate for your business requirement.
If you want to know how this is 'trapped' (filled) in RDW, please lookup the RMS operations guide nr1 and/or study the RMS RETL extraction scripts.
Best regards, Erik Ykema
PS: the better forum for RDW related questions is the Oracle Retail forum at Retail This forum relates to the ORDM, which is not an Oracle Retail product (though of course of interest to retailers...)
Edited by: ErikYkema on Oct 27, 2010 7:56 AM
Thanks Erik !!
Just check these tables DWB_INV_CNTRL_DOC, DWB_INV_CNTRL_DOC_LI, these capture movement of inventory in and out of warehouse.
Edited by: user8745296 on Oct 28, 2010 4:03 AM
Please note that Dhrubo relates his question to the ORDW product, while the tables you mention are from ORDM.
Best regards, Erik