FND Design Data [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: ViewAPPS.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