Procurement - EBS (MOSC)

MOSC Banner

SQL to match Auto-Created PO Lines with Source Requisitions

edited Aug 27, 2016 1:00AM in Procurement - EBS (MOSC) 7 commentsAnswered ✓

We run 'Auto-Release Planned Orders' from our ASCP plan, which will release Purchase Requisitions into EBS source side instance.

I could see the Requisition counts in the log of 'Auto-Release Planned Orders' (Planning instance), and 'Requisition Import' (EBS source instance).

To see the list of Requisitions created (auto-released) today, I use the following SQL:

SELECT * FROM APPS.PO_REQUISITION_HEADERS_ALL

WHERE CREATION_DATE >= TRUNC (SYSDATE)

AND INTERFACE_SOURCE_CODE = 'MSC'

AND CREATED_BY = :User_ID;

These requisitions are converted into Standard Purchase Orders through auto-create.

Though the PO Lines have 'Source Document Number', I am not able to see the information in PO_LINES_ALL

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