View: JL_ZZ_AR_TX_CUS_CLS_V

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

View Text

SELECT TCAC.ROWID ROW_ID
, TCAC.CUS_CLASS_ID CUS_CLASS_ID
, TCAC.ADDRESS_ID ADDRESS_ID
, TCAC.TAX_ATTR_CLASS_CODE TAX_ATTR_CLASS_CODE
, TCAC.TAX_CATEGORY_ID TAX_CATEGORY_ID
, TC.TAX_CATEGORY TAX_CATEGORY
, TCAC.TAX_ATTRIBUTE_NAME TAX_ATTRIBUTE_NAME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TCAC.TAX_ATTRIBUTE_NAME
, 'CONTRIBUTOR_ATTRIBUTE')
, 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
FROM JL_ZZ_AR_TX_CUS_CLS TCAC
, JL_ZZ_AR_TX_CATEG_ALL TC
, AR_SYSTEM_PARAMETERS_ALL ASP
WHERE TCAC.TAX_CATEGORY_ID = TC.TAX_CATEGORY_ID
AND TC.TAX_RULE_SET = ASP.GLOBAL_ATTRIBUTE13
AND NVL(TCAC.ORG_ID
, -99) = NVL(TC.ORG_ID
, -99)
AND NVL(TCAC.ORG_ID
, -99) = NVL(ASP.ORG_ID
, -99)

Columns