DBA Data[Home] [Help]

APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_SYSTEM_ITEMS

Line 2171: FROM msc_system_items

2167: BEGIN
2168: --
2169: SELECT inventory_item_id
2170: INTO sr_item_id
2171: FROM msc_system_items
2172: WHERE sr_inventory_item_id = x_Group_rec.inventory_item_id
2173: AND plan_id = -1
2174: AND organization_id = x_Group_rec.ship_from_org_id
2175: AND sr_instance_id IN (SELECT instance_id FROM mrp_ap_apps_instances);