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

MATERIALIZED VIEW: APPS.MSC_PHUB_MFG_CAL_DATES_MV

Object Details
Object Name: MSC_PHUB_MFG_CAL_DATES_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MSC_PHUB_MFG_CAL_DATES_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_BIS_PERIODS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CALENDAR_DATE DATE
Yes
MFG_CAL_WEEK_START_DATE DATE

MONTH_START_DATE DATE
Yes
FISCAL_PERIOD_START_DATE DATE

CALENDAR_CODE VARCHAR2 (30)
EXCEPTION_SET_ID NUMBER

PERIOD_SET_NAME VARCHAR2 (15)
DAY_COUNT NUMBER

Query Text

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


SELECT CALENDAR_DATE
,      MFG_CAL_WEEK_START_DATE
,      MONTH_START_DATE
,      FISCAL_PERIOD_START_DATE
,      CALENDAR_CODE
,      EXCEPTION_SET_ID
,      PERIOD_SET_NAME
,      DAY_COUNT
FROM APPS.MSC_PHUB_MFG_CAL_DATES_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_MFG_CAL_DATES_MV references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_BIS_PERIODS
SynonymMSC_CALENDARS
SynonymMSC_CALENDAR_DTL
SynonymMSC_CAL_WEEK_START_DATES
PL/SQL PackageMSC_GET_NAME - show dependent code
TableMSC_PHUB_MFG_CAL_DATES_MV
SchemaMSC
TableMSC_BIS_PERIODS
TableMSC_CALENDARS
TableMSC_CALENDAR_DTL
TableMSC_CAL_WEEK_START_DATES

APPS.MSC_PHUB_MFG_CAL_DATES_MV is not referenced by any database object