VIEW: APPS.CSP_WRP_RULES_VL

Source

View Text - Preformatted

SELECT cbrb.rowid,cbrb.business_rule_id,cbrb.business_rule_name, cbrb.business_rule_type, cbrt.description, cbrb.business_rule_value1, cbrb.business_rule_value2, cbrb.business_rule_value3, cbrb.business_rule_value4, cbrb.business_rule_value5, cbrb.business_rule_value6, cbrb.business_rule_value7, cbrb.business_rule_value8, cbrb.business_rule_value9, cbrb.business_rule_value10, cbrb.business_rule_value11,cbrb.business_rule_value12, cbrb.business_rule_value13,cbrb.business_rule_value14, cbrb.business_rule_value15,cbrb.business_rule_value16, cbrb.business_rule_value17,cbrb.business_rule_value18, cbrb.business_rule_value19,cbrb.business_rule_value20, cbrb.creation_date, cbrb.created_by, cbrb.last_update_date, cbrb.last_updated_by, cbrb.last_update_login, cbrb.attribute_category, cbrb.attribute1, cbrb.attribute2, cbrb.attribute3, cbrb.attribute4, cbrb.attribute5, cbrb.attribute6, cbrb.attribute7, cbrb.attribute8, cbrb.attribute9, cbrb.attribute10, cbrb.attribute11, cbrb.attribute12, cbrb.attribute13, cbrb.attribute14, cbrb.attribute15 from csp_business_rules_b cbrb, csp_business_rules_tl cbrt where cbrb.business_rule_type = 'WRP' and cbrb.business_rule_id = cbrt.business_rule_id and cbrt.language = userenv('LANG')

View Text - HTML Formatted

SELECT CBRB.ROWID
, CBRB.BUSINESS_RULE_ID
, CBRB.BUSINESS_RULE_NAME
, CBRB.BUSINESS_RULE_TYPE
, CBRT.DESCRIPTION
, CBRB.BUSINESS_RULE_VALUE1
, CBRB.BUSINESS_RULE_VALUE2
, CBRB.BUSINESS_RULE_VALUE3
, CBRB.BUSINESS_RULE_VALUE4
, CBRB.BUSINESS_RULE_VALUE5
, CBRB.BUSINESS_RULE_VALUE6
, CBRB.BUSINESS_RULE_VALUE7
, CBRB.BUSINESS_RULE_VALUE8
, CBRB.BUSINESS_RULE_VALUE9
, CBRB.BUSINESS_RULE_VALUE10
, CBRB.BUSINESS_RULE_VALUE11
, CBRB.BUSINESS_RULE_VALUE12
, CBRB.BUSINESS_RULE_VALUE13
, CBRB.BUSINESS_RULE_VALUE14
, CBRB.BUSINESS_RULE_VALUE15
, CBRB.BUSINESS_RULE_VALUE16
, CBRB.BUSINESS_RULE_VALUE17
, CBRB.BUSINESS_RULE_VALUE18
, CBRB.BUSINESS_RULE_VALUE19
, CBRB.BUSINESS_RULE_VALUE20
, CBRB.CREATION_DATE
, CBRB.CREATED_BY
, CBRB.LAST_UPDATE_DATE
, CBRB.LAST_UPDATED_BY
, CBRB.LAST_UPDATE_LOGIN
, CBRB.ATTRIBUTE_CATEGORY
, CBRB.ATTRIBUTE1
, CBRB.ATTRIBUTE2
, CBRB.ATTRIBUTE3
, CBRB.ATTRIBUTE4
, CBRB.ATTRIBUTE5
, CBRB.ATTRIBUTE6
, CBRB.ATTRIBUTE7
, CBRB.ATTRIBUTE8
, CBRB.ATTRIBUTE9
, CBRB.ATTRIBUTE10
, CBRB.ATTRIBUTE11
, CBRB.ATTRIBUTE12
, CBRB.ATTRIBUTE13
, CBRB.ATTRIBUTE14
, CBRB.ATTRIBUTE15
FROM CSP_BUSINESS_RULES_B CBRB
, CSP_BUSINESS_RULES_TL CBRT
WHERE CBRB.BUSINESS_RULE_TYPE = 'WRP'
AND CBRB.BUSINESS_RULE_ID = CBRT.BUSINESS_RULE_ID
AND CBRT.LANGUAGE = USERENV('LANG')