APPS.EAM_ASSETNUMBER_PUB dependencies on WIP_EAM_WORK_REQUESTS
Line 879: FROM wip_eam_work_requests wewr
875: AND wdj.maintenance_object_type = 3
876: AND wdj.organization_id = l_org)
877: OR EXISTS
878: (SELECT wewr.asset_number 879: FROM wip_eam_work_requests wewr 880: WHERE wewr.work_request_status_id not in (5, 6)
881: AND wewr.organization_id = l_org
882: AND wewr.maintenance_object_id = l_instance_id
883: AND wewr.maintenance_object_type = 3);