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

MATERIALIZED VIEW: APPS.MSC_PHUB_CATEGORIES_MV

Object Details
Object Name: MSC_PHUB_CATEGORIES_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MSC_PHUB_CATEGORIES_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

MSC_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_SET_ID NUMBER
Yes
SR_CATEGORY_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
CATEGORY_NAME VARCHAR2 (250) Yes
DESCRIPTION VARCHAR2 (240)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CATEGORY_SET_ID
,      SR_CATEGORY_ID
,      SR_INSTANCE_ID
,      CATEGORY_NAME
,      DESCRIPTION
FROM APPS.MSC_PHUB_CATEGORIES_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_CATEGORIES_MV references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_CATEGORY_SETS
SynonymMSC_ITEM_CATEGORIES
TableMSC_PHUB_CATEGORIES_MV
SchemaMSC
TableMSC_CATEGORY_SETS
TableMSC_ITEM_CATEGORIES

APPS.MSC_PHUB_CATEGORIES_MV is not referenced by any database object