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.

VIEW: APPS.MSC_COLL_SNAPSHOTS_V

Source

View Text - Preformatted


SELECT lookup_type, lookup_code serial_no, meaning mview_name, description mview_description, attribute1 erp_product_code, attribute3 logging_clause, attribute4 parallel_degree, attribute6 snapshot_group_string, attribute7 synonym_name, attribute11 master_table, attribute13 last_split_refresh_type, attribute12 complete_refresh_timestamp, attribute10 existance_check, attribute8 ad_table_name, attribute9 check_for_cont_refresh FROM fnd_lookup_values WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND enabled_flag = 'Y' AND view_application_id = 700 AND LANGUAGE = userenv('lang')

View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE SERIAL_NO
, MEANING MVIEW_NAME
, DESCRIPTION MVIEW_DESCRIPTION
, ATTRIBUTE1 ERP_PRODUCT_CODE
, ATTRIBUTE3 LOGGING_CLAUSE
, ATTRIBUTE4 PARALLEL_DEGREE
, ATTRIBUTE6 SNAPSHOT_GROUP_STRING
, ATTRIBUTE7 SYNONYM_NAME
, ATTRIBUTE11 MASTER_TABLE
, ATTRIBUTE13 LAST_SPLIT_REFRESH_TYPE
, ATTRIBUTE12 COMPLETE_REFRESH_TIMESTAMP
, ATTRIBUTE10 EXISTANCE_CHECK
, ATTRIBUTE8 AD_TABLE_NAME
, ATTRIBUTE9 CHECK_FOR_CONT_REFRESH
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MSC_COLL_SNAPSHOTS'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 700
AND LANGUAGE = USERENV('LANG')