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_SERIAL_NUMBERS_TEMP

Line 1953: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq

1949: AND msn.inventory_item_id = p_item_id
1950: AND msn.lpn_id = p_lpn_id
1951: AND NVL(line_mark_id, -999) <> 1
1952: AND NOT EXISTS (SELECT 1
1953: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq
1954: WHERE (msnt.transaction_temp_id = wlq.transaction_temp_id
1955: OR msnt.transaction_temp_id = wlq.serial_transaction_temp_id)
1956: AND msn.serial_number = msnt.fm_serial_number
1957: AND msn.inventory_item_id = wlq.inventory_item_id

Line 1988: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq

1984: AND msn.inventory_item_id = p_item_id
1985: AND msn.lpn_id = p_lpn_id
1986: AND NVL(line_mark_id, -9) <> 1
1987: AND NOT EXISTS (SELECT 1
1988: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq
1989: WHERE (msnt.transaction_temp_id = wlq.transaction_temp_id
1990: OR msnt.transaction_temp_id = wlq.serial_transaction_temp_id)
1991: AND msn.serial_number = msnt.fm_serial_number
1992: AND msn.inventory_item_id = wlq.inventory_item_id

Line 2149: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq

2145: NULL, NULL,
2146: p_organization_id, inventory_item_id,
2147: NULL, NULL, NULL, serial_number, 'S') = 'Y'
2148: AND NOT EXISTS (SELECT 1
2149: FROM mtl_serial_numbers_temp msnt , wms_loaded_quantities_v wlq
2150: WHERE (msnt.transaction_temp_id = wlq.transaction_temp_id
2151: OR msnt.transaction_temp_id = wlq.serial_transaction_temp_id)
2152: AND serial_number = msnt.fm_serial_number
2153: AND msn.inventory_item_id = wlq.inventory_item_id

Line 2477: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2473: , msn.lot_number
2474: , 0
2475: , msn.current_status
2476: , mms.status_code
2477: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2478: WHERE msn.inventory_item_id = p_item_id
2479: AND msn.current_organization_id = p_organization_id
2480: AND msn.current_status = 3
2481: AND msn.current_subinventory_code = p_subinv_code

Line 2501: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2497: , msn.lot_number
2498: , 0
2499: , msn.current_status
2500: , mms.status_code
2501: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2502: WHERE msn.inventory_item_id = p_item_id
2503: AND msn.current_organization_id = p_organization_id
2504: AND msn.current_status = 3
2505: AND msn.current_subinventory_code = p_subinv_code

Line 2759: FROM mtl_serial_numbers_temp

2755: , 0
2756: , 0
2757: , ''
2758: , ''
2759: FROM mtl_serial_numbers_temp
2760: WHERE transaction_temp_id = p_temp_id
2761: ORDER BY LPAD(fm_serial_number, 20);
2762: ELSE
2763: OPEN x_serial_number FOR

Line 2771: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2767: , 0
2768: , 0
2769: , ''
2770: , ''
2771: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2772: WHERE mtlt.transaction_temp_id = p_temp_id
2773: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2774: ORDER BY LPAD(fm_serial_number, 20);
2775: END IF;

Line 2824: FROM mtl_serial_numbers_temp msnt

2820: WHERE mr.reservation_id = msn.reservation_id
2821: AND NVL(mr.staged_flag, 'N') = 'Y')
2822: AND NOT EXISTS (
2823: SELECT 1
2824: FROM mtl_serial_numbers_temp msnt
2825: WHERE msn.serial_number BETWEEN msnt.fm_serial_number
2826: AND msnt.to_serial_number)
2827: )
2828: