DBA Data[Home] [Help]

VIEW: APPS.JL_ZZ_AR_TX_CAT_ATT_V

Source

View Text - Preformatted

SELECT att.rowid row_id, att.tax_categ_attr_id, att.tax_category_id, cat.tax_category, att.tax_attribute_type, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(att.tax_attribute_type, 'JLZZ_AR_TX_CATEG_ATTR_TYPE'),1,80) attr_type_desc, att.tax_attribute_name, att.grouping_attribute, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(att.tax_attribute_name, att.tax_attribute_type),1,80) attr_desc, att.mandatory_in_class, att.determining_factor, att.priority_number, att.org_id, att.creation_date, att.created_by, att.last_update_date, att.last_update_login, att.last_updated_by, att.attribute_category, att.attribute1, att.attribute2, att.attribute3, att.attribute4, att.attribute5, att.attribute6, att.attribute7, att.attribute8, att.attribute9, att.attribute10, att.attribute11, att.attribute12, att.attribute13, att.attribute14, att.attribute15 FROM jl_zz_ar_tx_cat_att att, jl_zz_ar_tx_categ_all cat, ar_system_parameters_all sys WHERE att.tax_category_id = cat.tax_category_id AND cat.tax_rule_set = sys.global_attribute13 AND nvl(att.org_id,-99) = nvl(cat.org_id,-99) AND nvl(att.org_id,-99) = nvl(sys.org_id,-99)
View Text - HTML Formatted

SELECT ATT.ROWID ROW_ID
, ATT.TAX_CATEG_ATTR_ID
, ATT.TAX_CATEGORY_ID
, CAT.TAX_CATEGORY
, ATT.TAX_ATTRIBUTE_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(ATT.TAX_ATTRIBUTE_TYPE
, 'JLZZ_AR_TX_CATEG_ATTR_TYPE')
, 1
, 80) ATTR_TYPE_DESC
, ATT.TAX_ATTRIBUTE_NAME
, ATT.GROUPING_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(ATT.TAX_ATTRIBUTE_NAME
, ATT.TAX_ATTRIBUTE_TYPE)
, 1
, 80) ATTR_DESC
, ATT.MANDATORY_IN_CLASS
, ATT.DETERMINING_FACTOR
, ATT.PRIORITY_NUMBER
, ATT.ORG_ID
, ATT.CREATION_DATE
, ATT.CREATED_BY
, ATT.LAST_UPDATE_DATE
, ATT.LAST_UPDATE_LOGIN
, ATT.LAST_UPDATED_BY
, ATT.ATTRIBUTE_CATEGORY
, ATT.ATTRIBUTE1
, ATT.ATTRIBUTE2
, ATT.ATTRIBUTE3
, ATT.ATTRIBUTE4
, ATT.ATTRIBUTE5
, ATT.ATTRIBUTE6
, ATT.ATTRIBUTE7
, ATT.ATTRIBUTE8
, ATT.ATTRIBUTE9
, ATT.ATTRIBUTE10
, ATT.ATTRIBUTE11
, ATT.ATTRIBUTE12
, ATT.ATTRIBUTE13
, ATT.ATTRIBUTE14
, ATT.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CAT_ATT ATT
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE ATT.TAX_CATEGORY_ID = CAT.TAX_CATEGORY_ID
AND CAT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND NVL(ATT.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)
AND NVL(ATT.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)