[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 | (40) | 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 | (16) | Yes | Cost component class |
RESOURCE_COST_COMP_CLASS_DESC | VARCHAR2 | (40) | 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 | (4) | 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 | (16) | Cost component class | |
OPERATION_COST_COMP_CLASS_DESC | VARCHAR2 | (40) | 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.PMIFV_RESOURCE_PLAN_V is not referenced by any database object
|
|
|