2517: AND wdj.maintenance_object_id = l_instance_id
2518: AND wdj.organization_id = l_organization_id)
2519: OR EXISTS
2520: (SELECT wewr.asset_number
2521: FROM wip_eam_work_requests wewr
2522: WHERE wewr.work_request_status_id not in (5, 6)
2523: AND wewr.organization_id = l_organization_id
2524: AND wewr.maintenance_object_type = 3
2525: AND wewr.maintenance_object_id = l_instance_id);
3096: AND wdj.maintenance_object_id = p_maintenance_object_id
3097: )
3098: OR EXISTS
3099: (SELECT wewr.asset_number
3100: FROM wip_eam_work_requests wewr
3101: WHERE wewr.work_request_status_id not in (5, 6)
3102: AND wewr.maintenance_object_type = 3
3103: AND wewr.maintenance_object_id = p_maintenance_object_id);
3104: exception