Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | This view lists the taxes on a standalone AP Invoice |
Implementation/DBA Data: | APPS.JAI_AP_STANDALONE_TAXES_V |
SELECT MAX(DOC_TAX_ID) DOC_TAX_ID
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, SUM(TAX_AMT) TAX_AMT
, SUM(FUNC_TAX_AMT) FUNC_TAX_AMT
, MAX(MODVAT_FLAG) MODVAT_FLAG
, TAX_CATEGORY_ID
, SOURCE_DOC_TYPE
, SOURCE_DOC_ID
, MAX(SOURCE_DOC_LINE_ID) SOURCE_DOC_LINE_ID
, SOURCE_TABLE_NAME
, TAX_MODIFIED_BY
, ADHOC_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_DOC_PARENT_LINE_NO
FROM JAI_CMN_DOCUMENT_TAXES
WHERE SOURCE_DOC_TYPE = 'STANDALONE_INVOICE' GROUP BY TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, TAX_CATEGORY_ID
, SOURCE_DOC_TYPE
, SOURCE_DOC_ID
, SOURCE_TABLE_NAME
, TAX_MODIFIED_BY
, ADHOC_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_DOC_PARENT_LINE_NO