DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 1250: INSERT INTO mtl_serial_numbers_interface

1246: );
1247: END IF;
1248:
1249: IF p_serial_number IS NOT NULL THEN
1250: INSERT INTO mtl_serial_numbers_interface
1251: ( transaction_interface_id
1252: , fm_serial_number
1253: , to_serial_number
1254: , last_update_date

Line 1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from

1567: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the
1568: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1569: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1570: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1572: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1573: --
1574: -- History :
1575: -- Person Date Descriptions