APPS.MSC_RELEASE_PK dependencies on MSC_DESIGNATORS

Line 313: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e

309: AND rsi.inventory_item_id = mr.inventory_item_id
310: AND ( NVL(rsi.in_source_plan, 2) <> 1
311: OR
312: mr.transaction_id in (
313: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e
314: where a.schedule_designator_id is not null
315: and a.schedule_designator_id = b.schedule_designator_id
316: and a.organization_id = mr.organization_id
317: and a.organization_id = b.organization_id

Line 639: msc_designators sched

635: var_start_date,
636: var_demand_class,
637: lv_plan_name
638: FROM msc_plans mp,
639: msc_designators sched
640: WHERE sched.organization_id(+)= mp.organization_id
641: AND sched.designator(+) = mp.compile_designator
642: AND sched.sr_instance_id(+) = mp.sr_instance_id
643: AND mp.plan_id = arg_plan_id;