VIEW: APPS.AR_XML_INVOICE_TAX_V

Source

View Text - Preformatted

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_rate_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, zx_lines_v v WHERE l.line_type = 'TAX' and l.tax_line_id = v.tax_line_id and l.link_to_cust_trx_line_id is not null order by l.line_number

View Text - HTML Formatted

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_RATE_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
, ZX_LINES_V V
WHERE L.LINE_TYPE = 'TAX'
AND L.TAX_LINE_ID = V.TAX_LINE_ID
AND L.LINK_TO_CUST_TRX_LINE_ID IS NOT NULL ORDER BY L.LINE_NUMBER