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_UI_ITEM_ATT_LOVS dependencies on MTL_PHYSICAL_INVENTORY_TAGS

Line 839: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms

835: , msn.lot_number
836: , 0
837: , msn.current_status
838: , mms.status_code
839: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms
840: WHERE msn.inventory_item_id = p_inventory_item_id
841: AND (msn.group_mark_id IS NULL
842: OR msn.group_mark_id = -1
843: )

Line 977: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms

973: , msn.lot_number
974: , 0
975: , msn.current_status
976: , mms.status_code
977: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms
978: WHERE msn.inventory_item_id = p_inventory_item_id
979: AND (msn.group_mark_id IS NULL
980: OR msn.group_mark_id = -1
981: )

Line 1088: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

1084: , msn.lpn_id
1085: , wlpn.license_plate_number
1086: , msn.current_status
1087: , msik.primary_uom_code
1088: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1089: WHERE (msn.group_mark_id IS NULL
1090: OR msn.group_mark_id = -1
1091: )
1092: AND msn.current_organization_id = p_organization_id