DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PWB dependencies on MSC_ITEM_SUPPLIERS

Line 377: msc_item_suppliers mis

373: CURSOR c_supp (l_supplier_id in number) IS
374: SELECT count(*)
375: FROM msc_designators d,
376: msc_plans p,
377: msc_item_suppliers mis
378: WHERE p.organization_id = d.organization_id
379: AND p.sr_instance_id = d.sr_instance_id
380: AND p.compile_designator = d.designator
381: AND p.plan_completion_date IS NOT NULL