588: WHERE tmp.AssemblyItemName = P_assembly_item_name
589: AND tmp.OrganizationCode = P_organization_code
590: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
591: AND EXISTS (SELECT 1
592: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
593: bom_operational_routings rtg,
594: BOM_OPERATION_SEQUENCES oper,
595: mtl_parameters org,
596: mtl_system_items_kfv item
659: WHERE tmp.AssemblyItemName = P_assembly_item_name
660: AND tmp.OrganizationCode = P_organization_code
661: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
662: AND NOT EXISTS (SELECT 1
663: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
664: bom_operational_routings rtg,
665: BOM_OPERATION_SEQUENCES oper,
666: mtl_parameters org,
667: mtl_system_items_kfv item