View: AR_XML_INVOICE_TAX_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_INVOICE_TAX_V

View Text

SELECT 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 TAX_AMOUNT
, L.TAXABLE_AMOUNT TAXABLE_AMOUNT
, L.TAX_RATE TAX_RATE
, V.TAX_CODE TAX_CODE
, L.LINE_NUMBER LINE_NUMBER
, L.DESCRIPTION DESCRIPTION
, AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION1(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION2(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION3(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION4(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION5(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER5
FROM RA_CUSTOMER_TRX_LINES L
, AR_VAT_TAX V
WHERE L.LINE_TYPE = 'TAX'
AND L.VAT_TAX_ID = V.VAT_TAX_ID
AND L.LINK_TO_CUST_TRX_LINE_ID IS NOT NULL ORDER BY L.LINE_NUMBER

Columns