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: GMI.GMI_CATEGORY_SETS

Object Details

Object Name:	GMI_CATEGORY_SETS
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.GMI_CATEGORY_SETS
Subobject Name:
Status:	VALID

Stores the association between the OPM Classifications and the Category Sets. Any defined Category Set can be assigned to an OPM Classification and the Category from that Category Set will be used in OPM for displaying and validating the values entered for the OPM Classifications.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMI_CATEGORY_SETS_U1	NORMAL	UNIQUE	APPS_TS_SEED	USER_OPM_CLASS
GMI_CATEGORY_SETS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	CATEGORY_SET_ID
GMI_CATEGORY_SETS_PK	NORMAL	NONUNIQUE	APPS_TS_SEED	OPM_CLASS

Columns

Name	Datatype	Length	Mandatory	Comments
OPM_CLASS	VARCHAR2	(40)	Yes	OPM Classifications surrogate code.
CATEGORY_SET_ID	NUMBER			Category Set assigned to the OPM Classification
USER_OPM_CLASS	VARCHAR2	(40)	Yes	OPM Classifications as displayed on the form.
RESTRICTED	VARCHAR2	(1)		This column will used internally to determine the classes which will be restricted to 1. upper case2. 8 character length. 3. No code change after assigning it to item.Valid values are (Y/N).
CREATED_BY	NUMBER		Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER			Who Column
MIGRATED_IND	NUMBER	(5)		Column indicating if the record has been migrated to discrete.1 = Yes, NULL = No

Query Text

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


SELECT OPM_CLASS
,      CATEGORY_SET_ID
,      USER_OPM_CLASS
,      RESTRICTED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MIGRATED_IND
FROM GMI.GMI_CATEGORY_SETS;

Dependencies

[top of page]

GMI.GMI_CATEGORY_SETS does not reference any database object

GMI.GMI_CATEGORY_SETS is referenced by following:

APPS: GMI_CATEGORY_SETS