[Home] [Help] [Dependency Information]
Object Name: | MSC_COLL_SNAPSHOTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
List of Collections snapshots
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | lookup type |
SERIAL_NO | VARCHAR2 | (30) | Yes | Serial Number |
MVIEW_NAME | VARCHAR2 | (80) | Yes | materialzied view name |
MVIEW_DESCRIPTION | VARCHAR2 | (240) | Description | |
ERP_PRODUCT_CODE | VARCHAR2 | (150) | erp product code | |
LOGGING_CLAUSE | VARCHAR2 | (150) | Logging clause | |
PARALLEL_DEGREE | VARCHAR2 | (150) | Parallel degree | |
SNAPSHOT_GROUP_STRING | VARCHAR2 | (150) | Snapshot Group String | |
SYNONYM_NAME | VARCHAR2 | (150) | Synonym Name | |
MASTER_TABLE | VARCHAR2 | (150) | Master table | |
LAST_SPLIT_REFRESH_TYPE | VARCHAR2 | (150) | Last split refresh Type | |
COMPLETE_REFRESH_TIMESTAMP | VARCHAR2 | (150) | Complete refresh Timestamp | |
EXISTANCE_CHECK | VARCHAR2 | (150) | Existance Check | |
AD_TABLE_NAME | VARCHAR2 | (150) | ad table based on this snapshot | |
CHECK_FOR_CONT_REFRESH | VARCHAR2 | (150) | flag to idicating whether this MV need to checked while deciding continuous refresh |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, SERIAL_NO
, MVIEW_NAME
, MVIEW_DESCRIPTION
, ERP_PRODUCT_CODE
, LOGGING_CLAUSE
, PARALLEL_DEGREE
, SNAPSHOT_GROUP_STRING
, SYNONYM_NAME
, MASTER_TABLE
, LAST_SPLIT_REFRESH_TYPE
, COMPLETE_REFRESH_TIMESTAMP
, EXISTANCE_CHECK
, AD_TABLE_NAME
, CHECK_FOR_CONT_REFRESH
FROM APPS.MSC_COLL_SNAPSHOTS_V;
|
|
|