[Home] [Help]
View: AR_XML_SO_INFO_V
View Text
SELECT CUSTOMER_TRX_LINE_ID
, SALES_ORDER
, SALES_ORDER_REVISION
, SALES_ORDER_DATE
, SALES_ORDER_LINE
, AR_XML_VIEW_FUNCTIONS.SO_FUNCTION1(CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.SO_FUNCTION2(CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.SO_FUNCTION3(CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.SO_FUNCTION4(CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.SO_FUNCTION5(CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID) USER5 FROM RA_CUSTOMER_TRX_LINES
WHERE SALES_ORDER IS NOT NULL
Columns
Name |
CUSTOMER_TRX_LINE_ID |
SALES_ORDER |
SALES_ORDER_REVISION |
SALES_ORDER_DATE |
SALES_ORDER_LINE |
USER1 |
USER2 |
USER3 |
USER4 |
USER5 |