[Home] [Help] [Dependency Information]
Object Name: | CRP_PLANNED_RESOURCES |
---|---|
Object Type: | TABLE |
Owner: | CRP |
FND Design Data: | CRP.CRP_PLANNED_RESOURCES |
Subobject Name: | |
Status: | VALID |
CRP_PLANNED_RESOURCES stores the list of resources planned by the
planning process. CRP_PLANNED_RESOURCES stores resource information
for both routing based departments/resources and rate based lines.
OWNING_DEPARTMENT_ID stores the department identifier of the owning
department for shared resources.
RESOURCE_SHORTAGE_TYPE and RESOURCE_EXCESS_TYPE columns indicate the
nature of time fences used in calculating resource exceptions in the
memory based planner.
OVERUTILIZED_PERCENT and UNDERUTILIZED_PERCENT contain tolerances for
flagging resource overutilization and underutilization exceptions in
the memory based planner.
This table is populated by the Snapshot, and is used by the Planner.
Data in the table can be viewed in the Planner's Workbench.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CRP_PLANNED_RESOURCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
DEPARTMENT_ID RESOURCE_ID ORGANIZATION_ID |
CRP_PLANNED_RESOURCES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
LINE_ID ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
LINE_ID | NUMBER | Line identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
OWNING_DEPARTMENT_ID | NUMBER | Owning Department identifier for shared resource | ||
RESOURCE_SHORTAGE_TYPE | NUMBER | Resource shortage type | ||
RESOURCE_EXCESS_TYPE | NUMBER | Resource excess type | ||
OVERUTILIZED_PERCENT | NUMBER | Overutilization Tolerance(%) | ||
UNDERUTILIZED_PERCENT | NUMBER | Underutilization Tolerance(%) | ||
MAX_UTILIZATION | NUMBER | Not currently used | ||
MIN_UTILIZATION | NUMBER | Not currently used | ||
UTILIZATION | NUMBER | Utilization of the planned resource | ||
EFFICIENCY | NUMBER | Efficiency of the planned resource | ||
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 | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT COMPILE_DESIGNATOR
, ORGANIZATION_ID
, LINE_ID
, DEPARTMENT_ID
, RESOURCE_ID
, OWNING_DEPARTMENT_ID
, RESOURCE_SHORTAGE_TYPE
, RESOURCE_EXCESS_TYPE
, OVERUTILIZED_PERCENT
, UNDERUTILIZED_PERCENT
, MAX_UTILIZATION
, MIN_UTILIZATION
, UTILIZATION
, EFFICIENCY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM CRP.CRP_PLANNED_RESOURCES;
CRP.CRP_PLANNED_RESOURCES does not reference any database object
CRP.CRP_PLANNED_RESOURCES is referenced by following:
|
|
|