[Home] [Help]
[Dependency Information]
| Object Name: | CSF_MD_LYR_METADATA |
|---|---|
| Object Type: | TABLE |
| Owner: | CSF |
| FND Design Data: | CSF.CSF_MD_LYR_METADATA
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | APPS_TS_MEDIA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAYER_METADATA_ID | NUMBER | (30) | Yes | |
| THEME_METADATA_ID | NUMBER | (30) | Yes | |
| LAYER_NAME | VARCHAR2 | (32) | ||
| LAYER_DB_LINK | VARCHAR2 | (32) | ||
| LAYER_OWNER | VARCHAR2 | (32) | ||
| LAYER_TABLE | VARCHAR2 | (32) | ||
| LAYER_WHERE_CLAUSE | VARCHAR2 | (1024) | ||
| LAYER_VERSION | VARCHAR2 | (32) | ||
| CREATION_DATE | DATE | |||
| COPYRIGHT_DATE | DATE | |||
| LAST_EDIT_DATE | DATE | |||
| CHAR_SET | VARCHAR2 | (32) | ||
| LAYER_STYLE_SHEET_ID | NUMBER | (30) | Yes | |
| INST_STYLE_ID | NUMBER | (30) | Yes | |
| LAYER_TABLE_2 | VARCHAR2 | (32) | ||
| LAYER_TABLE_3 | VARCHAR2 | (32) | ||
| LAYER_WHERE_CLAUSE_2 | VARCHAR2 | (1024) | ||
| GEOMETRY_COLUMN_NAME | VARCHAR2 | (240) | ||
| ID_COLUMN_NAME | VARCHAR2 | (240) | ||
| ITEM_NAME_COLUMN_NAME | VARCHAR2 | (240) | ||
| SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LAYER_METADATA_ID
, THEME_METADATA_ID
, LAYER_NAME
, LAYER_DB_LINK
, LAYER_OWNER
, LAYER_TABLE
, LAYER_WHERE_CLAUSE
, LAYER_VERSION
, CREATION_DATE
, COPYRIGHT_DATE
, LAST_EDIT_DATE
, CHAR_SET
, LAYER_STYLE_SHEET_ID
, INST_STYLE_ID
, LAYER_TABLE_2
, LAYER_TABLE_3
, LAYER_WHERE_CLAUSE_2
, GEOMETRY_COLUMN_NAME
, ID_COLUMN_NAME
, ITEM_NAME_COLUMN_NAME
, SECURITY_GROUP_ID
FROM CSF.CSF_MD_LYR_METADATA;
CSF.CSF_MD_LYR_METADATA does not reference any database object
CSF.CSF_MD_LYR_METADATA is referenced by following:
CSF
CSF_MD_LYR_METADATA#
|
|
|
|