APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_SERIAL_NUMBERS_TEMP

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

2386: , msn.lot_number
2387: , 0
2388: , msn.current_status
2389: , mms.status_code
2390: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2391: WHERE msn.inventory_item_id = p_item_id
2392: AND msn.current_organization_id = p_organization_id
2393: AND msn.current_status = 3
2394: AND msn.current_subinventory_code = p_subinv_code

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

2410: , msn.lot_number
2411: , 0
2412: , msn.current_status
2413: , mms.status_code
2414: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2415: WHERE msn.inventory_item_id = p_item_id
2416: AND msn.current_organization_id = p_organization_id
2417: AND msn.current_status = 3
2418: AND msn.current_subinventory_code = p_subinv_code

Line 2672: FROM mtl_serial_numbers_temp

2668: , 0
2669: , 0
2670: , ''
2671: , ''
2672: FROM mtl_serial_numbers_temp
2673: WHERE transaction_temp_id = p_temp_id
2674: ORDER BY LPAD(fm_serial_number, 20);
2675: ELSE
2676: OPEN x_serial_number FOR

Line 2684: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2680: , 0
2681: , 0
2682: , ''
2683: , ''
2684: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2685: WHERE mtlt.transaction_temp_id = p_temp_id
2686: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2687: ORDER BY LPAD(fm_serial_number, 20);
2688: END IF;

Line 2737: FROM mtl_serial_numbers_temp msnt

2733: WHERE mr.reservation_id = msn.reservation_id
2734: AND NVL(mr.staged_flag, 'N') = 'Y')
2735: AND NOT EXISTS (
2736: SELECT 1
2737: FROM mtl_serial_numbers_temp msnt
2738: WHERE msn.serial_number BETWEEN msnt.fm_serial_number
2739: AND msnt.to_serial_number)
2740: )
2741: