View: JL_ZZ_AR_TX_FSC_CLS_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_ZZ_AR_TX_FSC_CLS_V

View Text

SELECT FCL.ROWID
, FCL.FSC_CLS_ID
, FCL.FISCAL_CLASSIFICATION_CODE
, FCL.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, FCL.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, FCL.BASE_RATE
, FCL.START_DATE_ACTIVE
, FCL.END_DATE_ACTIVE
, FCL.ENABLED_FLAG
, FCL.ORG_ID
, FCL.LAST_UPDATED_BY
, FCL.LAST_UPDATE_DATE
, FCL.LAST_UPDATE_LOGIN
, FCL.CREATION_DATE
, FCL.CREATED_BY
, FCL.ATTRIBUTE_CATEGORY
, FCL.ATTRIBUTE1
, FCL.ATTRIBUTE2
, FCL.ATTRIBUTE3
, FCL.ATTRIBUTE4
, FCL.ATTRIBUTE5
, FCL.ATTRIBUTE6
, FCL.ATTRIBUTE7
, FCL.ATTRIBUTE8
, FCL.ATTRIBUTE9
, FCL.ATTRIBUTE10
, FCL.ATTRIBUTE11
, FCL.ATTRIBUTE12
, FCL.ATTRIBUTE13
, FCL.ATTRIBUTE14
, FCL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_FSC_CLS FCL
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE FCL.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND FCL.TAX_CODE IS NOT NULL
AND FCL.TAX_CODE = ART.TAX_CODE
AND NVL(ART.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND NVL(FCL.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND FCL.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND FCL.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND FCL.END_DATE_ACTIVE >= ART.START_DATE
AND NOT EXISTS (SELECT 1
FROM AR_VAT_TAX ART1
WHERE ART1.TAX_CODE = ART.TAX_CODE
AND ART1.SET_OF_BOOKS_ID = ART.SET_OF_BOOKS_ID
AND NVL(ART1.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART1.TAX_CLASS
, 'O') = 'O'
AND NVL(ART1.ENABLED_FLAG
, 'Y') = 'Y'
AND ART1.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= FCL.END_DATE_ACTIVE) UNION SELECT FCL.ROWID
, FCL.FSC_CLS_ID
, FCL.FISCAL_CLASSIFICATION_CODE
, FCL.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, FCL.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, FCL.BASE_RATE
, FCL.START_DATE_ACTIVE
, FCL.END_DATE_ACTIVE
, FCL.ENABLED_FLAG
, FCL.ORG_ID
, FCL.LAST_UPDATED_BY
, FCL.LAST_UPDATE_DATE
, FCL.LAST_UPDATE_LOGIN
, FCL.CREATION_DATE
, FCL.CREATED_BY
, FCL.ATTRIBUTE_CATEGORY
, FCL.ATTRIBUTE1
, FCL.ATTRIBUTE2
, FCL.ATTRIBUTE3
, FCL.ATTRIBUTE4
, FCL.ATTRIBUTE5
, FCL.ATTRIBUTE6
, FCL.ATTRIBUTE7
, FCL.ATTRIBUTE8
, FCL.ATTRIBUTE9
, FCL.ATTRIBUTE10
, FCL.ATTRIBUTE11
, FCL.ATTRIBUTE12
, FCL.ATTRIBUTE13
, FCL.ATTRIBUTE14
, FCL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_FSC_CLS FCL
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE FCL.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND FCL.TAX_CODE IS NULL
AND NVL(FCL.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns