FND Design Data [Home] [Help]

View: JL_ZZ_AR_TX_CATEGRY_V

Product: JL - Latin America Localizations
Description:
Implementation/DBA Data: ViewAPPS.JL_ZZ_AR_TX_CATEGRY_V
View Text

SELECT TAX.ROWID
, TAX.TAX_CATEGORY_ID
, TAX.TAX_CATEGORY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_CATEGORY
, 'JLZZ_AR_TX_CATEGRY')
, 1
, 80)
, TAX.END_DATE_ACTIVE
, TAX.LAST_UPDATE_DATE
, TAX.LAST_UPDATED_BY
, TAX.THRESHOLD_CHECK_LEVEL
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_LEVEL
, 'JLZZ_AR_TX_THRESH_CHECK_
, LEVEL')
, 1
, 80)
, DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION') THRESHOLD_CHECK_GRP_BY_NB
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION')
, 'JLZZ_AR_TX_THRESH_GRP_BY')
, 1
, 80)
, TAX.THRESHOLD_CHECK_GRP_BY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_GRP_BY
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.MIN_AMOUNT
, TAX.MIN_TAXABLE_BASIS
, TAX.MIN_PERCENTAGE
, TAX.TAX_INCLUSIVE
, TAX.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, TAX.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, TAX.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.TRIBUTARY_SUBSTITUTION
, TAX.USED_TO_REDUCE
, TAX.TAX_CATEG_TO_REDUCE_ID
, CAT.TAX_CATEGORY TAX_CATEG_TO_REDUCE_DESC
, TAX.MANDATORY_IN_CLASS
, TAX.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, TAX.TAX_AUTHORITY_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_AUTHORITY_CODE
, 'JLAR_AP_DGI_TAX_TYPE')
, 1
, 80)
, TAX.PRINT_FLAG
, TAX.TAX_RULE_SET
, TAX.START_DATE_ACTIVE
, TAX.ORG_ID
, TAX.TAX_REGIME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_REGIME
, 'JLZZ_AR_TAX_REGIME')
, 1
, 80)
, TAX.LAST_UPDATE_LOGIN
, TAX.CREATION_DATE
, TAX.CREATED_BY
, TAX.ATTRIBUTE_CATEGORY
, TAX.ATTRIBUTE1
, TAX.ATTRIBUTE2
, TAX.ATTRIBUTE3
, TAX.ATTRIBUTE4
, TAX.ATTRIBUTE5
, TAX.ATTRIBUTE6
, TAX.ATTRIBUTE7
, TAX.ATTRIBUTE8
, TAX.ATTRIBUTE9
, TAX.ATTRIBUTE10
, TAX.ATTRIBUTE11
, TAX.ATTRIBUTE12
, TAX.ATTRIBUTE13
, TAX.ATTRIBUTE14
, TAX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CATEG TAX
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TAX.TAX_CATEG_TO_REDUCE_ID = CAT.TAX_CATEGORY_ID (+)
AND TAX.TAX_CODE IS NOT NULL
AND TAX.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 TAX.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TAX.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TAX.END_DATE_ACTIVE >= ART.START_DATE
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID /*AND NVL(TAX.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)*/
AND NVL(TAX.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TAX.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.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= TAX.END_DATE_ACTIVE)
AND NVL(CAT.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TAX.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13 UNION SELECT TAX.ROWID
, TAX.TAX_CATEGORY_ID
, TAX.TAX_CATEGORY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_CATEGORY
, 'JLZZ_AR_TX_CATEGRY')
, 1
, 80)
, TAX.END_DATE_ACTIVE
, TAX.LAST_UPDATE_DATE
, TAX.LAST_UPDATED_BY
, TAX.THRESHOLD_CHECK_LEVEL
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_LEVEL
, 'JLZZ_AR_TX_THRESH_CHECK_LEVEL')
, 1
, 80)
, DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION') THRESHOLD_CHECK_GRP_BY_NB
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION')
, 'JLZZ_AR_TX_THRESH_GRP_BY')
, 1
, 80)
, TAX.THRESHOLD_CHECK_GRP_BY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_GRP_BY
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.MIN_AMOUNT
, TAX.MIN_TAXABLE_BASIS
, TAX.MIN_PERCENTAGE
, TAX.TAX_INCLUSIVE
, TAX.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, TAX.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, TAX.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.TRIBUTARY_SUBSTITUTION
, TAX.USED_TO_REDUCE
, TAX.TAX_CATEG_TO_REDUCE_ID
, CAT.TAX_CATEGORY
, TAX.MANDATORY_IN_CLASS
, TAX.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, TAX.TAX_AUTHORITY_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_AUTHORITY_CODE
, 'JLAR_AP_DGI_TAX_TYPE')
, 1
, 80)
, TAX.PRINT_FLAG
, TAX.TAX_RULE_SET
, TAX.START_DATE_ACTIVE
, TAX.ORG_ID
, TAX.TAX_REGIME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_REGIME
, 'JLZZ_AR_TAX_REGIME')
, 1
, 80)
, TAX.LAST_UPDATE_LOGIN
, TAX.CREATION_DATE
, TAX.CREATED_BY
, TAX.ATTRIBUTE_CATEGORY
, TAX.ATTRIBUTE1
, TAX.ATTRIBUTE2
, TAX.ATTRIBUTE3
, TAX.ATTRIBUTE4
, TAX.ATTRIBUTE5
, TAX.ATTRIBUTE6
, TAX.ATTRIBUTE7
, TAX.ATTRIBUTE8
, TAX.ATTRIBUTE9
, TAX.ATTRIBUTE10
, TAX.ATTRIBUTE11
, TAX.ATTRIBUTE12
, TAX.ATTRIBUTE13
, TAX.ATTRIBUTE14
, TAX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CATEG TAX
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TAX.TAX_CATEG_TO_REDUCE_ID = CAT.TAX_CATEGORY_ID(+)
AND TAX.TAX_CODE IS NULL
AND NVL(CAT.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TAX.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13 /*AND NVL(TAX.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)*/
AND NVL(TAX.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns

Name
ROW_ID
TAX_CATEGORY_ID
TAX_CATEGORY
DESCRIPTION
END_DATE_ACTIVE
LAST_UPDATE_DATE
LAST_UPDATED_BY
THRESHOLD_CHECK_LEVEL
THRESHOLD_CHECK_LEVEL_DESC
THRESHOLD_CHECK_GRP_BY_NB
THRESHOLD_CHECK_GRP_BY_DESC_NB
THRESHOLD_CHECK_GRP_BY
THRESHOLD_CHECK_GRP_BY_DESC
MIN_AMOUNT
MIN_TAXABLE_BASIS
MIN_PERCENTAGE
TAX_INCLUSIVE
ORG_TAX_ATTRIBUTE
ORG_TAX_ATTRIBUTE_DESC
CUS_TAX_ATTRIBUTE
CUS_TAX_ATTRIBUTE_DESC
TXN_TAX_ATTRIBUTE
TXN_TAX_ATTRIBUTE_DESC
TRIBUTARY_SUBSTITUTION
USED_TO_REDUCE
TAX_CATEG_TO_REDUCE_ID
TAX_CATEG_TO_REDUCE_DESC
MANDATORY_IN_CLASS
TAX_CODE
TAX_DESCRIPTION
TAX_RATE
TAX_AUTHORITY_CODE
TAX_AUTHORITY_MEANING
PRINT_FLAG
TAX_RULE_SET
START_DATE_ACTIVE
ORG_ID
TAX_REGIME
TAX_REGIME_DESC
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15