APPS.INV_CYC_LOVS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 5094: FROM mtl_serial_numbers_temp s,

5090: IF l_lot_control_code = 1 THEN -- no lot control code
5091: -- just check with msnt
5092: SELECT COUNT ( * )
5093: INTO l_serial_count
5094: FROM mtl_serial_numbers_temp s,
5095: wms_loaded_quantities_v wl
5096: WHERE s.transaction_temp_id = wl.transaction_temp_id
5097: AND p_serial_number BETWEEN s.fm_serial_number
5098: AND s.to_serial_number;

Line 5110: FROM mtl_serial_numbers_temp s,

5106: END IF;
5107: ELSE -- have to join mtlt also
5108: SELECT COUNT ( * )
5109: INTO l_serial_count
5110: FROM mtl_serial_numbers_temp s,
5111: wms_loaded_quantities_v wl,
5112: mtl_transaction_lots_temp l
5113: WHERE wl.transaction_temp_id = l.transaction_temp_id
5114: AND s.transaction_temp_id = l.serial_transaction_temp_id

Line 8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl

8967: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
8968:
8969: select count(*)
8970: into l_loaded_sys_qty
8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl
8972: where ((msnt.transaction_temp_id = wl.transaction_temp_id
8973: and wl.lot_number is null) or
8974: (msnt.transaction_temp_id = wl.serial_transaction_temp_id
8975: and wl.lot_number is not null)