DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_COLL_SNAPSHOTS_V

Object Details
Object Name: MSC_COLL_SNAPSHOTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


List of Collections snapshots


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSC_COLL_SNAPSHOTS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.MSC_COLL_SNAPSHOTS_V is referenced by following:

SchemaAPPS
ViewMRP_CL_REFRESH_COLL_SNAPSHOT_V
Package BodyMRP_CL_REFRESH_SNAPSHOT - show dependent code
Package BodyMSC_UTIL - show dependent code