Inventory 物料库存 mtl_transactions_interface 开发[转]
Inventory 物料库存 mtl_transactions_interface 开发
mtl_transactions_interface的开发:
比如杂收,杂发,物料库存数控制等。
注意item的属性控制。
INSERT INTO mtl_transactions_interface
(transaction_interface_id,
transaction_header_id,
source_code,
source_header_id,
source_line_id,
process_flag,
transaction_mode,
inventory_item_id,
-- item_segment1 ,
revision,
organization_id,
transaction_date,
transaction_quantity,
subinventory_code,
locator_id,
transaction_source_id,
transaction_source_name,
transaction_reference,
transaction_type_id,
transaction_uom,
last_update_date,
last_updated_by,
creation_date,
created_by,
distribution_account_id,
wip_entity_type,
flow_schedule,
scheduled_flag,
-- ACCT_PERIOD_ID ,
attribute1,
attribute2)
VALUES
(v_interface_id, --999 , --transaction_interface_id
v_header_id, --transaction_header_id
'ROHS_CVT', --source_code
1, --source_header_id
1, --source_line_id
1, --process_flag
3, --transaction_mode 3-background 2-immediate
to_number(c2.attribute9), --inventory_item_id
-- NULL , --item_segment1
c2.revision, --revision
to_number(c2.attribute8), --organization_id
SYSDATE, --transaction_date
-1 * c2.quantity, --transaction_quantity
c2.attribute4, --subinventory_code
null, --locator_id
v_trans_source_id, -- 999 , --transaction_source_id
'ROHS LOT ADJUSTMENT', --to_char(c2.set_id) , --transaction_source_name
v_set_name || to_char(c2.id), --transaction_reference
v_issue, --transaction_type_id
v_primary_uom_code, --transaction_uom
SYSDATE, --last_update_date
p_userid, --last_updated_by
SYSDATE, --creation_date
p_userid, --created_by
l_inventory_debit_ccid, --distribution_account_id
null, --wip_entity_type
'Y', --flow_schedule
2, --scheduled_flag
-- 1655, --ACCT_PERIOD_ID
null, --'Y' , --attribute1
null --'N15387' --attribute2
);
------------------------------------------------
--mtl_transaction_lots_interface
------------------------------------------------
v_err := 'Inert 00item into mtl_transaction_lots_interface';
INSERT INTO mtl_transaction_lots_interface
(transaction_interface_id,
source_code,
source_line_id,
lot_number,
lot_expiration_date,
transaction_quantity,
process_flag,
last_update_date,
last_updated_by,
creation_date,
created_by)
VALUES
(v_interface_id, --transaction_interface_id
'ROHS_CVT', --source_code
NULL, --source_line_id
c2.attribute3, --lot_number
NULL, --lot_expiration_date
-1 * c2.quantity, --transaction_quantity
1, --process_flag
SYSDATE, --last_update_date
p_userid, --last_updated_by
SYSDATE, --creation_date
p_userid --created_by
);
*********后台提交接口管理器***************
l_request_id := INV_TXN_MANAGER_PUB.process_Transactions(p_api_version => 1,
p_init_msg_list => fnd_api.g_false ,
p_commit => fnd_api.g_true ,
p_validation_level => fnd_api.g_valid_level_full ,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_trans_count => l_trans_count,
p_table => 1,
p_header_id => v_header_id);
--刘轶鹤转