DBA Data[Home] [Help]

VIEW: APPS.GME_PROCESS_PARAMETERS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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