[Home] [Help] [Dependency Information]
Object Name: | GME_PROCESS_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_PROCESS_PARAMETERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Supplementary view based on table gme_process_parameters
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_PARAM_ID | NUMBER | (15) | Yes | Resource Process Parameter ID Uniquely identifies a row in GME_PROCESS_PARAM |
BATCH_ID | NUMBER | (10) | Yes | Batch Id - FK to batch header table to identify the batch |
BATCHSTEP_ID | NUMBER | (15) | Yes | Batch Step ID - FK to Batch Step table to identify the batch step |
BATCHSTEP_ACTIVITY_ID | NUMBER | (15) | Yes | FK to Batch Step Activity Table |
BATCHSTEP_RESOURCE_ID | NUMBER | (15) | Yes | FK to Batch Step Resources Table |
RESOURCES | VARCHAR2 | (16) | Yes | Name of the resource to which process parameters are being attached |
PARAMETER_ID | NUMBER | Yes | Process Parameter ID from Master Table | |
PARAMETER_NAME | VARCHAR2 | (40) | Yes | Parameter Name |
PARAMETER_DESCRIPTION | VARCHAR2 | (240) | Yes | Parameter Description |
TARGET_VALUE | VARCHAR2 | (16) | Ideal value fo this process parameter.Not required if a Min & Max value are provided. May be text or a number | |
MINIMUM_VALUE | NUMBER | Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided | ||
MAXIMUM_VALUE | NUMBER | Maximum value for this Process Parameter. Not required if a Target or a Minimum value is provided | ||
ACTUAL_VALUE | VARCHAR2 | (16) | Actual value fo this process parameter. | |
PARAMETER_UOM | VARCHAR2 | (25) | Process Parameter UOM |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_PARAM_ID
, BATCH_ID
, BATCHSTEP_ID
, BATCHSTEP_ACTIVITY_ID
, BATCHSTEP_RESOURCE_ID
, RESOURCES
, PARAMETER_ID
, PARAMETER_NAME
, PARAMETER_DESCRIPTION
, TARGET_VALUE
, MINIMUM_VALUE
, MAXIMUM_VALUE
, ACTUAL_VALUE
, PARAMETER_UOM
FROM APPS.GME_PROCESS_PARAMETERS_V;
APPS.GME_PROCESS_PARAMETERS_V is not referenced by any database object
|
|
|