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 970: from msc_single_lvl_peg

966: nvl(FND_PROFILE.value('MSC_DRP_REL_EXP_OFFSET_DAYS'),0);
967:
968: cursor pegged_supply is
969: select child_id
970: from msc_single_lvl_peg
971: where plan_id = p_plan_id
972: and pegging_type = 2 -- supply to parent demand
973: and parent_id = p_demand_id;
974: