eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JL_ZZ_AR_TX_CUS_CLS_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)