VIEW: APPS.CSP_NOTIFICATION_RULES_VL

Source

View Text - Preformatted

SELECT cbrb.rowid row_id, cbrb.business_rule_id notification_rule_id, cbrb.business_rule_name notification_rule_name, cbrb.business_rule_type business_rule_type, cbrt.description description, to_number(cbrb.business_rule_value1) io_excess_value, to_number(cbrb.business_rule_value2) io_repair_value, to_number(cbrb.business_rule_value3) io_recommend_value, to_number(cbrb.business_rule_value4) io_tracking_signal_min, to_number(cbrb.business_rule_value5) io_tracking_signal_max, to_number(cbrb.business_rule_value6) req_excess_value, to_number(cbrb.business_rule_value7) req_repair_value, to_number(cbrb.business_rule_value8) req_recommend_value, to_number(cbrb.business_rule_value9) req_tracking_signal_min, to_number(cbrb.business_rule_value10) req_tracking_signal_max, to_number(cbrb.business_rule_value11) wip_order_excess_value, to_number(cbrb.business_rule_value12) wip_order_repair_value, to_number(cbrb.business_rule_value13) wip_order_recommend_value, to_number(cbrb.business_rule_value14) wip_order_tracking_signal_min, to_number(cbrb.business_rule_value15) wip_order_tracking_signal_max, 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 = 'NOTIFICATIONS' 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 NOTIFICATION_RULE_ID
, CBRB.BUSINESS_RULE_NAME NOTIFICATION_RULE_NAME
, CBRB.BUSINESS_RULE_TYPE BUSINESS_RULE_TYPE
, CBRT.DESCRIPTION DESCRIPTION
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE1) IO_EXCESS_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE2) IO_REPAIR_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE3) IO_RECOMMEND_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE4) IO_TRACKING_SIGNAL_MIN
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE5) IO_TRACKING_SIGNAL_MAX
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE6) REQ_EXCESS_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE7) REQ_REPAIR_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE8) REQ_RECOMMEND_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE9) REQ_TRACKING_SIGNAL_MIN
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE10) REQ_TRACKING_SIGNAL_MAX
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE11) WIP_ORDER_EXCESS_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE12) WIP_ORDER_REPAIR_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE13) WIP_ORDER_RECOMMEND_VALUE
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE14) WIP_ORDER_TRACKING_SIGNAL_MIN
, TO_NUMBER(CBRB.BUSINESS_RULE_VALUE15) WIP_ORDER_TRACKING_SIGNAL_MAX
, 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 = 'NOTIFICATIONS'
AND CBRT.BUSINESS_RULE_ID = CBRB.BUSINESS_RULE_ID
AND CBRT.LANGUAGE = USERENV('LANG')