DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on MSC_DESIGNATORS

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

333: AND rsi.inventory_item_id = mr.inventory_item_id
334: AND ( NVL(rsi.in_source_plan, 2) <> 1
335: OR
336: mr.transaction_id in (
337: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e
338: where a.schedule_designator_id is not null
339: and a.schedule_designator_id = b.schedule_designator_id
340: and a.organization_id = mr.organization_id
341: and a.organization_id = b.organization_id

Line 788: msc_designators sched

784: var_demand_class,
785: lv_plan_name,
786: lv_auto_release_method
787: FROM msc_plans mp,
788: msc_designators sched
789: WHERE sched.organization_id(+)= mp.organization_id
790: AND sched.designator(+) = mp.compile_designator
791: AND sched.sr_instance_id(+) = mp.sr_instance_id
792: AND mp.plan_id = arg_plan_id;