View: JL_ZZ_AR_TX_CAT_ATT_V

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

View Text

SELECT ATT.ROWID ROW_ID
, ATT.TAX_CATEG_ATTR_ID
, ATT.TAX_CATEGORY_ID
, CAT.TAX_CATEGORY
, ATT.TAX_ATTRIBUTE_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(ATT.TAX_ATTRIBUTE_TYPE
, 'JLZZ_AR_TX_CATEG_ATTR_TYPE')
, 1
, 80) ATTR_TYPE_DESC
, ATT.TAX_ATTRIBUTE_NAME
, ATT.GROUPING_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(ATT.TAX_ATTRIBUTE_NAME
, ATT.TAX_ATTRIBUTE_TYPE)
, 1
, 80) ATTR_DESC
, ATT.MANDATORY_IN_CLASS
, ATT.DETERMINING_FACTOR
, ATT.PRIORITY_NUMBER
, ATT.ORG_ID
, ATT.CREATION_DATE
, ATT.CREATED_BY
, ATT.LAST_UPDATE_DATE
, ATT.LAST_UPDATE_LOGIN
, ATT.LAST_UPDATED_BY
, ATT.ATTRIBUTE_CATEGORY
, ATT.ATTRIBUTE1
, ATT.ATTRIBUTE2
, ATT.ATTRIBUTE3
, ATT.ATTRIBUTE4
, ATT.ATTRIBUTE5
, ATT.ATTRIBUTE6
, ATT.ATTRIBUTE7
, ATT.ATTRIBUTE8
, ATT.ATTRIBUTE9
, ATT.ATTRIBUTE10
, ATT.ATTRIBUTE11
, ATT.ATTRIBUTE12
, ATT.ATTRIBUTE13
, ATT.ATTRIBUTE14
, ATT.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CAT_ATT ATT
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE ATT.TAX_CATEGORY_ID = CAT.TAX_CATEGORY_ID
AND CAT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND NVL(ATT.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)
AND NVL(ATT.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns