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_QUERY_TEMPLATE_ALL

Object Details

Object Name:	AMS_QUERY_TEMPLATE_ALL
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_QUERY_TEMPLATE_ALL
Subobject Name:
Status:	VALID

This table stores the query template information in Audience Workbench.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_QUERY_TEMPLATE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
AMS_QUERY_TEMPLATE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_TYPE
AMS_QUERY_TEMPLATE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_SRC_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER		Yes	Unique 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			Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
VIEW_APPLICATION_ID	NUMBER			Application Id of Oracle Product that created the lov.
SEEDED_FLAG	VARCHAR2	(1)		Indicates if the query template is seeded.
ENABLED_FLAG	VARCHAR2	(1)		Indicates if the query template is enabled.
TEMPLATE_TYPE	VARCHAR2	(30)		The template type - STANDARD or PARAMETERIZED.
IN_USE_FLAG	VARCHAR2	(1)		Indicates if the query template has been used by any list etc.
LIST_SRC_TYPE	VARCHAR2	(30)		Data source code identifying the data source to which the query template is tied.
SECURITY_GROUP_ID	NUMBER			Column not currently used.
MV_NAME	VARCHAR2	(30)		Stores the view name.
MV_AVAILABLE_FLAG	VARCHAR2	(1)		Flag for views availability.
SAMPLE_PCT	NUMBER			Sample pct.
MASTER_DS_REC_NUMBERS	NUMBER			Total # of records in the data source.
SAMPLE_PCT_RECORDS	NUMBER			Total # of sample records.
AQE_ID	NUMBER			Stores Programmatic access code
RECALC_TABLE_STATUS	VARCHAR2	(30)		recalc table status

Query Text

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


SELECT TEMPLATE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      VIEW_APPLICATION_ID
,      SEEDED_FLAG
,      ENABLED_FLAG
,      TEMPLATE_TYPE
,      IN_USE_FLAG
,      LIST_SRC_TYPE
,      SECURITY_GROUP_ID
,      MV_NAME
,      MV_AVAILABLE_FLAG
,      SAMPLE_PCT
,      MASTER_DS_REC_NUMBERS
,      SAMPLE_PCT_RECORDS
,      AQE_ID
,      RECALC_TABLE_STATUS
FROM AMS.AMS_QUERY_TEMPLATE_ALL;

Dependencies

[top of page]

AMS.AMS_QUERY_TEMPLATE_ALL does not reference any database object

AMS.AMS_QUERY_TEMPLATE_ALL is referenced by following:

APPS: AMS_QUERY_TEMPLATE_ALL