VIEW: APPS.CSP_RESCHEDULE_RULES_VL

Source

View Text - Preformatted

SELECT cbrb.rowid row_id, cbrb.business_rule_id, cbrb.business_rule_name, cbrb.business_rule_type, cbrt.description, cbrb.business_rule_value1, fl1.meaning, cbrb.business_rule_value2, cbrb.business_rule_value3, cbrb.business_rule_value4, fl3.meaning, cbrb.business_rule_value5, cbrb.business_rule_value6, fl2.meaning, cbrb.business_rule_value7, cbrb.business_rule_value8, cbrb.business_rule_value9, cbrb.business_rule_value10, cbrb.business_rule_value11, 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 , fnd_lookups fl1, fnd_lookups fl2, fnd_lookups fl3 where cbrb.business_rule_type = 'RESCHEDULE' and cbrt.business_rule_id = cbrb.business_rule_id and cbrt.language = userenv('LANG') and fl1.lookup_type(+) = 'CSP_PLAN_DETAIL_TYPE' and fl1.lookup_code(+) = cbrb.business_rule_value1 and fl2.lookup_type(+) = 'CSP_PLAN_DETAIL_TYPE' and fl2.lookup_code(+) = cbrb.business_rule_value6 and fl3.lookup_type(+) = 'CSP_PLAN_OHB_CONDITION' and fl3.lookup_code(+) = cbrb.business_rule_value4

View Text - HTML Formatted

SELECT CBRB.ROWID ROW_ID
, CBRB.BUSINESS_RULE_ID
, CBRB.BUSINESS_RULE_NAME
, CBRB.BUSINESS_RULE_TYPE
, CBRT.DESCRIPTION
, CBRB.BUSINESS_RULE_VALUE1
, FL1.MEANING
, CBRB.BUSINESS_RULE_VALUE2
, CBRB.BUSINESS_RULE_VALUE3
, CBRB.BUSINESS_RULE_VALUE4
, FL3.MEANING
, CBRB.BUSINESS_RULE_VALUE5
, CBRB.BUSINESS_RULE_VALUE6
, FL2.MEANING
, CBRB.BUSINESS_RULE_VALUE7
, CBRB.BUSINESS_RULE_VALUE8
, CBRB.BUSINESS_RULE_VALUE9
, CBRB.BUSINESS_RULE_VALUE10
, CBRB.BUSINESS_RULE_VALUE11
, 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
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FND_LOOKUPS FL3
WHERE CBRB.BUSINESS_RULE_TYPE = 'RESCHEDULE'
AND CBRT.BUSINESS_RULE_ID = CBRB.BUSINESS_RULE_ID
AND CBRT.LANGUAGE = USERENV('LANG')
AND FL1.LOOKUP_TYPE(+) = 'CSP_PLAN_DETAIL_TYPE'
AND FL1.LOOKUP_CODE(+) = CBRB.BUSINESS_RULE_VALUE1
AND FL2.LOOKUP_TYPE(+) = 'CSP_PLAN_DETAIL_TYPE'
AND FL2.LOOKUP_CODE(+) = CBRB.BUSINESS_RULE_VALUE6
AND FL3.LOOKUP_TYPE(+) = 'CSP_PLAN_OHB_CONDITION'
AND FL3.LOOKUP_CODE(+) = CBRB.BUSINESS_RULE_VALUE4