APPS.MSC_SET_DEMAND_PRIORITY dependencies on MSC_SCHEDULING_RULES

Line 47: FROM msc_scheduling_rules

43: /* Get the default demand priority rule id */
44: /****************************************************/
45: SELECT RULE_ID
46: INTO def_rule_id
47: FROM msc_scheduling_rules
48: WHERE DEFAULT_FLAG = 'Y';
49:
50:
51: /****************************************************/

Line 72: FROM MSC_SCHEDULING_RULES MSR, MSC_PLANS MP

68: 'NVL(md.REQUEST_DATE,
69: md.USING_ASSEMBLY_DEMAND_DATE)',
70: 'NULL')
71: bulk collect INTO v_DemandSort.criteria
72: FROM MSC_SCHEDULING_RULES MSR, MSC_PLANS MP
73: WHERE MSR.rule_id = NVL(MP.dem_priority_rule_id, def_rule_id)
74: AND MP.plan_id = arg_plan_id
75: ORDER BY MSR.sequence_number;
76: