VIEW: APPS.JL_ZZ_AR_TX_ATT_VAL_V

Source

View Text - Preformatted

SELECT val.rowid row_id, val.tax_category_id, val.tax_categ_attr_val_id, val.tax_attribute_type, val.tax_attribute_name, val.tax_attribute_value, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(val.tax_attribute_value, 'JLZZ_AR_TX_ATTR_VALUE'),1,80) attr_val_desc, val.tax_attr_value_code, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(val.tax_attr_value_code, decode(val.tax_attribute_type, 'CONTRIBUTOR_ATTRIBUTE', 'JLAR_AP_SUPP_CONDITION_CODE', 'TRANSACTION_ATTRIBUTE', 'JLAR_TAX_AUTHORITY_CATEGORY', 'X')),1,80) tax_attr_value_meaning, val.default_to_class, val.org_id, val.creation_date, val.created_by, val.last_update_date, val.last_update_login, val.last_updated_by, val.attribute_category, val.attribute1, val.attribute2, val.attribute3, val.attribute4, val.attribute5, val.attribute6, val.attribute7, val.attribute8, val.attribute9, val.attribute10, val.attribute11, val.attribute12, val.attribute13, val.attribute14, val.attribute15 FROM jl_zz_ar_tx_att_val_all val, ar_system_parameters_all sys WHERE NVL(val.org_id, -99) = NVL(sys.org_id,-99)

View Text - HTML Formatted

SELECT VAL.ROWID ROW_ID
, VAL.TAX_CATEGORY_ID
, VAL.TAX_CATEG_ATTR_VAL_ID
, VAL.TAX_ATTRIBUTE_TYPE
, VAL.TAX_ATTRIBUTE_NAME
, VAL.TAX_ATTRIBUTE_VALUE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(VAL.TAX_ATTRIBUTE_VALUE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80) ATTR_VAL_DESC
, VAL.TAX_ATTR_VALUE_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(VAL.TAX_ATTR_VALUE_CODE
, DECODE(VAL.TAX_ATTRIBUTE_TYPE
, 'CONTRIBUTOR_ATTRIBUTE'
, 'JLAR_AP_SUPP_CONDITION_CODE'
, 'TRANSACTION_ATTRIBUTE'
, 'JLAR_TAX_AUTHORITY_CATEGORY'
, 'X'))
, 1
, 80) TAX_ATTR_VALUE_MEANING
, VAL.DEFAULT_TO_CLASS
, VAL.ORG_ID
, VAL.CREATION_DATE
, VAL.CREATED_BY
, VAL.LAST_UPDATE_DATE
, VAL.LAST_UPDATE_LOGIN
, VAL.LAST_UPDATED_BY
, VAL.ATTRIBUTE_CATEGORY
, VAL.ATTRIBUTE1
, VAL.ATTRIBUTE2
, VAL.ATTRIBUTE3
, VAL.ATTRIBUTE4
, VAL.ATTRIBUTE5
, VAL.ATTRIBUTE6
, VAL.ATTRIBUTE7
, VAL.ATTRIBUTE8
, VAL.ATTRIBUTE9
, VAL.ATTRIBUTE10
, VAL.ATTRIBUTE11
, VAL.ATTRIBUTE12
, VAL.ATTRIBUTE13
, VAL.ATTRIBUTE14
, VAL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_ATT_VAL_ALL VAL
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE NVL(VAL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)