VIEW: APPS.JAI_AP_TAXES_V

Source

View Text - Preformatted

SELECT SOURCE_DOC_ID invoice_id, SOURCE_DOC_PARENT_LINE_NO parent_line_number, TAX_LINE_NO, TAX_ID, TAX_TYPE, CURRENCY_CODE, TAX_RATE, QTY_RATE, UOM, TAX_AMT, MODVAT_FLAG, PRECEDENCE_1, PRECEDENCE_2, PRECEDENCE_3, PRECEDENCE_4, PRECEDENCE_5, PRECEDENCE_6, PRECEDENCE_7, PRECEDENCE_8, PRECEDENCE_9, PRECEDENCE_10 FROM JAI_AP_STANDALONE_TAXES_V UNION ALL SELECT invoice_id, parent_invoice_line_number parent_line_number, TAX_LINE_NO, TAX_ID, TAX_TYPE, CURRENCY currency_code, TAX_RATE, QTY_RATE, UOM, TAX_AMOUNT tax_amt, MODVAT_FLAG, PRECEDENCE_1, PRECEDENCE_2, PRECEDENCE_3, PRECEDENCE_4, PRECEDENCE_5, PRECEDENCE_6, PRECEDENCE_7, PRECEDENCE_8, PRECEDENCE_9, PRECEDENCE_10 FROM JAI_AP_MATCH_INV_TAX_V

View Text - HTML Formatted

SELECT SOURCE_DOC_ID INVOICE_ID
, SOURCE_DOC_PARENT_LINE_NO PARENT_LINE_NUMBER
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMT
, MODVAT_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
FROM JAI_AP_STANDALONE_TAXES_V UNION ALL SELECT INVOICE_ID
, PARENT_INVOICE_LINE_NUMBER PARENT_LINE_NUMBER
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMOUNT TAX_AMT
, MODVAT_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
FROM JAI_AP_MATCH_INV_TAX_V