DBA Data[Home] [Help]

APPS.GMIVTDX dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 496: TYPE mtlt_row_tbl IS TABLE OF mtl_transaction_lots_temp%ROWTYPE INDEX BY BINARY_INTEGER;

492: ) IS
493: l_api_name CONSTANT VARCHAR2(30) := 'create_txn_update_bal_in_odm' ;
494: l_api_version CONSTANT NUMBER := 1.0 ;
495: l_mmtt_row mtl_material_transactions_temp%ROWTYPE;
496: TYPE mtlt_row_tbl IS TABLE OF mtl_transaction_lots_temp%ROWTYPE INDEX BY BINARY_INTEGER;
497: l_mtlt_row_tbl mtlt_row_tbl;
498: l_count pls_integer;
499:
500: /* Jalaj Srivastava Bug 3812701 */

Line 688: --lets see if we have records to be inserted in mtl_transaction_lots_temp

684: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
685: log_msg('Inserted 1 record in mtl_material_transactions_temp');
686: END IF;
687:
688: --lets see if we have records to be inserted in mtl_transaction_lots_temp
689: --line could have multiple lots
690: --{
691: IF (p_txn_vars_rec.lot_control = 1) THEN --if item is lot controlled
692:

Line 735: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

731: process lots are first created in discrete lot master due
732: to which lot attribute info is lost in migartion transaction.
733: Populate lot attributes information from lot master
734: for lot transactions */
735: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
736: (
737: transaction_temp_id
738: ,group_header_id
739: ,transaction_quantity