VIEW: APPS.CSD_RULES_V

Source

View Text - Preformatted

SELECT rulb.rowid , rulb.rule_id , rultl.name , rultl.description , rulb.rule_type_code , rtype_fnd.meaning , rulb.precedence , rulb.entity_attribute_code , attr_fnd.meaning , rulb.entity_attribute_type , ent_fnd.meaning , rulb.value_type_code , val_fnd.meaning , rulb.created_by , rulb.creation_date , rulb.last_updated_by , rulb.last_update_date , rulb.last_update_login , rulb.object_version_number , rulb.attribute_category , rulb.attribute1 , rulb.attribute2 , rulb.attribute3 , rulb.attribute4 , rulb.attribute5 , rulb.attribute6 , rulb.attribute7 , rulb.attribute8 , rulb.attribute9 , rulb.attribute10 , rulb.attribute11 , rulb.attribute12 , rulb.attribute13 , rulb.attribute14 , rulb.attribute15 FROM csd_rules_b rulb , csd_rules_tl rultl , fnd_lookups ent_fnd , fnd_lookups rtype_fnd , fnd_lookups attr_fnd , fnd_lookups val_fnd WHERE rulb.rule_id = rultl.rule_id and rultl.language = userenv('LANG') and ent_fnd.lookup_type(+) = 'CSD_DEFAULTING_ENTITIES' and ent_fnd.lookup_code(+) = rulb.entity_attribute_type and attr_fnd.lookup_type(+) = rulb.entity_attribute_type and attr_fnd.lookup_code(+) = rulb.entity_attribute_code and rtype_fnd.lookup_type = 'CSD_RULE_TYPES' and rtype_fnd.lookup_code = rulb.rule_type_code and val_fnd.lookup_type(+) = 'CSD_DEFAULTING_VALUE_TYPES' and val_fnd.lookup_code(+) = rulb.value_type_code

View Text - HTML Formatted

SELECT RULB.ROWID
, RULB.RULE_ID
, RULTL.NAME
, RULTL.DESCRIPTION
, RULB.RULE_TYPE_CODE
, RTYPE_FND.MEANING
, RULB.PRECEDENCE
, RULB.ENTITY_ATTRIBUTE_CODE
, ATTR_FND.MEANING
, RULB.ENTITY_ATTRIBUTE_TYPE
, ENT_FND.MEANING
, RULB.VALUE_TYPE_CODE
, VAL_FND.MEANING
, RULB.CREATED_BY
, RULB.CREATION_DATE
, RULB.LAST_UPDATED_BY
, RULB.LAST_UPDATE_DATE
, RULB.LAST_UPDATE_LOGIN
, RULB.OBJECT_VERSION_NUMBER
, RULB.ATTRIBUTE_CATEGORY
, RULB.ATTRIBUTE1
, RULB.ATTRIBUTE2
, RULB.ATTRIBUTE3
, RULB.ATTRIBUTE4
, RULB.ATTRIBUTE5
, RULB.ATTRIBUTE6
, RULB.ATTRIBUTE7
, RULB.ATTRIBUTE8
, RULB.ATTRIBUTE9
, RULB.ATTRIBUTE10
, RULB.ATTRIBUTE11
, RULB.ATTRIBUTE12
, RULB.ATTRIBUTE13
, RULB.ATTRIBUTE14
, RULB.ATTRIBUTE15
FROM CSD_RULES_B RULB
, CSD_RULES_TL RULTL
, FND_LOOKUPS ENT_FND
, FND_LOOKUPS RTYPE_FND
, FND_LOOKUPS ATTR_FND
, FND_LOOKUPS VAL_FND
WHERE RULB.RULE_ID = RULTL.RULE_ID
AND RULTL.LANGUAGE = USERENV('LANG')
AND ENT_FND.LOOKUP_TYPE(+) = 'CSD_DEFAULTING_ENTITIES'
AND ENT_FND.LOOKUP_CODE(+) = RULB.ENTITY_ATTRIBUTE_TYPE
AND ATTR_FND.LOOKUP_TYPE(+) = RULB.ENTITY_ATTRIBUTE_TYPE
AND ATTR_FND.LOOKUP_CODE(+) = RULB.ENTITY_ATTRIBUTE_CODE
AND RTYPE_FND.LOOKUP_TYPE = 'CSD_RULE_TYPES'
AND RTYPE_FND.LOOKUP_CODE = RULB.RULE_TYPE_CODE
AND VAL_FND.LOOKUP_TYPE(+) = 'CSD_DEFAULTING_VALUE_TYPES'
AND VAL_FND.LOOKUP_CODE(+) = RULB.VALUE_TYPE_CODE