SQL to match Auto-Created PO Lines with Source Requisitions
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