APPS.EAM_PROCESS_WO_PVT dependencies on WIP_DISCRETE_JOBS

Line 3501: wip_discrete_jobs

3497:
3498: -- create requisitions if the quantity has changed and wo is in released status
3499: -- and item is non-stockable/purchasable item.
3500: select status_type into l_wo_status from
3501: wip_discrete_jobs
3502: where wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3503: and organization_id = l_eam_mat_req_rec.organization_id;
3504:
3505:

Line 4380: wip_discrete_jobs

4376: ELSE
4377:
4378: -- create requisitions if the quantity has changed and wo is in released status
4379: select status_type into l_wo_status from
4380: wip_discrete_jobs
4381: where wip_entity_id = l_eam_direct_items_rec.wip_entity_id
4382: and organization_id = l_eam_direct_items_rec.organization_id;
4383: if l_wo_status = 3
4384: and l_eam_direct_items_rec.auto_request_material = 'Y'

Line 7491: FROM wip_discrete_jobs

7487: (l_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE )) THEN
7488:
7489: /* If the parent WO is complete, disable meter hierarchy and IB hierarchy */
7490: SELECT status_type INTO l_current_status
7491: FROM wip_discrete_jobs
7492: WHERE wip_entity_id = l_eam_wo_rec.parent_wip_entity_id;
7493:
7494: IF (l_current_status in (4, 5, 12) ) THEN
7495:

Line 7884: FROM WIP_DISCRETE_JOBS

7880: END IF;
7881:
7882: SELECT firm_planned_flag
7883: INTO l_firm_planned_flag
7884: FROM WIP_DISCRETE_JOBS
7885: WHERE wip_entity_id = l_wip_entity_id;
7886:
7887: IF(l_firm_planned_flag=1) OR (nvl(l_eam_wo_rec.ds_scheduled_flag,'N')='Y')THEN
7888: --if firm set the scheduled flag as firm

Line 8339: UPDATE WIP_DISCRETE_JOBS

8335: l_eam_wo_rec.date_released := sysdate;
8336: END IF;
8337: END IF; --end of check for date_released is null
8338:
8339: UPDATE WIP_DISCRETE_JOBS
8340: SET date_released = l_eam_wo_rec.date_released,
8341: last_update_date = SYSDATE,
8342: last_updated_by = FND_GLOBAL.User_Id,
8343: last_update_login = FND_GLOBAL.Login_Id

Line 8525: UPDATE WIP_DISCRETE_JOBS

8521:
8522:
8523:
8524: --Set the workorder's estimation status to 'Running' and call online cost estimation API CSTPECEP.Estimate_WorkOrder_Grp
8525: UPDATE WIP_DISCRETE_JOBS
8526: SET estimation_status = 2,
8527: last_update_date = SYSDATE,
8528: last_updated_by = FND_GLOBAL.User_Id,
8529: last_update_login = FND_GLOBAL.Login_Id

Line 8983: from wip_discrete_jobs

8979: end if;
8980:
8981: IF l_wip_entity_id IS NOT NULL THEN
8982: select SCHEDULED_START_DATE into l_wo_old_sch_start_date
8983: from wip_discrete_jobs
8984: where wip_entity_id = l_wip_entity_id;
8985: END IF;
8986:
8987: -- Start with processing of the EAM Work Order Header

Line 9542: from wip_discrete_jobs

9538: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating date required columns for WIP_REQUIREMENT_OPERATIONS'); END IF;
9539:
9540: IF l_wip_entity_id IS NOT NULL THEN
9541: select SCHEDULED_START_DATE into l_wo_new_sch_start_date
9542: from wip_discrete_jobs
9543: where wip_entity_id = l_wip_entity_id;
9544: END IF;
9545:
9546: IF l_wo_old_sch_start_date <> l_wo_new_sch_start_date THEN

Line 10867: FROM WIP_DISCRETE_JOBS

10863: --start of populating workorder dates
10864: IF(x_eam_wo_rec.TRANSACTION_TYPE IN (EAM_PROCESS_WO_PUB.G_OPR_CREATE,EAM_PROCESS_WO_PUB.G_OPR_UPDATE)) THEN
10865: SELECT scheduled_start_date,scheduled_completion_date
10866: INTO l_start_date,l_completion_date
10867: FROM WIP_DISCRETE_JOBS
10868: WHERE wip_entity_id=x_eam_wo_rec.wip_entity_id
10869: AND organization_id=x_eam_wo_rec.organization_id;
10870:
10871: x_eam_wo_rec.scheduled_start_date := l_start_date;

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 11584: FROM wip_discrete_jobs wdj,csi_item_instances cii

11580:
11581: SELECT cii.instance_number,cii.instance_id
11582: into l_asset_instance_number,
11583: l_asset_instance_id
11584: FROM wip_discrete_jobs wdj,csi_item_instances cii
11585: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11586: AND wdj.maintenance_object_type = 3
11587: AND wdj.maintenance_object_id = cii.instance_id
11588: AND cii.serial_number = l_asset_number;

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

Line 12524: FROM wip_discrete_jobs wdj,csi_item_instances cii

12520: IF l_asset_number IS NOT NULL THEN
12521:
12522: SELECT cii.instance_number,cii.instance_id into l_asset_instance_number,
12523: l_asset_instance_id
12524: FROM wip_discrete_jobs wdj,csi_item_instances cii
12525: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
12526: AND wdj.maintenance_object_type = 3
12527: AND wdj.maintenance_object_id = cii.instance_id
12528: AND cii.serial_number = l_asset_number;