Table: PJI_RM_AGGR_AVL4 | Oracle EBS ETRM Search

Table: PJI_RM_AGGR_AVL4 12.1.1

owner PJI·PJI - Project Intelligence·10 columns

This is an intermediate summarization table.

PJI.PJI_RM_AGGR_AVL4·Explore PJI module →

Table: PJI_CA_ORG_F 12.1.1 link

owner PJI·PJI - Project Intelligence·14 columns

This table stores resource availability data by expenditure organization.

PJI.PJI_CA_ORG_F·Explore PJI module →

Table: PJI_CA_ORGO_F_MV 12.1.1

PJI - Project Intelligence·12 columns

APPS.PJI_CA_ORGO_F_MV·Explore PJI module →

Table: PJI_AV_ORG_F 12.1.1 link

owner PJI·PJI - Project Intelligence·23 columns

This table stores resource availability data by expenditure organization.

PJI.PJI_AV_ORG_F·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_AVL3 12.1.1

owner PJI·PJI - Project Intelligence·19 columns

This is an intermediate summarization table.

PJI.PJI_RM_AGGR_AVL3·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_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_AV_ORGO_F_MV 12.1.1

PJI - Project Intelligence·30 columns

APPS.PJI_AV_ORGO_F_MV·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_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 →

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_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 →

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_CA_ORGO_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_RM_ORG_F_MV 12.1.1

TABLE: APPS.PJI_CA_ORGO_F_MV 12.1.1

TABLE: PJI.PJI_RM_AGGR_AVL4 12.1.1

owner PJI

TABLE: PJI.PJI_RM_AGGR_AVL3 12.1.1

owner PJI

MATERIALIZED VIEW: APPS.PJI_RM_JOB_F_MV 12.1.1

TABLE: PJI.MLOG$_PJI_AV_ORG_F 12.1.1

owner PJI

VIEW: PJI.PJI_RM_RES_F# 12.2.2

VIEW: PJI.PJI_RM_AGGR_RES5# 12.2.2

VIEW: APPS.PJI_RM_ORG_F_MV 12.2.2

APPS.PJI_PMV_AVL SQL Statements 12.1.1

TABLE: PJI.MLOG$_PJI_CA_ORG_F 12.1.1

owner PJI

TABLE: APPS.PJI_AV_ORGO_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_AV_ORGO_F_MV 12.1.1

VIEW: PJI.PJI_RM_AGGR_RES5# 12.2.2

owner PJI

TABLE: PJI.MLOG$_PJI_RM_RES_F 12.1.1

owner PJI

TABLE: PJI.PJI_RM_AGGR_RES5 12.2.2

owner PJI

TABLE: PJI.PJI_CA_ORG_F 12.1.1

owner PJI

VIEW: PJI.PJI_RM_RES_F# 12.2.2

owner PJI

TABLE: PJI.PJI_AV_ORG_F 12.1.1

owner PJI

TABLE: PJI.PJI_RM_AGGR_RES5 12.1.1

owner PJI

TABLE: PJI.PJI_RM_AGGR_RES2 12.1.1

owner PJI

VIEW: APPS.PJI_RM_ORG_F_MV 12.2.2

TABLE: APPS.PJI_RM_JOBO_F_MV 12.1.1

TABLE: APPS.MLOG$_PJI_RM_JOB_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_CA_ORGO_F_MV 12.1.1

TABLE: APPS.MLOG$_PJI_RM_ORG_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_RM_JOB_F_MV 12.1.1

TABLE: APPS.PJI_RM_JOB_F_MV 12.1.1

TABLE: APPS.PJI_RM_ORG_F_MV 12.1.1

TABLE: APPS.PJI_RM_ORGO_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_RM_JOBO_F_MV 12.1.1

MATERIALIZED VIEW: APPS.PJI_RM_ORGO_F_MV 12.1.1

Results for “total_res_count”