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: WSM.WSM_LOT_MOVE_TXN_INTERFACE

Object Details

Object Name:	WSM_LOT_MOVE_TXN_INTERFACE
Object Type:	TABLE
Owner:	WSM
FND Design Data:	WSM.WSM_LOT_MOVE_TXN_INTERFACE
Subobject Name:
Status:	VALID

Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSM_LOT_MOVE_TXN_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	HEADER_ID
WSM_LOT_MOVE_TXN_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID INTERNAL_GROUP_ID
WSM_LOT_MOVE_TXN_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	WIP_ENTITY_ID GROUP_ID STATUS
WSM_LOT_MOVE_TXN_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
WSM_LOT_MOVE_TXN_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	WIP_ENTITY_NAME STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER
TRANSACTION_ID	NUMBER			Transaction Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY_NAME	VARCHAR2	(100)		Standard Who Column
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATED_BY_NAME	VARCHAR2	(100)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
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			dentifier used by source shop floor control system (null if created by Oracle Work in 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)		Lot based job name
ENTITY_TYPE	NUMBER			WIP entity type code for Lot based Jobs
PRIMARY_ITEM_ID	NUMBER			nventory 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 department 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	(15)		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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition 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
QA_COLLECTION_ID	NUMBER			Collection Identifier for quality results
KANBAN_CARD_ID	NUMBER			Kanban Card reference for Move completions
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.
ERROR	VARCHAR2	(2000)		Error Message
JUMP_FLAG	VARCHAR2	(1)		Flag to enable Jump functionality
HEADER_ID	NUMBER		Yes	Header Identifier
PROCESSING_ORDER	NUMBER			Determines move processsing order within a job
XML_DOCUMENT_ID	VARCHAR2	(240)		Xml Document Identifier
NEW_WIP_ENTITY_NAME	VARCHAR2	(240)		New job name when a job is completed
PRIMARY_SCRAP_QUANTITY	NUMBER			Scrap quantity of assembly being moved between operations expressed in the assembly's primary unit of measure
SCRAP_QUANTITY	NUMBER			Quantity of the assembly being scrapped
SCRAP_AT_OPERATION_FLAG	NUMBER			Indicates the operation at which the user wishes to perform the scrap in a move and scrap transaction
INTERNAL_GROUP_ID	NUMBER			Internally populated and should not be populated by the user.
INTERNAL_SCRAP_TXN_ID	NUMBER			Internally populated and should not be populated by the user.
SERIAL_START_FLAG	NUMBER			1 - User intends to start serial tracking from the current move transaction

Query Text

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


SELECT INTERFACE_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
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      QA_COLLECTION_ID
,      KANBAN_CARD_ID
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_ID
,      ERROR
,      JUMP_FLAG
,      HEADER_ID
,      PROCESSING_ORDER
,      XML_DOCUMENT_ID
,      NEW_WIP_ENTITY_NAME
,      PRIMARY_SCRAP_QUANTITY
,      SCRAP_QUANTITY
,      SCRAP_AT_OPERATION_FLAG
,      INTERNAL_GROUP_ID
,      INTERNAL_SCRAP_TXN_ID
,      SERIAL_START_FLAG
FROM WSM.WSM_LOT_MOVE_TXN_INTERFACE;

Dependencies

[top of page]

WSM.WSM_LOT_MOVE_TXN_INTERFACE does not reference any database object

WSM.WSM_LOT_MOVE_TXN_INTERFACE is referenced by following:

WSM: WSM_LOT_MOVE_TXN_INTERFACE#