Table: PJI_RM_AGGR_RES1 | Oracle EBS ETRM Search

Table: PJI_RM_AGGR_RES1 12.1.1 standalone

owner PJI·PJI - Project Intelligence·23 columns

This is an intermediate summarization table.

PJI.PJI_RM_AGGR_RES1·Explore PJI module →

Table: PJI_RM_RES_WT_F 12.1.1 link

owner PJI·PJI - Project Intelligence·23 columns

This table stores summarized data for utilization and availabilty measures by resource and worktype for project intelligence

PJI.PJI_RM_RES_WT_F·Explore PJI module →

Table: PJI_RM_WT_F_MV 12.1.1 standalone

PJI - Project Intelligence·23 columns

snapshot table for snapshot APPS.PJI_RM_WT_F_MV

APPS.PJI_RM_WT_F_MV·Explore PJI module →

Table: PJI_RM_DNGL_RES 12.2.2 standalone

owner PJI·PJI - Project Intelligence(Obsolete)·23 columns

Information about dangling records of resource summarization.

PJI.PJI_RM_DNGL_RES·Explore PJI module →

View: PJI_DIS_RESWT_V 12.1.1

PJI - Project Intelligence·42 columns

Discoverer view of resource work type utilization data.

APPS.PJI_DIS_RESWT_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_WORK_TYPES_B·Explore PJI module →

Table: PJI_RM_RES_WT_F 12.2.2 link

owner PJI·PJI - Project Intelligence(Obsolete)·23 columns

This table stores summarized data for utilization and availabilty measures by resource and worktype for project intelligence

PJI.PJI_RM_RES_WT_F·Explore PJI module →

Table: PJI_RM_DNGL_RES 12.1.1 standalone

owner PJI·PJI - Project Intelligence·23 columns

Information about dangling records of resource summarization.

PJI.PJI_RM_DNGL_RES·Explore PJI module →

Table: PJI_RM_RES_F 12.1.1 link

owner PJI·PJI - Project Intelligence·53 columns

This table stores summarized data for utilization and availabilty measures by resources for project intelligence

PJI.PJI_RM_RES_F·Explore PJI module →

Table: PJI_RM_ORGO_F_MV 12.1.1

PJI - Project Intelligence·84 columns

snapshot table for snapshot APPS.PJI_RM_ORGO_F_MV

APPS.PJI_RM_ORGO_F_MV·Explore PJI module →

Table: PJI_RM_WTO_F_MV 12.1.1

PJI - Project Intelligence·23 columns

snapshot table for snapshot APPS.PJI_RM_WTO_F_MV

APPS.PJI_RM_WTO_F_MV·Explore PJI module →

View: PJI_DIS_MGRWT_V 12.1.1

PJI - Project Intelligence·43 columns

Discoverer view of manager work type utilization data.

APPS.PJI_DIS_MGRWT_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HRI_CS_SUPH_V·Explore PJI module →

Table: PJI_RM_RES_F 12.2.2 link

owner PJI·PJI - Project Intelligence(Obsolete)·53 columns

This table stores summarized data for utilization and availabilty measures by resources for project intelligence

PJI.PJI_RM_RES_F·Explore PJI module →

Table: PJI_RM_AGGR_RES2 12.1.1

owner PJI·PJI - Project Intelligence·51 columns

This is an intermediate summarization table.

PJI.PJI_RM_AGGR_RES2·Explore PJI module →

Table: PJI_RM_JOB_F_MV 12.1.1

PJI - Project Intelligence·85 columns

snapshot table for snapshot APPS.PJI_RM_JOB_F_MV

APPS.PJI_RM_JOB_F_MV·Explore PJI module →

Table: PJI_RM_ORG_F_MV 12.1.1

PJI - Project Intelligence·84 columns

snapshot table for snapshot APPS.PJI_RM_ORG_F_MV

APPS.PJI_RM_ORG_F_MV·Explore PJI module →

View: PJI_DIS_ORGWT_V 12.1.1

PJI - Project Intelligence·37 columns

Discoverer view of organization work type utilization data.

APPS.PJI_DIS_ORGWT_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_WORK_TYPES_B·Explore PJI module →

View: PJI_DIS_ORGJOB_V 12.1.1

PJI - Project Intelligence·67 columns

Discoverer view of organization job utilization data.

APPS.PJI_DIS_ORGJOB_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PJI_ORG_DENORM·Explore PJI module →

View: PJI_DIS_ORG_V 12.1.1

PJI - Project Intelligence·66 columns

Discoverer view of organization utilization data.

APPS.PJI_DIS_ORG_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PJI_ORG_DENORM·Explore PJI module →

Table: PJI_RM_JOBO_F_MV 12.1.1

PJI - Project Intelligence·85 columns

snapshot table for snapshot APPS.PJI_RM_JOBO_F_MV

APPS.PJI_RM_JOBO_F_MV·Explore PJI module →

View: PJI_DIS_ORGRES_V 12.1.1

PJI - Project Intelligence·71 columns

Discoverer view of organization resource utilization data.

APPS.PJI_DIS_ORGRES_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PER_PERSON_TYPES·Explore PJI module →

View: PJI_DIS_MGRRES_V 12.1.1

PJI - Project Intelligence·72 columns

Discoverer view of manager resource utilization data.

APPS.PJI_DIS_MGRRES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HRI_CS_SUPH_V·Explore PJI module →

MATERIALIZED VIEW: APPS.PJI_RM_WT_F_MV 12.1.1

APPS.PJI_RM_SUM_EXTR SQL Statements 12.1.1

View: PJI_DIS_MGRWT_V 12.2.2

PJI - Project Intelligence(Obsolete)

Discoverer view of manager work type utilization data.

Not implemented in this database·Explore PJI module →

APPS.PJI_RM_SUM_ROLLUP_RES SQL Statements 12.1.1

View: PJI_DIS_RESWT_V 12.2.2

PJI - Project Intelligence(Obsolete)

Discoverer view of resource work type utilization data.

Not implemented in this database·Explore PJI module →

VIEW: PJI.PJI_RM_DNGL_RES# 12.2.2

VIEW: APPS.PJI_DIS_RESWT_V 12.1.1

VIEW: APPS.PJI_DIS_MGRWT_V 12.1.1

VIEW: PJI.PJI_RM_RES_WT_F# 12.2.2

TABLE: PJI.PJI_RM_AGGR_RES4 12.1.1

owner PJI

MATERIALIZED VIEW: APPS.PJI_RM_ORG_F_MV 12.1.1

TABLE: PJI.PJI_RM_DNGL_RES 12.1.1

owner PJI

MATERIALIZED VIEW: APPS.PJI_RM_JOB_F_MV 12.1.1

VIEW: PJI.PJI_RM_AGGR_RES5# 12.2.2

VIEW: PJI.PJI_RM_RES_F# 12.2.2

VIEW: APPS.PJI_RM_ORG_F_MV 12.2.2

VIEW: PJI.PJI_RM_DNGL_RES# 12.2.2

owner PJI

TABLE: APPS.MLOG$_PJI_RM_WT_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_RM_WT_F_MV 12.1.1

TABLE: PJI.MLOG$_PJI_RM_RES_WT_F 12.1.1

owner PJI

TABLE: APPS.PJI_RM_WT_F_MV 12.1.1

VIEW: PJI.PJI_RM_RES_WT_F# 12.2.2

owner PJI

PACKAGE BODY: APPS.PJI_RM_SUM_EXTR 12.1.1

TABLE: PJI.PJI_RM_AGGR_RES1 12.1.1

owner PJI

MATERIALIZED VIEW: APPS.PJI_RM_WTO_F_MV 12.1.1

TABLE: APPS.PJI_RM_JOBO_F_MV 12.1.1

TABLE: APPS.MLOG$_PJI_RM_JOB_F_MV 12.1.1

TABLE: APPS.PJI_RM_WTO_F_MV 12.1.1

PACKAGE: APPS.PJI_RM_SUM_EXTR 12.1.1

used by 2

Results for “prov_hrs_s”