WIP Move Transaction Interface

Interface Table :-

WIP_MOVE_TXN_INTERFACE

Concurrent Program to Import data :- Move Transaction Report

Basic Insert Statement
-----------------------

INSERT INTO WIP_MOVE_TXN_INTERFACE
(
LAST_UPDATE_DATE,
LAST_UPDATED_BY_NAME,
CREATION_DATE,
CREATED_BY_NAME,
PROCESS_PHASE,
PROCESS_STATUS,
ORGANIZATION_CODE,
WIP_ENTITY_NAME,
TRANSACTION_DATE,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_TYPE,
FM_OPERATION_SEQ_NUM,
FM_INTRAOPERATION_STEP_TYPE,
TO_OPERATION_SEQ_NUM,
TO_INTRAOPERATION_STEP_TYPE
)
VALUES
(
SYSDATE, --LAST_UPDATE_DATE
'KPMG', --LAST_UPDATED_BY_NAME
SYSDATE , --CREATION_DATE
'KPMG', --CREATED_BY_NAME
1, /*1. Move Validation 2. Move Processing 3. Operation Backflush Setup.
You should always load 1 (Move Validation)*/
1, /*1. Pending 2. Running 3. Error You should always load 1 (Pending)*/
'MST', --ORGANIZATION_CODE
'624054', --WIP_ENTITY_NAME
SYSDATE, --TRANSACTION_DATE
1, --TRANSACTION_QUANTITY
'PCS', --TRANSACTION_UOM
2, --TRANSACTION_TYPE /* 1. Move 2. Move Completion 3. Move Return */
10, --FM_OPERATION_SEQ_NUM
2, --FM_INTRAOPERATION_STEP_TYPE /* 1. Queue,2.Run 3.To move,4.Reject, */
10, --TO_OPERATION_SEQ_NUM
3); --TO_INTRAOPERATION_STEP_TYPE /* 1. Queue,2.Run 3.To move,4.Reject, */