DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_SINGLE_LVL_PEG

Line 129: msc_single_lvl_peg mslp

125: RETURN date IS
126: CURSOR date_c IS
127: select ms.new_schedule_date
128: from msc_supplies ms,
129: msc_single_lvl_peg mslp
130: where mslp.plan_id = p_plan_id
131: and mslp.pegging_type = 1 -- supply to parent supply
132: and mslp.parent_id = p_supply_id
133: and mslp.child_id = ms.transaction_id

Line 961: from msc_single_lvl_peg

957: nvl(FND_PROFILE.value('MSC_DRP_REL_EXP_OFFSET_DAYS'),0);
958:
959: cursor pegged_supply is
960: select child_id
961: from msc_single_lvl_peg
962: where plan_id = p_plan_id
963: and pegging_type = 2 -- supply to parent demand
964: and parent_id = p_demand_id;
965: