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 2783: 'MTL_SYSTEM_ITEMS_VL'.*/

2779: 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
2780: BEGIN
2781: -- For serial triggered subinventory transfer
2782: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
2783: 'MTL_SYSTEM_ITEMS_VL'.*/
2784: OPEN x_serials FOR
2785: SELECT DISTINCT msn.serial_number
2786: , msn.current_subinventory_code
2787: , msn.current_locator_id

Line 2808: , mtl_system_items_vl msiv

2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv
2810: , mtl_secondary_inventories msi
2811: WHERE msn.current_organization_id = p_current_organization_id
2812: AND msn.lpn_id IS NULL