View: JL_ZZ_AR_TX_ATT_CLS_V

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

View Text

SELECT TCAC.ROWID ROW_ID
, TCAC.ATTRIBUTE_CLASS_ID ATTRIBUTE_CLASS_ID
, TCAC.TAX_ATTR_CLASS_TYPE TAX_ATTR_CLASS_TYPE
, TCAC.TAX_ATTR_CLASS_CODE TAX_ATTR_CLASS_CODE
, TCAC.TAX_CATEGORY_ID TAX_CATEGORY_ID
, TC.TAX_CATEGORY TAX_CATEGORY
, TCAC.TAX_ATTRIBUTE_TYPE TAX_ATTRIBUTE_TYPE
, TCAC.TAX_ATTRIBUTE_NAME TAX_ATTRIBUTE_NAME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TCAC.TAX_ATTRIBUTE_NAME
, TCAC.TAX_ATTRIBUTE_TYPE)
, 1
, 80) ATTR_NAME_MEANING
, TCAC.TAX_ATTRIBUTE_VALUE TAX_ATTRIBUTE_VALUE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TCAC.TAX_ATTRIBUTE_VALUE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80) ATTR_VALUE_MEANING
, TCAC.ENABLED_FLAG ENABLED_FLAG
, TCAC.ORG_ID
, TCAC.CREATION_DATE CREATION_DATE
, TCAC.CREATED_BY CREATED_BY
, TCAC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TCAC.LAST_UPDATED_BY LAST_UPDATED_BY
, TCAC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TCAC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TCAC.ATTRIBUTE1 ATTRIBUTE1
, TCAC.ATTRIBUTE2 ATTRIBUTE2
, TCAC.ATTRIBUTE3 ATTRIBUTE3
, TCAC.ATTRIBUTE4 ATTRIBUTE4
, TCAC.ATTRIBUTE5 ATTRIBUTE5
, TCAC.ATTRIBUTE6 ATTRIBUTE6
, TCAC.ATTRIBUTE7 ATTRIBUTE7
, TCAC.ATTRIBUTE8 ATTRIBUTE8
, TCAC.ATTRIBUTE9 ATTRIBUTE9
, TCAC.ATTRIBUTE10 ATTRIBUTE10
, TCAC.ATTRIBUTE11 ATTRIBUTE11
, TCAC.ATTRIBUTE12 ATTRIBUTE12
, TCAC.ATTRIBUTE13 ATTRIBUTE13
, TCAC.ATTRIBUTE14 ATTRIBUTE14
, TCAC.ATTRIBUTE15 ATTRIBUTE15
FROM JL_ZZ_AR_TX_ATT_CLS TCAC
, JL_ZZ_AR_TX_CATEG_ALL TC
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TCAC.TAX_CATEGORY_ID = TC.TAX_CATEGORY_ID
AND TC.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND NVL(TCAC.ORG_ID
, -99) = NVL(TC.ORG_ID
, -99)
AND NVL(TCAC.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns