eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AMS.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_LIST_QUERIES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_QUERY_ID
AMS_LIST_QUERIES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACT_LIST_QUERY_USED_BY_ID ARC_ACT_LIST_QUERY_USED_BY
AMS_LIST_QUERIES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUERY_TEMPLATE_ID
AMS_LIST_QUERIES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LIST_QUERY_ID
AMS_LIST_QUERIES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_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	LONG	(0)		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.

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
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:

APPS: AMS_LIST_QUERIES_ALL