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: INV.MTL_CATEGORY_SET_VALID_CATS

Object Details

Object Name:	MTL_CATEGORY_SET_VALID_CATS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_CATEGORY_SET_VALID_CATS
Subobject Name:
Status:	VALID

MTL_CATEGORY_SET_VALID_CATS defines the valid category list for a
particular category set. A category set may be defined to either
require category validation or not. If category validation is
required, the list of valid categories for the category set is stored
in this table. This list is then used to restrict category selection
for the category set.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CATEGORY_SET_VALID_CATS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CATEGORY_SET_ID CATEGORY_ID
MTL_CATEGORY_SET_VALID_CATS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_SET_ID PARENT_CATEGORY_ID CATEGORY_ID

Columns

Name	Datatype	Mandatory	Comments
CATEGORY_SET_ID	NUMBER	Yes	Category set identifier
CATEGORY_ID	NUMBER	Yes	Valid category identifier
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column
PARENT_CATEGORY_ID	NUMBER		Valid parent category identifier

Query Text

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


SELECT CATEGORY_SET_ID
,      CATEGORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARENT_CATEGORY_ID
FROM INV.MTL_CATEGORY_SET_VALID_CATS;

Dependencies

[top of page]

INV.MTL_CATEGORY_SET_VALID_CATS does not reference any database object

INV.MTL_CATEGORY_SET_VALID_CATS is referenced by following:

APPS: MTL_CATEGORY_SET_VALID_CATS