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_WORKBENCH_TREE dependencies on EAM_ASSET_EXPLOSION_TEMP_S

Line 28: select eam_asset_explosion_temp_s.nextval

24: l_return_status := 0;
25: l_count_first := 0;
26: l_count_second := 0;
27:
28: select eam_asset_explosion_temp_s.nextval
29: into l_group_id from dual;
30:
31:
32: INSERT INTO eam_asset_explosion_temp(

Line 37: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

33: group_id,
34: asset_group_id,
35: asset_number,
36: low_level_code)
37: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
38: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd
39: WHERE msi.eam_item_type = 1 AND msi.inventory_item_id = cii.inventory_item_id
40: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1
41: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate

Line 69: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

65: group_id,
66: asset_group_id,
67: asset_number,
68: low_level_code)
69: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
70: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,
71: (select * from eam_org_maint_defaults where organization_id = p_org_id) eomd
72: WHERE msi.eam_item_type = 1
73: AND msi.inventory_item_id = cii.inventory_item_id

Line 111: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

107: group_id,
108: asset_group_id,
109: asset_number,
110: low_level_code)
111: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
112: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp
113: WHERE p_instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
114: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id;
115:

Line 129: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

125: group_id,
126: asset_group_id,
127: asset_number,
128: low_level_code)
129: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
130: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp
131: WHERE p_instance_id = mena.network_object_id
132: AND mena.maintenance_object_id = cii.instance_id
133: AND cii.last_vld_organization_id = mp.organization_id

Line 152: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

148: group_id,
149: asset_group_id,
150: asset_number,
151: low_level_code)
152: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
153: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp
154: WHERE ciin.serial_number = p_asset_number AND ciin.inventory_item_id = p_asset_group_id
155: AND ciin.instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
156: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id;

Line 170: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

166: group_id,
167: asset_group_id,
168: asset_number,
169: low_level_code)
170: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
171: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp
172: WHERE ciin.serial_number = p_asset_number
173: AND ciin.inventory_item_id = p_asset_group_id
174: AND ciin.instance_id = mena.network_object_id

Line 271: select eam_asset_explosion_temp_s.nextval

267:
268: begin
269: l_return_status := 0;
270: l_count_first := 0;
271: select eam_asset_explosion_temp_s.nextval
272: into l_group_id from dual;
273:
274: INSERT INTO eam_asset_explosion_temp(
275: group_id,

Line 279: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

275: group_id,
276: asset_group_id,
277: asset_number,
278: low_level_code)
279: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
280: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd
281: WHERE msi.eam_item_type in (1,3) AND msi.inventory_item_id = cii.inventory_item_id
282: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1
283: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate

Line 313: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

309: group_id,
310: asset_group_id,
311: asset_number,
312: low_level_code)
313: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
314: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,
315: (select * from eam_org_maint_defaults where organization_id = p_org_id) eomd
316: WHERE msi.eam_item_type in (1,3) AND msi.inventory_item_id = cii.inventory_item_id
317: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1

Line 350: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

346: group_id,
347: asset_group_id,
348: asset_number,
349: low_level_code)
350: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
351: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp
352: WHERE p_instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
353: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id;
354:

Line 367: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

363: group_id,
364: asset_group_id,
365: asset_number,
366: low_level_code)
367: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
368: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp
369: WHERE p_instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
370: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id <> p_org_id
371: AND EXISTS (SELECT 1

Line 387: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

383: group_id,
384: asset_group_id,
385: asset_number,
386: low_level_code)
387: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
388: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp
389: WHERE ciin.serial_number = p_asset_number AND ciin.inventory_item_id = p_asset_group_id
390: AND ciin.instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
391: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id;

Line 405: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1

401: group_id,
402: asset_group_id,
403: asset_number,
404: low_level_code)
405: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
406: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp
407: WHERE ciin.serial_number = p_asset_number AND ciin.inventory_item_id = p_asset_group_id
408: AND ciin.instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
409: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id <> p_org_id