VIEW: APPS.CSD_RULES_VL

Source

View Text - Preformatted

SELECT rulb.rowid , rulb.rule_id , rultl.name , rultl.description , rulb.rule_type_code , rulb.precedence , rulb.entity_attribute_code , rulb.entity_attribute_type , rulb.value_type_code , 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 WHERE rulb.rule_id = rultl.rule_id and rultl.language = userenv('LANG')

View Text - HTML Formatted

SELECT RULB.ROWID
, RULB.RULE_ID
, RULTL.NAME
, RULTL.DESCRIPTION
, RULB.RULE_TYPE_CODE
, RULB.PRECEDENCE
, RULB.ENTITY_ATTRIBUTE_CODE
, RULB.ENTITY_ATTRIBUTE_TYPE
, RULB.VALUE_TYPE_CODE
, 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
WHERE RULB.RULE_ID = RULTL.RULE_ID
AND RULTL.LANGUAGE = USERENV('LANG')