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


TABLE: APPS.PJI_TIME_PA_RPT_STR_MV

Object Details
Object Name: PJI_TIME_PA_RPT_STR_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TablePJI.PJI_TIME_PA_RPT_STR_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_TIME_PA_RPT_STR_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCALENDAR_ID
ColumnREPORT_DATE
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER
Yes
CALENDAR_TYPE CHAR (1)
REPORT_DATE DATE
Yes
PERIOD_TYPE_ID NUMBER

RECORD_TYPE_ID NUMBER

TIME_ID NUMBER
Yes
Query Text

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


SELECT CALENDAR_ID
,      CALENDAR_TYPE
,      REPORT_DATE
,      PERIOD_TYPE_ID
,      RECORD_TYPE_ID
,      TIME_ID
FROM APPS.PJI_TIME_PA_RPT_STR_MV;

Dependencies

[top of page]

APPS.PJI_TIME_PA_RPT_STR_MV does not reference any database object

APPS.PJI_TIME_PA_RPT_STR_MV is referenced by following:

SchemaAPPS
Package BodyPJI_FM_SUM_ROLLUP_ACT - show dependent code
Materialized ViewPJI_TIME_PA_RPT_STR_MV