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 940: -- insert row into wip_discrete_jobs, wip_entities

936:
937:
938: -------------------------------------------------------------------------------
939: -- Creating easy work order
940: -- insert row into wip_discrete_jobs, wip_entities
941: -- create a default operation 10 for the new work order
942: -- release the work order and call wip_change_status.release
943:
944: --anjgupta Changes for IB and Transactable Assets Project in R12

Line 1035: l_row wip_discrete_jobs%ROWTYPE;

1031: l_eam_class VARCHAR2(10);
1032: l_asset_class VARCHAR2(10);
1033: l_auto_firm VARCHAR2(10);
1034:
1035: l_row wip_discrete_jobs%ROWTYPE;
1036: l_entity wip_entities%ROWTYPE;
1037: l_op wip_operations%ROWTYPE;
1038:
1039: l_rowid VARCHAR2(250);

Line 1283: from wip_discrete_jobs wdj,wip_entities we

1279: begin
1280:
1281: select wdj.status_type
1282: into l_orig_wo_status
1283: from wip_discrete_jobs wdj,wip_entities we
1284: where we.wip_entity_id=wdj.wip_entity_id
1285: and we.organization_id=p_organization_id
1286: and wdj.organization_id=p_organization_id
1287: and we.wip_entity_name=p_wip_entity_name;

Line 1715: from wip_entities we, wip_discrete_jobs wdj

1711:
1712: /* select we.wip_entity_id, nvl(wdj.date_released,sysdate),wdj.parent_wip_entity_id,wdj.manual_rebuild_flag */
1713: select we.wip_entity_id,wdj.date_released,wdj.parent_wip_entity_id,wdj.manual_rebuild_flag
1714: into l_wip_entity_updt, l_date_released,l_old_rebuild_source,manual_rebuild_flag
1715: from wip_entities we, wip_discrete_jobs wdj
1716: where we.wip_entity_name = l_wip_entity_name
1717: and we.organization_id = p_organization_id
1718: and we.organization_id = wdj.organization_id
1719: and we.wip_entity_id = wdj.wip_entity_id;

Line 1793: from wip_discrete_jobs

1789: -- # 3436679 code added to prevent the defaulting of the asset activity if user removes it while updating work order
1790:
1791: BEGIN
1792: select primary_item_id,project_id,task_id into l_prev_activity_id,l_prev_project_id,l_prev_task_id
1793: from wip_discrete_jobs
1794: where wip_entity_id = l_workorder_rec.wip_entity_id
1795: and organization_id = l_workorder_rec.organization_id;
1796:
1797: EXCEPTION

Line 2634: FROM wip_discrete_jobs

2630: SELECT last_update_date, status_type, organization_id
2631: , scheduled_completion_date - scheduled_start_date
2632: , p_scheduled_start_date - scheduled_start_date
2633: INTO l_db_last_update_date, l_db_status , l_org_id , l_duration , l_shift
2634: FROM wip_discrete_jobs
2635: WHERE wip_entity_id = p_wip_entity_id
2636: FOR UPDATE;
2637:
2638: IF l_db_last_update_date <> p_stored_last_update_date THEN

Line 2689: update wip_discrete_jobs j

2685: END IF;
2686:
2687: -- call processing logic
2688: BEGIN
2689: update wip_discrete_jobs j
2690: set j.description = p_description
2691: , j.activity_type = p_activity_type
2692: , j.activity_cause = p_activity_cause
2693: , j.owning_department = l_dept_id

Line 2706: update wip_discrete_jobs j

2702: where j.wip_entity_id = p_wip_entity_id;
2703:
2704: if( p_firm_planned_flag = 1 and l_shift <> 0) then -- firm
2705: -- update work order start and completion date
2706: update wip_discrete_jobs j
2707: set j.scheduled_start_date = p_scheduled_start_date
2708: , j.scheduled_completion_date = j.scheduled_completion_date + l_shift
2709: where j.wip_entity_id = p_wip_entity_id;
2710:

Line 2822: from wip_discrete_jobs

2818: l_sched_end_date := p_sched_end_date;
2819: else
2820: select scheduled_start_date, scheduled_completion_date
2821: into l_sched_start_date, l_sched_end_date
2822: from wip_discrete_jobs
2823: where wip_entity_id = p_wip_entity_id;
2824: end if;
2825: x_start_date := l_sched_start_date;
2826: x_end_date := l_sched_end_date; --fixed for #2429880.