DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_SINGLE_LVL_PEG

Line 2502: from msc_supplies ms, msc_single_lvl_peg mslp

2498: END IF;
2499:
2500: update mrp_org_transfer_release motr
2501: set earliest_ship_date = (select max(ms.new_schedule_date)
2502: from msc_supplies ms, msc_single_lvl_peg mslp
2503: where ms.plan_id=l_arg_plan_id
2504: and ms.transaction_id = mslp.child_id
2505: and ms.plan_id= mslp.plan_id
2506: and mslp.parent_id = motr.transaction_id

Line 2723: from msc_part_supplies ms, msc_single_lvl_peg mslp

2719: END IF;
2720:
2721: /* update mrp_org_transfer_release motr
2722: set earliest_ship_date = (select max(ms.new_schedule_date)
2723: from msc_part_supplies ms, msc_single_lvl_peg mslp
2724: where ms.plan_id=l_arg_plan_id
2725: and ms.transaction_id = mslp.child_id
2726: and ms.plan_id= mslp.plan_id
2727: and mslp.parent_id = motr.transaction_id