[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_AUDIT_LKUPS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TABLE_APP_ID
AUDIT_TABLE_ID AUDIT_COLUMN_ID |
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 |
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;
APPLSYS.FND_AUDIT_LKUPS does not reference any database object
APPLSYS.FND_AUDIT_LKUPS is referenced by following:
|
|
|