eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.GME_PROCESS_PARAMETERS_V

Object Details

Object Name:	GME_PROCESS_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_PROCESS_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Supplementary view based on table gme_process_parameters

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.GME_PROCESS_PARAMETERS_V references the following:

APPS: GME_PROCESS_PARAMETERS; GMP_PROCESS_PARAMETERS_VL

APPS.GME_PROCESS_PARAMETERS_V is not referenced by any database object