[Home] [Help] [Dependency Information]
Object Name: | FND_VIEW_COLUMNS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_VIEW_COLUMNS |
Subobject Name: | |
Status: | VALID |
FND_VIEW_COLUMNS stores information about individual columns in
application views. Each row includes the view column name and its
sequence in the view. You need one row for each view column in
each application. Oracle Applications uses this information when
installing and upgrading the database.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_VIEW_COLUMNS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
COLUMN_NAME
APPLICATION_ID VIEW_ID ZD_EDITION_NAME |
FND_VIEW_COLUMNS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
VIEW_ID COLUMN_SEQUENCE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
VIEW_ID | NUMBER | (15) | Yes | View identifier |
COLUMN_SEQUENCE | NUMBER | (15) | Yes | Sequence of the column in the view |
COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
IREP_COMMENTS | VARCHAR2 | (4000) | Comments from CASE | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, VIEW_ID
, COLUMN_SEQUENCE
, COLUMN_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IREP_COMMENTS
, ZD_EDITION_NAME
FROM APPLSYS.FND_VIEW_COLUMNS;
APPLSYS.FND_VIEW_COLUMNS does not reference any database object
APPLSYS.FND_VIEW_COLUMNS is referenced by following:
|
|
|