DBA Data[Home] [Help]

APPS.MSC_WS_OTM_BPEL dependencies on MSC_DESIGNATORS

Line 414: FROM msc_plans plans, msc_designators desig

410: order_type IN NUMBER,
411: status OUT nocopy varchar2) IS
412: cursor getProductionPlans is
413: SELECT plans.plan_id
414: FROM msc_plans plans, msc_designators desig
415: WHERE plans.curr_plan_type in (1,2,3,5)
416: AND plans.organization_id = desig.organization_id
417: AND plans.sr_instance_id = desig.sr_instance_id
418: AND plans.compile_designator = desig.designator