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_WORKORDERS_JSP dependencies on WIP_DISCRETE_JOBS

Line 282: FROM wip_discrete_jobs

278: SELECT '1'
279: INTO network_child_job_var
280: FROM dual
281: WHERE EXISTS (SELECT '1'
282: FROM wip_discrete_jobs
283: WHERE wip_entity_id IN
284: (
285: SELECT DISTINCT child_object_id
286: FROM eam_wo_relationships

Line 308: FROM WIP_DISCRETE_JOBS wdj

304: else
305: begin
306: SELECT decode(wdj.status_type,3,1,0)
307: INTO wo_released
308: FROM WIP_DISCRETE_JOBS wdj
309: WHERE wdj.wip_entity_id=p_wip_entity_id;
310:
311: SELECT '1'
312: INTO dependent_rel

Line 315: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj

311: SELECT '1'
312: INTO dependent_rel
313: FROM DUAL
314: WHERE EXISTS (SELECT ewr.child_object_id
315: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj
316: WHERE ewr.parent_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
317: AND wdj.wip_entity_id=ewr.child_object_id AND (wo_released=1 OR wdj.status_type=3)
318: UNION
319: SELECT ewr.parent_object_id

Line 320: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj

316: WHERE ewr.parent_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
317: AND wdj.wip_entity_id=ewr.child_object_id AND (wo_released=1 OR wdj.status_type=3)
318: UNION
319: SELECT ewr.parent_object_id
320: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj
321: WHERE ewr.child_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
322: AND wdj.wip_entity_id=ewr.parent_object_id AND (wo_released=1 OR wdj.status_type=3)
323: );
324: exception

Line 467: FROM wip_discrete_jobs

463: -- using last_update_date as indicator
464: BEGIN
465: SELECT last_update_date, status_type, shutdown_type
466: INTO l_db_last_update_date, l_db_status , l_shutdown_type
467: FROM wip_discrete_jobs
468: WHERE wip_entity_id = p_wip_entity_id
469: FOR UPDATE;
470:
471: IF l_db_last_update_date <> p_stored_last_update_date THEN

Line 920: -- insert row into wip_discrete_jobs, wip_entities

916:
917:
918: -------------------------------------------------------------------------------
919: -- Creating easy work order
920: -- insert row into wip_discrete_jobs, wip_entities
921: -- create a default operation 10 for the new work order
922: -- release the work order and call wip_change_status.release
923:
924: --anjgupta Changes for IB and Transactable Assets Project in R12

Line 1014: l_row wip_discrete_jobs%ROWTYPE;

1010: l_eam_class VARCHAR2(10);
1011: l_asset_class VARCHAR2(10);
1012: l_auto_firm VARCHAR2(10);
1013:
1014: l_row wip_discrete_jobs%ROWTYPE;
1015: l_entity wip_entities%ROWTYPE;
1016: l_op wip_operations%ROWTYPE;
1017:
1018: l_rowid VARCHAR2(250);

Line 1252: from wip_discrete_jobs wdj,wip_entities we

1248: begin
1249:
1250: select wdj.status_type
1251: into l_orig_wo_status
1252: from wip_discrete_jobs wdj,wip_entities we
1253: where we.wip_entity_id=wdj.wip_entity_id
1254: and we.organization_id=p_organization_id
1255: and wdj.organization_id=p_organization_id
1256: and we.wip_entity_name=p_wip_entity_name;

Line 1684: from wip_entities we, wip_discrete_jobs wdj

1680:
1681: /* select we.wip_entity_id, nvl(wdj.date_released,sysdate),wdj.parent_wip_entity_id,wdj.manual_rebuild_flag */
1682: select we.wip_entity_id,wdj.date_released,wdj.parent_wip_entity_id,wdj.manual_rebuild_flag
1683: into l_wip_entity_updt, l_date_released,l_old_rebuild_source,manual_rebuild_flag
1684: from wip_entities we, wip_discrete_jobs wdj
1685: where we.wip_entity_name = l_wip_entity_name
1686: and we.organization_id = p_organization_id
1687: and we.organization_id = wdj.organization_id
1688: and we.wip_entity_id = wdj.wip_entity_id;

Line 1762: from wip_discrete_jobs

1758: -- # 3436679 code added to prevent the defaulting of the asset activity if user removes it while updating work order
1759:
1760: BEGIN
1761: select primary_item_id,project_id,task_id into l_prev_activity_id,l_prev_project_id,l_prev_task_id
1762: from wip_discrete_jobs
1763: where wip_entity_id = l_workorder_rec.wip_entity_id
1764: and organization_id = l_workorder_rec.organization_id;
1765:
1766: EXCEPTION

Line 2603: FROM wip_discrete_jobs

2599: SELECT last_update_date, status_type, organization_id
2600: , scheduled_completion_date - scheduled_start_date
2601: , p_scheduled_start_date - scheduled_start_date
2602: INTO l_db_last_update_date, l_db_status , l_org_id , l_duration , l_shift
2603: FROM wip_discrete_jobs
2604: WHERE wip_entity_id = p_wip_entity_id
2605: FOR UPDATE;
2606:
2607: IF l_db_last_update_date <> p_stored_last_update_date THEN

Line 2658: update wip_discrete_jobs j

2654: END IF;
2655:
2656: -- call processing logic
2657: BEGIN
2658: update wip_discrete_jobs j
2659: set j.description = p_description
2660: , j.activity_type = p_activity_type
2661: , j.activity_cause = p_activity_cause
2662: , j.owning_department = l_dept_id

Line 2675: update wip_discrete_jobs j

2671: where j.wip_entity_id = p_wip_entity_id;
2672:
2673: if( p_firm_planned_flag = 1 and l_shift <> 0) then -- firm
2674: -- update work order start and completion date
2675: update wip_discrete_jobs j
2676: set j.scheduled_start_date = p_scheduled_start_date
2677: , j.scheduled_completion_date = j.scheduled_completion_date + l_shift
2678: where j.wip_entity_id = p_wip_entity_id;
2679:

Line 2791: from wip_discrete_jobs

2787: l_sched_end_date := p_sched_end_date;
2788: else
2789: select scheduled_start_date, scheduled_completion_date
2790: into l_sched_start_date, l_sched_end_date
2791: from wip_discrete_jobs
2792: where wip_entity_id = p_wip_entity_id;
2793: end if;
2794: x_start_date := l_sched_start_date;
2795: x_end_date := l_sched_end_date; --fixed for #2429880.