[Home] [Help] [Dependency Information]
Object Name: | AMS_LIST_QUERIES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LIST_QUERIES_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
QUERY_TEMPLATE_ID | NUMBER | |||
OWNER_USER_ID | NUMBER | |||
QUERY_TYPE | VARCHAR2 | (30) | ||
ACT_LIST_QUERY_USED_BY_ID | NUMBER | |||
ARC_ACT_LIST_QUERY_USED_BY | VARCHAR2 | (30) | ||
SEED_FLAG | VARCHAR2 | (1) | ||
SQL_STRING | VARCHAR2 | (4000) | ||
SOURCE_OBJECT_NAME | VARCHAR2 | (60) | ||
PARENT_LIST_QUERY_ID | NUMBER | |||
SEQUENCE_ORDER | NUMBER | |||
PARAMETERIZED_FLAG | VARCHAR2 | (1) | ||
ADMIN_FLAG | VARCHAR2 | (1) | ||
LIST_QUERY_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
TYPE | VARCHAR2 | (30) | ||
QUERY | CLOB | (4000) | ||
ENABLED_FLAG | VARCHAR2 | (1) | ||
PRIMARY_KEY | VARCHAR2 | (60) | ||
PUBLIC_FLAG | VARCHAR2 | (1) | ||
COMMENTS | VARCHAR2 | (900) | ||
SECURITY_GROUP_ID | NUMBER | |||
NAME | VARCHAR2 | (300) | Yes | |
DESCRIPTION | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, QUERY_TEMPLATE_ID
, OWNER_USER_ID
, QUERY_TYPE
, 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
, ADMIN_FLAG
, LIST_QUERY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, TYPE
, QUERY
, ENABLED_FLAG
, PRIMARY_KEY
, PUBLIC_FLAG
, COMMENTS
, SECURITY_GROUP_ID
, NAME
, DESCRIPTION
FROM APPS.AMS_LIST_QUERIES_VL;
|
|
|