APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1572: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.

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
1576: -- ------ ---- --------------

Line 1633: from mtl_transaction_lots_temp

1629:
1630: Cursor l_Get_Lot_Temp_Csr IS
1631: select transaction_temp_id, serial_transaction_temp_id,
1632: lot_number, lot_expiration_date, transaction_quantity
1633: from mtl_transaction_lots_temp
1634: where transaction_temp_id = p_transaction_temp_id;
1635:
1636: Cursor l_Get_Serial_Temp_Csr(l_transaction_temp_id NUMBER) IS
1637: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp