APPS.EAM_PROCESS_WO_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 7804: from eam_work_order_details

7800: ) then
7801: select pm_suggested_start_date, pm_suggested_end_date into
7802: l_eam_wo_rec.pm_suggested_start_date,
7803: l_eam_wo_rec.pm_suggested_end_date
7804: from eam_work_order_details
7805: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
7806: end if;
7807:
7808: EAM_WO_UTILITY_PVT.PERFORM_WRITES

Line 9740: from EAM_WORK_ORDER_DETAILS

9736: select material_shortage_check_date,
9737: material_shortage_flag
9738: into l_eam_wo_rec.material_shortage_check_date ,
9739: l_eam_wo_rec.material_shortage_flag
9740: from EAM_WORK_ORDER_DETAILS
9741: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
9742: exception
9743: when no_data_found then
9744: null;

Line 9960: Update eam_work_order_details

9956: IF ( l_emp_assignment = TRUE ) THEN
9957:
9958: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Updating assignment details of an employee ') ; END IF ;
9959:
9960: Update eam_work_order_details
9961: set ASSIGNMENT_COMPLETE = EAM_ASSIGN_EMP_PUB.Get_Emp_Assignment_Status(l_eam_wo_rec.wip_entity_id,l_eam_wo_rec.organization_id)
9962: where wip_entity_id = l_eam_wo_rec.wip_entity_id;
9963: END IF;
9964:

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

11688: wdj.status_type,
11689: ewod.workflow_type,
11690: eam_linear_location_id,
11691: owning_department
11692: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod
11693: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11694: AND wdj.maintenance_object_type = 3
11695: AND wdj.maintenance_object_id = cii.instance_id
11696: AND wdj.wip_entity_id = ewod.wip_entity_id(+)

Line 11712: FROM wip_discrete_jobs wdj,eam_work_order_details ewod

11708: wdj.status_type,
11709: ewod.workflow_type,
11710: eam_linear_location_id,
11711: owning_department
11712: FROM wip_discrete_jobs wdj,eam_work_order_details ewod
11713: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11714: AND wdj.maintenance_object_type = 2
11715: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
11716:

Line 11901: UPDATE EAM_WORK_ORDER_DETAILS

11897: x_workflow_process => l_workflow_process
11898: );
11899:
11900: IF(l_approval_required) THEN
11901: UPDATE EAM_WORK_ORDER_DETAILS
11902: SET user_defined_status_id=3,
11903: pending_flag='Y',
11904: last_update_date=SYSDATE,
11905: last_update_login=FND_GLOBAL.login_id,

Line 12986: FROM wip_discrete_jobs wdj,eam_work_order_details ewod

12982: l_asset_number,
12983: l_asset_activity_id,
12984: l_maint_obj_source,
12985: l_workflow_type
12986: FROM wip_discrete_jobs wdj,eam_work_order_details ewod
12987: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
12988: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
12989:
12990: SELECT msi.concatenated_segments