[Home] [Help]
View: AR_XML_INVOICE_CHARGE_V
View Text
SELECT L.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, L.LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, L.EXTENDED_AMOUNT CHARGE_AMOUNT
, L.DESCRIPTION DESCRIPTION
, L.LINE_NUMBER LINE_NUMBER
, L.LINE_TYPE LINE_TYPE
, AR_XML_VIEW_FUNCTIONS.CHARGE_FUNCTION1(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.CHARGE_FUNCTION2(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.CHARGE_FUNCTION3(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.CHARGE_FUNCTION4(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.CHARGE_FUNCTION5(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER5
FROM RA_CUSTOMER_TRX_LINES L
WHERE L.LINE_TYPE NOT IN ('LINE'
, 'TAX') ORDER BY L.LINE_NUMBER
Columns
Name |
CUSTOMER_TRX_ID |
CUSTOMER_TRX_LINE_ID |
LINK_TO_CUST_TRX_LINE_ID |
CHARGE_AMOUNT |
DESCRIPTION |
LINE_NUMBER |
LINE_TYPE |
USER1 |
USER2 |
USER3 |
USER4 |
USER5 |