eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: WIP.WIP_MOVE_TRANSACTIONS

Object Details

Object Name:	WIP_MOVE_TRANSACTIONS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_MOVE_TRANSACTIONS
Subobject Name:
Status:	VALID

WIP_MOVE_TRANSACTIONS stores information about shop floor Move
transactions. Each row represents a single Move transaction and
includes a unique transaction identifier, the transaction date, the
job or repetitive schedule in which the Move occurs, the Move
quantity, as well as information about the From and To operation
sequence numbers, operation codes, and intraoperation steps. Oracle
Work in Process uses this information to track Move transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_MOVE_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
WIP_MOVE_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID
WIP_MOVE_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE CREATION_DATE TRANSACTION_ID
WIP_MOVE_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
GROUP_ID	NUMBER		Yes	Transaction group Identifier
SOURCE_CODE	VARCHAR2	(30)		Code of the shop floor control system that generated the transaction record (null if created by Oracle Work in Process)
SOURCE_LINE_ID	NUMBER			Identifier used by source shop floor control system (null if created by Oracle Work in Process)
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly Identifier
LINE_ID	NUMBER			WIP line Identifier
PRIMARY_ITEM_ID	NUMBER			Inventory item Identifier for assembly that the job or schedule creates
TRANSACTION_DATE	DATE		Yes	Date transaction was performed
ACCT_PERIOD_ID	NUMBER		Yes	Accounting period Identifier
FM_OPERATION_SEQ_NUM	NUMBER		Yes	From operation number
FM_OPERATION_CODE	VARCHAR2	(4)		Short code that uniquely identifies the From operation
FM_DEPARTMENT_ID	NUMBER		Yes	From department Identifier
FM_INTRAOPERATION_STEP_TYPE	NUMBER		Yes	From intraoperation step
TO_OPERATION_SEQ_NUM	NUMBER		Yes	To operation number
TO_OPERATION_CODE	VARCHAR2	(4)		Short code that uniquely identifies the To operation
TO_DEPARTMENT_ID	NUMBER		Yes	To department Identifier
TO_INTRAOPERATION_STEP_TYPE	NUMBER		Yes	To intraoperation step
TRANSACTION_QUANTITY	NUMBER		Yes	Transaction move quantity
TRANSACTION_UOM	VARCHAR2	(3)	Yes	Transaction unit of measure code
PRIMARY_QUANTITY	NUMBER		Yes	Transaction move quantity in assembly's primary unit of measure
PRIMARY_UOM	VARCHAR2	(3)	Yes	Unit of measure code of the assembly
SCRAP_ACCOUNT_ID	NUMBER			General Ledger account charged when material is scrapped
REASON_ID	NUMBER			Standard reason Identifier for performing the move transaction
REFERENCE	VARCHAR2	(240)		Transaction reference descriptive text
QA_COLLECTION_ID	NUMBER			Collection Identifier for quality results
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
OVERCOMPLETION_TRANSACTION_QTY	NUMBER			Overcompletion quantity specified in the transaction UOM
OVERCOMPLETION_PRIMARY_QTY	NUMBER			Overcompletion quantity derived in the Primary UOM
OVERCOMPLETION_TRANSACTION_ID	NUMBER			Links parent Move or Completion transactions with a child Move transaction for Overcompletions
WF_ITEMTYPE	VARCHAR2	(8)		Workflow Item Type
WF_ITEMKEY	VARCHAR2	(240)		Workflow Item Key
WSM_UNDO_TXN_ID	NUMBER			Undo Transaction Identifier
JOB_QUANTITY_SNAPSHOT	NUMBER			Job quantity at the time of doing move
BATCH_ID	NUMBER			Batch ID
EMPLOYEE_ID	NUMBER			An ID of employee who perform a transaction.
COMPLETED_INSTRUCTIONS	NUMBER			Flag to identify if instructions were completed

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      PRIMARY_ITEM_ID
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      FM_OPERATION_SEQ_NUM
,      FM_OPERATION_CODE
,      FM_DEPARTMENT_ID
,      FM_INTRAOPERATION_STEP_TYPE
,      TO_OPERATION_SEQ_NUM
,      TO_OPERATION_CODE
,      TO_DEPARTMENT_ID
,      TO_INTRAOPERATION_STEP_TYPE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SCRAP_ACCOUNT_ID
,      REASON_ID
,      REFERENCE
,      QA_COLLECTION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_ID
,      WF_ITEMTYPE
,      WF_ITEMKEY
,      WSM_UNDO_TXN_ID
,      JOB_QUANTITY_SNAPSHOT
,      BATCH_ID
,      EMPLOYEE_ID
,      COMPLETED_INSTRUCTIONS
FROM WIP.WIP_MOVE_TRANSACTIONS;

Dependencies

[top of page]

WIP.WIP_MOVE_TRANSACTIONS does not reference any database object

WIP.WIP_MOVE_TRANSACTIONS is referenced by following:

APPS: WIP_MOVE_TRANSACTIONS