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 MTL_PARAMETERS

Line 38: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd

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
42: AND msi.organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id

Line 70: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,

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
74: AND msi.organization_id = cii.last_vld_organization_id

Line 112: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp

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:
116: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN

Line 130: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp

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
134: AND mp.maint_organization_id <> p_org_id

Line 153: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp

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;
157:

Line 171: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp

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
175: AND mena.maintenance_object_id = cii.instance_id

Line 280: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd

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
284: AND msi.organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id

Line 314: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,

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
318: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate

Line 351: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp

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:
355: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN

Line 368: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp

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
372: FROM wip_discrete_jobs

Line 388: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp

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;
392:

Line 406: FROM mtl_eam_network_assets mena, csi_item_instances ciin, csi_item_instances cii, mtl_parameters mp

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
410: AND EXISTS (SELECT 1