Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | This view will be used to fetch the taxes for the invoices where are not Standalone invoices |
Implementation/DBA Data: | APPS.JAI_AP_MATCH_INV_TAX_V |
SELECT TAX_LINE.MATCH_TYPE
, TAX_LINE.INVOICE_ID
, TAX_LINE.PARENT_INVOICE_LINE_NUMBER
, TAX_LINE.TRANSACTION_ID
, TAX_LINE.TAX_LINE_NO
, TAX_LINE.TAX_ID
, TAX_LINE.TAX_TYPE
, TAX_LINE.PRECEDENCE_1
, TAX_LINE.PRECEDENCE_2
, TAX_LINE.PRECEDENCE_3
, TAX_LINE.PRECEDENCE_4
, TAX_LINE.PRECEDENCE_5
, TAX_LINE.PRECEDENCE_6
, TAX_LINE.PRECEDENCE_7
, TAX_LINE.PRECEDENCE_8
, TAX_LINE.PRECEDENCE_9
, TAX_LINE.PRECEDENCE_10
, TAX_LINE.CURRENCY
, TAX_LINE.TAX_RATE
, TAX_LINE.QTY_RATE
, TAX_LINE.UOM
, SUM(NVL(TAX_LINE.TAX_AMOUNT
, 0)) TAX_AMOUNT
, TAX_LINE.VENDOR_ID
, TAX_LINE.VENDOR_SITE_ID
, TAX_LINE.MODVAT_FLAG
FROM (SELECT 'ITEM_TO_PO' MATCH_TYPE
, B.INVOICE_ID
, B.PARENT_INVOICE_LINE_NUMBER
, A.LINE_LOCATION_ID TRANSACTION_ID
, A.TAX_LINE_NO
, A.TAX_ID
, A.TAX_TYPE
, A.PRECEDENCE_1
, A.PRECEDENCE_2
, A.PRECEDENCE_3
, A.PRECEDENCE_4
, A.PRECEDENCE_5
, A.PRECEDENCE_6
, A.PRECEDENCE_7
, A.PRECEDENCE_8
, A.PRECEDENCE_9
, A.PRECEDENCE_10
, A.CURRENCY
, A.TAX_RATE
, A.QTY_RATE
, A.UOM
, B.TAX_AMOUNT
, A.VENDOR_ID
, NULL VENDOR_SITE_ID
, A.MODVAT_FLAG
FROM JAI_PO_TAXES A
, JAI_AP_MATCH_INV_TAXES B
WHERE A.TAX_ID = B.TAX_ID
AND A.LINE_LOCATION_ID = B.LINE_LOCATION_ID
AND B.RCV_TRANSACTION_ID IS NULL UNION ALL SELECT 'ITEM_TO_RECEIPT' MATCH_TYPE
, B.INVOICE_ID
, B.PARENT_INVOICE_LINE_NUMBER
, A.TRANSACTION_ID
, A.TAX_LINE_NO
, A.TAX_ID
, A.TAX_TYPE
, A.PRECEDENCE_1
, A.PRECEDENCE_2
, A.PRECEDENCE_3
, A.PRECEDENCE_4
, A.PRECEDENCE_5
, A.PRECEDENCE_6
, A.PRECEDENCE_7
, A.PRECEDENCE_8
, A.PRECEDENCE_9
, A.PRECEDENCE_10
, A.CURRENCY
, A.TAX_RATE
, A.QTY_RATE
, A.UOM
, B.TAX_AMOUNT
, A.VENDOR_ID
, A.VENDOR_SITE_ID
, A.MODVAT_FLAG
FROM JAI_RCV_LINE_TAXES A
, JAI_AP_MATCH_INV_TAXES B
, RCV_TRANSACTIONS C
WHERE A.TAX_ID = B.TAX_ID
AND B.RCV_TRANSACTION_ID = C.TRANSACTION_ID
AND B.RCV_TRANSACTION_ID IS NOT NULL
AND A.SHIPMENT_LINE_ID = C.SHIPMENT_LINE_ID ) TAX_LINE GROUP BY TAX_LINE.MATCH_TYPE
, TAX_LINE.INVOICE_ID
, TAX_LINE.PARENT_INVOICE_LINE_NUMBER
, TAX_LINE.TRANSACTION_ID
, TAX_LINE.TAX_LINE_NO
, TAX_LINE.TAX_ID
, TAX_LINE.TAX_TYPE
, TAX_LINE.PRECEDENCE_1
, TAX_LINE.PRECEDENCE_2
, TAX_LINE.PRECEDENCE_3
, TAX_LINE.PRECEDENCE_4
, TAX_LINE.PRECEDENCE_5
, TAX_LINE.PRECEDENCE_6
, TAX_LINE.PRECEDENCE_7
, TAX_LINE.PRECEDENCE_8
, TAX_LINE.PRECEDENCE_9
, TAX_LINE.PRECEDENCE_10
, TAX_LINE.CURRENCY
, TAX_LINE.TAX_RATE
, TAX_LINE.QTY_RATE
, TAX_LINE.UOM
, TAX_LINE.VENDOR_ID
, TAX_LINE.VENDOR_SITE_ID
, TAX_LINE.MODVAT_FLAG