DBA Data[Home] [Help]

VIEW: APPS.AR_XML_PO_INFO_V

Source

View Text - Preformatted

SELECT CUSTOMER_TRX_ID, PURCHASE_ORDER, PURCHASE_ORDER_REVISION, PURCHASE_ORDER_DATE, ar_xml_view_functions.po_function1(customer_trx_id) USER1, ar_xml_view_functions.po_function2(customer_trx_id) USER2, ar_xml_view_functions.po_function3(customer_trx_id) USER3, ar_xml_view_functions.po_function4(customer_trx_id) USER4, ar_xml_view_functions.po_function5(customer_trx_id) USER5 FROM RA_CUSTOMER_TRX WHERE PURCHASE_ORDER is NOT NULL
View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID
, PURCHASE_ORDER
, PURCHASE_ORDER_REVISION
, PURCHASE_ORDER_DATE
, AR_XML_VIEW_FUNCTIONS.PO_FUNCTION1(CUSTOMER_TRX_ID) USER1
, AR_XML_VIEW_FUNCTIONS.PO_FUNCTION2(CUSTOMER_TRX_ID) USER2
, AR_XML_VIEW_FUNCTIONS.PO_FUNCTION3(CUSTOMER_TRX_ID) USER3
, AR_XML_VIEW_FUNCTIONS.PO_FUNCTION4(CUSTOMER_TRX_ID) USER4
, AR_XML_VIEW_FUNCTIONS.PO_FUNCTION5(CUSTOMER_TRX_ID) USER5
FROM RA_CUSTOMER_TRX
WHERE PURCHASE_ORDER IS NOT NULL