eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_DISCRETE_JOBS

Line 3522: wip_discrete_jobs

3518:
3519: -- create requisitions if the quantity has changed and wo is in released status
3520: -- and item is non-stockable/purchasable item.
3521: select status_type into l_wo_status from
3522: wip_discrete_jobs
3523: where wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3524: and organization_id = l_eam_mat_req_rec.organization_id;
3525:
3526:

Line 4495: wip_discrete_jobs

4491: ELSE
4492:
4493: -- create requisitions if the quantity has changed and wo is in released status
4494: select status_type into l_wo_status from
4495: wip_discrete_jobs
4496: where wip_entity_id = l_eam_direct_items_rec.wip_entity_id
4497: and organization_id = l_eam_direct_items_rec.organization_id;
4498: if l_wo_status = 3
4499: and l_eam_direct_items_rec.auto_request_material = 'Y'

Line 6112: from wip_discrete_jobs where wip_entity_id=l_eam_op_rec.wip_entity_id;

6108: OR l_eam_op_rec.completion_date<>l_old_eam_op_rec.completion_date)) THEN
6109: /*bug 12757636 - for CMRO*/
6110: BEGIN
6111: select source_code into l_source_code
6112: from wip_discrete_jobs where wip_entity_id=l_eam_op_rec.wip_entity_id;
6113: EXCEPTION
6114: WHEN OTHERS THEN
6115: l_source_code:='X';
6116: END;

Line 7220: from wip_discrete_jobs

7216: l_eam_wo_rec.owning_department := FND_API.G_MISS_NUM;
7217: end if;
7218:
7219: select estimation_status into l_estimation_staus
7220: from wip_discrete_jobs
7221: WHERE wip_entity_id=l_eam_wo_rec.wip_entity_id
7222: AND organization_id=l_eam_wo_rec.organization_id;
7223:
7224: if(l_estimation_staus = 7) then

Line 7917: FROM wip_discrete_jobs

7913: (l_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE )) THEN
7914:
7915: /* If the parent WO is complete, disable meter hierarchy and IB hierarchy */
7916: SELECT status_type INTO l_current_status
7917: FROM wip_discrete_jobs
7918: WHERE wip_entity_id = l_eam_wo_rec.parent_wip_entity_id;
7919:
7920: IF (l_current_status in (4, 5, 12) ) THEN
7921:

Line 8310: FROM WIP_DISCRETE_JOBS

8306: END IF;
8307:
8308: SELECT firm_planned_flag
8309: INTO l_firm_planned_flag
8310: FROM WIP_DISCRETE_JOBS
8311: WHERE wip_entity_id = l_wip_entity_id;
8312:
8313: IF(l_firm_planned_flag=1) OR (nvl(l_eam_wo_rec.ds_scheduled_flag,'N')='Y')THEN
8314: --if firm set the scheduled flag as firm

Line 8888: UPDATE WIP_DISCRETE_JOBS

8884: l_eam_wo_rec.date_released := sysdate;
8885: END IF;
8886: END IF; --end of check for date_released is null
8887:
8888: UPDATE WIP_DISCRETE_JOBS
8889: SET date_released = l_eam_wo_rec.date_released,
8890: last_update_date = SYSDATE,
8891: last_updated_by = FND_GLOBAL.User_Id,
8892: last_update_login = FND_GLOBAL.Login_Id

Line 9075: UPDATE WIP_DISCRETE_JOBS

9071:
9072:
9073:
9074: --Set the workorder's estimation status to 'Running' and call online cost estimation API CSTPECEP.Estimate_WorkOrder_Grp
9075: UPDATE WIP_DISCRETE_JOBS
9076: SET estimation_status = 2,
9077: last_update_date = SYSDATE,
9078: last_updated_by = FND_GLOBAL.User_Id,
9079: last_update_login = FND_GLOBAL.Login_Id

Line 9545: from wip_discrete_jobs

9541: end if;
9542:
9543: IF l_wip_entity_id IS NOT NULL THEN
9544: select SCHEDULED_START_DATE into l_wo_old_sch_start_date
9545: from wip_discrete_jobs
9546: where wip_entity_id = l_wip_entity_id;
9547: END IF;
9548:
9549: -- Start with processing of the EAM Work Order Header

Line 10148: from wip_discrete_jobs

10144: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Updating date required columns for WIP_REQUIREMENT_OPERATIONS'); END IF;
10145:
10146: IF l_wip_entity_id IS NOT NULL THEN
10147: select SCHEDULED_START_DATE into l_wo_new_sch_start_date
10148: from wip_discrete_jobs
10149: where wip_entity_id = l_wip_entity_id;
10150: END IF;
10151:
10152: IF l_wo_old_sch_start_date <> l_wo_new_sch_start_date THEN

Line 11475: FROM WIP_DISCRETE_JOBS

11471: --start of populating workorder dates
11472: IF(x_eam_wo_rec.TRANSACTION_TYPE IN (EAM_PROCESS_WO_PUB.G_OPR_CREATE,EAM_PROCESS_WO_PUB.G_OPR_UPDATE)) THEN
11473: SELECT scheduled_start_date,scheduled_completion_date
11474: INTO l_start_date,l_completion_date
11475: FROM WIP_DISCRETE_JOBS
11476: WHERE wip_entity_id=x_eam_wo_rec.wip_entity_id
11477: AND organization_id=x_eam_wo_rec.organization_id;
11478:
11479: x_eam_wo_rec.scheduled_start_date := l_start_date;

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 11744: SELECT last_update_date INTO l_wo_last_update_date1 FROM wip_discrete_jobs WHERE wip_entity_id = l_wip_entity_id FOR UPDATE;

11740: l_org_id := l_eam_wo_comp_rec.organization_id;
11741: l_wip_entity_id := l_eam_wo_comp_rec.wip_entity_id;
11742:
11743: -- for FP bug of bug# 10147896, Capturing WO last_update_date at starting of COMP_UNCOMP_WORKORDER procedure.
11744: SELECT last_update_date INTO l_wo_last_update_date1 FROM wip_discrete_jobs WHERE wip_entity_id = l_wip_entity_id FOR UPDATE;
11745:
11746: OPEN cur_work_order_details;
11747:
11748: FETCH cur_work_order_details INTO

Line 12018: SELECT last_update_date INTO l_wo_last_update_date2 FROM wip_discrete_jobs WHERE wip_entity_id = l_wip_entity_id FOR UPDATE;

12014: end if; -- end of source entity check
12015: END IF;
12016:
12017: -- for FP bug of bug# 10147896, Capturing WO last_update_date just before Writing WO Completion record to database .
12018: SELECT last_update_date INTO l_wo_last_update_date2 FROM wip_discrete_jobs WHERE wip_entity_id = l_wip_entity_id FOR UPDATE;
12019:
12020: IF l_wo_last_update_date1 <> l_wo_last_update_date2
12021: THEN
12022: l_other_message := 'EAM_WO_COMP_WRONG_STATUS';

Line 12217: FROM wip_discrete_jobs wdj,csi_item_instances cii

12213:
12214: SELECT cii.instance_number,cii.instance_id
12215: into l_asset_instance_number,
12216: l_asset_instance_id
12217: FROM wip_discrete_jobs wdj,csi_item_instances cii
12218: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
12219: AND wdj.maintenance_object_type = 3
12220: AND wdj.maintenance_object_id = cii.instance_id
12221: AND cii.serial_number = l_asset_number;

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

Line 13194: FROM wip_discrete_jobs wdj,csi_item_instances cii

13190: IF l_asset_number IS NOT NULL THEN
13191:
13192: SELECT cii.instance_number,cii.instance_id into l_asset_instance_number,
13193: l_asset_instance_id
13194: FROM wip_discrete_jobs wdj,csi_item_instances cii
13195: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
13196: AND wdj.maintenance_object_type = 3
13197: AND wdj.maintenance_object_id = cii.instance_id
13198: AND cii.serial_number = l_asset_number;