View: JL_ZZ_AR_TX_ATTCLS_VAL_V

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

View Text

SELECT DISTINCT TAX_ATTR_CLASS_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX_ATTR_CLASS_CODE
, TAX_ATTR_CLASS_TYPE)
, 1
, 80) DESCRIPTION
, TAX_ATTR_CLASS_TYPE
FROM JL_ZZ_AR_TX_ATT_CLS TAC
, JL_ZZ_AR_TX_CATEG_ALL TC
, AR_SYSTEM_PARAMETERS_ALL ASP
WHERE TAC.TAX_CATEGORY_ID = TC.TAX_CATEGORY_ID
AND TC.TAX_RULE_SET = ASP.GLOBAL_ATTRIBUTE13
AND TAC.ENABLED_FLAG = 'Y'
AND NVL(TAC.ORG_ID
, -99) = NVL(TC.ORG_ID
, -99)
AND NVL(TAC.ORG_ID
, -99) = NVL(ASP.ORG_ID
, -99)

Columns