APPS.INV_COST_GROUP_UPDATE dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 16: FROM mtl_serial_numbers_temp msnt

12:
13: CURSOR cur_msnt(cp_transaction_temp_id NUMBER) IS
14: SELECT msnt.* ,
15: msnt.ROWID msnt_rowid
16: FROM mtl_serial_numbers_temp msnt
17: WHERE transaction_temp_id = cp_transaction_temp_id;
18:
19: CURSOR cur_msn(cp_fm_serial_number VARCHAR2,
20: cp_to_serial_number VARCHAR2,

Line 168: UPDATE mtl_serial_numbers_temp

164: END IF;
165:
166: x_return_status := fnd_api.g_ret_sts_success;
167:
168: UPDATE mtl_serial_numbers_temp
169: SET
170: transaction_temp_id = p_new_transaction_temp_id,
171: fm_serial_number = p_from_serial_number,
172: to_serial_number = p_to_serial_number

Line 178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');

174:
175: IF (SQL%NOTFOUND) THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');
179: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
180: fnd_msg_pub.add;
181: IF (l_debug = 1) THEN
182: print_debug('proc_update_msnt .. nodatafound OTHERS : ');

Line 646: mtl_serial_numbers_temp msnt

642: END IF;
643: Select cost_group_id INTO x_cost_group_id FROM (
644: SELECT mmtt.cost_group_id
645: FROM mtl_material_transactions_temp mmtt,
646: mtl_serial_numbers_temp msnt
647: WHERE mmtt.transfer_organization = p_organization_id
648: AND mmtt.transfer_subinventory = p_subinventory_code
649: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
650: AND mmtt.inventory_item_id = p_inventory_item_id

Line 663: mtl_serial_numbers_temp msnt

659: UNION
660:
661: SELECT mmtt.cost_group_id
662: FROM mtl_material_transactions_temp mmtt,
663: mtl_serial_numbers_temp msnt
664: WHERE mmtt.organization_id = p_organization_id
665: AND mmtt.subinventory_code = p_subinventory_code
666: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
667: AND mmtt.inventory_item_id = p_inventory_item_id

Line 692: mtl_serial_numbers_temp msnt

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)
696: AND mmtt.inventory_item_id = p_inventory_item_id

Line 712: mtl_serial_numbers_temp msnt

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)
716: AND mmtt.inventory_item_id = p_inventory_item_id

Line 1052: INSERT INTO mtl_serial_numbers_temp

1048: print_debug('proc_insert_msnt.. TSN: ' || p_to_serial_number);
1049: print_debug('proc_insert_msnt.. Txn temp id: ' || p_new_txn_temp_id);
1050: END IF;
1051:
1052: INSERT INTO mtl_serial_numbers_temp
1053: (TRANSACTION_TEMP_ID
1054: ,LAST_UPDATE_DATE
1055: ,LAST_UPDATED_BY
1056: ,CREATION_DATE