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

TABLE: AMS.AMS_LIST_QUERIES_ALL

Object Details
Object Name: AMS_LIST_QUERIES_ALL
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_LIST_QUERIES_ALL
Subobject Name:
Status: VALID


Stores the predefined criteria for list creation.
The table was created to support upgrade from OSM to Oracle Marketing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_LIST_QUERIES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_QUERY_ID
ColumnZD_EDITION_NAME
SYS_IL0000081112C00024$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
AMS_LIST_QUERIES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACT_LIST_QUERY_USED_BY_ID
ColumnARC_ACT_LIST_QUERY_USED_BY
AMS_LIST_QUERIES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_TEMPLATE_ID
AMS_LIST_QUERIES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_LIST_QUERY_ID
AMS_LIST_QUERIES_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_USER_ID
Columns
Name Datatype Length Mandatory Comments
LIST_QUERY_ID NUMBER
Yes Query Identifier.
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who Column.
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
NAME VARCHAR2 (240)
Name of the query.
TYPE VARCHAR2 (30)
Type of list that can be generated from this query.
ENABLED_FLAG VARCHAR2 (1)
Enabled Flag
PRIMARY_KEY VARCHAR2 (60)
Primary Key identifier.
PUBLIC_FLAG VARCHAR2 (1)
Public Flag.
ORG_ID NUMBER (32)
for OSM upgrade only.
COMMENTS VARCHAR2 (900)
Long description for this query.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
ACT_LIST_QUERY_USED_BY_ID NUMBER

Cell Id
ARC_ACT_LIST_QUERY_USED_BY VARCHAR2 (30)
Sys Arc Qualifer for Segment ie. CELL
SEED_FLAG VARCHAR2 (1)
Seed Flag Y or N
SQL_STRING VARCHAR2 (4000)
SQL string
SOURCE_OBJECT_NAME VARCHAR2 (60)
Name of Primary Table
PARENT_LIST_QUERY_ID NUMBER

SQL could be split in chunks of 4000 charachters. Parent list query id provides the link to the first chunk.
SEQUENCE_ORDER NUMBER

Order of sql strings
PARAMETERIZED_FLAG VARCHAR2 (1)
Parameterized flag to indicate whether the query is parameterized.
QUERY CLOB (4000)
Query SQL statement.
ADMIN_FLAG VARCHAR2 (1)
Populated as Y if query corresponds to parameterized admin query template.
QUERY_TEMPLATE_ID NUMBER

Populated for a parameterized query template
OWNER_USER_ID NUMBER

Owner User Id
QUERY_TYPE VARCHAR2 (30)
Value indicating SQL/SPLIT or PARAMETERIZED.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT LIST_QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      NAME
,      TYPE
,      ENABLED_FLAG
,      PRIMARY_KEY
,      PUBLIC_FLAG
,      ORG_ID
,      COMMENTS
,      SECURITY_GROUP_ID
,      ACT_LIST_QUERY_USED_BY_ID
,      ARC_ACT_LIST_QUERY_USED_BY
,      SEED_FLAG
,      SQL_STRING
,      SOURCE_OBJECT_NAME
,      PARENT_LIST_QUERY_ID
,      SEQUENCE_ORDER
,      PARAMETERIZED_FLAG
,      QUERY
,      ADMIN_FLAG
,      QUERY_TEMPLATE_ID
,      OWNER_USER_ID
,      QUERY_TYPE
,      ZD_EDITION_NAME
FROM AMS.AMS_LIST_QUERIES_ALL;

Dependencies

[top of page]

AMS.AMS_LIST_QUERIES_ALL does not reference any database object

AMS.AMS_LIST_QUERIES_ALL is referenced by following:

SchemaAMS
ViewAMS_LIST_QUERIES_ALL#