APPS.EAM_ASSETNUMBER_PUB dependencies on WIP_EAM_WORK_REQUESTS

Line 911: FROM wip_eam_work_requests wewr

907: AND wdj.maintenance_object_type = 3
908: AND wdj.organization_id = l_org)
909: OR EXISTS
910: (SELECT wewr.asset_number
911: FROM wip_eam_work_requests wewr
912: WHERE wewr.work_request_status_id not in (4, 5, 6)
913: AND wewr.organization_id = l_org
914: AND wewr.maintenance_object_id = l_instance_id
915: AND wewr.maintenance_object_type = 3);