APPS.INV_CYC_LOVS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 5160: FROM mtl_serial_numbers_temp s,

5156: IF l_lot_control_code = 1 THEN -- no lot control code
5157: -- just check with msnt
5158: SELECT COUNT ( * )
5159: INTO l_serial_count
5160: FROM mtl_serial_numbers_temp s,
5161: wms_loaded_quantities_v wl
5162: WHERE s.transaction_temp_id = wl.transaction_temp_id
5163: AND wl.inventory_item_id = p_inventory_item_id -- Bug 13652899
5164: AND wl.organization_id = p_organization_id -- Bug 13796753

Line 5177: FROM mtl_serial_numbers_temp s,

5173:
5174: ELSE -- have to join mtlt also
5175: SELECT COUNT ( * )
5176: INTO l_serial_count
5177: FROM mtl_serial_numbers_temp s,
5178: wms_loaded_quantities_v wl,
5179: mtl_transaction_lots_temp l
5180: WHERE wl.transaction_temp_id = l.transaction_temp_id
5181: AND wl.organization_id = p_organization_id -- Bug 13796753

Line 5215: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt,

5211: ELSE
5212:
5213: SELECT Count(DISTINCT msn.serial_number)
5214: INTO l_serial_count
5215: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt,
5216: mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
5217: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
5218: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
5219: mtlt.lot_number is null) or

Line 9196: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl

9192: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9193:
9194: select count(*)
9195: into l_loaded_sys_qty
9196: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl
9197: where ((msnt.transaction_temp_id = wl.transaction_temp_id
9198: and wl.lot_number is null) or
9199: (msnt.transaction_temp_id = wl.serial_transaction_temp_id
9200: and wl.lot_number is not null)

Line 9233: from mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, wms_loaded_quantities_v wl

9229:
9230: --Bug#12645638
9231: SELECT Count(DISTINCT msn.serial_number)
9232: into l_loaded_sys_qty
9233: from mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, wms_loaded_quantities_v wl
9234: where msn.lpn_id = nvl(wl.content_lpn_id,nvl(wl.lpn_id,-1))
9235: AND ((msnt.transaction_temp_id = wl.transaction_temp_id and wl.lot_number is null)
9236: or (msnt.transaction_temp_id = wl.serial_transaction_temp_id and wl.lot_number is not null))
9237: and wl.containerized_flag = 1