VIEW: APPS.MRP_CL_REFRESH_COLL_SNAPSHOT_V

Source

View Text - Preformatted

SELECT snapshot_group_string, snapshot_group_display FROM msc_coll_entities_v WHERE snapshot_usage = 'Y' UNION ALL SELECT mview_name, mview_name FROM msc_coll_snapshots_v

View Text - HTML Formatted

SELECT SNAPSHOT_GROUP_STRING
, SNAPSHOT_GROUP_DISPLAY
FROM MSC_COLL_ENTITIES_V
WHERE SNAPSHOT_USAGE = 'Y' UNION ALL SELECT MVIEW_NAME
, MVIEW_NAME
FROM MSC_COLL_SNAPSHOTS_V