View: AMS_LIST_QUERIES_VL

Product:	AMS - Marketing
Description:	This view stores the list queries.
Implementation/DBA Data:	APPS.AMS_LIST_QUERIES_VL

View Text

SELECT B.ROWID ROW_ID
, B.QUERY_TEMPLATE_ID
, B.OWNER_USER_ID
, B.QUERY_TYPE
, B.ACT_LIST_QUERY_USED_BY_ID
, B.ARC_ACT_LIST_QUERY_USED_BY
, B.SEED_FLAG
, B.SQL_STRING
, B.SOURCE_OBJECT_NAME
, B.PARENT_LIST_QUERY_ID
, B.SEQUENCE_ORDER
, B.PARAMETERIZED_FLAG
, B.ADMIN_FLAG
, B.LIST_QUERY_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.TYPE
, B.QUERY
, B.ENABLED_FLAG
, B.PRIMARY_KEY
, B.PUBLIC_FLAG
, B.COMMENTS
, B.SECURITY_GROUP_ID
, T.NAME
, T.DESCRIPTION
FROM AMS_LIST_QUERIES_TL T
, AMS_LIST_QUERIES_ALL B
WHERE B.LIST_QUERY_ID = T.LIST_QUERY_ID
AND T.LANGUAGE = USERENV('LANG')

Columns