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 DUAL

Line 280: FROM dual

276: begin
277: begin
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: (

Line 313: FROM DUAL

309: WHERE wdj.wip_entity_id=p_wip_entity_id;
310:
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)

Line 1996: from dual;

1992: -- if service request is specified then insert into eam_wo_service_association
1993: if (l_service_request_id is not null) then
1994: select eam_wo_service_association_s.nextval
1995: into l_service_association_id
1996: from dual;
1997:
1998: --Assign only one service request to a work order
1999:
2000: select count(*)

Line 2325: from dual;

2321: -- if service request is specified then insert into eam_wo_service_association
2322: if (l_service_request_id is not null) then
2323: select eam_wo_service_association_s.nextval
2324: into l_service_association_id
2325: from dual;
2326:
2327: insert into eam_wo_service_association
2328: (
2329: wo_service_entity_assoc_id