FND Design Data [Home] [Help]

View: AX_AP_TAXABLE_V

Product: AX - Global Accounting Engine
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT AID2.INVOICE_ID
, AID2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE
, SUM(AID.AMOUNT) L_TAXABLE_AMOUNT
, SUM(NVL(AID.BASE_AMOUNT
, AID.AMOUNT)) L_TAXABLE_BASE_AMOUNT
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_CHRG_ALLOCATIONS_ALL ACA
, AP_INVOICE_DISTRIBUTIONS_ALL AID2
WHERE AID.INVOICE_DISTRIBUTION_ID = ACA.ITEM_DIST_ID
AND ACA.CHARGE_DIST_ID = AID2.INVOICE_DISTRIBUTION_ID
AND AID2.LINE_TYPE_LOOKUP_CODE IN ('TAX'
, 'AWT') GROUP BY AID2.INVOICE_ID
, AID2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE

Columns

Name
INVOICE_ID
INVOICE_DISTRIBUTION_ID
TAX_CODE_ID
VAT_CODE
L_TAXABLE_AMOUNT
L_TAXABLE_BASE_AMOUNT