DBA Data[Home] [Help]

APPS.INV_MATERIAL_ALLOCATIONS_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 689: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;

685: || ',p_lot='|| p_lot || ',p_primary_quantity='|| p_primary_quantity|| ')');
686: end if;
687:
688: --API start
689: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;
690: update mtl_transaction_lots_temp
691: set serial_transaction_temp_id = l_ser_trx_id
692: where transaction_temp_id = p_transaction_temp_id
693: and lot_number = p_lot