[Home] [Help] [Dependency Information]
Object Name: | WSM_OP_REASON_CODES |
---|---|
Object Type: | TABLE |
Owner: | WSM |
Subobject Name: | |
Status: | VALID |
Stores the reason codes and quantity for an operation performed on the lot based job
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSM_OP_REASON_CODES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WIP_ENTITY_ID
OPERATION_SEQ_NUM CODE_TYPE REASON_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
WIP_ENTITY_ID | NUMBER | Yes | Lot Based Job Identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number within a routing | |
CODE_TYPE | NUMBER | Yes | Flag that determines whether the reason code is a scrap code or bonus code | |
REASON_CODE | VARCHAR2 | (100) | Yes | Code for the reason for which the scrap or bonus was performed |
QUANTITY | NUMBER | Quantity corresponding to the scrap or bonus reason | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when the row was last updated | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) | ||
CREATION_DATE | DATE | Standard Who column - date when the row was created | ||
LAST_UPDATED_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, CODE_TYPE
, REASON_CODE
, QUANTITY
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATED_LOGIN
FROM WSM.WSM_OP_REASON_CODES;
WSM.WSM_OP_REASON_CODES does not reference any database object
WSM.WSM_OP_REASON_CODES is referenced by following:
|
|
|