DBA Data[Home] [Help]

APPS.EAM_MATERIAL_ALLOCATIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

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

630: || ',p_lot='|| p_lot || ',p_primary_quantity='|| p_primary_quantity|| ')');
631: end if;
632:
633: --API start
634: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;
635: update mtl_transaction_lots_temp
636: set serial_transaction_temp_id = l_ser_trx_id
637: where transaction_temp_id = p_transaction_temp_id
638: and lot_number = p_lot