INSERT INTO MTL_TRANSACTIONS_INTERFACE
(TRANSACTION_HEADER_ID,
TRANSACTION_INTERFACE_ID,
SOURCE_CODE,
SOURCE_HEADER_ID,
SOURCE_LINE_ID,
TRANSACTION_MODE,
LOCK_FLAG,
PROCESS_FLAG,
VALIDATION_REQUIRED,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
INVENTORY_ITEM_ID,
REVISION,
ORGANIZATION_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
PRIMARY_QUANTITY,
TRANSACTION_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_DATE,
ACCT_PERIOD_ID,
REASON_ID,
TRANSFER_ORGANIZATION,
TRANSFER_SUBINVENTORY,
TRANSFER_LOCATOR,
TRANSACTION_REFERENCE,
ATTRIBUTE_CATEGORY)
VALUES
(V_TXN_ID,--NULL,
V_TXN_ID,--NULL,
'SUB&PRJ Transf Program', -- Source Code
0, -- Source Header ID
0, -- Source Line ID
3, -- Transaction Mode => 1: On-Line processing; 2: Concurrent processing; 3: Background processing
2, -- Lock Flag => 1: Yes; 2: No
1, -- Process Flag
1, -- Validation Required
SYSDATE,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
NULL,
P_ITEM_ID,
NULL,
P_ORGANIZATION_ID,
P_SUBINV_CODE,
P_FROM_LOC_ID,
(-1)*P_TRANSACTION_QTY,
V_UOM_CODE,
(-1)*P_TRANSACTION_QTY,
V_TXN_TYPE_ID, -- Transaction Type ID - Project Transfer
2, -- Transaction Action ID - Subinventory Transfer
13, -- Trasaction Source Type ID - Inventory
SYSDATE,
V_ACCT_PERIOD, -- Accounting Period ID
P_REASON_ID, -- Reason ID
P_ORGANIZATION_ID,
P_TO_SUBINV_CODE,
P_TO_LOC_ID,
P_REFERENCE, -- Transaction Reference
NULL);
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15225049/viewspace-709379/
,如需转载,请注明出处,否则将追究法律责任。