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

TABLE: WIP.WIP_MOVE_TXN_INTERFACE

Object Details
Object Name: WIP_MOVE_TXN_INTERFACE
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_MOVE_TXN_INTERFACE
Subobject Name:
Status: VALID


WIP_MOVE_TXN_INTERFACE contains information about the shop floor
Move transactions that need to be processed. Each row contains the
transaction date, the job or repetitive schedule in which you are moving
assemblies, the primary unit of measure, the actual unit of measure,
transaction quantities, the foreign keys necessary for WIP to process
the Move transaction as well as information about the From and To
operation sequence numbers, operation codes, and intraoperation
steps. This table supports all shop floor Move transactions including
transactions loaded from other systems, such as bar code readers,
using the Oracle Work in Process Open Move Transaction Interface.
Scope: public
Product: WIP
Lifecycle: active
Display Name: WIP Move Transaction Interface
Category: BUSINESS_ENTITY WIP_MOVE_TRANSACTION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_MOVE_TXN_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnTRANSACTION_ID
WIP_MOVE_TXN_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnWIP_ENTITY_ID
ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transaction Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
User name of the person who last updated the record
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATED_BY_NAME VARCHAR2 (100)
User name of the person who created the record
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

Transaction group Identifier
KANBAN_CARD_ID NUMBER

Kanban Card reference for Move completions
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)
PROCESS_PHASE NUMBER
Yes Transaction processing phase
PROCESS_STATUS NUMBER
Yes Transaction processing status
TRANSACTION_TYPE NUMBER

Transaction type
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
WIP job or repetitive assembly name
ENTITY_TYPE NUMBER

WIP entity type code
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier for assembly that the job or schedule creates
LINE_ID NUMBER

WIP line Identifier
LINE_CODE VARCHAR2 (10)
Line name
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier (this column is solely for internal use)
TRANSACTION_DATE DATE
Yes Date transaction was performed
ACCT_PERIOD_ID NUMBER

Accounting period Identifier
FM_OPERATION_SEQ_NUM NUMBER

From operation sequence number
FM_OPERATION_CODE VARCHAR2 (4)
From operation code
FM_DEPARTMENT_ID NUMBER

From operation Identifier
FM_DEPARTMENT_CODE VARCHAR2 (10)
From department code
FM_INTRAOPERATION_STEP_TYPE NUMBER

From intra-operation step
TO_OPERATION_SEQ_NUM NUMBER

To operation sequence number
TO_OPERATION_CODE VARCHAR2 (4)
To operation code
TO_DEPARTMENT_ID NUMBER

To department Identifier
TO_DEPARTMENT_CODE VARCHAR2 (10)
To department code
TO_INTRAOPERATION_STEP_TYPE NUMBER

To intraoperation step
TRANSACTION_QUANTITY NUMBER
Yes Transaction quantity (between operations)
TRANSACTION_UOM VARCHAR2 (3) Yes Unit of measure used in transaction
PRIMARY_QUANTITY NUMBER

Quantity of assembly being moved between operations expressed in the assembly's primary unit of measure
PRIMARY_UOM VARCHAR2 (3)
Primary unit of measure for the assembly
SCRAP_ACCOUNT_ID NUMBER

General Ledger account charged when material is scrapped
REASON_ID NUMBER

Standard transaction reason identifier
REASON_NAME VARCHAR2 (30)
Standard transaction reason name
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 unit of measure
OVERCOMPLETION_TRANSACTION_ID NUMBER

Column that links parent Move/Completion transaction with a child Move transaction for Overcompletions.
XML_DOCUMENT_ID VARCHAR2 (240)
Identifies the XML message that triggered the transaction
PROCESSING_ORDER NUMBER

Order of the record in the same group to be processed.
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
,      LAST_UPDATED_BY_NAME
,      CREATION_DATE
,      CREATED_BY
,      CREATED_BY_NAME
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      KANBAN_CARD_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      PROCESS_PHASE
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ENTITY_TYPE
,      PRIMARY_ITEM_ID
,      LINE_ID
,      LINE_CODE
,      REPETITIVE_SCHEDULE_ID
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      FM_OPERATION_SEQ_NUM
,      FM_OPERATION_CODE
,      FM_DEPARTMENT_ID
,      FM_DEPARTMENT_CODE
,      FM_INTRAOPERATION_STEP_TYPE
,      TO_OPERATION_SEQ_NUM
,      TO_OPERATION_CODE
,      TO_DEPARTMENT_ID
,      TO_DEPARTMENT_CODE
,      TO_INTRAOPERATION_STEP_TYPE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SCRAP_ACCOUNT_ID
,      REASON_ID
,      REASON_NAME
,      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
,      XML_DOCUMENT_ID
,      PROCESSING_ORDER
,      BATCH_ID
,      EMPLOYEE_ID
,      COMPLETED_INSTRUCTIONS
FROM WIP.WIP_MOVE_TXN_INTERFACE;

Dependencies

[top of page]

WIP.WIP_MOVE_TXN_INTERFACE does not reference any database object

WIP.WIP_MOVE_TXN_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_MOVE_TXN_INTERFACE#