[Home] [Help] [Dependency Information]
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 |
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
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|