v_misc_trans_tbl.transaction_mode := 3; --后台处理 v_misc_trans_tbl.inventory_item_id := rec_misc_in2.inventory_item_id; --v_misc_trans_tbl.item_segment1 := rec_misc_in2.epi_item; v_misc_trans_tbl.organization_id := rec_misc_in2.org_id; v_misc_trans_tbl.subinventory_code ...
v_misc_trans_tbl.transaction_mode := 3; --后台处理 v_misc_trans_tbl.inventory_item_id := rec_misc_in2.inventory_item_id; --v_misc_trans_tbl.item_segment1 := rec_misc_in2.epi_item; v_misc_trans_tbl.organization_id := rec_misc_in2.org_id; v_misc_trans_tbl.subinventory_code ...
lv_transaction_date DATE;lv_distribution_account_id NUMBER;lv_transaction_source_id NUMBER;ln_txn_type_id NUMBER;ln_period_id number;ln_txn_source_type_id NUMBER :=6;l_iface_rec inv.mtl_transactions_interface%ROWTYPE;l_iface_lot_rec inv.mtl_transaction_lots_interface%ROWTYPE;BEGIN XV_STATUS...
transaction_mode = 3 Q2. What is the MTL_MATERIAL_TRANSACTIONS_TEMP table used for? A2. Once the transactions have been passed to this table after initial validation by the Transactions Manager (INCTCM) from the MTL_TRANSACTIONS_INTERFACE a job id is attached and a Transactions Worker (INCTCW...
l_iface_rec.transaction_header_id := l_iface_rec.transaction_interface_id; l_iface_rec.transaction_mode := 3; l_iface_rec.process_flag := 1; l_iface_rec.transaction_type_id := ln_txn_type_id; l_iface_rec.transaction_source_id := lv_transaction_source_id; ...