APPS.MRP_RELEASE_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 166: AND NOT EXISTS ( SELECT 1 FROM bom_operational_routings

162: BUY) = MAKE)
163: OR (msi.purchasing_enabled_flag = 'Y'
164: AND DECODE(mr.source_organization_id, mr.organization_id, MAKE,
165: BUY) = BUY))
166: AND NOT EXISTS ( SELECT 1 FROM bom_operational_routings
167: WHERE assembly_item_id = mr.inventory_item_id
168: AND organization_id = mr.organization_id
169: AND nvl(alternate_routing_designator,'-23453') =
170: nvl(mr.alternate_routing_designator,'-23453')