[Home] [Help] [Dependency Information]
Object Name: | WIP_WS_PPM_DEFECTS |
---|---|
Object Type: | TABLE |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
WIP_WS_PPM_DEFECTS stores information about Parts per Million Defects. Each row represents the value of PPM Defects for a single job. The data is populated by concurrent program. MES uses this information to display Parts per Million Defects API on the Dashboard.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_WS_PPM_DEFECTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID WIP_ENTITY_ID SHIFT_DATE SHIFT_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
WIP_ENTITY_ID | NUMBER | Yes | Job Identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Assembly Identifier | |
SHIFT_NUM | NUMBER | Yes | Shift Number | |
SHIFT_DATE | DATE | Yes | Shift Date | |
QUANTITY_DEFECTED | NUMBER | Quantity Defected | ||
QUANTITY_PRODUCED | NUMBER | Quantity Produced | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | Enhanced Who column | ||
PROGRAM_ID | NUMBER | Enhanced Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who column | ||
PROGRAM_UPDATE_DATE | DATE | Enhanced Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, WIP_ENTITY_ID
, INVENTORY_ITEM_ID
, SHIFT_NUM
, SHIFT_DATE
, QUANTITY_DEFECTED
, QUANTITY_PRODUCED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM WIP.WIP_WS_PPM_DEFECTS;
WIP.WIP_WS_PPM_DEFECTS does not reference any database object
WIP.WIP_WS_PPM_DEFECTS is referenced by following:
|
|
|