Procedure insere_into_mtl_trans_interf(
r_item in c_itens%rowtype,
p_qtde_reg_inseridos in out number
) is
v_transaction_interface_id apps.mtl_transactions_interface.transaction_interface_id%type;
Begin
Select
mtl_material_transactions_s.nextval
Into
v_transaction_interface_id
From
dual;
Insert Into apps.mtl_transactions_interface(
transaction_interface_id
,source_code
,source_header_id
,source_line_id
,process_flag
,lock_flag
,transaction_mode
,validation_required
,organization_id
,inventory_item_id
,transaction_type_id
,subinventory_code
,transaction_uom
,transaction_quantity
,transaction_cost
,transaction_date
,distribution_account_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,acct_period_id
,locator_id
,transaction_reference
)
Values(
v_transaction_interface_id — transaction_interface_id
,’Inventory’ — source_code
,v_transaction_interface_id — source_header_id
,v_transaction_interface_id — source_line_id
,1 — process_flag
,2 — lock_flag
,3 — transaction_mode
,1 — validation_required
,r_item.organization_id — organization_id
,r_item.inventory_item_id — inventory_item_id
,r_item.transaction_type_id — transaction_type_id
,r_item.secondary_inventory_name — subinventory_code
,r_item.udm — transaction_uom
,r_item.qtde — transaction_quantity
,r_item.custo — transaction_cost
,r_item.dt_para_baixa — transaction_date
,r_item.ccid_para_baixa — distribution_account_id
,G_USER_ID — created_by
,sysdate — creation_date
,G_USER_ID — last_updated_by
,sysdate — last_update_date
,r_item.acct_period_id — acct_period_id
,r_item.inventory_location_id — locator_id
,r_item.transaction_reference — transaction_reference
);
p_qtde_reg_inseridos := p_qtde_reg_inseridos + 1;
End;
 |
Livre de vírus. www.avast.com. |
Em 9 de agosto de 2017 11:29, Lucinda Violante lucinda.violante@gmail.com <> escreveu:
Bom dia, pessoal.Alguém teria alguma documentação que auxiliasse a criação de entradas e saidas de um estoque com valor unitário para uma Organização de Inventário nova, como uma transferência de saldo de uma organização para outra? Fora os manuais da Oracle que já consultei, algum exemplo de insert e processo, White Paper, qualquer coisa.Grata.
—
Lucinda A. Violante
(21) 8720-9370 (Claro)
(21) 3392-1130