[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIFV_RESOURCE_PLAN_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIFV_RESOURCE_PLAN_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Availability and planned usage of Process Manufacturing resources
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESOURCES | VARCHAR2 | (16) | Yes | Code for the resource. |
| RESOURCE_DESC | VARCHAR2 | (240) | Yes | Description of the resource. |
| STD_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which resource usage is expressed. | |
| RESOURCE_CLASS | VARCHAR2 | (8) | Resource class to which the resource belongs. | |
| RESOURCE_COST_COMP_CLASS_ID | NUMBER | (10) | Yes | Surrogate key of the cost component class which is used for tracking costs. |
| RESOURCE_COST_COMP_CLASS_CODE | VARCHAR2 | (32) | Yes | Cost component class |
| RESOURCE_COST_COMP_CLASS_DESC | VARCHAR2 | (240) | Yes | Cost component class description |
| ORGANIZATION | VARCHAR2 | (4) | Plant code | |
| GROUP_RESOURCE | VARCHAR2 | (16) | Resource group - resources can be grouped by this type | |
| ASSIGNED_QTY | NUMBER | How many of this resource are in this plant. | ||
| DAILY_AVAIL_USE | NUMBER | Number of hours the resource is available in the plant each day. | ||
| RESOURCE_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which daily_avail_use is expressed. | |
| NOMINAL_COST | NUMBER | Cost of the resource in the plant. | ||
| INACTIVE_IND | NUMBER | Inactive indicator. 0=Active, 1=Inactive. | ||
| IDEAL_CAPACITY | NUMBER | Optimum throughput capacity. | ||
| MIN_CAPACITY | NUMBER | Minimum throughput capacity. | ||
| MAX_CAPACITY | NUMBER | Maximum throughput capacity. | ||
| CAPACITY_UOM | VARCHAR2 | (4) | Unit of measure in which capacity is expressed. | |
| BATCH_ID | NUMBER | (10) | Surrogate key to the batch. | |
| BATCHSTEP_NO | NUMBER | (10) | Yes | The number of the batch step performing the operation. |
| ACTIVITY | VARCHAR2 | (16) | Yes | The activity performed in the operation. |
| ACTIVITY_DESC | VARCHAR2 | (40) | Description of the activity. | |
| BATCHSTEPLINE_ID | NUMBER | (10) | Surrogate key to the batch step line. | |
| OPRN_LINE_ID | NUMBER | (10) | Surrogate key to the operation line, 0 if a resource/activity was inserted for the batch. | |
| COST_ANALYSIS_CODE | VARCHAR2 | (32) | Cost analysis code, defaults from fm_oprn_dtl. | |
| OPERATION_COST_COMP_CLASS_ID | NUMBER | (10) | Surrogate key for a cost component class , defaults from fm_oprn_dtl. | |
| OPERATION_COST_COMP_CLASS_CODE | VARCHAR2 | (32) | Cost component class | |
| OPERATION_COST_COMP_CLASS_DESC | VARCHAR2 | (240) | Cost component class description | |
| PRIMARY_RESOURCE_INDICATOR | NUMBER | (5) | Primary resource indicator. 0=Not primary resource, 1=Primary resource. | |
| SCALE_TYPE | NUMBER | (5) | Scale type. 0=Non-scaleable, 1=Linear scaling. | |
| PLAN_RESOURCE_COUNT | NUMBER | Planned resource count, defaults from fm_oprn_dtl. | ||
| ACTUAL_RESOURCE_COUNT | NUMBER | Actual resource count, recorded during WIP or certification. | ||
| PLAN_RESOURCE_QTY | NUMBER | Planned quantity processed by the resource. | ||
| ACTUAL_RESOURCE_QTY | NUMBER | Actual quantity processed by the resource. | ||
| PLAN_RESOURCE_USAGE | NUMBER | Planned resource usage, defaults from fm_oprn_dtl. | ||
| ACTUAL_RESOURCE_USAGE | NUMBER | Actual resource usage, recorded during WIP or certification. | ||
| OPERATION_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which the usage is expressed. | |
| DEPENDENT_OPRN_LINE_ID | VARCHAR2 | (0) | Surrogate key to the operation line that this step depends on. | |
| OFFSET_INTERVAL | NUMBER | Time offset in hours from operation start to this resource/activity. | ||
| PLAN_START_DATE | DATE | Planned start date/time for this step. | ||
| ACTUAL_START_DATE | DATE | Actual start date/time for this step. | ||
| PLAN_COMPLETE_DATE | DATE | Planned completion date/time for this step. | ||
| ACTUAL_COMPLETE_DATE | DATE | Actual completion date/time for this step. | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCES
, RESOURCE_DESC
, STD_USAGE_UOM
, RESOURCE_CLASS
, RESOURCE_COST_COMP_CLASS_ID
, RESOURCE_COST_COMP_CLASS_CODE
, RESOURCE_COST_COMP_CLASS_DESC
, ORGANIZATION
, GROUP_RESOURCE
, ASSIGNED_QTY
, DAILY_AVAIL_USE
, RESOURCE_USAGE_UOM
, NOMINAL_COST
, INACTIVE_IND
, IDEAL_CAPACITY
, MIN_CAPACITY
, MAX_CAPACITY
, CAPACITY_UOM
, BATCH_ID
, BATCHSTEP_NO
, ACTIVITY
, ACTIVITY_DESC
, BATCHSTEPLINE_ID
, OPRN_LINE_ID
, COST_ANALYSIS_CODE
, OPERATION_COST_COMP_CLASS_ID
, OPERATION_COST_COMP_CLASS_CODE
, OPERATION_COST_COMP_CLASS_DESC
, PRIMARY_RESOURCE_INDICATOR
, SCALE_TYPE
, PLAN_RESOURCE_COUNT
, ACTUAL_RESOURCE_COUNT
, PLAN_RESOURCE_QTY
, ACTUAL_RESOURCE_QTY
, PLAN_RESOURCE_USAGE
, ACTUAL_RESOURCE_USAGE
, OPERATION_USAGE_UOM
, DEPENDENT_OPRN_LINE_ID
, OFFSET_INTERVAL
, PLAN_START_DATE
, ACTUAL_START_DATE
, PLAN_COMPLETE_DATE
, ACTUAL_COMPLETE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIFV_RESOURCE_PLAN_V;
APPS
CM_CMPT_MST
CR_RSRC_DTL
CR_RSRC_MST
FM_ACTV_MST
GMA_CORE_PKG
- show dependent code
GME_BATCH_STEPS
GME_BATCH_STEP_ACTIVITIES
GME_BATCH_STEP_RESOURCES
PMI_SECURITY_PKG
- show dependent code
SY_ORGN_MST
APPS.PMIFV_RESOURCE_PLAN_V is not referenced by any database object
|
|
|
|