DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_TRANSACTIONS_INTERFACE

Line 139: from mtl_transactions_interface

135: if (p_trx_type_id = 43) then
136: --transaction qty is same as primary qty since we always
137: --transact in primary UOM.
138: select sum(transaction_quantity) into l_mti_qty
139: from mtl_transactions_interface
140: where transaction_source_id = p_trx_src_id
141: and transaction_type_id = 43
142: and organization_id = p_org_id
143: and inventory_item_id = p_item_id

Line 364: UPDATE MTL_TRANSACTIONS_INTERFACE SET

360: end if;
361:
362: /* Updating MTI data which are not populated by the above API */
363:
364: UPDATE MTL_TRANSACTIONS_INTERFACE SET
365: WIP_ENTITY_TYPE = p_wip_entity_type,
366: OPERATION_SEQ_NUM = p_operation_seq_num,
367: TRANSACTION_REFERENCE = p_trx_reference,
368: NEGATIVE_REQ_FLAG = negative_req_flag,