Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | View to fetch Taxes attached to a Standalone AP Invoice |
Implementation/DBA Data: | APPS.JAI_AP_TAXES_V |
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