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: GMA.GMA_AUDIT_LKUPS

Object Details

Object Name:	GMA_AUDIT_LKUPS
Object Type:	TABLE
Owner:	GMA
FND Design Data:	GMA.GMA_AUDIT_LKUPS
Subobject Name:
Status:	VALID

This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMA_AUDIT_LKUPS_P	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TABLE_APP_ID AUDIT_TABLE_ID AUDIT_COLUMN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_TABLE_ID	NUMBER		Yes	Table ID as defined in FND Audit Columns Table
AUDIT_COLUMN_ID	NUMBER		Yes	Column ID as defined in FND Audit Columns Table
TABLE_APP_ID	NUMBER		Yes	Table Owner Application ID as defined in FND Audit Columns Table
LOOKUP_TYPE	VARCHAR2	(80)		FND Lookup Type

Query Text

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


SELECT AUDIT_TABLE_ID
,      AUDIT_COLUMN_ID
,      TABLE_APP_ID
,      LOOKUP_TYPE
FROM GMA.GMA_AUDIT_LKUPS;

Dependencies

[top of page]

GMA.GMA_AUDIT_LKUPS does not reference any database object

GMA.GMA_AUDIT_LKUPS is referenced by following:

APPS: GMA_AUDIT_LKUPS