VIEW: APPS.JAI_AP_STANDALONE_TAXES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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