APPS.INV_COST_GROUP_UPDATE dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 10: FROM mtl_transaction_lots_temp mtlt

6:
7: CURSOR cur_mtlt (p_transaction_temp_id NUMBER) IS
8: SELECT mtlt.ROWID mtlt_rowid,
9: mtlt.*
10: FROM mtl_transaction_lots_temp mtlt
11: WHERE mtlt.transaction_temp_id = p_transaction_temp_id;
12:
13: CURSOR cur_msnt(cp_transaction_temp_id NUMBER) IS
14: SELECT msnt.* ,

Line 216: UPDATE mtl_transaction_lots_temp

212: END IF;
213:
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: UPDATE mtl_transaction_lots_temp
217: SET
218: transaction_temp_id = p_new_transaction_temp_id,
219: lot_number = Nvl(p_lot_number, lot_number),
220: primary_quantity = Nvl(p_primary_quantity, primary_quantity),

Line 596: mtl_transaction_lots_temp mtlt

592: -- Lot control
593: Select cost_group_id INTO x_cost_group_id FROM (
594: SELECT mmtt.cost_group_id
595: FROM mtl_material_transactions_temp mmtt,
596: mtl_transaction_lots_temp mtlt
597: WHERE mmtt.transfer_organization = p_organization_id
598: AND mmtt.transfer_subinventory = p_subinventory_code
599: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
600: AND mmtt.inventory_item_id = p_inventory_item_id

Line 612: mtl_transaction_lots_temp mtlt

608: UNION
609:
610: SELECT mmtt.cost_group_id
611: FROM mtl_material_transactions_temp mmtt,
612: mtl_transaction_lots_temp mtlt
613: WHERE mmtt.organization_id = p_organization_id
614: AND mmtt.subinventory_code = p_subinventory_code
615: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
616: AND mmtt.inventory_item_id = p_inventory_item_id

Line 691: mtl_transaction_lots_temp mtlt,

687: -- Lot and serial control
688: Select cost_group_id INTO x_cost_group_id FROM (
689: SELECT mmtt.cost_group_id
690: FROM mtl_material_transactions_temp mmtt,
691: mtl_transaction_lots_temp mtlt,
692: mtl_serial_numbers_temp msnt
693: WHERE mmtt.transfer_organization = p_organization_id
694: AND mmtt.transfer_subinventory = p_subinventory_code
695: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)

Line 711: mtl_transaction_lots_temp mtlt,

707: UNION
708:
709: SELECT mmtt.cost_group_id
710: FROM mtl_material_transactions_temp mmtt,
711: mtl_transaction_lots_temp mtlt,
712: mtl_serial_numbers_temp msnt
713: WHERE mmtt.organization_id = p_organization_id
714: AND mmtt.subinventory_code = p_subinventory_code
715: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)

Line 1248: INSERT INTO mtl_transaction_lots_temp

1244: print_debug( 'proc_insert_mtlt ..p_new_serial_trx_temp_id: '|| p_new_serial_trx_temp_id );
1245: print_debug( 'proc_insert_mtlt ..RowId : '|| p_mtlt_rec.mtlt_RowId );
1246: END IF;
1247:
1248: INSERT INTO mtl_transaction_lots_temp
1249: ( TRANSACTION_TEMP_ID
1250: ,LAST_UPDATE_DATE
1251: ,LAST_UPDATED_BY
1252: ,CREATION_DATE

Line 4059: FROM mtl_transaction_lots_temp

4055: IF l_mmtt_rec.lot_number IS NULL THEN
4056: BEGIN
4057: SELECT lot_number
4058: INTO l_lot_number
4059: FROM mtl_transaction_lots_temp
4060: WHERE transaction_temp_id = l_mmtt_rec.transaction_temp_id;
4061: IF (l_debug = 1) THEN
4062: print_debug('Lot number from MTLT: ' || l_lot_number);
4063: END IF;