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: GMP.GMP_PROCESS_PARAMETERS_B

Object Details

Object Name:	GMP_PROCESS_PARAMETERS_B
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.GMP_PROCESS_PARAMETERS_B
Subobject Name:
Status:	VALID

Table for Process Parameters

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMP_PROCESS_PARAM_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARAMETER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_ID	NUMBER	(15)	Yes	Surrogate Key which uniquely identifies the Process Parameter
PARAMETER_NAME	VARCHAR2	(40)	Yes	Column which identifies the Process Parameter name (e.g., Speed, temperature etc., )
PARAMETER_TYPE	NUMBER		Yes	This field is a Validation type for this Process Parameter. Possible Values are 1Text 2Numeric Range 3List of values
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
UNITS	VARCHAR2	(25)		This field stores the unit of measure for the process parameter (e.g Degress, Celsius, Millimeters....)
DELETE_MARK	NUMBER		Yes	This column identifies if the process parameter is marked deleted or not. Valid values are 1Deleted, 0Not deleted.
TEXT_CODE	NUMBER	(10)		This column provides the edit Text feature
CREATION_DATE	DATE		Yes	Standard "Row Who" column
CREATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_DATE	DATE		Yes	Standard "Row Who" column
LAST_UPDATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_LOGIN	NUMBER			Standard "Row Who" column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Flex fields
ATTRIBUTE1	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE2	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE3	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE4	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE5	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE6	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE7	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE8	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE9	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE10	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE11	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE12	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE13	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE14	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE15	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE16	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE17	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE18	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE19	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE20	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE21	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE22	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE23	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE24	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE25	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE26	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE27	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE28	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE29	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE30	VARCHAR2	(240)		Standard Flex fields

Query Text

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


SELECT PARAMETER_ID
,      PARAMETER_NAME
,      PARAMETER_TYPE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      UNITS
,      DELETE_MARK
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM GMP.GMP_PROCESS_PARAMETERS_B;

Dependencies

[top of page]

GMP.GMP_PROCESS_PARAMETERS_B does not reference any database object

GMP.GMP_PROCESS_PARAMETERS_B is referenced by following:

APPS: GMP_PROCESS_PARAMETERS_B