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

TABLE: WIP.WIP_WS_FPY

Object Details
Object Name: WIP_WS_FPY
Object Type: TABLE
Owner: WIP
Subobject Name:
Status: VALID


WIP_WS_FPY stores data for the First Pass Yield KPI on MES dashboard. The First Pass Yield calculation concurrent program populates First Pass Yield, Reject, and Scrap percent into this table. Data is stores for four different level including Job Operation, Job, Assembly, and Department. Data at Job, Assembly and Department level will be generated for each date, shift, and week.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_WS_FPY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnDEPARTMENT_ID
ColumnINVENTORY_ITEM_ID
ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
ColumnSHIFT_DATE
ColumnSHIFT_NUM
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization Identifier
DEPARTMENT_ID NUMBER

Department Identifier
WIP_ENTITY_ID NUMBER

Job Identifier
OPERATION_SEQ_NUM NUMBER

Operation Sequence Number
INVENTORY_ITEM_ID NUMBER

Assembly Identifier
SHIFT_DATE DATE

Shift Date
SHIFT_NUM NUMBER

Shift Number
QUANTITY_REJECTED NUMBER

Quantity Rejected
QUANTITY_SCRAPPED NUMBER

Quantity Scrapped
QUANTITY_COMPLETED NUMBER

Quantity Completed
QUANTITY_FIRST_PASS NUMBER

First Pass Quantity
REJECT_PERCENT NUMBER

Reject Percent
SCRAP_PERCENT NUMBER

Scrap Percent
FPY_PERCENT NUMBER

First Pass Yield Percent
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
Query Text

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


SELECT ORGANIZATION_ID
,      DEPARTMENT_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      INVENTORY_ITEM_ID
,      SHIFT_DATE
,      SHIFT_NUM
,      QUANTITY_REJECTED
,      QUANTITY_SCRAPPED
,      QUANTITY_COMPLETED
,      QUANTITY_FIRST_PASS
,      REJECT_PERCENT
,      SCRAP_PERCENT
,      FPY_PERCENT
,      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_FPY;

Dependencies

[top of page]

WIP.WIP_WS_FPY does not reference any database object

WIP.WIP_WS_FPY is referenced by following:

SchemaAPPS
SynonymWIP_WS_FPY