APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on WIP_DISCRETE_JOBS

Line 176: FROM wip_discrete_jobs

172:
173: BEGIN
174: SELECT maintenance_object_id, maintenance_object_type, owning_department, organization_id
175: INTO l_object_id , l_object_type , l_department_id , l_organization_id
176: FROM wip_discrete_jobs
177: WHERE wip_entity_id = l_eam_failure_entry_record.source_id;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

Line 469: FROM WIP_DISCRETE_JOBS

465:
466: BEGIN
467: SELECT owning_department , organization_id
468: INTO l_department_id , l_organization_id
469: FROM WIP_DISCRETE_JOBS
470: WHERE wip_entity_id = l_source_id;
471: EXCEPTION
472: WHEN NO_DATA_FOUND THEN
473: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

Line 727: FROM wip_discrete_jobs wdj, eam_work_order_details edw

723:
724: BEGIN
725: SELECT wdj.date_completed, nvl(edw.failure_code_required, 'N')
726: INTO l_date_completed , l_failure_code_required
727: FROM wip_discrete_jobs wdj, eam_work_order_details edw
728: WHERE wdj.wip_entity_id = edw.wip_entity_id
729: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN