--SQL to Check PO Detail--
SELECT *
FROM FUSION.PO_HEADERS_ALL
WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER
--SQL to Check PO Version Details--
SELECT CO_NUM,
VERSION_ID
FROM FUSION.PO_VERSIONS
WHERE PO_HEADER_ID IN
(SELECT PO_HEADER_ID FROM FUSION.PO_HEADERS_ALL WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER
)
ORDER BY CREATION_DATE DESC
--SQL to Check PO Approval Error--
SELECT TEXT_LINE
FROM FUSION.PO_ONLINE_REPORT_TEXT
WHERE VERSION_ID = 300000225949043 --ENTER THE 1ST VERSION ID RECEIVED FROM ABOVE QUERY
ORDER BY CREATION_DATE DESC
No comments:
Post a Comment