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


VIEW: APPS.WIP_MOVE_TXN_INTERFACE_V

Object Details
Object Name: WIP_MOVE_TXN_INTERFACE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_MOVE_TXN_INTERFACE_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier (internal use only)
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

Extended Who column
PROGRAM_APPLICATION_ID NUMBER

Extended Who column
PROGRAM_ID NUMBER

Extended Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
GROUP_ID NUMBER

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)
PROCESS_PHASE NUMBER
Yes Transaction processing phase
PROCESS_PHASE_MEANING VARCHAR2 (80) Yes Processing phase meaning
PROCESS_STATUS NUMBER
Yes Transaction processing status
PROCESS_STATUS_MEANING VARCHAR2 (80) Yes Processing status meaning
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 of assembly 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
FM_INTRAOPERATION_STEP_MEANING VARCHAR2 (80)
From intra-operation step meaning
TO_OPERATION_SEQ_NUM NUMBER

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

To operation identifier
TO_DEPARTMENT_CODE VARCHAR2 (10)
To department code
TO_INTRAOPERATION_STEP_TYPE NUMBER

To intra-operation step
TO_INTRAOPERATION_STEP_MEANING VARCHAR2 (80)
To intraoperation step meaning
TRANSACTION_QUANTITY NUMBER
Yes Transaction quantity (that was moved 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
TRANSACTION_TYPE NUMBER

Transaction type
TRANSACTION_TYPE_MEANING VARCHAR2 (80)
Transaction type meaning
OVERCOMPLETION_TRANSACTION_QTY NUMBER

COMPLETED_INSTRUCTIONS NUMBER

Completed Instructions
Query Text

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


SELECT ROW_ID
,      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
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      PROCESS_PHASE
,      PROCESS_PHASE_MEANING
,      PROCESS_STATUS
,      PROCESS_STATUS_MEANING
,      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
,      FM_INTRAOPERATION_STEP_MEANING
,      TO_OPERATION_SEQ_NUM
,      TO_OPERATION_CODE
,      TO_DEPARTMENT_ID
,      TO_DEPARTMENT_CODE
,      TO_INTRAOPERATION_STEP_TYPE
,      TO_INTRAOPERATION_STEP_MEANING
,      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
,      TRANSACTION_TYPE
,      TRANSACTION_TYPE_MEANING
,      OVERCOMPLETION_TRANSACTION_QTY
,      COMPLETED_INSTRUCTIONS
FROM APPS.WIP_MOVE_TXN_INTERFACE_V;

Dependencies

[top of page]

APPS.WIP_MOVE_TXN_INTERFACE_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymWIP_MOVE_TXN_INTERFACE

APPS.WIP_MOVE_TXN_INTERFACE_V is not referenced by any database object