View: JL_ZZ_AR_TX_SCHEDULES_V

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

View Text

SELECT SCH.ROWID ROW_ID
, SCH.TAX_CATEG_SLAB_ID
, SCH.TAX_CATEGORY_ID
, SCH.END_DATE_ACTIVE
, SCH.MIN_TAXABLE_BASIS
, SCH.LAST_UPDATE_DATE
, SCH.LAST_UPDATED_BY
, SCH.MAX_TAXABLE_BASIS
, ART.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, SCH.START_DATE_ACTIVE
, SCH.ORG_ID
, SCH.LAST_UPDATE_LOGIN
, SCH.CREATION_DATE
, SCH.CREATED_BY
, SCH.ATTRIBUTE_CATEGORY
, SCH.ATTRIBUTE1
, SCH.ATTRIBUTE2
, SCH.ATTRIBUTE3
, SCH.ATTRIBUTE4
, SCH.ATTRIBUTE5
, SCH.ATTRIBUTE6
, SCH.ATTRIBUTE7
, SCH.ATTRIBUTE8
, SCH.ATTRIBUTE9
, SCH.ATTRIBUTE10
, SCH.ATTRIBUTE11
, SCH.ATTRIBUTE12
, SCH.ATTRIBUTE13
, SCH.ATTRIBUTE14
, SCH.ATTRIBUTE15
FROM JL_ZZ_AR_TX_SCHEDULES SCH
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE SCH.TAX_CODE IS NOT NULL
AND ART.TAX_CODE = SCH.TAX_CODE
AND SCH.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND SCH.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND SCH.END_DATE_ACTIVE >= ART.START_DATE
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(SCH.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(SCH.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99) UNION SELECT SCH.ROWID ROW_ID
, SCH.TAX_CATEG_SLAB_ID
, SCH.TAX_CATEGORY_ID
, SCH.END_DATE_ACTIVE
, SCH.MIN_TAXABLE_BASIS
, SCH.LAST_UPDATE_DATE
, SCH.LAST_UPDATED_BY
, SCH.MAX_TAXABLE_BASIS
, TO_CHAR(NULL) TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, SCH.START_DATE_ACTIVE
, SCH.ORG_ID
, SCH.LAST_UPDATE_LOGIN
, SCH.CREATION_DATE
, SCH.CREATED_BY
, SCH.ATTRIBUTE_CATEGORY
, SCH.ATTRIBUTE1
, SCH.ATTRIBUTE2
, SCH.ATTRIBUTE3
, SCH.ATTRIBUTE4
, SCH.ATTRIBUTE5
, SCH.ATTRIBUTE6
, SCH.ATTRIBUTE7
, SCH.ATTRIBUTE8
, SCH.ATTRIBUTE9
, SCH.ATTRIBUTE10
, SCH.ATTRIBUTE11
, SCH.ATTRIBUTE12
, SCH.ATTRIBUTE13
, SCH.ATTRIBUTE14
, SCH.ATTRIBUTE15
FROM JL_ZZ_AR_TX_SCHEDULES SCH
WHERE SCH.TAX_CODE IS NULL

Columns