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