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


TABLE: APPS.PJI_RM_WT_F_MV

Object Details
Object Name: PJI_RM_WT_F_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TablePJI.PJI_RM_WT_F_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_PJI_RM_WT_F_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("EXPENDITURE_ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("CALENDAR_TYPE")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("WORK_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("EXPENDITURE_ORG_ID")
PJI_RM_WT_F_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnCALENDAR_TYPE
ColumnEXPENDITURE_ORGANIZATION_ID
ColumnWORK_TYPE_ID
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 does not reference any database object

APPS.PJI_RM_WT_F_MV is referenced by following:

SchemaAPPS
ViewPJI_DIS_ORGWT_V
Materialized ViewPJI_RM_WTO_F_MV
Materialized ViewPJI_RM_WT_F_MV