View: JL_ZZ_AR_TX_CAT_DTL_V

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

View Text

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

Columns