View: JL_ZZ_AR_TX_GROUPS_V

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

View Text

SELECT TGR.ROWID
, TGR.GROUP_TAX_ID
, TGR.TAX_CATEGORY_ID
, TGR.TAX_GROUP_RECORD_ID
, CAT.TAX_CATEGORY
, TGR.ESTABLISHMENT_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.ESTABLISHMENT_TYPE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, TGR.CONTRIBUTOR_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.CONTRIBUTOR_TYPE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, TGR.TRANSACTION_NATURE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.TRANSACTION_NATURE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, CAT.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING (CAT.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, CAT.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(CAT.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, CAT.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(CAT.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TGR.END_DATE_ACTIVE
, TGR.USE_TX_CATEG_THRESHOLDS
, TGR.LAST_UPDATE_DATE
, TGR.LAST_UPDATED_BY
, TGR.COMPOUND_PRECEDENCE
, TGR.MIN_AMOUNT
, TGR.MIN_TAXABLE_BASIS
, TGR.MIN_PERCENTAGE
, TGR.TAX_INCLUSIVE
, TGR.TRIBUTARY_SUBSTITUTION
, TGR.USED_TO_REDUCE
, TGR.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, TGR.BASE_RATE
, TGR.START_DATE_ACTIVE
, TGR.ORG_ID
, TGR.LAST_UPDATE_LOGIN
, TGR.CREATION_DATE
, TGR.CREATED_BY
, TGR.TAX_CATEGORY_TO_REDUCE_ID
, CAT_REDUCE.TAX_CATEGORY
, TGR.CALCULATE_IN_OE
, TGR.ATTRIBUTE_CATEGORY
, TGR.ATTRIBUTE1
, TGR.ATTRIBUTE2
, TGR.ATTRIBUTE3
, TGR.ATTRIBUTE4
, TGR.ATTRIBUTE5
, TGR.ATTRIBUTE6
, TGR.ATTRIBUTE7
, TGR.ATTRIBUTE8
, TGR.ATTRIBUTE9
, TGR.ATTRIBUTE10
, TGR.ATTRIBUTE11
, TGR.ATTRIBUTE12
, TGR.ATTRIBUTE13
, TGR.ATTRIBUTE14
, TGR.ATTRIBUTE15
FROM JL_ZZ_AR_TX_GROUPS TGR
, JL_ZZ_AR_TX_CATEG_ALL CAT_REDUCE
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TGR.TAX_CATEGORY_ID = CAT.TAX_CATEGORY_ID
AND CAT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND NVL(CAT_REDUCE.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TGR.TAX_CODE IS NOT NULL
AND TGR.TAX_CODE = ART.TAX_CODE
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND NVL(ART.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(TGR.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)
AND NVL(TGR.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TGR.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND TGR.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TGR.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TGR.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 <= TGR.END_DATE_ACTIVE)
AND TGR.TAX_CATEGORY_TO_REDUCE_ID = CAT_REDUCE.TAX_CATEGORY_ID(+) UNION SELECT TGR.ROWID
, TGR.GROUP_TAX_ID
, TGR.TAX_CATEGORY_ID
, TGR.TAX_GROUP_RECORD_ID
, CAT.TAX_CATEGORY
, TGR.ESTABLISHMENT_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.ESTABLISHMENT_TYPE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, TGR.CONTRIBUTOR_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.CONTRIBUTOR_TYPE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, TGR.TRANSACTION_NATURE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TGR.TRANSACTION_NATURE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80)
, CAT.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING (CAT.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, CAT.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(CAT.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, CAT.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(CAT.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TGR.END_DATE_ACTIVE
, TGR.USE_TX_CATEG_THRESHOLDS
, TGR.LAST_UPDATE_DATE
, TGR.LAST_UPDATED_BY
, TGR.COMPOUND_PRECEDENCE
, TGR.MIN_AMOUNT
, TGR.MIN_TAXABLE_BASIS
, TGR.MIN_PERCENTAGE
, TGR.TAX_INCLUSIVE
, TGR.TRIBUTARY_SUBSTITUTION
, TGR.USED_TO_REDUCE
, TGR.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, TGR.BASE_RATE
, TGR.START_DATE_ACTIVE
, TGR.ORG_ID
, TGR.LAST_UPDATE_LOGIN
, TGR.CREATION_DATE
, TGR.CREATED_BY
, TGR.TAX_CATEGORY_TO_REDUCE_ID
, CAT_REDUCE.TAX_CATEGORY
, TGR.CALCULATE_IN_OE
, TGR.ATTRIBUTE_CATEGORY
, TGR.ATTRIBUTE1
, TGR.ATTRIBUTE2
, TGR.ATTRIBUTE3
, TGR.ATTRIBUTE4
, TGR.ATTRIBUTE5
, TGR.ATTRIBUTE6
, TGR.ATTRIBUTE7
, TGR.ATTRIBUTE8
, TGR.ATTRIBUTE9
, TGR.ATTRIBUTE10
, TGR.ATTRIBUTE11
, TGR.ATTRIBUTE12
, TGR.ATTRIBUTE13
, TGR.ATTRIBUTE14
, TGR.ATTRIBUTE15
FROM JL_ZZ_AR_TX_GROUPS TGR
, JL_ZZ_AR_TX_CATEG CAT_REDUCE
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TGR.TAX_CATEGORY_ID = CAT.TAX_CATEGORY_ID
AND CAT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND NVL(CAT_REDUCE.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TGR.TAX_CATEGORY_TO_REDUCE_ID = CAT_REDUCE.TAX_CATEGORY_ID(+)
AND TGR.TAX_CODE IS NULL
AND NVL(TGR.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)
AND NVL(TGR.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns