inv interface

--select * from mtl_onhand_quantities where organization_id=255

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,
transfer_subinventory,
TRANSFER_LOCATOR ,
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
(999, --999 , --transaction_interface_id
999, --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(111198), --inventory_item_id
-- NULL , --item_segment1
NULL, --revision
to_number(255), --organization_id
SYSDATE, --transaction_date
4, --transaction_quantity
'DE2', --subinventory_code,
'9693', --locator_id
999, -- 999 , --transaction_source_id
'ROHS LOT ADJUSTMENT', --to_char(c2.set_id) , --transaction_source_name
'11', --transaction_reference
2, --transaction_type_id
'KG', --transaction_uom
'DB2', --transfer_subinventory
'10148',    --TRANSFER_LOCATOR
SYSDATE-35, --last_update_date
'11', --last_updated_by
SYSDATE-35, --creation_date
'11', --created_by
'11', --distribution_account_id
null, --wip_entity_type
'Y', --flow_schedule
2, --scheduled_flag
-- 1655, --ACCT_PERIOD_ID
null, --'Y' , --attribute1
null --'N15387' --attribute2
);

COMMIT;

select * from mtl_transactions_interface

DELETE FROM mtl_transactions_interface

SELECT * FROM mtl_system_items where segment1='7200-0200200' and organization_id=255  111198
     
select * from mtl_onhand_quantities where organization_id=255 and inventory_item_id=111198
select * from inv.mtl_safety_stocks where organization_id=255 and inventory_item_id=111198
     
select * from inv.mtl_item_locations where organization_id=255 AND  subinventory_code='DB2'
     
select * from mtl_material_transactions where transaction_id=57050012

SELECT * FROM MTL_ITEM_REVISIONS WHERE inventory_item_id=111198

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12122734/viewspace-490912/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12122734/viewspace-490912/