APPS.INV_CYC_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2274: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2270: p_sec_system_quantity => l_sec_system_quantity -- nsinghi bug#6052831 Pass sec qty.
2271: );
2272: END IF;
2273:
2274: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2275: SET LOCATOR_ID = l_locator_id
2276: WHERE CYCLE_COUNT_ID = l_cc_entry_id
2277: AND TRANSACTION_SOURCE_ID = l_cc_header_id
2278: AND LOCATOR_ID = -1;

Line 3560: FROM mtl_material_transactions_temp

3556: -- Check to see if a sub transfer record has already been
3557: -- inserted into MMTT for this LPN so that we only do this once
3558: SELECT COUNT ( * )
3559: INTO l_temp_lpn_count
3560: FROM mtl_material_transactions_temp
3561: WHERE transaction_header_id = l_txn_header_id
3562: AND inventory_item_id = -1
3563: AND content_lpn_id = l_lpn_id
3564: AND transaction_source_id = l_cc_header_id

Line 3974: FROM mtl_material_transactions_temp

3970: -- manager to process
3971: IF ( l_commit_status_flag = 1 ) THEN
3972: SELECT COUNT ( * )
3973: INTO l_temp_count
3974: FROM mtl_material_transactions_temp
3975: WHERE transaction_header_id = l_txn_header_id;
3976:
3977: IF ( l_temp_count = 0 ) THEN
3978: IF ( l_debug = 1 ) THEN