---receipt
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,
transaction_cost)
VALUES
(MTL_MATERIAL_TRANSACTIONs_S.NEXTVAL, --999 , --transaction_interface_id
MTL_MATERIAL_TRANSACTIONs_S.NEXTVAL, --transaction_header_id
'Inventory', --source_code
0, --source_header_id
0, --source_line_id
1, --process_flag
2, --transaction_mode 3-background 2-immediate
&item_id, --inventory_item_id
-- NULL , --item_segment1
null, --revision
&org, --organization_id
SYSDATE, --transaction_date
&qty, --transaction_quantity issue should with negative qty
&sub, --subinventory_code
&loc_id, --locator_id
null, -- 999 , --transaction_source_id
null, --to_char(c2.set_id) , --transaction_source_name
'Miscellaneous Adjustments Request', --transaction_reference
42, --transaction_type_id 42:: Miscellaneous receipt; 32 isse
&UOM, --transaction_uom
SYSDATE, --last_update_date
-1, --last_updated_by
SYSDATE, --creation_date
-1, --created_by
&distr_id, --distribution_account_id
null, --wip_entity_type
--'Y', --flow_schedule
--2, --scheduled_flag
-- 1655, --ACCT_PERIOD_ID
null, --'Y' , --attribute1
&tran_cost --'N15387' --attribute2
);
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,
transaction_cost)
VALUES
(MTL_MATERIAL_TRANSACTIONs_S.NEXTVAL, --999 , --transaction_interface_id
MTL_MATERIAL_TRANSACTIONs_S.NEXTVAL, --transaction_header_id
'Inventory', --source_code
0, --source_header_id
0, --source_line_id
1, --process_flag
2, --transaction_mode 3-background 2-immediate
&item_id, --inventory_item_id
-- NULL , --item_segment1
null, --revision
&org, --organization_id
SYSDATE, --transaction_date
&qty, --transaction_quantity issue should with negative qty
&sub, --subinventory_code
&loc_id, --locator_id
null, -- 999 , --transaction_source_id
null, --to_char(c2.set_id) , --transaction_source_name
'Miscellaneous Adjustments Request', --transaction_reference
42, --transaction_type_id 42:: Miscellaneous receipt; 32 isse
&UOM, --transaction_uom
SYSDATE, --last_update_date
-1, --last_updated_by
SYSDATE, --creation_date
-1, --created_by
&distr_id, --distribution_account_id
null, --wip_entity_type
--'Y', --flow_schedule
--2, --scheduled_flag
-- 1655, --ACCT_PERIOD_ID
null, --'Y' , --attribute1
&tran_cost --'N15387' --attribute2
);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15225049/viewspace-709380/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15225049/viewspace-709380/