Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_ZZ_AR_TX_CATEGRY |
SELECT TXC.TAX_CATEGORY_ID
, TXC.TAX_CATEGORY
, FND_CAT_DESC.MEANING
, TXC.END_DATE_ACTIVE
, TXC.LAST_UPDATE_DATE
, TXC.LAST_UPDATED_BY
, TXC.THRESHOLD_CHECK_LEVEL
, TXC.THRESHOLD_CHECK_GRP_BY
, TXC.MIN_AMOUNT
, TXC.MIN_TAXABLE_BASIS
, TXC.MIN_PERCENTAGE
, TXC.TAX_INCLUSIVE
, TXC.ORG_TAX_ATTRIBUTE
, TXC.CUS_TAX_ATTRIBUTE
, TXC.TXN_TAX_ATTRIBUTE
, TXC.TRIBUTARY_SUBSTITUTION
, TXC.USED_TO_REDUCE
, TXC.TAX_CATEG_TO_REDUCE_ID
, TXC.TAX_CODE
, TXC.MANDATORY_IN_CLASS
, TXC.TAX_AUTHORITY_CODE
, TXC.TAX_RULE_SET
, TXC.PRINT_FLAG
, TXC.START_DATE_ACTIVE
, TXC.TAX_REGIME
, TXC.ORG_ID
, TXC.LAST_UPDATE_LOGIN
, TXC.CREATION_DATE
, TXC.CREATED_BY
, TXC.ATTRIBUTE_CATEGORY
, TXC.ATTRIBUTE1
, TXC.ATTRIBUTE2
, TXC.ATTRIBUTE3
, TXC.ATTRIBUTE4
, TXC.ATTRIBUTE5
, TXC.ATTRIBUTE6
, TXC.ATTRIBUTE7
, TXC.ATTRIBUTE8
, TXC.ATTRIBUTE9
, TXC.ATTRIBUTE10
, TXC.ATTRIBUTE11
, TXC.ATTRIBUTE12
, TXC.ATTRIBUTE13
, TXC.ATTRIBUTE14
, TXC.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CATEG TXC
, FND_LOOKUPS FND_CAT_DESC
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TXC.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND FND_CAT_DESC.LOOKUP_TYPE = 'JLZZ_AR_TX_CATEGRY'
AND TXC.TAX_CATEGORY = FND_CAT_DESC.LOOKUP_CODE
AND FND_CAT_DESC.ENABLED_FLAG = 'Y'
AND NVL(TXC.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND SYSDATE BETWEEN NVL(FND_CAT_DESC.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FND_CAT_DESC.END_DATE_ACTIVE
, SYSDATE)
AND SYSDATE BETWEEN NVL(FND_CAT_DESC.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FND_CAT_DESC.END_DATE_ACTIVE
, SYSDATE)