APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on BOM_OPERATIONAL_ROUTINGS

Line 311: and exists ( select 1 from bom_operational_routings

307: where query_id = g_rec_query_id)
308: and mr.order_type =5
309: and mr.source_vendor_id is null
310: and mr.organization_id = nvl(mr.source_organization_id,mr.organization_id)
311: and exists ( select 1 from bom_operational_routings
312: where assembly_item_id = mr.inventory_item_id
313: and organization_id = mr.organization_id
314: and nvl(alternate_routing_designator,'-23453') =
315: nvl(mr.alternate_routing_designator,'-23453')