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_SYSTEM_ITEMS_VL

Line 2696: 'MTL_SYSTEM_ITEMS_VL'.*/

2692: PROCEDURE get_serial_subxfr_lov(x_serials OUT NOCOPY t_genref, p_current_organization_id IN NUMBER, p_serial_number IN VARCHAR2, p_transaction_type_id IN NUMBER, p_wms_installed IN VARCHAR2) IS
2693: BEGIN
2694: -- For serial triggered subinventory transfer
2695: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
2696: 'MTL_SYSTEM_ITEMS_VL'.*/
2697: OPEN x_serials FOR
2698: SELECT DISTINCT msn.serial_number
2699: , msn.current_subinventory_code
2700: , msn.current_locator_id

Line 2721: , mtl_system_items_vl msiv

2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv
2723: , mtl_secondary_inventories msi
2724: WHERE msn.current_organization_id = p_current_organization_id
2725: AND msn.lpn_id IS NULL