DBA Data[Home] [Help] [Dependency Information]


TABLE: CSF.CSF_MD_LYR_METADATA

Object Details
Object Name: CSF_MD_LYR_METADATA
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_MD_LYR_METADATA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Columns
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

Query Text

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;

Dependencies

[top of page]

CSF.CSF_MD_LYR_METADATA does not reference any database object

CSF.CSF_MD_LYR_METADATA is referenced by following:

SchemaAPPS
SynonymCSF_MD_LYR_METADATA