View: JL_ZZ_AR_TX_NAT_RAT_V

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

View Text

SELECT TNR.ROWID ROW_ID
, TNR.TXN_NATURE_ID TXN_NATURE_ID
, TCAV.TAX_CATEG_ATTR_VAL_ID TAX_CATEG_ATTR_VAL_ID
, TCAV.TAX_CATEGORY_ID TAX_CATEGORY_ID
, TCAV.TAX_ATTRIBUTE_NAME TAX_ATTRIBUTE_NAME
, TCAV.TAX_ATTRIBUTE_VALUE TAX_ATTRIBUTE_VALUE
, TCAV.ATTR_VAL_DESC MEANING
, TNR.END_DATE_ACTIVE END_DATE_ACTIVE
, TNR.TAX_CODE TAX_CODE
, ART.DESCRIPTION TAX_DESCRIPTION
, ART.TAX_RATE TAX_RATE
, TNR.MIN_TAXABLE_BASIS MIN_TAXABLE_BASIS
, TNR.MIN_AMOUNT MIN_AMOUNT
, TNR.MIN_PERCENTAGE MIN_PERCENTAGE
, TNR.BASE_RATE BASE_RATE
, TNR.START_DATE_ACTIVE START_DATE_ACTIVE
, TNR.ORG_ID
, TNR.CREATION_DATE CREATION_DATE
, TNR.CREATED_BY CREATED_BY
, TNR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TNR.LAST_UPDATED_BY LAST_UPDATED_BY
, TNR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TNR.ATTRIBUTE_CATEGORY
, TNR.ATTRIBUTE1
, TNR.ATTRIBUTE2
, TNR.ATTRIBUTE3
, TNR.ATTRIBUTE4
, TNR.ATTRIBUTE5
, TNR.ATTRIBUTE6
, TNR.ATTRIBUTE7
, TNR.ATTRIBUTE8
, TNR.ATTRIBUTE9
, TNR.ATTRIBUTE10
, TNR.ATTRIBUTE11
, TNR.ATTRIBUTE12
, TNR.ATTRIBUTE13
, TNR.ATTRIBUTE14
, TNR.ATTRIBUTE15
FROM JL_ZZ_AR_TX_ATT_VAL_V TCAV
, JL_ZZ_AR_TX_NAT_RAT TNR
, AR_VAT_TAX_ALL ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TCAV.TAX_CATEG_ATTR_VAL_ID = TNR.TAX_CATEG_ATTR_VAL_ID
AND TCAV.TAX_ATTRIBUTE_TYPE = 'TRANSACTION_ATTRIBUTE'
AND TNR.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 NVL(ART.SET_OF_BOOKS_ID
, SYS.SET_OF_BOOKS_ID) = SYS.SET_OF_BOOKS_ID
AND TCAV.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TNR.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TNR.END_DATE_ACTIVE >= ART.START_DATE
AND NVL(TNR.ORG_ID
, -99) = NVL(TCAV.ORG_ID
, -99)
AND NVL(TNR.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TNR.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
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.TAX_TYPE = ART.TAX_TYPE
AND ART1.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= TNR.END_DATE_ACTIVE)

Columns