[Home] [Help] [Dependency Information]
Object Name: | WSM_SERIAL_TRANSACTIONS |
---|---|
Object Type: | TABLE |
Owner: | WSM |
Subobject Name: | |
Status: | VALID |
Table to store the WIP Lot Transactions underwent by a serial number
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSM_SERIAL_TRANSACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GEN_OBJECT_ID |
WSM_SERIAL_TRANSACTIONS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
TRANSACTION_TYPE_ID SERIAL_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | WIP Lot transaction ID | ||
TRANSACTION_TYPE_ID | NUMBER | Transaction type id | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
GEN_OBJECT_ID | NUMBER | Geneology Object id of the serial number | ||
CURRENT_WIP_ENTITY_NAME | VARCHAR2 | (240) | WIP Entity name of the linked job before the transaction | |
CHANGED_WIP_ENTITY_NAME | VARCHAR2 | (240) | WIP Entity name of the linked job after the transaction | |
CURRENT_WIP_ENTITY_ID | NUMBER | WIP Entity ID of the linked job before the transaction | ||
CHANGED_WIP_ENTITY_ID | NUMBER | WIP Entity ID of the linked job after the transaction | ||
CREATED_BY | NUMBER | Standard columns | ||
LAST_UPDATE_DATE | DATE | Standard columns | ||
LAST_UPDATED_BY | NUMBER | Standard columns | ||
CREATION_DATE | DATE | Standard columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard columns | ||
REQUEST_ID | NUMBER | Standard columns | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard columns | ||
PROGRAM_ID | NUMBER | Standard columns | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Standard columns |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, TRANSACTION_TYPE_ID
, SERIAL_NUMBER
, GEN_OBJECT_ID
, CURRENT_WIP_ENTITY_NAME
, CHANGED_WIP_ENTITY_NAME
, CURRENT_WIP_ENTITY_ID
, CHANGED_WIP_ENTITY_ID
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORIGINAL_SYSTEM_REFERENCE
FROM WSM.WSM_SERIAL_TRANSACTIONS;
WSM.WSM_SERIAL_TRANSACTIONS does not reference any database object
WSM.WSM_SERIAL_TRANSACTIONS is referenced by following:
|
|
|