Tables behind the Item/Product availability detail page - ATP_DETAIL_INV
Hello,
I would appreciate it so much if any one can tell me these?
1) Which tables are behind the Item/Product availability "Detail" page (ATP_DETAIL_INV)?
2) What the specific logic/conditions are used to derive the rows that display in the scroll?
I am unfamiliar with PeopleCode. So i wasn't able to get much by looking around the PeopleCodes of the component as attempting to find how the scroll is populated.
Backgroud - my users raised a ticket on an inventory item with an outstanding PO showing at this page; however at the receiving and putaway end, it has been stocked away and cleared out long time ago. The transactions are back to 2013. I need to fix up the data so that the PO is cleared from this page, and the quantity be cleared too. Otherwise the item cannot be picked up by replenishing process because of the quantiy being Outstanding.