APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 49: FROM wip_discrete_jobs

45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual start date'); END IF;
46:
47: SELECT status_type,shutdown_type
48: INTO l_status_type,l_shutdown_type
49: FROM wip_discrete_jobs
50: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
51:
52: IF p_eam_wo_comp_rec.actual_start_date IS NULL
53: THEN

Line 222: FROM wip_discrete_jobs wdj,csi_item_instances cii

218: l_inventory_item_id NUMBER;
219:
220: CURSOR cur_work_order_details IS
221: SELECT cii.inventory_item_id
222: FROM wip_discrete_jobs wdj,csi_item_instances cii
223: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
224: AND wdj.maintenance_object_type = 3
225: AND wdj.maintenance_object_id = cii.instance_id
226: UNION

Line 228: FROM wip_discrete_jobs wdj

224: AND wdj.maintenance_object_type = 3
225: AND wdj.maintenance_object_id = cii.instance_id
226: UNION
227: SELECT wdj.maintenance_object_id
228: FROM wip_discrete_jobs wdj
229: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
230: AND wdj.maintenance_object_type = 2;
231:
232: BEGIN

Line 247: FROM wip_discrete_jobs

243: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
244:
245: SELECT maintenance_object_type
246: INTO l_maintenance_object_type
247: FROM wip_discrete_jobs
248: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
249:
250: OPEN cur_work_order_details;
251: FETCH cur_work_order_details into l_inventory_item_id;

Line 507: FROM wip_discrete_jobs wdj,

503: l_completion_info := 0;
504:
505: IF l_maintenance_object_type = 2 THEN
506: SELECT count(*) into l_count
507: FROM wip_discrete_jobs wdj,
508: mtl_system_items_b msib
509: WHERE wdj.organization_id = msib.organization_id
510: AND wdj.maintenance_object_id = msib.inventory_item_id
511: AND wdj.organization_id = p_eam_wo_comp_rec.organization_id

Line 522: FROM wip_discrete_jobs wdj,

518: END IF;
519: IF l_maintenance_object_type = 3 THEN
520:
521: SELECT count(*) into l_count
522: FROM wip_discrete_jobs wdj,
523: csi_item_instances cii
524: WHERE wdj.organization_id = cii.last_vld_organization_id
525: AND wdj.maintenance_object_id = cii.instance_id
526: AND wdj.organization_id = p_eam_wo_comp_rec.organization_id

Line 536: FROM wip_discrete_jobs wdj,

532: SELECT cii.serial_number ,
533: msn.current_status
534: INTO l_serial_number ,
535: l_serial_status
536: FROM wip_discrete_jobs wdj,
537: csi_item_instances cii,
538: mtl_serial_numbers msn
539: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
540: AND wdj.maintenance_object_type = 3

Line 804: FROM wip_discrete_jobs wdj, wip_entities we

800: SELECT '1'
801: INTO child_job_var
802: FROM dual
803: WHERE EXISTS (SELECT '1'
804: FROM wip_discrete_jobs wdj, wip_entities we
805: WHERE wdj.wip_entity_id = we.wip_entity_id
806: AND wdj.parent_wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
807: AND wdj.manual_rebuild_flag = 'Y'
808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

Line 877: FROM wip_discrete_jobs

873: SELECT '1'
874: INTO network_child_job_var
875: FROM dual
876: WHERE EXISTS ( SELECT '1'
877: FROM wip_discrete_jobs
878: WHERE wip_entity_id IN
879: (
880: SELECT DISTINCT child_object_id
881: FROM eam_wo_relationships

Line 926: FROM wip_discrete_jobs

922: SELECT '1'
923: INTO sibling_parent_job_var
924: FROM dual
925: WHERE EXISTS (SELECT '1'
926: FROM wip_discrete_jobs
927: WHERE wip_entity_id IN
928: (
929: SELECT DISTINCT parent_object_id
930: FROM eam_wo_relationships

Line 970: FROM WIP_DISCRETE_JOBS

966: SELECT manual_rebuild_flag,
967: parent_wip_entity_id
968: INTO l_manual_rebuild_flag,
969: l_parent_wip_entity_id
970: FROM WIP_DISCRETE_JOBS
971: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
972:
973: IF l_manual_rebuild_flag = 'Y' and l_parent_wip_entity_id IS NOT NULL THEN
974: SELECT status_type

Line 976: FROM WIP_DISCRETE_JOBS

972:
973: IF l_manual_rebuild_flag = 'Y' and l_parent_wip_entity_id IS NOT NULL THEN
974: SELECT status_type
975: INTO l_parent_status_type
976: FROM WIP_DISCRETE_JOBS
977: WHERE wip_entity_id = l_parent_wip_entity_id;
978:
979: IF(l_parent_status_type = WIP_CONSTANTS.COMP_CHRG) THEN
980: raise fnd_api.g_exc_unexpected_error;