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.GMD_OPRN_PROCESS_PARAMETERS_V1

Object Details

Object Name:	GMD_OPRN_PROCESS_PARAMETERS_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_OPRN_PROCESS_PARAMETERS_V1
Subobject Name:
Status:	VALID

View Type

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

View of joining the overrides from operation resource and generic resource

[View Source]

Columns

Name	Datatype	Length	Comments
OPERATION_OVERRIDE	NUMBER		Operation Override
OPRN_LINE_ID	NUMBER	(15)	Column which identifies the Operation line, Foreign key to GMD_OPERATION_RESOURCES.OPRN_LINE_ID
RESOURCES	VARCHAR2	(16)	Column which identifies the Resources, Foreign key to cr_rsrc_mst.resources
SEQUENCE_NO	NUMBER		This column uniquely identifies the orders in which the Process Parameter is stored
PARAMETER_ID	NUMBER	(15)	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		Standard "Row Who" Column
LAST_UPDATE_LOGIN	NUMBER		Standard "Row Who" Column
CREATED_BY	NUMBER		Standard "Row Who" Column
LAST_UPDATE_DATE	DATE		Standard "Row Who" Column
LAST_UPDATED_BY	NUMBER		Standard "Row Who" Column

Query Text

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


SELECT OPERATION_OVERRIDE
,      OPRN_LINE_ID
,      RESOURCES
,      SEQUENCE_NO
,      PARAMETER_ID
,      TARGET_VALUE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.GMD_OPRN_PROCESS_PARAMETERS_V1;

Dependencies

[top of page]

APPS.GMD_OPRN_PROCESS_PARAMETERS_V1 references the following:

APPS: GMD_OPERATION_RESOURCES; GMD_OPRN_PROCESS_PARAMETERS; GMP_RESOURCE_PARAMETERS

APPS.GMD_OPRN_PROCESS_PARAMETERS_V1 is referenced by following:

APPS: GMD_FETCH_OPRN - show dependent code; GMD_VERSION_CONTROL - show dependent code