DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 2522: FROM wip_eam_work_requests wewr

2518: AND wdj.maintenance_object_id = l_instance_id
2519: AND wdj.organization_id = l_organization_id)
2520: OR EXISTS
2521: (SELECT wewr.asset_number
2522: FROM wip_eam_work_requests wewr
2523: WHERE wewr.work_request_status_id not in (5, 6)
2524: AND wewr.organization_id = l_organization_id
2525: AND wewr.maintenance_object_type = 3
2526: AND wewr.maintenance_object_id = l_instance_id);

Line 3242: FROM wip_eam_work_requests wewr

3238: AND wdj.maintenance_object_id = p_maintenance_object_id
3239: )
3240: OR EXISTS
3241: (SELECT wewr.asset_number
3242: FROM wip_eam_work_requests wewr
3243: WHERE wewr.work_request_status_id not in (5, 6)
3244: AND wewr.maintenance_object_type = 3
3245: AND wewr.maintenance_object_id = p_maintenance_object_id);
3246: exception