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 ZD_EDITION_NAME
MTL_CATEGORY_SET_VALID_CATS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_SET_ID PARENT_CATEGORY_ID CATEGORY_ID

Columns

Name	Datatype	Length	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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
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:

INV: MTL_CATEGORY_SET_VALID_CATS#