View: JL_ZZ_AR_TX_EXC_CUS_V

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

View Text

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

Columns