FND Design Data [Home] [Help]

View: JL_ZZ_AR_TX_CUS_CLS_V

Product: JL - Latin America Localizations
Description:
Implementation/DBA Data: ViewAPPS.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

Name
ROW_ID
CUS_CLASS_ID
ADDRESS_ID
TAX_ATTR_CLASS_CODE
TAX_CATEGORY_ID
TAX_CATEGORY
TAX_ATTRIBUTE_NAME
ATTR_NAME_MEANING
TAX_ATTRIBUTE_VALUE
ATTR_VALUE_MEANING
ENABLED_FLAG
ORG_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN