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 776: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms

772: , msn.lot_number
773: , 0
774: , msn.current_status
775: , mms.status_code
776: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms
777: WHERE msn.inventory_item_id = p_inventory_item_id
778: AND (msn.group_mark_id IS NULL
779: OR msn.group_mark_id = -1
780: )

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

910: , msn.lot_number
911: , 0
912: , msn.current_status
913: , mms.status_code
914: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_material_statuses_tl mms
915: WHERE msn.inventory_item_id = p_inventory_item_id
916: AND (msn.group_mark_id IS NULL
917: OR msn.group_mark_id = -1
918: )

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

1021: , msn.lpn_id
1022: , wlpn.license_plate_number
1023: , msn.current_status
1024: , msik.primary_uom_code
1025: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1026: WHERE (msn.group_mark_id IS NULL
1027: OR msn.group_mark_id = -1
1028: )
1029: AND msn.current_organization_id = p_organization_id