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

MATERIALIZED VIEW: APPS.PJI_TIME_TREND_MV

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

PJI_TIME_MV
     FII_TIME_CAL_YEAR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
REPORTING_PERIOD VARCHAR2 (120)
REPORTING_PERIOD_ID NUMBER

PERIOD_NAME VARCHAR2 (100)
PERIOD_ID NUMBER

SEQUENCE NUMBER

PERIOD_TYPE VARCHAR2 (19)
PERIOD_START_DATE DATE

ORIGINAL_REPORTING_PERIOD VARCHAR2 (100)
Query Text

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


SELECT REPORTING_PERIOD
,      REPORTING_PERIOD_ID
,      PERIOD_NAME
,      PERIOD_ID
,      SEQUENCE
,      PERIOD_TYPE
,      PERIOD_START_DATE
,      ORIGINAL_REPORTING_PERIOD
FROM APPS.PJI_TIME_TREND_MV;

Dependencies

[top of page]

APPS.PJI_TIME_TREND_MV references the following:

SchemaAPPS
TablePJI_TIME_MV
Materialized ViewPJI_TIME_MV
TablePJI_TIME_TREND_MV

APPS.PJI_TIME_TREND_MV is not referenced by any database object