Oracle EBS SQL Query - To Get the Object Source Code

 select dbms_metadata.get_ddl('VIEW','PO_LINES_INQ_V','APPS') from dual;

Oracle Fusion - SQL Query to check error message while Change Purchase Order Failed while send for and approval

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