APPS.EAM_PROCESS_WO_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 7378: from eam_work_order_details

7374: ) then
7375: select pm_suggested_start_date, pm_suggested_end_date into
7376: l_eam_wo_rec.pm_suggested_start_date,
7377: l_eam_wo_rec.pm_suggested_end_date
7378: from eam_work_order_details
7379: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
7380: end if;
7381:
7382: EAM_WO_UTILITY_PVT.PERFORM_WRITES

Line 9144: from EAM_WORK_ORDER_DETAILS

9140: select material_shortage_check_date,
9141: material_shortage_flag
9142: into l_eam_wo_rec.material_shortage_check_date ,
9143: l_eam_wo_rec.material_shortage_flag
9144: from EAM_WORK_ORDER_DETAILS
9145: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
9146: exception
9147: when no_data_found then
9148: null;

Line 9359: Update eam_work_order_details

9355: IF ( l_emp_assignment = TRUE ) THEN
9356:
9357: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating assignment details of an employee ') ; END IF ;
9358:
9359: Update eam_work_order_details
9360: set ASSIGNMENT_COMPLETE = EAM_ASSIGN_EMP_PUB.Get_Emp_Assignment_Status(l_eam_wo_rec.wip_entity_id,l_eam_wo_rec.organization_id)
9361: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
9362: END IF;
9363:

Line 11074: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod

11070: wdj.status_type,
11071: ewod.workflow_type,
11072: eam_linear_location_id,
11073: owning_department
11074: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod
11075: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11076: AND wdj.maintenance_object_type = 3
11077: AND wdj.maintenance_object_id = cii.instance_id
11078: AND wdj.wip_entity_id = ewod.wip_entity_id(+)

Line 11094: FROM wip_discrete_jobs wdj,eam_work_order_details ewod

11090: wdj.status_type,
11091: ewod.workflow_type,
11092: eam_linear_location_id,
11093: owning_department
11094: FROM wip_discrete_jobs wdj,eam_work_order_details ewod
11095: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11096: AND wdj.maintenance_object_type = 2
11097: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
11098:

Line 11280: UPDATE EAM_WORK_ORDER_DETAILS

11276: x_workflow_process => l_workflow_process
11277: );
11278:
11279: IF(l_approval_required) THEN
11280: UPDATE EAM_WORK_ORDER_DETAILS
11281: SET user_defined_status_id=3,
11282: pending_flag='Y',
11283: last_update_date=SYSDATE,
11284: last_update_login=FND_GLOBAL.login_id,

Line 12316: FROM wip_discrete_jobs wdj,eam_work_order_details ewod

12312: l_asset_number,
12313: l_asset_activity_id,
12314: l_maint_obj_source,
12315: l_workflow_type
12316: FROM wip_discrete_jobs wdj,eam_work_order_details ewod
12317: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
12318: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
12319:
12320: SELECT msi.concatenated_segments