DBA Data[Home] [Help]

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