DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_TRANSACTIONS_INTERFACE

Line 221: from mtl_transactions_interface

217: if (p_trx_type_id = 43) then
218: --transaction qty is same as primary qty since we always
219: --transact in primary UOM.
220: select sum(transaction_quantity) into l_mti_qty
221: from mtl_transactions_interface
222: where transaction_source_id = p_trx_src_id
223: and transaction_type_id = 43
224: and organization_id = p_org_id
225: and inventory_item_id = p_item_id

Line 479: UPDATE MTL_TRANSACTIONS_INTERFACE SET

475:
476:
477: /* Updating MTI data which are not populated by the above API */
478:
479: UPDATE MTL_TRANSACTIONS_INTERFACE SET
480: WIP_ENTITY_TYPE = p_wip_entity_type,
481: OPERATION_SEQ_NUM = p_operation_seq_num,
482: TRANSACTION_REFERENCE = p_trx_reference,
483: NEGATIVE_REQ_FLAG = negative_req_flag,