DBA Data[Home] [Help]

APPS.MSC_SET_DEMAND_PRIORITY dependencies on MSC_PLANS

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: