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


TABLE: OSM.AS_LIST_QUERIES

Object Details
Object Name: AS_LIST_QUERIES
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_LIST_QUERIES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_LIST_QUERIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQUERY_ID
AS_LIST_QUERIES_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnNAME
ColumnTYPE
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes
NAME VARCHAR2 (240) Yes
TYPE VARCHAR2 (30) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
PRIMARY_KEY VARCHAR2 (60) Yes
PUBLIC_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
COMMENTS VARCHAR2 (900)
QUERY LONG (0)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUERY_ID
,      NAME
,      TYPE
,      ENABLED_FLAG
,      PRIMARY_KEY
,      PUBLIC_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMENTS
,      QUERY
FROM OSM.AS_LIST_QUERIES;

Dependencies

[top of page]

OSM.AS_LIST_QUERIES does not reference any database object

OSM.AS_LIST_QUERIES is referenced by following:

SchemaAPPS
SynonymAS_LIST_QUERIES