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.

[Home] [Help]

VIEW: AMS.AMS_PORTAL_CACHE#

Source

View Text - Preformatted


select CACHE_ID CACHE_ID, PARENT_ID PARENT_ID, CATEGORY_TYPE CATEGORY_TYPE, CATEGORY_ID CATEGORY_ID, DISPLAY_ORDER DISPLAY_ORDER, MEANING_CODE MEANING_CODE, MAX_CHILDREN MAX_CHILDREN, CHILD_COUNT CHILD_COUNT, PERZ_QUERY_ID PERZ_QUERY_ID, SUBCAT_TYPE SUBCAT_TYPE, VO_CLASSNAME VO_CLASSNAME, TD_CLASSNAME TD_CLASSNAME, QUERY_TYPE QUERY_TYPE, PERZ_QUERY_BIND_VARS PERZ_QUERY_BIND_VARS, ITEM_BIND_VARS ITEM_BIND_VARS, METHOD_CODE METHOD_CODE, CATEGORY_NAME CATEGORY_NAME, LANGUAGE LANGUAGE, DELETE_FLAG DELETE_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE from "AMS"."AMS_PORTAL_CACHE"

View Text - HTML Formatted

SELECT CACHE_ID CACHE_ID
, PARENT_ID PARENT_ID
, CATEGORY_TYPE CATEGORY_TYPE
, CATEGORY_ID CATEGORY_ID
, DISPLAY_ORDER DISPLAY_ORDER
, MEANING_CODE MEANING_CODE
, MAX_CHILDREN MAX_CHILDREN
, CHILD_COUNT CHILD_COUNT
, PERZ_QUERY_ID PERZ_QUERY_ID
, SUBCAT_TYPE SUBCAT_TYPE
, VO_CLASSNAME VO_CLASSNAME
, TD_CLASSNAME TD_CLASSNAME
, QUERY_TYPE QUERY_TYPE
, PERZ_QUERY_BIND_VARS PERZ_QUERY_BIND_VARS
, ITEM_BIND_VARS ITEM_BIND_VARS
, METHOD_CODE METHOD_CODE
, CATEGORY_NAME CATEGORY_NAME
, LANGUAGE LANGUAGE
, DELETE_FLAG DELETE_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "AMS"."AMS_PORTAL_CACHE"