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

TABLE: AMS.AMS_CPAG_QUERY_USAGES

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_CPAG_QUERY_USAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQUERY_USAGE_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_USAGE_ID NUMBER
Yes The Primary Key for this table.
QUERY_USED_BY_TYPE VARCHAR2 (30) Yes The Object Type, the sys arc qualifier of the Object that uses this Query. This field along with the Query Used By Id uniquely identifies the object that uses this Query.
QUERY_USED_BY_ID NUMBER
Yes The Object ID of the Object that uses the Query.
QUERY_ID NUMBER
Yes The Query Id of the Query used by the Object indicated in the record.
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Last update login
OBJECT_VERSION_NUMBER NUMBER

Used for locking purposes
SECURITY_GROUP_ID NUMBER

Used for locking purpose
Query Text

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


SELECT QUERY_USAGE_ID
,      QUERY_USED_BY_TYPE
,      QUERY_USED_BY_ID
,      QUERY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM AMS.AMS_CPAG_QUERY_USAGES;

Dependencies

[top of page]

AMS.AMS_CPAG_QUERY_USAGES does not reference any database object

AMS.AMS_CPAG_QUERY_USAGES is referenced by following:

SchemaAMS
ViewAMS_CPAG_QUERY_USAGES#