[Home] [Help] [Dependency Information]
Object Name: | FND_AUDIT_DISP_COLS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_AUDIT_DISP_COLS |
Subobject Name: | |
Status: | VALID |
This table stores display columns for the Audit Query Navigator
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_AUDIT_DISP_COLS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
TABLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Application ID | |
TABLE_ID | NUMBER | Yes | Table ID | |
COL_DISP_IND | NUMBER | 0 - for Column List, 1 - for sql query | ||
SELECT_CLAUSE | VARCHAR2 | (2000) | This is to store column list for both options | |
FROM_CLAUSE | VARCHAR2 | (2000) | f col_disp_ind=1, the column stores the from clause | |
WHERE_CLAUSE | VARCHAR2 | (2000) | if col_disp_ind=1, the column stores the where clause |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, TABLE_ID
, COL_DISP_IND
, SELECT_CLAUSE
, FROM_CLAUSE
, WHERE_CLAUSE
FROM APPLSYS.FND_AUDIT_DISP_COLS;
APPLSYS.FND_AUDIT_DISP_COLS does not reference any database object
APPLSYS.FND_AUDIT_DISP_COLS is referenced by following:
|
|
|