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]

TABLE: GMD.GMD_OPRN_PROCESS_PARAMETERS

Object Details

Object Name:	GMD_OPRN_PROCESS_PARAMETERS
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_OPRN_PROCESS_PARAMETERS
Subobject Name:
Status:	VALID

Table associating process parameters to operation resource

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_OPRN_PROC_PARAM_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OPRN_LINE_ID RESOURCES PARAMETER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OPRN_LINE_ID	NUMBER	(15)	Yes	Column which identifies the Operation line, Foregn key to GMD_OPERATION_RESOURCES.OPRN_LINE_ID
RESOURCES	VARCHAR2	(16)	Yes	Column which identifies the Resources, Foreign key to cr_rsrc_mst.resources
PARAMETER_ID	NUMBER	(15)	Yes	Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set
TARGET_VALUE	VARCHAR2	(16)		Ideal Value for this process parameter. Not required if a Min and max Values are specified
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 Maximum value is provided
CREATION_DATE	DATE		Yes	Standard "Row Who" column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard "Row Who" column
CREATED_BY	NUMBER	(15)	Yes	Standard "Row Who" column
LAST_UPDATE_DATE	DATE		Yes	Standard "Row Who" column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard "Row Who" column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPRN_LINE_ID
,      RESOURCES
,      PARAMETER_ID
,      TARGET_VALUE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM GMD.GMD_OPRN_PROCESS_PARAMETERS;

Dependencies

[top of page]

GMD.GMD_OPRN_PROCESS_PARAMETERS does not reference any database object

GMD.GMD_OPRN_PROCESS_PARAMETERS is referenced by following:

APPS: GMD_OPRN_PROCESS_PARAMETERS