APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 898: UPDATE MTL_TRANSACTIONS_INTERFACE

894: --if transaction type is of interorg-intransit then we need to enter the shipment number into MTI table explicitly.
895:
896: IF(p_transaction_type_id=21) THEN
897: --code for entering the shipment values into MTI
898: UPDATE MTL_TRANSACTIONS_INTERFACE
899: SET SHIPMENT_NUMBER=p_shipment_number where TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
900: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
901:
902: END IF;

Line 905: UPDATE MTL_TRANSACTIONS_INTERFACE

901:
902: END IF;
903:
904: IF(validAssets_rec.prepare_status='MR') THEN --for --for 7370638 Batch seq to be 2 as the transfer is dependent on the Misc. receipt
905: UPDATE MTL_TRANSACTIONS_INTERFACE
906: SET TRANSACTION_BATCH_ID = l_transaction_batch_id,
907: TRANSACTION_BATCH_SEQ = 2
908: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
909: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;

Line 966: FROM MTL_TRANSACTIONS_INTERFACE MTI

962: SELECT MTI.TRANSACTION_HEADER_ID ,
963: MTI.TRANSACTION_INTERFACE_ID,
964: MTI.ERROR_CODE ,
965: MTI.ERROR_EXPLANATION
966: FROM MTL_TRANSACTIONS_INTERFACE MTI
967: WHERE MTI.TRANSACTION_HEADER_ID = p_txn_header_id ;
968:
969: BEGIN
970: --Dbms_Output.put_line('begining of processAssetMoveTxn');

Line 1210: INSERT INTO mtl_transactions_interface

1206: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1207: INTO l_txn_if_id
1208: FROM sys.dual;
1209:
1210: INSERT INTO mtl_transactions_interface
1211: (transaction_header_id,
1212: source_code,
1213: source_line_id,
1214: source_header_id,