<\/u> <\/p>\n
<\/span> <\/p>\n\n\n\n\nProcedure insere_into_mtl_trans_interf(<\/div>\nr_item in c_itens%rowtype, <\/div>\np_qtde_reg_inseridos in out number<\/div>\n) is<\/div>\n<\/div>\nv_transaction_interface_id apps.mtl_transactions_interface.transaction_ interface_id%type;<\/div>\n <\/div>\nBegin<\/div>\nSelect <\/div>\nmtl_material_transactions_s.nextval<\/div>\n Into <\/div>\nv_transaction_interface_id<\/div>\nFrom <\/div>\ndual;<\/div>\n<\/div>\nInsert Into apps.mtl_transactions_interface(<\/div>\n transaction_interface_id<\/div>\n,source_code<\/div>\n,source_header_id<\/div>\n,source_line_id<\/div>\n,process_flag<\/div>\n,lock_flag<\/div>\n,transaction_mode<\/div>\n,validation_required<\/div>\n,organization_id<\/div>\n,inventory_item_id<\/div>\n,transaction_type_id<\/div>\n,subinventory_code<\/div>\n,transaction_uom<\/div>\n,transaction_quantity<\/div>\n,transaction_cost<\/div>\n,transaction_date<\/div>\n,distribution_account_id<\/div>\n,created_by<\/div>\n,creation_date<\/div>\n,last_updated_by<\/div>\n,last_update_date<\/div>\n,acct_period_id<\/div>\n,locator_id<\/div>\n,transaction_reference<\/div>\n)<\/div>\nValues(<\/div>\nv_transaction_interface_id — transaction_interface_id<\/div>\n,’Inventory’ — source_code <\/div>\n,v_transaction_interface_id — source_header_id <\/div>\n,v_transaction_interface_id — source_line_id <\/div>\n,1 — process_flag <\/div>\n,2 — lock_flag <\/div>\n,3 — transaction_mode <\/div>\n,1 — validation_required <\/div>\n,r_item.organization_id — organization_id <\/div>\n,r_item.inventory_item_id — inventory_item_id <\/div>\n,r_item.transaction_type_id — transaction_type_id <\/div>\n,r_item.secondary_inventory_name — subinventory_code <\/div>\n ,r_item.udm — transaction_uom <\/div>\n,r_item.qtde — transaction_quantity <\/div>\n,r_item.custo — transaction_cost <\/div>\n,r_item.dt_para_baixa — transaction_date <\/div>\n,r_item.ccid_para_baixa — distribution_account_id <\/div>\n,G_USER_ID — created_by <\/div>\n,sysdate — creation_date <\/div>\n,G_USER_ID — last_updated_by <\/div>\n,sysdate — last_update_date <\/div>\n,r_item.acct_period_id — acct_period_id <\/div>\n,r_item.inventory_location_id — locator_id <\/div>\n,r_item.transaction_reference — transaction_reference<\/div>\n);<\/div>\n<\/div>\np_qtde_reg_inseridos := p_qtde_reg_inseridos + 1;<\/div>\nEnd;<\/div>\n<\/div>\n<\/p><\/div>\n<\/p>\n
![\"\"](\"https:\/\/ipmcdn.avast.com\/images\/icons\/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif\"){kind=icon}
<\/a><\/td>\n