DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_TRANSACTIONS_INTERFACE

Line 2503: FROM mtl_transactions_interface

2499: organization_id NUMBER );
2500: l_Interface_Rec l_Interface_Type;
2501: CURSOR l_Get_Interface_Csr IS
2502: SELECT transaction_source_id, trx_source_line_id, organization_id
2503: FROM mtl_transactions_interface
2504: WHERE transaction_header_id = p_transaction_header_id;
2505: Begin
2506: -- Commit the changes before calling mtl_onlien_transaction_pub.process_online
2507: commit;

Line 2536: -- mtl_transactions_interface table.

2532: EXIT WHEN l_Get_Interface_Csr%NOTFOUND;
2533: -- Update the move_order_line_id in the mtl_material_transactions so that the transaction record
2534: -- has track-back history to the move order.
2535: -- We need to do this post transaction update because there is no such column move_order_line_id in the
2536: -- mtl_transactions_interface table.
2537: update mtl_material_transactions
2538: set move_order_line_id = l_Interface_Rec.trx_source_line_id
2539: where transaction_source_id = l_Interface_Rec.transaction_source_id
2540: and trx_source_line_id = l_Interface_Rec.trx_source_line_id