VIEW: APPS.CSP_RECOMMENDATION_RULES_VL

Source

View Text - Preformatted

SELECT cbrb.rowid row_id, cbrb.business_rule_id recommendation_rule_id, cbrb.business_rule_name recommendation_rule_name, cbrb.business_rule_type business_rule_type, cbrt.description description, to_number(cbrb.business_rule_value1) tracking_signal_min, to_number(cbrb.business_rule_value2) tracking_signal_max, to_number(cbrb.business_rule_value3) value_change, to_number(cbrb.business_rule_value4) value_change_perc, to_number(cbrb.business_rule_value5) quantity_change, to_number(cbrb.business_rule_value6) quantity_change_perc, 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 = 'RECOMMENDATIONS' and cbrt.business_rule_id = cbrb.business_rule_id and cbrt.language = userenv('LANG')

View Text - HTML Formatted

SELECT CBRB.ROWID ROW_ID
, CBRB.BUSINESS_RULE_ID RECOMMENDATION_RULE_ID
, CBRB.BUSINESS_RULE_NAME RECOMMENDATION_RULE_NAME
, CBRB.BUSINESS_RULE_TYPE BUSINESS_RULE_TYPE
, CBRT.DESCRIPTION DESCRIPTION
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE1) TRACKING_SIGNAL_MIN
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE2) TRACKING_SIGNAL_MAX
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE3) VALUE_CHANGE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE4) VALUE_CHANGE_PERC
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE5) QUANTITY_CHANGE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE6) QUANTITY_CHANGE_PERC
, 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 = 'RECOMMENDATIONS'
AND CBRT.BUSINESS_RULE_ID = CBRB.BUSINESS_RULE_ID
AND CBRT.LANGUAGE = USERENV('LANG')