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: QA.QA_CHAR_INDEXES

Object Details

Object Name:	QA_CHAR_INDEXES
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_CHAR_INDEXES
Subobject Name:
Status:	VALID

Collection Element User-Defined Indexes. This table keeps track of information about user-defined indexes created on collection elements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_CHAR_INDEXES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHAR_ID ENABLED_FLAG
SYS_IL0000412102C00014$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
CHAR_ID	NUMBER		Yes	Collection element ID. This collection element has a user-defined index.
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
ENABLED_FLAG	NUMBER		Yes	Enabled Flag. 1 = Enabled, 2 = Disabled.
INDEX_NAME	VARCHAR2	(30)	Yes	The name of the index as specified by the user.
DEFAULT_RESULT_COLUMN	VARCHAR2	(30)		Default result column used as the final catch-all parameter in the decode function.
TEXT	CLOB	(4000)		The function text used in the function-based index.
ADDITIONAL_PARAMETERS	VARCHAR2	(2000)		Optional parameters as given by the user to be used as hints to the create index command.

Query Text

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


SELECT CHAR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ENABLED_FLAG
,      INDEX_NAME
,      DEFAULT_RESULT_COLUMN
,      TEXT
,      ADDITIONAL_PARAMETERS
FROM QA.QA_CHAR_INDEXES;

Dependencies

[top of page]

QA.QA_CHAR_INDEXES does not reference any database object

QA.QA_CHAR_INDEXES is referenced by following:

APPS: QA_CHAR_INDEXES