[Home] [Help] [Dependency Information]
Object Name: | GMA_AUDIT_DISP_COLS |
---|---|
Object Type: | TABLE |
Owner: | GMA |
FND Design Data: | GMA.GMA_AUDIT_DISP_COLS |
Subobject Name: | |
Status: | VALID |
This table is to store Display columns for Shown on Audit Query Navigator
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMA_AUDIT_DISP_COLS_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
APPLICATION_ID
TABLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Table Owner Application ID as defined in FND Tables Table | |
TABLE_ID | NUMBER | Yes | Table ID as defined in FND Tables Table | |
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) | This column store From clause of SQL Query if COL_DISP_IND value is 1 | |
WHERE_CLAUSE | VARCHAR2 | (2000) | This column store Where clause of SQL Query if COL_DISP_IND value is 1 | |
MIGRATED_IND | VARCHAR2 | (1) | This column is to indentify data migrated to FND tables or not |
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
, MIGRATED_IND
FROM GMA.GMA_AUDIT_DISP_COLS;
GMA.GMA_AUDIT_DISP_COLS does not reference any database object
GMA.GMA_AUDIT_DISP_COLS is referenced by following:
|
|
|