[Home] [Help]
View: GME_PROCESS_PARAMETERS_V
Product: | GME - Process Manufacturing Process Execution |
Description: | Supplementary view based on table gme_process_parameters |
Implementation/DBA Data: |
APPS.GME_PROCESS_PARAMETERS_V
|
View Text
SELECT GPP.PROCESS_PARAM_ID
, GPP.BATCH_ID
, GPP.BATCHSTEP_ID
, GPP.BATCHSTEP_ACTIVITY_ID
, GPP.BATCHSTEP_RESOURCE_ID
, GPP.RESOURCES
, GPP.PARAMETER_ID
, PP.PARAMETER_NAME
, PP.PARAMETER_DESCRIPTION
, GPP.TARGET_VALUE
, GPP.MINIMUM_VALUE
, GPP.MAXIMUM_VALUE
, GPP.ACTUAL_VALUE
, GPP.PARAMETER_UOM
FROM GME_PROCESS_PARAMETERS GPP
, GMP_PROCESS_PARAMETERS_VL PP
WHERE GPP.PARAMETER_ID = PP.PARAMETER_ID
Columns
Name |
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 |