APPS.MSC_PHUB_PKG dependencies on MSC_ITEM_SUPPLIERS
Line 1579: from msc_item_suppliers
1575: and sysdate between effective_date and nvl(disable_date, sysdate)
1576: )
1577: ) s,
1578: (select distinct sr_instance_id, organization_id, inventory_item_id, to_number(1) vmi_flag 1579: from msc_item_suppliers 1580: where plan_id=p_plan_id
1581: and vmi_flag=1
1582: ) mis
1583: where i.plan_id=p_plan_id