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.INV_OBJECT_GENEALOGY dependencies on MTL_SYSTEM_ITEMS_VL

Line 87: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln

83: , p_primary_uom
84: , p_inventory_item_id
85: , p_object_number
86: , l_status_id
87: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln
88: WHERE mln.gen_object_id = p_object_id
89: AND mln.inventory_item_id = msivl.inventory_item_id
90: AND mln.organization_id = msivl.organization_id;
91:

Line 157: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn

153: , p_unit_number
154: , p_object_number
155: , p_inventory_item_id
156: , l_status_id
157: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn
158: WHERE msn.gen_object_id = p_object_id
159: AND msn.inventory_item_id = msivl.inventory_item_id
160: AND msn.current_organization_id = msivl.organization_id;
161:

Line 260: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln

256: , p_primary_uom
257: , p_inventory_item_id
258: , p_object_number
259: , l_status_id
260: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln
261: WHERE mln.gen_object_id = p_object_id
262: AND mln.inventory_item_id = msivl.inventory_item_id
263: AND mln.organization_id = msivl.organization_id;
264:

Line 340: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn

336: , x_wip_entity_id
337: , x_operation_seq_num
338: , x_intraoperation_step_type
339: , x_current_lot_number
340: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn
341: WHERE msn.gen_object_id = p_object_id
342: AND msn.inventory_item_id = msivl.inventory_item_id
343: AND msn.current_organization_id = msivl.organization_id;
344: