VIEW: APPS.JL_ZZ_AR_TX_CATEGRY

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)