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

MATERIALIZED VIEW: APPS.MSC_PHUB_FISCAL_PERIODS_MV

Object Details
Object Name: MSC_PHUB_FISCAL_PERIODS_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MSC_PHUB_FISCAL_PERIODS_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
SR_INSTANCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PERIOD_NAME VARCHAR2 (15) Yes
ENTERED_PERIOD_NAME VARCHAR2 (15) Yes
PERIOD_NUM NUMBER (15) Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
DAY_COUNT NUMBER

QUARTER_START_DATE DATE

PERIOD_SET_NAME VARCHAR2 (15) Yes
DESCRIPTION VARCHAR2 (240)
Query Text

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


SELECT SR_INSTANCE_ID
,      ORGANIZATION_ID
,      PERIOD_NAME
,      ENTERED_PERIOD_NAME
,      PERIOD_NUM
,      START_DATE
,      END_DATE
,      DAY_COUNT
,      QUARTER_START_DATE
,      PERIOD_SET_NAME
,      DESCRIPTION
FROM APPS.MSC_PHUB_FISCAL_PERIODS_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_FISCAL_PERIODS_MV references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_BIS_PERIODS
PL/SQL PackageMSC_GET_NAME - show dependent code
TableMSC_PHUB_FISCAL_PERIODS_MV
SchemaMSC
TableMSC_BIS_PERIODS

APPS.MSC_PHUB_FISCAL_PERIODS_MV is not referenced by any database object