[Home] [Help] [Dependency Information]
Object Name: | WIP_WS_RES_SHORTAGE |
---|---|
Object Type: | TABLE |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
Table to maintain resource shortages information for Discrete MES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_WS_RES_SHORTAGE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
WIP_ENTITY_ID OPERATION_SEQ_NUM RESOURCE_ID |
WIP_WS_RES_SHORTAGE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Oraganization ID | |
WIP_ENTITY_ID | NUMBER | Yes | Job ID | |
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number | |
RESOURCE_ID | NUMBER | Yes | Resource ID | |
DEPARTMENT_ID | NUMBER | Yes | Department ID | |
DATE_REQUIRED | DATE | Required date of the resource | ||
REQUIRED_QTY | NUMBER | Required quantity of the resource | ||
QUANTITY_ISSUED | NUMBER | Quantity charged to the resource | ||
QUANTITY_OPEN | NUMBER | Quantity need to be charged to the resource | ||
RESOURCE_AVAIL | NUMBER | Availability of the resource | ||
RESOURCE_PROJ_AVAIL | NUMBER | Projected availability of the resource | ||
RESOURCE_SHORTAGE | NUMBER | Resource shortage | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM | |
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_APPLICATION_ID | NUMBER | Enhance Who column | ||
PROGRAM_ID | NUMBER | Enhance Who column | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
PROGRAM_RUN_DATE | DATE | The date that concurrent request is run |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, RESOURCE_ID
, DEPARTMENT_ID
, DATE_REQUIRED
, REQUIRED_QTY
, QUANTITY_ISSUED
, QUANTITY_OPEN
, RESOURCE_AVAIL
, RESOURCE_PROJ_AVAIL
, RESOURCE_SHORTAGE
, PRIMARY_UOM_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, OBJECT_VERSION_NUMBER
, PROGRAM_RUN_DATE
FROM WIP.WIP_WS_RES_SHORTAGE;
WIP.WIP_WS_RES_SHORTAGE does not reference any database object
WIP.WIP_WS_RES_SHORTAGE is referenced by following:
|
|
|