[Home] [Help] [Dependency Information]
Object Name: | PC_RESOURCE_WK |
---|---|
Object Type: | TABLE |
Owner: | GME |
FND Design Data: | GME.PC_RESOURCE_WK |
Subobject Name: | |
Status: | VALID |
Table used for storing temporary data for running the Resource Variance Inquiry.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PC_RESOURCE_WK_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SEQ_ID
RESOURCES BATCH_ID BATCHSTEP_NO ACTIVITY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | (15) | Yes | Unique key identifying a run of the inquiry. |
RESOURCES | VARCHAR2 | (16) | Yes | A resource used in a batch step. |
BATCH_ID | NUMBER | (10) | Yes | Surrogate key identifying a batch. |
BATCHSTEP_NO | NUMBER | (5) | Yes | Number identifying a batch step. |
ACTIVITY | VARCHAR2 | (16) | Yes | Activity performed by a resource in a batch step. |
ACTUAL_START_DATE | DATE | Yes | Actual start date of a batch step. | |
PLAN_RSRC_USAGE | NUMBER | Yes | Planned usage of the resource. | |
ACTUAL_RSRC_USAGE | NUMBER | Yes | Actual usage of the resource. | |
USAGE_UM | VARCHAR2 | (4) | Yes | Unit of measure in which the usage is measured. |
ACTUAL_RSRC_COUNT | NUMBER | Yes | Actual number of the specific resource which were used. | |
PLAN_RSRC_COUNT | NUMBER | Yes | Number of specific resources which were planned to be used. | |
ACTUAL_USAGE | NUMBER | Yes | Actual usage of the resource, converted to the UOM specified by SY$UOM_HOURS. | |
PLND_USAGE | NUMBER | Yes | Planned usage of the resource, converted to the UOM specified by SY$UOM_HOURS. | |
PLAN_CMPLT_DATE | DATE | Yes | Planned completion date of the batch step. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
ACTUAL_CMPLT_DATE | DATE | Yes | Actual completion date of the batch step. | |
PLAN_START_DATE | DATE | Yes | Planned start date of the batch step. |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, RESOURCES
, BATCH_ID
, BATCHSTEP_NO
, ACTIVITY
, ACTUAL_START_DATE
, PLAN_RSRC_USAGE
, ACTUAL_RSRC_USAGE
, USAGE_UM
, ACTUAL_RSRC_COUNT
, PLAN_RSRC_COUNT
, ACTUAL_USAGE
, PLND_USAGE
, PLAN_CMPLT_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, ACTUAL_CMPLT_DATE
, PLAN_START_DATE
FROM GME.PC_RESOURCE_WK;
GME.PC_RESOURCE_WK does not reference any database object
GME.PC_RESOURCE_WK is referenced by following:
|
|
|