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: APPLSYS.FND_AUDIT_LKUPS

Object Details

Object Name:	FND_AUDIT_LKUPS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_AUDIT_LKUPS
Subobject Name:
Status:	VALID

This table stores Lookup Type information to show decoded column values in the Audit Query Navigator.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_AUDIT_LKUPS_U1	NORMAL	UNIQUE	APPS_TS_SEED	TABLE_APP_ID AUDIT_TABLE_ID AUDIT_COLUMN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_TABLE_ID	NUMBER		Yes	Audit table ID
AUDIT_COLUMN_ID	NUMBER		Yes	Audit column ID
TABLE_APP_ID	NUMBER		Yes	Table application ID
LOOKUP_TYPE	VARCHAR2	(80)		FND Lookup type
LOOKUP_APP_ID	NUMBER	(15)		Lookup App Id
LOOKUP_TABLE_ID	NUMBER	(15)		Lookup Table Id
LOOKUP_TABLE_NAME	VARCHAR2	(30)		Lookup Table Name
LOOKUP_COLUMN_NAME	VARCHAR2	(30)		Lookup Column Name
DISPLAY_COLUMN_NAME	VARCHAR2	(30)		Display Column Name

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
,      LOOKUP_APP_ID
,      LOOKUP_TABLE_ID
,      LOOKUP_TABLE_NAME
,      LOOKUP_COLUMN_NAME
,      DISPLAY_COLUMN_NAME
FROM APPLSYS.FND_AUDIT_LKUPS;

Dependencies

[top of page]

APPLSYS.FND_AUDIT_LKUPS does not reference any database object

APPLSYS.FND_AUDIT_LKUPS is referenced by following:

APPS: FND_AUDIT_LKUPS