APPS.INV_CYC_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2521: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2517: p_sec_system_quantity => l_sec_system_quantity -- nsinghi bug#6052831 Pass sec qty.
2518: );
2519: END IF;
2520:
2521: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2522: SET LOCATOR_ID = l_locator_id
2523: WHERE CYCLE_COUNT_ID = l_cc_entry_id
2524: AND TRANSACTION_SOURCE_ID = l_cc_header_id
2525: AND LOCATOR_ID = -1;

Line 3867: FROM mtl_material_transactions_temp

3863: -- Check to see if a sub transfer record has already been
3864: -- inserted into MMTT for this LPN so that we only do this once
3865: SELECT COUNT ( * )
3866: INTO l_temp_lpn_count
3867: FROM mtl_material_transactions_temp
3868: WHERE transaction_header_id = l_txn_header_id
3869: AND inventory_item_id = -1
3870: AND content_lpn_id = l_lpn_id
3871: AND transaction_source_id = l_cc_header_id

Line 4287: FROM mtl_material_transactions_temp

4283: -- manager to process
4284: IF ( l_commit_status_flag = 1 ) THEN
4285: SELECT COUNT ( * )
4286: INTO l_temp_count
4287: FROM mtl_material_transactions_temp
4288: WHERE transaction_header_id = l_txn_header_id;
4289:
4290: IF ( l_temp_count = 0 ) THEN
4291: IF ( l_debug = 1 ) THEN

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