VIEW: APPS.MSC_PRI_RULES_CALCULATED_V

Source

View Text - Preformatted

SELECT rule_set_id, substr(msc_get_name.lookup_meaning('PRIORITY_RULES_DEMAND_TYPE', demand_type) || decode(demand_type, 4, null, 5, null, 6, null, ' - ' || decode(demand_class,'-1', msc_get_name.lookup_meaning('MSC_ALL_OTHER_DMD_CLASS',-1), demand_class)),1,60), priority from msc_drp_pri_rules_calc

View Text - HTML Formatted

SELECT RULE_SET_ID
, SUBSTR(MSC_GET_NAME.LOOKUP_MEANING('PRIORITY_RULES_DEMAND_TYPE'
, DEMAND_TYPE) || DECODE(DEMAND_TYPE
, 4
, NULL
, 5
, NULL
, 6
, NULL
, ' - ' || DECODE(DEMAND_CLASS
, '-1'
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ALL_OTHER_DMD_CLASS'
, -1)
, DEMAND_CLASS))
, 1
, 60)
, PRIORITY
FROM MSC_DRP_PRI_RULES_CALC