DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_SINGLE_LVL_PEG

Line 3040: from msc_supplies ms, msc_single_lvl_peg mslp

3036: END IF;
3037:
3038: update mrp_org_transfer_release motr
3039: set earliest_ship_date = (select max(ms.new_schedule_date)
3040: from msc_supplies ms, msc_single_lvl_peg mslp
3041: where ms.plan_id=l_arg_plan_id
3042: and ms.transaction_id = mslp.child_id
3043: and ms.plan_id= mslp.plan_id
3044: and mslp.parent_id = motr.transaction_id

Line 3263: from msc_part_supplies ms, msc_single_lvl_peg mslp

3259: END IF;
3260:
3261: /* update mrp_org_transfer_release motr
3262: set earliest_ship_date = (select max(ms.new_schedule_date)
3263: from msc_part_supplies ms, msc_single_lvl_peg mslp
3264: where ms.plan_id=l_arg_plan_id
3265: and ms.transaction_id = mslp.child_id
3266: and ms.plan_id= mslp.plan_id
3267: and mslp.parent_id = motr.transaction_id