Supply Chain Management - PSFT (MOSC)

MOSC Banner

Tables behind the Item/Product availability detail page - ATP_DETAIL_INV

edited Jun 16, 2015 12:06PM in Supply Chain Management - PSFT (MOSC) 1 commentAnswered ✓


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)?

Navigation path:  Inventory > Manage Inventory > Review Inventory Balance Info > Item/Product Availability, then click the Detail button at left bottom corner.

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center