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

MATERIALIZED VIEW: APPS.PJI_RM_WT_F_MV

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

PJI_RM_RES_WT_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CNT NUMBER

CAPACITY_HRS NUMBER

CAPACITY_HRS_CNT NUMBER

TOTAL_HRS_A NUMBER

TOTAL_HRS_A_CNT NUMBER

BILL_HRS_A NUMBER

BILL_HRS_A_CNT NUMBER

CONF_HRS_S NUMBER

CONF_HRS_S_CNT NUMBER

PROV_HRS_S NUMBER

PROV_HRS_S_CNT NUMBER

UNASSIGNED_HRS_S NUMBER

UNASSIGNED_HRS_S_CNT NUMBER

CONF_OVERCOM_HRS_S NUMBER

CONF_OVERCOM_HRS_S_CNT NUMBER

PROV_OVERCOM_HRS_S NUMBER

PROV_OVERCOM_HRS_S_CNT NUMBER

TIME_ID NUMBER (15) Yes
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes
CALENDAR_TYPE VARCHAR2 (1) Yes
PERIOD_TYPE_ID NUMBER (15) Yes
WORK_TYPE_ID NUMBER (15) Yes
EXPENDITURE_ORG_ID NUMBER (15)
Query Text

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


SELECT CNT
,      CAPACITY_HRS
,      CAPACITY_HRS_CNT
,      TOTAL_HRS_A
,      TOTAL_HRS_A_CNT
,      BILL_HRS_A
,      BILL_HRS_A_CNT
,      CONF_HRS_S
,      CONF_HRS_S_CNT
,      PROV_HRS_S
,      PROV_HRS_S_CNT
,      UNASSIGNED_HRS_S
,      UNASSIGNED_HRS_S_CNT
,      CONF_OVERCOM_HRS_S
,      CONF_OVERCOM_HRS_S_CNT
,      PROV_OVERCOM_HRS_S
,      PROV_OVERCOM_HRS_S_CNT
,      TIME_ID
,      EXPENDITURE_ORGANIZATION_ID
,      CALENDAR_TYPE
,      PERIOD_TYPE_ID
,      WORK_TYPE_ID
,      EXPENDITURE_ORG_ID
FROM APPS.PJI_RM_WT_F_MV;

Dependencies

[top of page]

APPS.PJI_RM_WT_F_MV references the following:

SchemaAPPS
TablePJI_RM_WT_F_MV
SchemaPJI
TablePJI_RM_RES_WT_F
APPS.PJI_RM_WT_F_MV is referenced by following:

SchemaAPPS
Materialized ViewPJI_RM_WTO_F_MV