eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
Release 11i - Copyright (c) 2001 - 2005 Oracle
This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is
provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and
other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to
safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or
a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential
Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c)
restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was
disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends
or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or
by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this
TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter,
please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is'
with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements.
Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this
TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's
responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the
Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.
Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose.
Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and
use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the
applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal
Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this
TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500
Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™,
.comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM,
GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™,
NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™,
On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE ®, Oracle Business OnLine®,
OracleDevConnect SM, Oracle® Discoverer™,
Oracle® Expert™, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP™,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile™, Oracle Names®,
Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services™, Oracle® SQL*TutorSM,
OracleSTERLING SM, Oracle Store®,
Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™,
PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®,
Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®,
Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™,
Secure Access 2.0™, Secure Network Services®, Security Without Compromise™,
SellingPoint®, SQL*Plus®, Tutor™ are trademarks or
registered trademarks of Oracle. Other names may be trademarks of their respective owners.
The absence of a product or service name, slogan, or logo from this list does not constitute a
waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan,
or logo.
eTRM - PJI Tables and Views
TABLE - PJI.PJI_AC_AGGR_PJP0
TABLE - PJI.PJI_AC_AGGR_PJP1
TABLE - APPS.PJI_AC_CLSO_F_MV
TABLE - APPS.PJI_AC_CLS_F_MV
TABLE - PJI.PJI_AC_CUST_PJP0
TABLE - APPS.PJI_AC_ORGO_F_MV
TABLE - APPS.PJI_AC_ORG_F_MV
TABLE - PJI.PJI_AC_PROJ_F
TABLE - PJI.PJI_AC_RMAP_ACR
TABLE - PJI.PJI_AC_XBS_ACCUM_F
TABLE - APPS.PJI_AV_ORGO_F_MV
TABLE - PJI.PJI_AV_ORG_F
TABLE - APPS.PJI_CA_ORGO_F_MV
TABLE - PJI.PJI_CA_ORG_F
TABLE - PJI.PJI_CLASS_CATEGORIES
TABLE - PJI.PJI_CLASS_CODES
TABLE - PJI.PJI_FM_AGGR_ACT1
TABLE - PJI.PJI_FM_AGGR_ACT2
TABLE - PJI.PJI_FM_AGGR_ACT3
TABLE - PJI.PJI_FM_AGGR_ACT4
TABLE - PJI.PJI_FM_AGGR_ACT5
TABLE - PJI.PJI_FM_AGGR_DLY_RATES
TABLE - PJI.PJI_FM_AGGR_FIN1
TABLE - PJI.PJI_FM_AGGR_FIN2
TABLE - PJI.PJI_FM_AGGR_FIN3
TABLE - PJI.PJI_FM_AGGR_FIN4
TABLE - PJI.PJI_FM_AGGR_FIN5
TABLE - PJI.PJI_FM_AGGR_FIN6
TABLE - PJI.PJI_FM_AGGR_FIN7
TABLE - PJI.PJI_FM_AGGR_FIN8
TABLE - PJI.PJI_FM_AGGR_FIN9
TABLE - PJI.PJI_FM_AGGR_PLN
TABLE - PJI.PJI_FM_AGGR_RES_TYPES
TABLE - PJI.PJI_FM_DNGL_ACT
TABLE - PJI.PJI_FM_DNGL_FIN
TABLE - PJI.PJI_FM_EXTR_ARINV
TABLE - PJI.PJI_FM_EXTR_DINVC
TABLE - PJI.PJI_FM_EXTR_DINVCITM
TABLE - PJI.PJI_FM_EXTR_DREVN
TABLE - PJI.PJI_FM_EXTR_FUNDG
TABLE - PJI.PJI_FM_EXTR_PLAN
TABLE - PJI.PJI_FM_EXTR_PLAN_LINES
TABLE - PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG
TABLE - PJI.PJI_FM_EXTR_PLN
TABLE - PJI.PJI_FM_EXTR_PLNVER1
TABLE - PJI.PJI_FM_EXTR_PLNVER2
TABLE - PJI.PJI_FM_EXTR_PLNVER4
TABLE - PJI.PJI_FM_EXTR_PLN_LOG
TABLE - PJI.PJI_FM_PROJ_BATCH_MAP
TABLE - PJI.PJI_FM_PROJ_BATCH_STAT
TABLE - PJI.PJI_FM_REXT_CDL
TABLE - PJI.PJI_FM_REXT_CRDL
TABLE - PJI.PJI_FM_REXT_ERDL
TABLE - PJI.PJI_FM_RMAP_ACT
TABLE - PJI.PJI_FM_RMAP_FIN
TABLE - PJI.PJI_FM_RMAP_PSI
TABLE - PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG
TABLE - PJI.PJI_FP_AGGR_PJP0
TABLE - PJI.PJI_FP_AGGR_PJP1
TABLE - PJI.PJI_FP_AGGR_PJP1_T
TABLE - PJI.PJI_FP_AGGR_RBS
TABLE - PJI.PJI_FP_AGGR_XBS
TABLE - APPS.PJI_FP_CLSO_ET_F_MV
TABLE - APPS.PJI_FP_CLSO_ET_WT_F_MV
TABLE - APPS.PJI_FP_CLSO_F_MV
TABLE - APPS.PJI_FP_CLS_ET_F_MV
TABLE - APPS.PJI_FP_CLS_ET_WT_F_MV
TABLE - APPS.PJI_FP_CLS_F_MV
TABLE - PJI.PJI_FP_CUST_PJP0
TABLE - APPS.PJI_FP_ORGO_ET_F_MV
TABLE - APPS.PJI_FP_ORGO_ET_WT_F_MV
TABLE - APPS.PJI_FP_ORGO_F_MV
TABLE - APPS.PJI_FP_ORG_ET_F_MV
TABLE - APPS.PJI_FP_ORG_ET_WT_F_MV
TABLE - APPS.PJI_FP_ORG_F_MV
TABLE - PJI.PJI_FP_PROJ_ET_F
TABLE - PJI.PJI_FP_PROJ_ET_WT_F
TABLE - PJI.PJI_FP_PROJ_F
TABLE - PJI.PJI_FP_RMAP_FPR
TABLE - PJI.PJI_FP_TXN_ACCUM
TABLE - PJI.PJI_FP_TXN_ACCUM1
TABLE - PJI.PJI_FP_TXN_ACCUM_HEADER
TABLE - PJI.PJI_FP_XBS_ACCUM_F
TABLE - PJI.PJI_HELPER_BATCH_MAP
TABLE - PJI.PJI_MT_BUCKETS
TABLE - PJI.PJI_MT_MEASURES_B
TABLE - PJI.PJI_MT_MEASURES_TL
TABLE - PJI.PJI_MT_MEASURE_SETS_B
TABLE - PJI.PJI_MT_MEASURE_SETS_TL
TABLE - PJI.PJI_MT_PRC_STEPS
TABLE - PJI.PJI_MT_ROWSET_B
TABLE - PJI.PJI_MT_ROWSET_DET
TABLE - PJI.PJI_MT_ROWSET_TL
TABLE - PJI.PJI_ORG_DENORM
TABLE - PJI.PJI_ORG_EXTR_INFO
TABLE - PJI.PJI_ORG_EXTR_STATUS
TABLE - PJI.PJI_PA_PROJ_EVENTS_LOG
TABLE - PJI.PJI_PJI_PROJ_BATCH_MAP
TABLE - PJI.PJI_PJI_PROJ_EXTR_STATUS
TABLE - PJI.PJI_PJI_RMAP_ACT
TABLE - PJI.PJI_PJI_RMAP_FIN
TABLE - PJI.PJI_PJI_RMAP_RES
TABLE - PJI.PJI_PJP_PROJ_BATCH_MAP
TABLE - PJI.PJI_PJP_PROJ_EXTR_STATUS
TABLE - PJI.PJI_PJP_RBS_HEADER
TABLE - PJI.PJI_PJP_RMAP_ACR
TABLE - PJI.PJI_PJP_RMAP_FPR
TABLE - PJI.PJI_PJP_WBS_HEADER
TABLE - PJI.PJI_PJ_EXTR_PRJCLS
TABLE - PJI.PJI_PLAN_EXTR_TMP
TABLE - PJI.PJI_PMV_CLS_DIM_TMP
TABLE - PJI.PJI_PMV_EC_RC_DIM_TMP
TABLE - PJI.PJI_PMV_ET_RT_DIM_TMP
TABLE - PJI.PJI_PMV_ITD_DIM_TMP
TABLE - PJI.PJI_PMV_JB_DIM_TMP
TABLE - PJI.PJI_PMV_JL_DIM_TMP
TABLE - PJI.PJI_PMV_ORGZ_DIM_TMP
TABLE - PJI.PJI_PMV_ORG_DIM_TMP
TABLE - PJI.PJI_PMV_PRJ_DIM_TMP
TABLE - PJI.PJI_PMV_RC_DIM_TMP
TABLE - PJI.PJI_PMV_RT_DIM_TMP
TABLE - PJI.PJI_PMV_TCMP_DIM_TMP
TABLE - PJI.PJI_PMV_TIME_DIM_TMP
TABLE - PJI.PJI_PMV_UC_DIM_TMP
TABLE - PJI.PJI_PMV_WT_DIM_TMP
TABLE - PJI.PJI_PROJECT_CLASSES
TABLE - PJI.PJI_PROJ_EXTR_STATUS
TABLE - PJI.PJI_RBS_DENORM
TABLE - PJI.PJI_RBS_DENORM_DELTA
TABLE - PJI.PJI_REP_XBS_DENORM
TABLE - PJI.PJI_RESOURCES_DENORM
TABLE - PJI.PJI_RES_DELTA
TABLE - PJI.PJI_RES_UTILZ_TMP1
TABLE - PJI.PJI_RES_UTILZ_TMP2
TABLE - PJI.PJI_RES_UTILZ_TMP3
TABLE - PJI.PJI_RM_AGGR_AVL1
TABLE - PJI.PJI_RM_AGGR_AVL2
TABLE - PJI.PJI_RM_AGGR_AVL3
TABLE - PJI.PJI_RM_AGGR_AVL4
TABLE - PJI.PJI_RM_AGGR_AVL5
TABLE - PJI.PJI_RM_AGGR_RES1
TABLE - PJI.PJI_RM_AGGR_RES2
TABLE - PJI.PJI_RM_AGGR_RES3
TABLE - PJI.PJI_RM_AGGR_RES6
TABLE - PJI.PJI_RM_DNGL_RES
TABLE - APPS.PJI_RM_JOBO_F_MV
TABLE - APPS.PJI_RM_JOB_F_MV
TABLE - APPS.PJI_RM_ORGO_F_MV
TABLE - PJI.PJI_RM_ORG_BATCH_MAP
TABLE - PJI.PJI_RM_ORG_BATCH_STAT
TABLE - APPS.PJI_RM_ORG_F_MV
TABLE - PJI.PJI_RM_RES_BATCH_MAP
TABLE - PJI.PJI_RM_RES_F
TABLE - PJI.PJI_RM_RES_WT_F
TABLE - PJI.PJI_RM_REXT_FCSTITEM
TABLE - PJI.PJI_RM_WORK_TYPE_INFO
TABLE - PJI.PJI_RM_WORK_TYPE_ROWID
TABLE - APPS.PJI_RM_WTO_F_MV
TABLE - APPS.PJI_RM_WT_F_MV
TABLE - PJI.PJI_ROLLUP_LEVEL_STATUS
TABLE - PJI.PJI_ROLL_WEEK_OFFSET
TABLE - PJI.PJI_SYSTEM_CONFIG_HIST
TABLE - PJI.PJI_SYSTEM_DEBUG_MSG
TABLE - PJI.PJI_SYSTEM_PARAMETERS
TABLE - PJI.PJI_SYSTEM_PRC_STATUS
TABLE - PJI.PJI_SYSTEM_SETTINGS
TABLE - PJI.PJI_TIME_CAL_EXTR_INFO
TABLE - PJI.PJI_TIME_CAL_PERIOD
TABLE - PJI.PJI_TIME_CAL_QTR
TABLE - PJI.PJI_TIME_CAL_RPT_STRUCT
TABLE - PJI.PJI_TIME_CAL_YEAR
TABLE - APPS.PJI_TIME_DAY_MV
TABLE - PJI.PJI_TIME_ENT_PERIOD
TABLE - PJI.PJI_TIME_ENT_QTR
TABLE - PJI.PJI_TIME_ENT_YEAR
TABLE - APPS.PJI_TIME_MV
TABLE - APPS.PJI_TIME_PA_RPT_STR_MV
TABLE - PJI.PJI_TIME_RPT_STRUCT
TABLE - APPS.PJI_TIME_TREND_MV
TABLE - PJI.PJI_TIME_WEEK
TABLE - PJI.PJI_XBS_DENORM
TABLE - PJI.PJI_XBS_DENORM_DELTA
VIEW - APPS.PJI_ACCUM_RL_ACT_V
VIEW - APPS.PJI_ACCUM_WBS_ACT_V
VIEW - APPS.PJI_ACT_CMT_BY_PERIOD_V
VIEW - APPS.PJI_AC_ACT_CMT_BY_RSRC_V
VIEW - APPS.PJI_AC_ACT_CMT_BY_TASK_V
VIEW - APPS.PJI_AC_PLN_BY_RSRC_V
VIEW - APPS.PJI_AC_PLN_BY_TASK_V
VIEW - APPS.PJI_AC_XBS_ACCUM_F_V
VIEW - APPS.PJI_AVL_DAYS_V
VIEW - APPS.PJI_AVL_THRESHOLDS_V
VIEW - APPS.PJI_AVL_TYPES_V
VIEW - APPS.PJI_CLASS_CATEGORIES_V
VIEW - APPS.PJI_CLASS_CODES_V
VIEW - APPS.PJI_CURRENCY_TYPES_V
VIEW - APPS.PJI_DEFAULT_PERIOD_SETTINGS_V
VIEW - APPS.PJI_DIS_MGRRES_V
VIEW - APPS.PJI_DIS_MGRWT_V
VIEW - APPS.PJI_DIS_ORGJOB_V
VIEW - APPS.PJI_DIS_ORGRES_V
VIEW - APPS.PJI_DIS_ORGWT_V
VIEW - APPS.PJI_DIS_ORG_HRCHY_V
VIEW - APPS.PJI_DIS_ORG_ROHRCHY_V
VIEW - APPS.PJI_DIS_ORG_V
VIEW - APPS.PJI_DIS_PERSON_V
VIEW - APPS.PJI_DIS_RESWT_V
VIEW - APPS.PJI_DIS_SEC_ORGZ_V
VIEW - APPS.PJI_DIS_SEC_ORG_V
VIEW - APPS.PJI_DIS_SUP_HRCHY_V
VIEW - APPS.PJI_DIS_SUP_ROHRCHY_V
VIEW - APPS.PJI_DIS_WORK_TYPES_V
VIEW - APPS.PJI_EXP_CATEGORIES_V
VIEW - APPS.PJI_EXP_EVT_TYPES_V
VIEW - APPS.PJI_EXP_TYPES_V
VIEW - APPS.PJI_FP_XBS_ACCUM_F_V
VIEW - APPS.PJI_JOBS_V
VIEW - APPS.PJI_JOB_LEVELS_V
VIEW - APPS.PJI_LOOKUPS
VIEW - APPS.PJI_MT_MEASURES_V
VIEW - APPS.PJI_MT_MEASURES_VL
VIEW - APPS.PJI_MT_MEASURE_SETS_VL
VIEW - APPS.PJI_MT_ROWSET_VL
VIEW - APPS.PJI_OPERATING_UNITS_V
VIEW - APPS.PJI_ORGANIZATIONS_V
VIEW - APPS.PJI_PERIOD_TYPES_V
VIEW - APPS.PJI_PRD_ACT_CMT_BY_RSRC_V
VIEW - APPS.PJI_PRD_ACT_CMT_BY_TASK_V
VIEW - APPS.PJI_PRD_ACT_CMT_PG_TASK_V
VIEW - APPS.PJI_PRD_PLN_BY_RSRC_V
VIEW - APPS.PJI_PRD_PLN_BY_TASK_V
VIEW - APPS.PJI_PROJECTS_V
VIEW - APPS.PJI_REVENUE_CATEGORIES_V
VIEW - APPS.PJI_TIME_CAL_PERIOD_V
VIEW - APPS.PJI_TIME_CAL_QTR_V
VIEW - APPS.PJI_TIME_CAL_RPT_STRUCT_V
VIEW - APPS.PJI_TIME_CAL_YEAR_V
VIEW - APPS.PJI_TIME_ENT_PERIOD_V
VIEW - APPS.PJI_TIME_ENT_QTR_V
VIEW - APPS.PJI_TIME_ENT_YEAR_V
VIEW - APPS.PJI_TIME_PA_PERIOD_V
VIEW - APPS.PJI_TIME_RPT_STRUCT_V
VIEW - APPS.PJI_TIME_WEEK_V
VIEW - APPS.PJI_UTIL_CATEGORIES_V
VIEW - APPS.PJI_WORK_TYPES_V
VIEW - APPS.PJI_XBS_PLANS_PRJ_V
VIEW - APPS.PJI_XBS_PLANS_V
VIEW - APPS.PJI_XTD_ACT_CMT_BY_RSRC_V
VIEW - APPS.PJI_XTD_ACT_CMT_BY_TASK_V
VIEW - APPS.PJI_XTD_PLN_BY_RSRC_V
VIEW - APPS.PJI_XTD_PLN_BY_TASK_V
VIEW - APPS.PJI_YES_NO_V
Table: PJI_AC_AGGR_PJP0
[top of page]
PJI.PJI_AC_AGGR_PJP0 does not reference any database object
PJI.PJI_AC_AGGR_PJP0 is referenced by following:
APPS
SYNONYM - PJI_AC_AGGR_PJP0
[top of page]
Table: PJI_AC_AGGR_PJP1
[top of page]
PJI.PJI_AC_AGGR_PJP1 does not reference any database object
PJI.PJI_AC_AGGR_PJP1 is referenced by following:
APPS
SYNONYM - PJI_AC_AGGR_PJP1
[top of page]
Table: PJI_AC_CLSO_F_MV
[top of page]
APPS.PJI_AC_CLSO_F_MV does not reference any database object
APPS.PJI_AC_CLSO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_CLSO_F_MV
PACKAGE BODY - PJI_PMV_BACKLOG
PACKAGE BODY - PJI_PMV_BOOKINGS
PACKAGE BODY - PJI_PMV_BOOKINGS_BACKLOG
[top of page]
Table: PJI_AC_CLS_F_MV
[top of page]
APPS.PJI_AC_CLS_F_MV does not reference any database object
APPS.PJI_AC_CLS_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_CLSO_F_MV
MATERIALIZED VIEW - PJI_AC_CLS_F_MV
[top of page]
Table: PJI_AC_CUST_PJP0
[top of page]
PJI.PJI_AC_CUST_PJP0 does not reference any database object
PJI.PJI_AC_CUST_PJP0 is referenced by following:
APPS
SYNONYM - PJI_AC_CUST_PJP0
[top of page]
Table: PJI_AC_ORGO_F_MV
[top of page]
APPS.PJI_AC_ORGO_F_MV does not reference any database object
APPS.PJI_AC_ORGO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_ORGO_F_MV
PACKAGE BODY - PJI_PMV_BACKLOG
PACKAGE BODY - PJI_PMV_BOOKINGS
PACKAGE BODY - PJI_PMV_BOOKINGS_BACKLOG
[top of page]
Table: PJI_AC_ORG_F_MV
[top of page]
APPS.PJI_AC_ORG_F_MV does not reference any database object
APPS.PJI_AC_ORG_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_ORGO_F_MV
MATERIALIZED VIEW - PJI_AC_ORG_F_MV
[top of page]
Table: PJI_AC_PROJ_F
Description: This table stores summarized data for booking and backlog measures at the project level for Project Intelligence
[top of page]
PJI.PJI_AC_PROJ_F does not reference any database object
PJI.PJI_AC_PROJ_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_CLS_F_MV
MATERIALIZED VIEW - PJI_AC_ORG_F_MV
SYNONYM - PJI_AC_PROJ_F
[top of page]
Table: PJI_AC_RMAP_ACR
[top of page]
PJI.PJI_AC_RMAP_ACR does not reference any database object
PJI.PJI_AC_RMAP_ACR is referenced by following:
APPS
SYNONYM - PJI_AC_RMAP_ACR
[top of page]
Table: PJI_AC_XBS_ACCUM_F
Description: This table stores summarized booking and backlog activity measures for project performance by work breakdown and program hierarchies
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_AC_XBS_ACCUM_F.PROJECT_ORG_ID
HR_ALL_ORGANIZATION_UNITS
PJI_AC_XBS_ACCUM_F.PROJECT_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_AC_XBS_ACCUM_F.PROJECT_ID
PA_PROJECTS_ALL
PJI_AC_XBS_ACCUM_F.PROJECT_ELEMENT_ID
PA_PROJ_ELEMENTS
[top of page]
PJI.PJI_AC_XBS_ACCUM_F does not reference any database object
PJI.PJI_AC_XBS_ACCUM_F is referenced by following:
APPS
SYNONYM - PJI_AC_XBS_ACCUM_F
[top of page]
Table: PJI_AV_ORGO_F_MV
[top of page]
APPS.PJI_AV_ORGO_F_MV does not reference any database object
APPS.PJI_AV_ORGO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AV_ORGO_F_MV
PACKAGE BODY - PJI_PMV_AVL
[top of page]
Table: PJI_AV_ORG_F
Description: This table stores resource availability data by expenditure organization.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_AV_ORG_F.EXPENDITURE_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_AV_ORG_F.EXPENDITURE_ORG_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_AV_ORG_F does not reference any database object
PJI.PJI_AV_ORG_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AV_ORGO_F_MV
SYNONYM - PJI_AV_ORG_F
[top of page]
Table: PJI_CA_ORGO_F_MV
[top of page]
APPS.PJI_CA_ORGO_F_MV does not reference any database object
APPS.PJI_CA_ORGO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_CA_ORGO_F_MV
PACKAGE BODY - PJI_PMV_AVL
[top of page]
Table: PJI_CA_ORG_F
Description: This table stores resource availability data by expenditure organization.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_CA_ORG_F.EXPENDITURE_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_CA_ORG_F.EXPENDITURE_ORG_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_CA_ORG_F does not reference any database object
PJI.PJI_CA_ORG_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_CA_ORGO_F_MV
SYNONYM - PJI_CA_ORG_F
[top of page]
Table: PJI_CLASS_CATEGORIES
Description: Implementation-defined categories for classifying project.
Primary Key: PJI_CLASS_CATEGORIES_PK
CLASS_CATEGORY
Foreign Keys to this table:
Foreign Key Column
Foreign Table
PJI_CLASS_CODES.CLASS_CATEGORY
PJI_CLASS_CATEGORIES
[top of page]
PJI.PJI_CLASS_CATEGORIES does not reference any database object
PJI.PJI_CLASS_CATEGORIES is referenced by following:
APPS
SYNONYM - PJI_CLASS_CATEGORIES
[top of page]
Table: PJI_CLASS_CODES
Description: Implementation-defined values within class categories that can be used to classify projects.
Primary Key: PJI_CLASS_CODES_PK
CLASS_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_CLASS_CODES.CLASS_CATEGORY
PJI_CLASS_CATEGORIES
[top of page]
PJI.PJI_CLASS_CODES does not reference any database object
PJI.PJI_CLASS_CODES is referenced by following:
APPS
SYNONYM - PJI_CLASS_CODES
[top of page]
Table: PJI_FM_AGGR_ACT1
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_ACT1 does not reference any database object
PJI.PJI_FM_AGGR_ACT1 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_ACT1
[top of page]
Table: PJI_FM_AGGR_ACT2
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_ACT2 does not reference any database object
PJI.PJI_FM_AGGR_ACT2 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_ACT2
[top of page]
Table: PJI_FM_AGGR_ACT3
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_ACT3 does not reference any database object
PJI.PJI_FM_AGGR_ACT3 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_ACT3
[top of page]
Table: PJI_FM_AGGR_ACT4
Description: This intermediate table stages data between PJI and Project Performance summarization.
[top of page]
PJI.PJI_FM_AGGR_ACT4 does not reference any database object
PJI.PJI_FM_AGGR_ACT4 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_ACT4
[top of page]
Table: PJI_FM_AGGR_ACT5
[top of page]
PJI.PJI_FM_AGGR_ACT5 does not reference any database object
PJI.PJI_FM_AGGR_ACT5 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_ACT5
[top of page]
Table: PJI_FM_AGGR_DLY_RATES
Description: This intermediate table contains PJI currency conversion rates during a summarization run.
[top of page]
PJI.PJI_FM_AGGR_DLY_RATES does not reference any database object
PJI.PJI_FM_AGGR_DLY_RATES is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_DLY_RATES
[top of page]
Table: PJI_FM_AGGR_FIN1
Description: This intermediate table contains PJI summarization data during a summarization run.
[top of page]
PJI.PJI_FM_AGGR_FIN1 does not reference any database object
PJI.PJI_FM_AGGR_FIN1 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN1
[top of page]
Table: PJI_FM_AGGR_FIN2
Description: This intermediate table contains PJI summarization data during a summarization run.
[top of page]
PJI.PJI_FM_AGGR_FIN2 does not reference any database object
PJI.PJI_FM_AGGR_FIN2 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN2
[top of page]
Table: PJI_FM_AGGR_FIN3
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_FIN3 does not reference any database object
PJI.PJI_FM_AGGR_FIN3 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN3
[top of page]
Table: PJI_FM_AGGR_FIN4
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_FIN4 does not reference any database object
PJI.PJI_FM_AGGR_FIN4 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN4
[top of page]
Table: PJI_FM_AGGR_FIN5
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_FIN5 does not reference any database object
PJI.PJI_FM_AGGR_FIN5 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN5
[top of page]
Table: PJI_FM_AGGR_FIN6
Description: This intermediate table is used for the first aggregation of PJP data by periods.
[top of page]
PJI.PJI_FM_AGGR_FIN6 does not reference any database object
PJI.PJI_FM_AGGR_FIN6 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN6
[top of page]
Table: PJI_FM_AGGR_FIN7
Description: This intermediate table is used for staging data between PJI and PJP summarization runs.
[top of page]
PJI.PJI_FM_AGGR_FIN7 does not reference any database object
PJI.PJI_FM_AGGR_FIN7 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN7
[top of page]
Table: PJI_FM_AGGR_FIN8
Description: This intermediate table is used for staging data between PJI and PJP summarization runs.
[top of page]
PJI.PJI_FM_AGGR_FIN8 does not reference any database object
PJI.PJI_FM_AGGR_FIN8 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN8
[top of page]
Table: PJI_FM_AGGR_FIN9
[top of page]
PJI.PJI_FM_AGGR_FIN9 does not reference any database object
PJI.PJI_FM_AGGR_FIN9 is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_FIN9
[top of page]
Table: PJI_FM_AGGR_PLN
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_AGGR_PLN does not reference any database object
PJI.PJI_FM_AGGR_PLN is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_PLN
[top of page]
Table: PJI_FM_AGGR_RES_TYPES
Description: This intermediate table is used to look up Resource Class.
[top of page]
PJI.PJI_FM_AGGR_RES_TYPES does not reference any database object
PJI.PJI_FM_AGGR_RES_TYPES is referenced by following:
APPS
SYNONYM - PJI_FM_AGGR_RES_TYPES
[top of page]
Table: PJI_FM_DNGL_ACT
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_DNGL_ACT does not reference any database object
PJI.PJI_FM_DNGL_ACT is referenced by following:
APPS
SYNONYM - PJI_FM_DNGL_ACT
[top of page]
Table: PJI_FM_DNGL_FIN
Description: This intermediate table contains dangling PJI summarization data between summarization runs.
[top of page]
PJI.PJI_FM_DNGL_FIN does not reference any database object
PJI.PJI_FM_DNGL_FIN is referenced by following:
APPS
SYNONYM - PJI_FM_DNGL_FIN
[top of page]
Table: PJI_FM_EXTR_ARINV
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_ARINV does not reference any database object
PJI.PJI_FM_EXTR_ARINV is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_ARINV
[top of page]
Table: PJI_FM_EXTR_DINVC
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_DINVC does not reference any database object
PJI.PJI_FM_EXTR_DINVC is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_DINVC
[top of page]
Table: PJI_FM_EXTR_DINVCITM
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_DINVCITM does not reference any database object
PJI.PJI_FM_EXTR_DINVCITM is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_DINVCITM
[top of page]
Table: PJI_FM_EXTR_DREVN
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_DREVN does not reference any database object
PJI.PJI_FM_EXTR_DREVN is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_DREVN
[top of page]
Table: PJI_FM_EXTR_FUNDG
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_FUNDG does not reference any database object
PJI.PJI_FM_EXTR_FUNDG is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_FUNDG
[top of page]
Table: PJI_FM_EXTR_PLAN
[top of page]
PJI.PJI_FM_EXTR_PLAN does not reference any database object
PJI.PJI_FM_EXTR_PLAN is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLAN
[top of page]
Table: PJI_FM_EXTR_PLAN_LINES
Description: This table stores the changes to financial plan data
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_FM_EXTR_PLAN_LINES.PLAN_VERSION_ID
PA_BUDGET_VERSIONS
PJI_FM_EXTR_PLAN_LINES.PROJECT_ID
PA_PROJECTS_ALL
PJI_FM_EXTR_PLAN_LINES.PROJECT_ELEMENT_ID
PA_PROJ_ELEMENTS
[top of page]
PJI.PJI_FM_EXTR_PLAN_LINES does not reference any database object
PJI.PJI_FM_EXTR_PLAN_LINES is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLAN_LINES
[top of page]
Table: PJI_FM_EXTR_PLAN_LINES_DEBUG
Description: This table stores the changes to financial plan data
[top of page]
PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG does not reference any database object
PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLAN_LINES_DEBUG
[top of page]
Table: PJI_FM_EXTR_PLN
[top of page]
PJI.PJI_FM_EXTR_PLN does not reference any database object
PJI.PJI_FM_EXTR_PLN is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLN
[top of page]
Table: PJI_FM_EXTR_PLNVER1
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_PLNVER1 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER1 is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLNVER1
[top of page]
Table: PJI_FM_EXTR_PLNVER2
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_EXTR_PLNVER2 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER2 is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLNVER2
[top of page]
Table: PJI_FM_EXTR_PLNVER4
[top of page]
PJI.PJI_FM_EXTR_PLNVER4 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER4 is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLNVER4
[top of page]
Table: PJI_FM_EXTR_PLN_LOG
Description: Information about plan versions that have been extracted to project performance-reporting model.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_FM_EXTR_PLN_LOG.PROJECT_ID
PA_PROJECTS_ALL
PJI_FM_EXTR_PLN_LOG.BUDGET_VERSION_ID
PA_BUDGET_VERSIONS
PJI_FM_EXTR_PLN_LOG.PROJECT_ORG_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_FM_EXTR_PLN_LOG does not reference any database object
PJI.PJI_FM_EXTR_PLN_LOG is referenced by following:
APPS
SYNONYM - PJI_FM_EXTR_PLN_LOG
[top of page]
Table: PJI_FM_PROJ_BATCH_MAP
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_FM_PROJ_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_FM_PROJ_BATCH_MAP
[top of page]
Table: PJI_FM_PROJ_BATCH_STAT
[top of page]
PJI.PJI_FM_PROJ_BATCH_STAT does not reference any database object
PJI.PJI_FM_PROJ_BATCH_STAT is referenced by following:
APPS
SYNONYM - PJI_FM_PROJ_BATCH_STAT
[top of page]
Table: PJI_FM_REXT_CDL
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_REXT_CDL does not reference any database object
PJI.PJI_FM_REXT_CDL is referenced by following:
APPS
SYNONYM - PJI_FM_REXT_CDL
[top of page]
Table: PJI_FM_REXT_CRDL
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_REXT_CRDL does not reference any database object
PJI.PJI_FM_REXT_CRDL is referenced by following:
APPS
SYNONYM - PJI_FM_REXT_CRDL
[top of page]
Table: PJI_FM_REXT_ERDL
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_REXT_ERDL does not reference any database object
PJI.PJI_FM_REXT_ERDL is referenced by following:
APPS
SYNONYM - PJI_FM_REXT_ERDL
[top of page]
Table: PJI_FM_RMAP_ACT
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_RMAP_ACT does not reference any database object
PJI.PJI_FM_RMAP_ACT is referenced by following:
APPS
SYNONYM - PJI_FM_RMAP_ACT
[top of page]
Table: PJI_FM_RMAP_FIN
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_FM_RMAP_FIN does not reference any database object
PJI.PJI_FM_RMAP_FIN is referenced by following:
APPS
SYNONYM - PJI_FM_RMAP_FIN
[top of page]
Table: PJI_FM_RMAP_PSI
[top of page]
PJI.PJI_FM_RMAP_PSI does not reference any database object
PJI.PJI_FM_RMAP_PSI is referenced by following:
APPS
SYNONYM - PJI_FM_RMAP_PSI
[top of page]
Table: PJI_FM_XBS_ACCUM_TMP1_DEBUG
[top of page]
PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG does not reference any database object
PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG is referenced by following:
APPS
SYNONYM - PJI_FM_XBS_ACCUM_TMP1_DEBUG
[top of page]
Table: PJI_FP_AGGR_PJP0
[top of page]
PJI.PJI_FP_AGGR_PJP0 does not reference any database object
PJI.PJI_FP_AGGR_PJP0 is referenced by following:
APPS
SYNONYM - PJI_FP_AGGR_PJP0
[top of page]
Table: PJI_FP_AGGR_PJP1
Description: This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization
[top of page]
PJI.PJI_FP_AGGR_PJP1 does not reference any database object
PJI.PJI_FP_AGGR_PJP1 is referenced by following:
APPS
SYNONYM - PJI_FP_AGGR_PJP1
[top of page]
Table: PJI_FP_AGGR_PJP1_T
Description: This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization
[top of page]
PJI.PJI_FP_AGGR_PJP1_T does not reference any database object
PJI.PJI_FP_AGGR_PJP1_T is referenced by following:
APPS
SYNONYM - PJI_FP_AGGR_PJP1_T
[top of page]
Table: PJI_FP_AGGR_RBS
[top of page]
PJI.PJI_FP_AGGR_RBS does not reference any database object
PJI.PJI_FP_AGGR_RBS is referenced by following:
APPS
SYNONYM - PJI_FP_AGGR_RBS
[top of page]
Table: PJI_FP_AGGR_XBS
[top of page]
PJI.PJI_FP_AGGR_XBS does not reference any database object
PJI.PJI_FP_AGGR_XBS is referenced by following:
APPS
SYNONYM - PJI_FP_AGGR_XBS
[top of page]
Table: PJI_FP_CLSO_ET_F_MV
[top of page]
APPS.PJI_FP_CLSO_ET_F_MV does not reference any database object
APPS.PJI_FP_CLSO_ET_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_ET_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_CLSO_ET_WT_F_MV
[top of page]
APPS.PJI_FP_CLSO_ET_WT_F_MV does not reference any database object
APPS.PJI_FP_CLSO_ET_WT_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_ET_WT_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_CLSO_F_MV
[top of page]
APPS.PJI_FP_CLSO_F_MV does not reference any database object
APPS.PJI_FP_CLSO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_CLS_ET_F_MV
[top of page]
APPS.PJI_FP_CLS_ET_F_MV does not reference any database object
APPS.PJI_FP_CLS_ET_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_ET_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_ET_F_MV
[top of page]
Table: PJI_FP_CLS_ET_WT_F_MV
[top of page]
APPS.PJI_FP_CLS_ET_WT_F_MV does not reference any database object
APPS.PJI_FP_CLS_ET_WT_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_ET_WT_F_MV
[top of page]
Table: PJI_FP_CLS_F_MV
[top of page]
APPS.PJI_FP_CLS_F_MV does not reference any database object
APPS.PJI_FP_CLS_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLSO_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_F_MV
[top of page]
Table: PJI_FP_CUST_PJP0
[top of page]
PJI.PJI_FP_CUST_PJP0 does not reference any database object
PJI.PJI_FP_CUST_PJP0 is referenced by following:
APPS
SYNONYM - PJI_FP_CUST_PJP0
[top of page]
Table: PJI_FP_ORGO_ET_F_MV
[top of page]
APPS.PJI_FP_ORGO_ET_F_MV does not reference any database object
APPS.PJI_FP_ORGO_ET_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_ET_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_ORGO_ET_WT_F_MV
[top of page]
APPS.PJI_FP_ORGO_ET_WT_F_MV does not reference any database object
APPS.PJI_FP_ORGO_ET_WT_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_ET_WT_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_ORGO_F_MV
[top of page]
APPS.PJI_FP_ORGO_F_MV does not reference any database object
APPS.PJI_FP_ORGO_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_F_MV
PACKAGE BODY - PJI_PMV_CAPITAL_COST
PACKAGE BODY - PJI_PMV_COST
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_PROFITABILITY_TREND
[top of page]
Table: PJI_FP_ORG_ET_F_MV
[top of page]
APPS.PJI_FP_ORG_ET_F_MV does not reference any database object
APPS.PJI_FP_ORG_ET_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_ET_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_ET_F_MV
[top of page]
Table: PJI_FP_ORG_ET_WT_F_MV
[top of page]
APPS.PJI_FP_ORG_ET_WT_F_MV does not reference any database object
APPS.PJI_FP_ORG_ET_WT_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_ET_WT_F_MV
[top of page]
Table: PJI_FP_ORG_F_MV
[top of page]
APPS.PJI_FP_ORG_F_MV does not reference any database object
APPS.PJI_FP_ORG_F_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_ORGO_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_F_MV
[top of page]
Table: PJI_FP_PROJ_ET_F
Description: This table stores summarized data for cost and revenue measures at the project and expenditure type level for Project Intelligence
[top of page]
PJI.PJI_FP_PROJ_ET_F does not reference any database object
PJI.PJI_FP_PROJ_ET_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLS_ET_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_ET_F_MV
SYNONYM - PJI_FP_PROJ_ET_F
[top of page]
Table: PJI_FP_PROJ_ET_WT_F
Description: This table stores summarized cost and revenue measures at the project, expenditure type and worktype levels for Project Intelligence
[top of page]
PJI.PJI_FP_PROJ_ET_WT_F does not reference any database object
PJI.PJI_FP_PROJ_ET_WT_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLS_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_ET_WT_F_MV
SYNONYM - PJI_FP_PROJ_ET_WT_F
[top of page]
Table: PJI_FP_PROJ_F
Description: This table stores summarized cost and revenue measures at the project level for Project Intelligence
[top of page]
PJI.PJI_FP_PROJ_F does not reference any database object
PJI.PJI_FP_PROJ_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_FP_CLS_F_MV
MATERIALIZED VIEW - PJI_FP_ORG_F_MV
SYNONYM - PJI_FP_PROJ_F
[top of page]
Table: PJI_FP_RMAP_FPR
[top of page]
PJI.PJI_FP_RMAP_FPR does not reference any database object
PJI.PJI_FP_RMAP_FPR is referenced by following:
APPS
SYNONYM - PJI_FP_RMAP_FPR
[top of page]
Table: PJI_FP_TXN_ACCUM
Description: This table stores summarized cost and revenue measures at project, task and periodic levels for project performance
[top of page]
PJI.PJI_FP_TXN_ACCUM does not reference any database object
PJI.PJI_FP_TXN_ACCUM is referenced by following:
APPS
SYNONYM - PJI_FP_TXN_ACCUM
[top of page]
Table: PJI_FP_TXN_ACCUM1
Description: This table stores summarized commitment measures at project, task and periodic levels for project performance
[top of page]
PJI.PJI_FP_TXN_ACCUM1 does not reference any database object
PJI.PJI_FP_TXN_ACCUM1 is referenced by following:
APPS
SYNONYM - PJI_FP_TXN_ACCUM1
[top of page]
Table: PJI_FP_TXN_ACCUM_HEADER
Description: This table stores the resource attribute combinations which are used for resource breakdown structure mapping
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_FP_TXN_ACCUM_HEADER.EXPENDITURE_ORG_ID
HR_ALL_ORGANIZATION_UNITS
PJI_FP_TXN_ACCUM_HEADER.EXPENDITURE_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_FP_TXN_ACCUM_HEADER.EXPENDITURE_TYPE
PA_EXPENDITURE_TYPES
PJI_FP_TXN_ACCUM_HEADER.EVENT_TYPE
PA_EVENT_TYPES
[top of page]
PJI.PJI_FP_TXN_ACCUM_HEADER does not reference any database object
PJI.PJI_FP_TXN_ACCUM_HEADER is referenced by following:
APPS
SYNONYM - PJI_FP_TXN_ACCUM_HEADER
[top of page]
Table: PJI_FP_XBS_ACCUM_F
Description: This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, resource breakdown and program hierarchies
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_FP_XBS_ACCUM_F.PLAN_VERSION_ID
PA_BUDGET_VERSIONS
PJI_FP_XBS_ACCUM_F.RBS_ELEMENT_ID
PA_RBS_ELEMENTS
PJI_FP_XBS_ACCUM_F.PROJECT_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_FP_XBS_ACCUM_F.PROJECT_ORG_ID
HR_ALL_ORGANIZATION_UNITS
PJI_FP_XBS_ACCUM_F.PROJECT_ELEMENT_ID
PA_PROJ_ELEMENTS
PJI_FP_XBS_ACCUM_F.PROJECT_ID
PA_PROJECTS_ALL
[top of page]
PJI.PJI_FP_XBS_ACCUM_F does not reference any database object
PJI.PJI_FP_XBS_ACCUM_F is referenced by following:
APPS
SYNONYM - PJI_FP_XBS_ACCUM_F
[top of page]
Table: PJI_HELPER_BATCH_MAP
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_HELPER_BATCH_MAP does not reference any database object
PJI.PJI_HELPER_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_HELPER_BATCH_MAP
[top of page]
Table: PJI_MT_BUCKETS
Description: Information for bucket values for different measures.
Primary Key: PJI_MT_BUCKETS_PK
BUCKET_SET_CODE
NAME
[top of page]
PJI.PJI_MT_BUCKETS does not reference any database object
PJI.PJI_MT_BUCKETS is referenced by following:
APPS
SYNONYM - PJI_MT_BUCKETS
[top of page]
Table: PJI_MT_MEASURES_B
Description: This table stores the definition of the measures used for reporting in oracle projects.
[top of page]
PJI.PJI_MT_MEASURES_B does not reference any database object
PJI.PJI_MT_MEASURES_B is referenced by following:
APPS
SYNONYM - PJI_MT_MEASURES_B
[top of page]
Table: PJI_MT_MEASURES_TL
Description: This table stores translated measure definition.
[top of page]
PJI.PJI_MT_MEASURES_TL does not reference any database object
PJI.PJI_MT_MEASURES_TL is referenced by following:
APPS
SYNONYM - PJI_MT_MEASURES_TL
[top of page]
Table: PJI_MT_MEASURE_SETS_B
Description: This table stores information about measure sets used for reporting in Oracle Projects.
[top of page]
PJI.PJI_MT_MEASURE_SETS_B does not reference any database object
PJI.PJI_MT_MEASURE_SETS_B is referenced by following:
APPS
SYNONYM - PJI_MT_MEASURE_SETS_B
[top of page]
Table: PJI_MT_MEASURE_SETS_TL
Description: This table stores translated measure set definition.
[top of page]
PJI.PJI_MT_MEASURE_SETS_TL does not reference any database object
PJI.PJI_MT_MEASURE_SETS_TL is referenced by following:
APPS
SYNONYM - PJI_MT_MEASURE_SETS_TL
[top of page]
Table: PJI_MT_PRC_STEPS
Description: Information for process steps submitted during summarization.
[top of page]
PJI.PJI_MT_PRC_STEPS does not reference any database object
PJI.PJI_MT_PRC_STEPS is referenced by following:
APPS
SYNONYM - PJI_MT_PRC_STEPS
[top of page]
Table: PJI_MT_ROWSET_B
Description: This table stores the measures defined for a row set.
[top of page]
PJI.PJI_MT_ROWSET_B does not reference any database object
PJI.PJI_MT_ROWSET_B is referenced by following:
APPS
SYNONYM - PJI_MT_ROWSET_B
[top of page]
Table: PJI_MT_ROWSET_DET
Description: This table stores the measures defined for a row set
[top of page]
PJI.PJI_MT_ROWSET_DET does not reference any database object
PJI.PJI_MT_ROWSET_DET is referenced by following:
APPS
SYNONYM - PJI_MT_ROWSET_DET
[top of page]
Table: PJI_MT_ROWSET_TL
Description: This table stores translated measure set definition
[top of page]
PJI.PJI_MT_ROWSET_TL does not reference any database object
PJI.PJI_MT_ROWSET_TL is referenced by following:
APPS
SYNONYM - PJI_MT_ROWSET_TL
[top of page]
Table: PJI_ORG_DENORM
Description: This table stores the last summarized PA_RBS_DENORM structure for the financial plan.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_ORG_DENORM.ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_ORG_DENORM.SUB_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_ORG_DENORM does not reference any database object
PJI.PJI_ORG_DENORM is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_CLSO_F_MV
MATERIALIZED VIEW - PJI_AC_ORGO_F_MV
MATERIALIZED VIEW - PJI_AV_ORGO_F_MV
MATERIALIZED VIEW - PJI_CA_ORGO_F_MV
MATERIALIZED VIEW - PJI_FP_CLSO_ET_F_MV
MATERIALIZED VIEW - PJI_FP_CLSO_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_CLSO_F_MV
MATERIALIZED VIEW - PJI_FP_ORGO_ET_F_MV
MATERIALIZED VIEW - PJI_FP_ORGO_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_ORGO_F_MV
SYNONYM - PJI_ORG_DENORM
MATERIALIZED VIEW - PJI_RM_JOBO_F_MV
MATERIALIZED VIEW - PJI_RM_ORGO_F_MV
MATERIALIZED VIEW - PJI_RM_WTO_F_MV
[top of page]
Table: PJI_ORG_EXTR_INFO
Description: Information for organizations that have been extracted to project performance-reporting model.
Primary Key: POO_PK
[top of page]
PJI.PJI_ORG_EXTR_INFO does not reference any database object
PJI.PJI_ORG_EXTR_INFO is referenced by following:
APPS
SYNONYM - PJI_ORG_EXTR_INFO
MATERIALIZED VIEW - PJI_TIME_DAY_MV
MATERIALIZED VIEW - PJI_TIME_MV
[top of page]
Table: PJI_ORG_EXTR_STATUS
Description: Extraction status for organizations that have been extracted to project performance-reporting model.
[top of page]
PJI.PJI_ORG_EXTR_STATUS does not reference any database object
PJI.PJI_ORG_EXTR_STATUS is referenced by following:
APPS
SYNONYM - PJI_ORG_EXTR_STATUS
[top of page]
Table: PJI_PA_PROJ_EVENTS_LOG
[top of page]
PJI.PJI_PA_PROJ_EVENTS_LOG does not reference any database object
PJI.PJI_PA_PROJ_EVENTS_LOG is referenced by following:
APPS
SYNONYM - PJI_PA_PROJ_EVENTS_LOG
[top of page]
Table: PJI_PJI_PROJ_BATCH_MAP
[top of page]
PJI.PJI_PJI_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_PJI_PROJ_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_PJI_PROJ_BATCH_MAP
[top of page]
Table: PJI_PJI_PROJ_EXTR_STATUS
[top of page]
PJI.PJI_PJI_PROJ_EXTR_STATUS does not reference any database object
PJI.PJI_PJI_PROJ_EXTR_STATUS is referenced by following:
APPS
SYNONYM - PJI_PJI_PROJ_EXTR_STATUS
[top of page]
Table: PJI_PJI_RMAP_ACT
[top of page]
PJI.PJI_PJI_RMAP_ACT does not reference any database object
PJI.PJI_PJI_RMAP_ACT is referenced by following:
APPS
SYNONYM - PJI_PJI_RMAP_ACT
[top of page]
Table: PJI_PJI_RMAP_FIN
[top of page]
PJI.PJI_PJI_RMAP_FIN does not reference any database object
PJI.PJI_PJI_RMAP_FIN is referenced by following:
APPS
SYNONYM - PJI_PJI_RMAP_FIN
[top of page]
Table: PJI_PJI_RMAP_RES
Description: Summarization table used to identify current scope of extraction from stage 1 into stage 3 summarization.
[top of page]
PJI.PJI_PJI_RMAP_RES does not reference any database object
PJI.PJI_PJI_RMAP_RES is referenced by following:
APPS
SYNONYM - PJI_PJI_RMAP_RES
[top of page]
Table: PJI_PJP_PROJ_BATCH_MAP
Description: This table stores PJP summarization state.
[top of page]
PJI.PJI_PJP_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_PJP_PROJ_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_PJP_PROJ_BATCH_MAP
[top of page]
Table: PJI_PJP_PROJ_EXTR_STATUS
Description: This table stores PJP summarization state.
[top of page]
PJI.PJI_PJP_PROJ_EXTR_STATUS does not reference any database object
PJI.PJI_PJP_PROJ_EXTR_STATUS is referenced by following:
APPS
SYNONYM - PJI_PJP_PROJ_EXTR_STATUS
[top of page]
Table: PJI_PJP_RBS_HEADER
Description: This table tracks associations between project, plan and Resource Breakdown Structures
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_PJP_RBS_HEADER.PROJECT_ID
PA_PROJECTS_ALL
PJI_PJP_RBS_HEADER.PLAN_VERSION_ID
PA_BUDGET_VERSIONS
PJI_PJP_RBS_HEADER.RBS_VERSION_ID
PA_RBS_VERSIONS_B
[top of page]
PJI.PJI_PJP_RBS_HEADER does not reference any database object
PJI.PJI_PJP_RBS_HEADER is referenced by following:
APPS
SYNONYM - PJI_PJP_RBS_HEADER
[top of page]
Table: PJI_PJP_RMAP_ACR
[top of page]
PJI.PJI_PJP_RMAP_ACR does not reference any database object
PJI.PJI_PJP_RMAP_ACR is referenced by following:
APPS
SYNONYM - PJI_PJP_RMAP_ACR
[top of page]
Table: PJI_PJP_RMAP_FPR
[top of page]
PJI.PJI_PJP_RMAP_FPR does not reference any database object
PJI.PJI_PJP_RMAP_FPR is referenced by following:
APPS
SYNONYM - PJI_PJP_RMAP_FPR
[top of page]
Table: PJI_PJP_WBS_HEADER
Description: This table tracks associations between projects and Work Breakdown Structures.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_PJP_WBS_HEADER.PROJECT_ID
PA_PROJECTS_ALL
PJI_PJP_WBS_HEADER.PLAN_VERSION_ID
PA_BUDGET_VERSIONS
[top of page]
PJI.PJI_PJP_WBS_HEADER does not reference any database object
PJI.PJI_PJP_WBS_HEADER is referenced by following:
APPS
SYNONYM - PJI_PJP_WBS_HEADER
[top of page]
Table: PJI_PJ_EXTR_PRJCLS
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_PJ_EXTR_PRJCLS does not reference any database object
PJI.PJI_PJ_EXTR_PRJCLS is referenced by following:
APPS
SYNONYM - PJI_PJ_EXTR_PRJCLS
[top of page]
Table: PJI_PLAN_EXTR_TMP
[top of page]
PJI.PJI_PLAN_EXTR_TMP does not reference any database object
PJI.PJI_PLAN_EXTR_TMP is referenced by following:
APPS
SYNONYM - PJI_PLAN_EXTR_TMP
[top of page]
Table: PJI_PMV_CLS_DIM_TMP
[top of page]
PJI.PJI_PMV_CLS_DIM_TMP does not reference any database object
PJI.PJI_PMV_CLS_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_CLS_DIM_TMP
[top of page]
Table: PJI_PMV_EC_RC_DIM_TMP
[top of page]
PJI.PJI_PMV_EC_RC_DIM_TMP does not reference any database object
PJI.PJI_PMV_EC_RC_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_EC_RC_DIM_TMP
[top of page]
Table: PJI_PMV_ET_RT_DIM_TMP
[top of page]
PJI.PJI_PMV_ET_RT_DIM_TMP does not reference any database object
PJI.PJI_PMV_ET_RT_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_ET_RT_DIM_TMP
[top of page]
Table: PJI_PMV_ITD_DIM_TMP
[top of page]
PJI.PJI_PMV_ITD_DIM_TMP does not reference any database object
PJI.PJI_PMV_ITD_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_ITD_DIM_TMP
[top of page]
Table: PJI_PMV_JB_DIM_TMP
[top of page]
PJI.PJI_PMV_JB_DIM_TMP does not reference any database object
PJI.PJI_PMV_JB_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_JB_DIM_TMP
[top of page]
Table: PJI_PMV_JL_DIM_TMP
[top of page]
PJI.PJI_PMV_JL_DIM_TMP does not reference any database object
PJI.PJI_PMV_JL_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_JL_DIM_TMP
[top of page]
Table: PJI_PMV_ORGZ_DIM_TMP
[top of page]
PJI.PJI_PMV_ORGZ_DIM_TMP does not reference any database object
PJI.PJI_PMV_ORGZ_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
[top of page]
Table: PJI_PMV_ORG_DIM_TMP
[top of page]
PJI.PJI_PMV_ORG_DIM_TMP does not reference any database object
PJI.PJI_PMV_ORG_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_ORG_DIM_TMP
[top of page]
Table: PJI_PMV_PRJ_DIM_TMP
[top of page]
PJI.PJI_PMV_PRJ_DIM_TMP does not reference any database object
PJI.PJI_PMV_PRJ_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_PRJ_DIM_TMP
[top of page]
Table: PJI_PMV_RC_DIM_TMP
[top of page]
PJI.PJI_PMV_RC_DIM_TMP does not reference any database object
PJI.PJI_PMV_RC_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_RC_DIM_TMP
[top of page]
Table: PJI_PMV_RT_DIM_TMP
[top of page]
PJI.PJI_PMV_RT_DIM_TMP does not reference any database object
PJI.PJI_PMV_RT_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_RT_DIM_TMP
[top of page]
Table: PJI_PMV_TCMP_DIM_TMP
[top of page]
PJI.PJI_PMV_TCMP_DIM_TMP does not reference any database object
PJI.PJI_PMV_TCMP_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_TCMP_DIM_TMP
[top of page]
Table: PJI_PMV_TIME_DIM_TMP
[top of page]
PJI.PJI_PMV_TIME_DIM_TMP does not reference any database object
PJI.PJI_PMV_TIME_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_TIME_DIM_TMP
[top of page]
Table: PJI_PMV_UC_DIM_TMP
[top of page]
PJI.PJI_PMV_UC_DIM_TMP does not reference any database object
PJI.PJI_PMV_UC_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_UC_DIM_TMP
[top of page]
Table: PJI_PMV_WT_DIM_TMP
[top of page]
PJI.PJI_PMV_WT_DIM_TMP does not reference any database object
PJI.PJI_PMV_WT_DIM_TMP is referenced by following:
APPS
SYNONYM - PJI_PMV_WT_DIM_TMP
[top of page]
Table: PJI_PROJECT_CLASSES
Description: Class codes of class categories that are used to classify projects.
[top of page]
PJI.PJI_PROJECT_CLASSES does not reference any database object
PJI.PJI_PROJECT_CLASSES is referenced by following:
APPS
MATERIALIZED VIEW - PJI_AC_CLS_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_ET_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_ET_WT_F_MV
MATERIALIZED VIEW - PJI_FP_CLS_F_MV
SYNONYM - PJI_PROJECT_CLASSES
[top of page]
Table: PJI_PROJ_EXTR_STATUS
Description: Extraction status for projects that have been extracted to project performance-reporting model.
Primary Key: PJI_PROJ_EXTR_STATUS_PK
PROJECT_ID
[top of page]
PJI.PJI_PROJ_EXTR_STATUS does not reference any database object
PJI.PJI_PROJ_EXTR_STATUS is referenced by following:
APPS
SYNONYM - PJI_PROJ_EXTR_STATUS
[top of page]
Table: PJI_RBS_DENORM
Description: This table stores normalized resource breakdown structure information
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_RBS_DENORM.STRUCT_VERSION_ID
PA_RBS_VERSIONS_B
PJI_RBS_DENORM.SUP_ID
PA_RBS_ELEMENTS
PJI_RBS_DENORM.SUB_ID
PA_RBS_ELEMENTS
[top of page]
PJI.PJI_RBS_DENORM does not reference any database object
PJI.PJI_RBS_DENORM is referenced by following:
APPS
SYNONYM - PJI_RBS_DENORM
[top of page]
Table: PJI_RBS_DENORM_DELTA
[top of page]
PJI.PJI_RBS_DENORM_DELTA does not reference any database object
PJI.PJI_RBS_DENORM_DELTA is referenced by following:
APPS
SYNONYM - PJI_RBS_DENORM_DELTA
[top of page]
Table: PJI_REP_XBS_DENORM
Description: This table stores the denormalized information for project and program hierarchy
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_REP_XBS_DENORM.PROJECT_ID
PA_PROJECTS_ALL
[top of page]
PJI.PJI_REP_XBS_DENORM does not reference any database object
PJI.PJI_REP_XBS_DENORM is referenced by following:
APPS
SYNONYM - PJI_REP_XBS_DENORM
[top of page]
Table: PJI_RESOURCES_DENORM
Description: PJI_RESOURCES_DENORM is a denormalized table containing attributes for resources
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_RESOURCES_DENORM.PERSON_ID
RESOURCE_NAME
END_DATE
PER_ALL_PEOPLE_F
PJI_RESOURCES_DENORM.JOB_ID
PER_JOBS
[top of page]
PJI.PJI_RESOURCES_DENORM does not reference any database object
PJI.PJI_RESOURCES_DENORM is referenced by following:
APPS
SYNONYM - PJI_RESOURCES_DENORM
[top of page]
Table: PJI_RES_DELTA
Description: This table is used by PJI Resource Management and Financial Management Summarization
[top of page]
PJI.PJI_RES_DELTA does not reference any database object
PJI.PJI_RES_DELTA is referenced by following:
APPS
SYNONYM - PJI_RES_DELTA
[top of page]
Table: PJI_RES_UTILZ_TMP1
[top of page]
PJI.PJI_RES_UTILZ_TMP1 does not reference any database object
PJI.PJI_RES_UTILZ_TMP1 is referenced by following:
APPS
SYNONYM - PJI_RES_UTILZ_TMP1
[top of page]
Table: PJI_RES_UTILZ_TMP2
[top of page]
PJI.PJI_RES_UTILZ_TMP2 does not reference any database object
PJI.PJI_RES_UTILZ_TMP2 is referenced by following:
APPS
SYNONYM - PJI_RES_UTILZ_TMP2
[top of page]
Table: PJI_RES_UTILZ_TMP3
[top of page]
PJI.PJI_RES_UTILZ_TMP3 does not reference any database object
PJI.PJI_RES_UTILZ_TMP3 is referenced by following:
APPS
SYNONYM - PJI_RES_UTILZ_TMP3
[top of page]
Table: PJI_RM_AGGR_AVL1
[top of page]
PJI.PJI_RM_AGGR_AVL1 does not reference any database object
PJI.PJI_RM_AGGR_AVL1 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_AVL1
[top of page]
Table: PJI_RM_AGGR_AVL2
[top of page]
PJI.PJI_RM_AGGR_AVL2 does not reference any database object
PJI.PJI_RM_AGGR_AVL2 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_AVL2
[top of page]
Table: PJI_RM_AGGR_AVL3
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_AVL3 does not reference any database object
PJI.PJI_RM_AGGR_AVL3 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_AVL3
[top of page]
Table: PJI_RM_AGGR_AVL4
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_AVL4 does not reference any database object
PJI.PJI_RM_AGGR_AVL4 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_AVL4
[top of page]
Table: PJI_RM_AGGR_AVL5
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_AVL5 does not reference any database object
PJI.PJI_RM_AGGR_AVL5 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_AVL5
[top of page]
Table: PJI_RM_AGGR_RES1
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_RES1 does not reference any database object
PJI.PJI_RM_AGGR_RES1 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_RES1
[top of page]
Table: PJI_RM_AGGR_RES2
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_RES2 does not reference any database object
PJI.PJI_RM_AGGR_RES2 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_RES2
[top of page]
Table: PJI_RM_AGGR_RES3
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_AGGR_RES3 does not reference any database object
PJI.PJI_RM_AGGR_RES3 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_RES3
[top of page]
Table: PJI_RM_AGGR_RES6
Description: This intermediate table contains data to be loaded into PJI_RM_AGGR_RES1 when PJI RM summarization is run
[top of page]
PJI.PJI_RM_AGGR_RES6 does not reference any database object
PJI.PJI_RM_AGGR_RES6 is referenced by following:
APPS
SYNONYM - PJI_RM_AGGR_RES6
[top of page]
Table: PJI_RM_DNGL_RES
Description: Information about dangling records of resource summarization.
[top of page]
PJI.PJI_RM_DNGL_RES does not reference any database object
PJI.PJI_RM_DNGL_RES is referenced by following:
APPS
SYNONYM - PJI_RM_DNGL_RES
[top of page]
Table: PJI_RM_JOBO_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_JOBO_F_MV
[top of page]
APPS.PJI_RM_JOBO_F_MV does not reference any database object
APPS.PJI_RM_JOBO_F_MV is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_UTLZ
MATERIALIZED VIEW - PJI_RM_JOBO_F_MV
[top of page]
Table: PJI_RM_JOB_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_JOB_F_MV
[top of page]
APPS.PJI_RM_JOB_F_MV does not reference any database object
APPS.PJI_RM_JOB_F_MV is referenced by following:
APPS
VIEW - PJI_DIS_ORGJOB_V
PACKAGE BODY - PJI_PMV_UTLZ
MATERIALIZED VIEW - PJI_RM_JOBO_F_MV
MATERIALIZED VIEW - PJI_RM_JOB_F_MV
[top of page]
Table: PJI_RM_ORGO_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_ORGO_F_MV
[top of page]
APPS.PJI_RM_ORGO_F_MV does not reference any database object
APPS.PJI_RM_ORGO_F_MV is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_AVL
PACKAGE BODY - PJI_PMV_UTLZ
MATERIALIZED VIEW - PJI_RM_ORGO_F_MV
[top of page]
Table: PJI_RM_ORG_BATCH_MAP
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_ORG_BATCH_MAP does not reference any database object
PJI.PJI_RM_ORG_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_RM_ORG_BATCH_MAP
[top of page]
Table: PJI_RM_ORG_BATCH_STAT
[top of page]
PJI.PJI_RM_ORG_BATCH_STAT does not reference any database object
PJI.PJI_RM_ORG_BATCH_STAT is referenced by following:
APPS
SYNONYM - PJI_RM_ORG_BATCH_STAT
[top of page]
Table: PJI_RM_ORG_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_ORG_F_MV
[top of page]
APPS.PJI_RM_ORG_F_MV does not reference any database object
APPS.PJI_RM_ORG_F_MV is referenced by following:
APPS
PACKAGE BODY - PA_PJI_UTIL_PKG
VIEW - PJI_DIS_ORG_V
MATERIALIZED VIEW - PJI_RM_ORGO_F_MV
MATERIALIZED VIEW - PJI_RM_ORG_F_MV
[top of page]
Table: PJI_RM_RES_BATCH_MAP
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_RES_BATCH_MAP does not reference any database object
PJI.PJI_RM_RES_BATCH_MAP is referenced by following:
APPS
SYNONYM - PJI_RM_RES_BATCH_MAP
[top of page]
Table: PJI_RM_RES_F
Description: This table stores summarized data for utilization and availabilty measures by resources for project intelligence
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_RM_RES_F.JOB_ID
PER_JOBS
PJI_RM_RES_F.EXPENDITURE_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_RM_RES_F.EXPENDITURE_ORG_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_RM_RES_F does not reference any database object
PJI.PJI_RM_RES_F is referenced by following:
APPS
MATERIALIZED VIEW - PJI_RM_JOB_F_MV
MATERIALIZED VIEW - PJI_RM_ORG_F_MV
SYNONYM - PJI_RM_RES_F
[top of page]
Table: PJI_RM_RES_WT_F
Description: This table stores summarized data for utilization and availabilty measures by resource and worktype for project intelligence
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_RM_RES_WT_F.PROJECT_ID
PA_PROJECTS_ALL
PJI_RM_RES_WT_F.WORK_TYPE_ID
PA_WORK_TYPES_B
PJI_RM_RES_WT_F.JOB_ID
PER_JOBS
PJI_RM_RES_WT_F.EXPENDITURE_ORGANIZATION_ID
HR_ALL_ORGANIZATION_UNITS
PJI_RM_RES_WT_F.EXPENDITURE_ORG_ID
HR_ALL_ORGANIZATION_UNITS
[top of page]
PJI.PJI_RM_RES_WT_F does not reference any database object
PJI.PJI_RM_RES_WT_F is referenced by following:
APPS
SYNONYM - PJI_RM_RES_WT_F
MATERIALIZED VIEW - PJI_RM_WT_F_MV
[top of page]
Table: PJI_RM_REXT_FCSTITEM
Description: This is an intermediate summarization table.
[top of page]
PJI.PJI_RM_REXT_FCSTITEM does not reference any database object
PJI.PJI_RM_REXT_FCSTITEM is referenced by following:
APPS
SYNONYM - PJI_RM_REXT_FCSTITEM
[top of page]
Table: PJI_RM_WORK_TYPE_INFO
Description: Information about the work type.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_RM_WORK_TYPE_INFO.WORK_TYPE_ID
PA_WORK_TYPES_B
[top of page]
PJI.PJI_RM_WORK_TYPE_INFO does not reference any database object
PJI.PJI_RM_WORK_TYPE_INFO is referenced by following:
APPS
SYNONYM - PJI_RM_WORK_TYPE_INFO
[top of page]
Table: PJI_RM_WORK_TYPE_ROWID
[top of page]
PJI.PJI_RM_WORK_TYPE_ROWID does not reference any database object
PJI.PJI_RM_WORK_TYPE_ROWID is referenced by following:
APPS
SYNONYM - PJI_RM_WORK_TYPE_ROWID
[top of page]
Table: PJI_RM_WTO_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_WTO_F_MV
[top of page]
APPS.PJI_RM_WTO_F_MV does not reference any database object
APPS.PJI_RM_WTO_F_MV is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_UTLZ
MATERIALIZED VIEW - PJI_RM_WTO_F_MV
[top of page]
Table: PJI_RM_WT_F_MV
Description: snapshot table for snapshot APPS.PJI_RM_WT_F_MV
[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:
APPS
VIEW - PJI_DIS_ORGWT_V
MATERIALIZED VIEW - PJI_RM_WTO_F_MV
MATERIALIZED VIEW - PJI_RM_WT_F_MV
[top of page]
Table: PJI_ROLLUP_LEVEL_STATUS
Description: This table indicates if the resource rollup slices by the resource breakdown structure are created or not for a project and a plan
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_ROLLUP_LEVEL_STATUS.PROJECT_ID
PA_PROJECTS_ALL
PJI_ROLLUP_LEVEL_STATUS.RBS_VERSION_ID
PA_RBS_VERSIONS_B
PJI_ROLLUP_LEVEL_STATUS.PLAN_VERSION_ID
PA_BUDGET_VERSIONS
[top of page]
PJI.PJI_ROLLUP_LEVEL_STATUS does not reference any database object
PJI.PJI_ROLLUP_LEVEL_STATUS is referenced by following:
APPS
SYNONYM - PJI_ROLLUP_LEVEL_STATUS
[top of page]
Table: PJI_ROLL_WEEK_OFFSET
Description: Offset values for rolling week
[top of page]
PJI.PJI_ROLL_WEEK_OFFSET does not reference any database object
PJI.PJI_ROLL_WEEK_OFFSET is referenced by following:
APPS
SYNONYM - PJI_ROLL_WEEK_OFFSET
[top of page]
Table: PJI_SYSTEM_CONFIG_HIST
Description: History of the configuration of your Oracle Projects Intelligence
[top of page]
PJI.PJI_SYSTEM_CONFIG_HIST does not reference any database object
PJI.PJI_SYSTEM_CONFIG_HIST is referenced by following:
APPS
SYNONYM - PJI_SYSTEM_CONFIG_HIST
[top of page]
Table: PJI_SYSTEM_DEBUG_MSG
Description: Debug messages for Projects Intelligence
[top of page]
PJI.PJI_SYSTEM_DEBUG_MSG does not reference any database object
PJI.PJI_SYSTEM_DEBUG_MSG is referenced by following:
APPS
SYNONYM - PJI_SYSTEM_DEBUG_MSG
[top of page]
Table: PJI_SYSTEM_PARAMETERS
Description: Information about the configuration of an Oracle Projects Intelligence installation
Primary Key: PJI_SYSTEM_PARAMETERS_PK
NAME
[top of page]
PJI.PJI_SYSTEM_PARAMETERS does not reference any database object
PJI.PJI_SYSTEM_PARAMETERS is referenced by following:
APPS
SYNONYM - PJI_SYSTEM_PARAMETERS
[top of page]
Table: PJI_SYSTEM_PRC_STATUS
Description: Status of the steps that have been submitted
[top of page]
PJI.PJI_SYSTEM_PRC_STATUS does not reference any database object
PJI.PJI_SYSTEM_PRC_STATUS is referenced by following:
APPS
SYNONYM - PJI_SYSTEM_PRC_STATUS
[top of page]
Table: PJI_SYSTEM_SETTINGS
Description: Information about the configuration of an Oracle Projects Intelligence installation
Primary Key: PJI_SYSTEM_SETTINGS_PK
SETTING_ID
[top of page]
PJI.PJI_SYSTEM_SETTINGS does not reference any database object
PJI.PJI_SYSTEM_SETTINGS is referenced by following:
APPS
SYNONYM - PJI_SYSTEM_SETTINGS
[top of page]
Table: PJI_TIME_CAL_EXTR_INFO
Description: This table stores last extraction information for all calendards that have been extracted to project performance-reporting model.
[top of page]
PJI.PJI_TIME_CAL_EXTR_INFO does not reference any database object
PJI.PJI_TIME_CAL_EXTR_INFO is referenced by following:
APPS
SYNONYM - PJI_TIME_CAL_EXTR_INFO
[top of page]
Table: PJI_TIME_CAL_PERIOD
Description: This table stores period definition for fiscal calendar
[top of page]
PJI.PJI_TIME_CAL_PERIOD does not reference any database object
PJI.PJI_TIME_CAL_PERIOD is referenced by following:
APPS
SYNONYM - PJI_TIME_CAL_PERIOD
[top of page]
Table: PJI_TIME_CAL_QTR
Description: This table stores quarter definition for fiscal calendar
[top of page]
PJI.PJI_TIME_CAL_QTR does not reference any database object
PJI.PJI_TIME_CAL_QTR is referenced by following:
APPS
SYNONYM - PJI_TIME_CAL_QTR
[top of page]
Table: PJI_TIME_CAL_RPT_STRUCT
Description: This table stores fiscal time dimension information in a special format required for project performance reports
[top of page]
PJI.PJI_TIME_CAL_RPT_STRUCT does not reference any database object
PJI.PJI_TIME_CAL_RPT_STRUCT is referenced by following:
APPS
SYNONYM - PJI_TIME_CAL_RPT_STRUCT
[top of page]
Table: PJI_TIME_CAL_YEAR
Description: This table stores year definition for fiscal calendar
[top of page]
PJI.PJI_TIME_CAL_YEAR does not reference any database object
PJI.PJI_TIME_CAL_YEAR is referenced by following:
APPS
SYNONYM - PJI_TIME_CAL_YEAR
[top of page]
Table: PJI_TIME_DAY_MV
[top of page]
APPS.PJI_TIME_DAY_MV does not reference any database object
APPS.PJI_TIME_DAY_MV is referenced by following:
APPS
VIEW - PJI_DIS_MGRRES_V
VIEW - PJI_DIS_MGRWT_V
VIEW - PJI_DIS_ORGRES_V
VIEW - PJI_DIS_RESWT_V
MATERIALIZED VIEW - PJI_TIME_DAY_MV
[top of page]
Table: PJI_TIME_ENT_PERIOD
Description: This table stores period definition for enterprise calendar
[top of page]
PJI.PJI_TIME_ENT_PERIOD does not reference any database object
PJI.PJI_TIME_ENT_PERIOD is referenced by following:
APPS
SYNONYM - PJI_TIME_ENT_PERIOD
[top of page]
Table: PJI_TIME_ENT_QTR
Description: This table stores quarter definition for enterprise calendar
[top of page]
PJI.PJI_TIME_ENT_QTR does not reference any database object
PJI.PJI_TIME_ENT_QTR is referenced by following:
APPS
SYNONYM - PJI_TIME_ENT_QTR
[top of page]
Table: PJI_TIME_ENT_YEAR
Description: This table stores year definition for enterprise calendar
[top of page]
PJI.PJI_TIME_ENT_YEAR does not reference any database object
PJI.PJI_TIME_ENT_YEAR is referenced by following:
APPS
SYNONYM - PJI_TIME_ENT_YEAR
[top of page]
Table: PJI_TIME_MV
Description: snapshot table for snapshot APPS.PJI_TIME_MV
[top of page]
APPS.PJI_TIME_MV does not reference any database object
APPS.PJI_TIME_MV is referenced by following:
APPS
VIEW - PJI_DIS_ORGJOB_V
VIEW - PJI_DIS_ORGWT_V
VIEW - PJI_DIS_ORG_V
PACKAGE BODY - PJI_RESOURCE_UTILZ
MATERIALIZED VIEW - PJI_TIME_MV
MATERIALIZED VIEW - PJI_TIME_TREND_MV
[top of page]
Table: PJI_TIME_PA_RPT_STR_MV
[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:
APPS
PACKAGE BODY - PJI_FM_SUM_ROLLUP_ACT
MATERIALIZED VIEW - PJI_TIME_PA_RPT_STR_MV
[top of page]
Table: PJI_TIME_RPT_STRUCT
Description: This table stores enterprise time dimension information in a special format required for project performance reports
[top of page]
PJI.PJI_TIME_RPT_STRUCT does not reference any database object
PJI.PJI_TIME_RPT_STRUCT is referenced by following:
APPS
SYNONYM - PJI_TIME_RPT_STRUCT
[top of page]
Table: PJI_TIME_TREND_MV
[top of page]
APPS.PJI_TIME_TREND_MV does not reference any database object
APPS.PJI_TIME_TREND_MV is referenced by following:
APPS
MATERIALIZED VIEW - PJI_TIME_TREND_MV
[top of page]
Table: PJI_TIME_WEEK
Description: This table stores week definition for enterprise calendar
[top of page]
PJI.PJI_TIME_WEEK does not reference any database object
PJI.PJI_TIME_WEEK is referenced by following:
APPS
SYNONYM - PJI_TIME_WEEK
[top of page]
Table: PJI_XBS_DENORM
Description: This table stores normalized work breakdown structure and program hierarchy information
Foreign Keys from this table:
Foreign Key Column
Foreign Table
PJI_XBS_DENORM.STRUCT_VERSION_ID
PA_PROJ_ELEMENT_VERSIONS
PJI_XBS_DENORM.SUP_ID
PA_PROJ_ELEMENT_VERSIONS
PJI_XBS_DENORM.SUB_ID
PA_PROJ_ELEMENT_VERSIONS
[top of page]
PJI.PJI_XBS_DENORM does not reference any database object
PJI.PJI_XBS_DENORM is referenced by following:
APPS
SYNONYM - PJI_XBS_DENORM
[top of page]
Table: PJI_XBS_DENORM_DELTA
[top of page]
PJI.PJI_XBS_DENORM_DELTA does not reference any database object
PJI.PJI_XBS_DENORM_DELTA is referenced by following:
APPS
SYNONYM - PJI_XBS_DENORM_DELTA
[top of page]
View: PJI_ACCUM_RL_ACT_V
[top of page]
APPS.PJI_ACCUM_RL_ACT_V references the following:
APPS
VIEW - PA_ACCUM_RSRC_ACT_V
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FM_XBS_ACCUM_TMP1
APPS.PJI_ACCUM_RL_ACT_V is not referenced by any database object
[top of page]
View: PJI_ACCUM_WBS_ACT_V
[top of page]
APPS.PJI_ACCUM_WBS_ACT_V references the following:
APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PA_ACCUM_WBS_ACT_V
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FM_XBS_ACCUM_TMP1
APPS.PJI_ACCUM_WBS_ACT_V is not referenced by any database object
[top of page]
View: PJI_ACT_CMT_BY_PERIOD_V
[top of page]
APPS.PJI_ACT_CMT_BY_PERIOD_V references the following:
APPS
VIEW - PJI_PRD_ACT_CMT_BY_RSRC_V
APPS.PJI_ACT_CMT_BY_PERIOD_V is not referenced by any database object
[top of page]
View: PJI_AC_ACT_CMT_BY_RSRC_V
[top of page]
APPS.PJI_AC_ACT_CMT_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
APPS.PJI_AC_ACT_CMT_BY_RSRC_V is not referenced by any database object
[top of page]
View: PJI_AC_ACT_CMT_BY_TASK_V
[top of page]
APPS.PJI_AC_ACT_CMT_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
APPS.PJI_AC_ACT_CMT_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_AC_PLN_BY_RSRC_V
[top of page]
APPS.PJI_AC_PLN_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
APPS.PJI_AC_PLN_BY_RSRC_V is not referenced by any database object
[top of page]
View: PJI_AC_PLN_BY_TASK_V
[top of page]
APPS.PJI_AC_PLN_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
APPS.PJI_AC_PLN_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_AC_XBS_ACCUM_F_V
[top of page]
APPS.PJI_AC_XBS_ACCUM_F_V references the following:
APPS
SYNONYM - PJI_AC_XBS_ACCUM_F
APPS.PJI_AC_XBS_ACCUM_F_V is referenced by following:
APPS
PACKAGE BODY - PJI_REP_MEASURE_UTIL
[top of page]
View: PJI_AVL_DAYS_V
[top of page]
APPS.PJI_AVL_DAYS_V references the following:
APPS
SYNONYM - PJI_MT_BUCKETS
APPS.PJI_AVL_DAYS_V is not referenced by any database object
[top of page]
View: PJI_AVL_THRESHOLDS_V
[top of page]
APPS.PJI_AVL_THRESHOLDS_V references the following:
APPS
SYNONYM - PJI_MT_BUCKETS
APPS.PJI_AVL_THRESHOLDS_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_AVL
[top of page]
View: PJI_AVL_TYPES_V
[top of page]
APPS.PJI_AVL_TYPES_V references the following:
APPS
PACKAGE - FND_GLOBAL
VIEW - PJI_LOOKUPS
APPS.PJI_AVL_TYPES_V is not referenced by any database object
[top of page]
View: PJI_CLASS_CATEGORIES_V
[top of page]
APPS.PJI_CLASS_CATEGORIES_V references the following:
APPS
SYNONYM - PJI_CLASS_CATEGORIES
APPS.PJI_CLASS_CATEGORIES_V is not referenced by any database object
[top of page]
View: PJI_CLASS_CODES_V
[top of page]
APPS.PJI_CLASS_CODES_V references the following:
APPS
SYNONYM - PJI_CLASS_CODES
APPS.PJI_CLASS_CODES_V is not referenced by any database object
[top of page]
View: PJI_CURRENCY_TYPES_V
[top of page]
APPS.PJI_CURRENCY_TYPES_V references the following:
APPS
VIEW - FII_CURRENCIES_V
PACKAGE - FII_CURRENCY_API
VIEW - GL_SETS_OF_BOOKS
SYNONYM - PA_IMPLEMENTATIONS_ALL
APPS.PJI_CURRENCY_TYPES_V is not referenced by any database object
[top of page]
View: PJI_DEFAULT_PERIOD_SETTINGS_V
[top of page]
APPS.PJI_DEFAULT_PERIOD_SETTINGS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - PA_BILLING_CYCLES
VIEW - PJI_LOOKUPS
SYNONYM - PJI_SYSTEM_SETTINGS
APPS.PJI_DEFAULT_PERIOD_SETTINGS_V is not referenced by any database object
[top of page]
View: PJI_DIS_MGRRES_V
[top of page]
APPS.PJI_DIS_MGRRES_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
VIEW - HRI_CS_SUPH_V
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPE_USAGES_F
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_RM_RES_F
TABLE - PJI_TIME_DAY_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_MGRRES_V is not referenced by any database object
[top of page]
View: PJI_DIS_MGRWT_V
[top of page]
APPS.PJI_DIS_MGRWT_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
VIEW - HRI_CS_SUPH_V
SYNONYM - PA_WORK_TYPES_B
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPE_USAGES_F
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_RM_RES_F
SYNONYM - PJI_RM_RES_WT_F
TABLE - PJI_TIME_DAY_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_MGRWT_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORGJOB_V
[top of page]
APPS.PJI_DIS_ORGJOB_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PJI_ORG_DENORM
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
SYNONYM - PJI_PMV_ORG_DIM_TMP
TABLE - PJI_RM_JOB_F_MV
TABLE - PJI_TIME_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_ORGJOB_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORGRES_V
[top of page]
APPS.PJI_DIS_ORGRES_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPE_USAGES_F
SYNONYM - PJI_ORG_DENORM
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
SYNONYM - PJI_PMV_ORG_DIM_TMP
SYNONYM - PJI_RM_RES_F
TABLE - PJI_TIME_DAY_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_ORGRES_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORGWT_V
[top of page]
APPS.PJI_DIS_ORGWT_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PA_WORK_TYPES_B
SYNONYM - PJI_ORG_DENORM
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
SYNONYM - PJI_PMV_ORG_DIM_TMP
TABLE - PJI_RM_WT_F_MV
TABLE - PJI_TIME_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_ORGWT_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORG_HRCHY_V
[top of page]
APPS.PJI_DIS_ORG_HRCHY_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PJI_ORG_DENORM
APPS.PJI_DIS_ORG_HRCHY_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORG_ROHRCHY_V
[top of page]
APPS.PJI_DIS_ORG_ROHRCHY_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PJI_ORG_DENORM
APPS.PJI_DIS_ORG_ROHRCHY_V is not referenced by any database object
[top of page]
View: PJI_DIS_ORG_V
[top of page]
APPS.PJI_DIS_ORG_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PJI_ORG_DENORM
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
SYNONYM - PJI_PMV_ORG_DIM_TMP
TABLE - PJI_RM_ORG_F_MV
TABLE - PJI_TIME_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_ORG_V is not referenced by any database object
[top of page]
View: PJI_DIS_PERSON_V
[top of page]
APPS.PJI_DIS_PERSON_V references the following:
APPS
SYNONYM - PER_ALL_PEOPLE_F
APPS.PJI_DIS_PERSON_V is not referenced by any database object
[top of page]
View: PJI_DIS_RESWT_V
[top of page]
APPS.PJI_DIS_RESWT_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PA_WORK_TYPES_B
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPE_USAGES_F
SYNONYM - PJI_ORG_DENORM
SYNONYM - PJI_ORG_EXTR_INFO
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
SYNONYM - PJI_PMV_ORG_DIM_TMP
SYNONYM - PJI_RM_RES_F
SYNONYM - PJI_RM_RES_WT_F
TABLE - PJI_TIME_DAY_MV
PACKAGE - PJI_UTILS
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PJI_DIS_RESWT_V is not referenced by any database object
[top of page]
View: PJI_DIS_SEC_ORGZ_V
[top of page]
APPS.PJI_DIS_SEC_ORGZ_V references the following:
APPS
SYNONYM - PJI_PMV_ORGZ_DIM_TMP
APPS.PJI_DIS_SEC_ORGZ_V is not referenced by any database object
[top of page]
View: PJI_DIS_SEC_ORG_V
[top of page]
APPS.PJI_DIS_SEC_ORG_V references the following:
APPS
SYNONYM - PJI_PMV_ORG_DIM_TMP
APPS.PJI_DIS_SEC_ORG_V is not referenced by any database object
[top of page]
View: PJI_DIS_SUP_HRCHY_V
[top of page]
APPS.PJI_DIS_SUP_HRCHY_V references the following:
APPS
VIEW - HRI_CS_SUPH_V
SYNONYM - PER_ALL_PEOPLE_F
APPS.PJI_DIS_SUP_HRCHY_V is not referenced by any database object
[top of page]
View: PJI_DIS_SUP_ROHRCHY_V
[top of page]
APPS.PJI_DIS_SUP_ROHRCHY_V references the following:
APPS
VIEW - HRI_CS_SUPHRO_V
SYNONYM - PER_ALL_PEOPLE_F
APPS.PJI_DIS_SUP_ROHRCHY_V is not referenced by any database object
[top of page]
View: PJI_DIS_WORK_TYPES_V
[top of page]
APPS.PJI_DIS_WORK_TYPES_V references the following:
APPS
SYNONYM - PA_UTIL_CATEGORIES_B
SYNONYM - PA_UTIL_CATEGORIES_TL
SYNONYM - PA_WORK_TYPES_B
SYNONYM - PA_WORK_TYPES_TL
APPS.PJI_DIS_WORK_TYPES_V is not referenced by any database object
[top of page]
View: PJI_EXP_CATEGORIES_V
[top of page]
APPS.PJI_EXP_CATEGORIES_V references the following:
APPS
SYNONYM - PA_EXPENDITURE_CATEGORIES
APPS.PJI_EXP_CATEGORIES_V is not referenced by any database object
[top of page]
View: PJI_EXP_EVT_TYPES_V
[top of page]
APPS.PJI_EXP_EVT_TYPES_V references the following:
APPS
SYNONYM - PA_EVENT_TYPES
SYNONYM - PA_EXPENDITURE_TYPES
APPS.PJI_EXP_EVT_TYPES_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_EXP_TYPES_V
[top of page]
APPS.PJI_EXP_TYPES_V references the following:
APPS
SYNONYM - PA_EXPENDITURE_CATEGORIES
SYNONYM - PA_EXPENDITURE_TYPES
APPS.PJI_EXP_TYPES_V is not referenced by any database object
[top of page]
View: PJI_FP_XBS_ACCUM_F_V
[top of page]
APPS.PJI_FP_XBS_ACCUM_F_V references the following:
APPS
SYNONYM - PJI_FP_XBS_ACCUM_F
APPS.PJI_FP_XBS_ACCUM_F_V is referenced by following:
APPS
PACKAGE BODY - PJI_REP_MEASURE_UTIL
[top of page]
View: PJI_JOBS_V
[top of page]
APPS.PJI_JOBS_V references the following:
APPS
PACKAGE - PA_JOB_UTILS
SYNONYM - PER_JOBS
APPS.PJI_JOBS_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_JOB_LEVELS_V
[top of page]
APPS.PJI_JOB_LEVELS_V references the following:
APPS
PACKAGE - PA_JOB_UTILS
VIEW - PA_SETUP_JOB_LEVELS_V
APPS.PJI_JOB_LEVELS_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_LOOKUPS
[top of page]
APPS.PJI_LOOKUPS references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.PJI_LOOKUPS is referenced by following:
APPS
PACKAGE BODY - PJI_AUDIT_RPT
VIEW - PJI_AVL_TYPES_V
VIEW - PJI_DEFAULT_PERIOD_SETTINGS_V
VIEW - PJI_PERIOD_TYPES_V
PACKAGE BODY - PJI_PJ_PROJ_CLASS_EXTR
PACKAGE BODY - PJI_PMV_DFLT_PARAMS_PVT
PACKAGE BODY - PJI_PMV_PROFITABILITY
PACKAGE BODY - PJI_PMV_UTIL
PACKAGE BODY - PJI_RESOURCE_UTILZ
PACKAGE BODY - PJI_UTILS
[top of page]
View: PJI_MT_MEASURES_V
[top of page]
APPS.PJI_MT_MEASURES_V references the following:
APPS
VIEW - PJI_MT_MEASURES_VL
VIEW - PJI_MT_MEASURE_SETS_VL
APPS.PJI_MT_MEASURES_V is referenced by following:
APPS
PACKAGE BODY - PA_EXCEPTION_ENGINE_PKG
VIEW - PA_PERF_RULES_V
[top of page]
View: PJI_MT_MEASURES_VL
[top of page]
APPS.PJI_MT_MEASURES_VL references the following:
APPS
SYNONYM - PJI_MT_MEASURES_B
SYNONYM - PJI_MT_MEASURES_TL
APPS.PJI_MT_MEASURES_VL is referenced by following:
APPS
VIEW - PJI_MT_MEASURES_V
PACKAGE BODY - PJI_REP_MEASURE_UTIL
[top of page]
View: PJI_MT_MEASURE_SETS_VL
[top of page]
APPS.PJI_MT_MEASURE_SETS_VL references the following:
APPS
SYNONYM - PJI_MT_MEASURE_SETS_B
SYNONYM - PJI_MT_MEASURE_SETS_TL
APPS.PJI_MT_MEASURE_SETS_VL is referenced by following:
APPS
VIEW - PJI_MT_MEASURES_V
PACKAGE BODY - PJI_REP_MEASURE_UTIL
[top of page]
View: PJI_MT_ROWSET_VL
[top of page]
APPS.PJI_MT_ROWSET_VL references the following:
APPS
SYNONYM - PJI_MT_ROWSET_B
SYNONYM - PJI_MT_ROWSET_TL
APPS.PJI_MT_ROWSET_VL is not referenced by any database object
[top of page]
View: PJI_OPERATING_UNITS_V
[top of page]
APPS.PJI_OPERATING_UNITS_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PA_IMPLEMENTATIONS_ALL
SYNONYM - PER_ORGANIZATION_LIST
SYNONYM - PER_SECURITY_PROFILES
APPS.PJI_OPERATING_UNITS_V is not referenced by any database object
[top of page]
View: PJI_ORGANIZATIONS_V
[top of page]
APPS.PJI_ORGANIZATIONS_V references the following:
APPS
PACKAGE - PJI_PMV_UTIL
APPS.PJI_ORGANIZATIONS_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_DFLT_PARAMS_PVT
[top of page]
View: PJI_PERIOD_TYPES_V
[top of page]
APPS.PJI_PERIOD_TYPES_V references the following:
APPS
PACKAGE - FND_GLOBAL
VIEW - PJI_LOOKUPS
APPS.PJI_PERIOD_TYPES_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_DFLT_PARAMS_PVT
[top of page]
View: PJI_PRD_ACT_CMT_BY_RSRC_V
[top of page]
APPS.PJI_PRD_ACT_CMT_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
VIEW - PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_ACT_CMT_BY_RSRC_V is referenced by following:
APPS
VIEW - PJI_ACT_CMT_BY_PERIOD_V
[top of page]
View: PJI_PRD_ACT_CMT_BY_TASK_V
[top of page]
APPS.PJI_PRD_ACT_CMT_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
VIEW - PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_ACT_CMT_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_PRD_ACT_CMT_PG_TASK_V
[top of page]
APPS.PJI_PRD_ACT_CMT_PG_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
VIEW - PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_ACT_CMT_PG_TASK_V is not referenced by any database object
[top of page]
View: PJI_PRD_PLN_BY_RSRC_V
[top of page]
APPS.PJI_PRD_PLN_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
VIEW - PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_PLN_BY_RSRC_V is not referenced by any database object
[top of page]
View: PJI_PRD_PLN_BY_TASK_V
[top of page]
APPS.PJI_PRD_PLN_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
VIEW - PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_PLN_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_PROJECTS_V
[top of page]
APPS.PJI_PROJECTS_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
APPS.PJI_PROJECTS_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_REVENUE_CATEGORIES_V
[top of page]
APPS.PJI_REVENUE_CATEGORIES_V references the following:
APPS
VIEW - PA_LOOKUPS
APPS.PJI_REVENUE_CATEGORIES_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_TIME_CAL_PERIOD_V
[top of page]
APPS.PJI_TIME_CAL_PERIOD_V references the following:
APPS
SYNONYM - PJI_TIME_CAL_PERIOD
APPS.PJI_TIME_CAL_PERIOD_V is referenced by following:
APPS
VIEW - PA_ALLOC_TXN_ACCUM_RBS_V
VIEW - PA_ALLOC_TXN_ACCUM_V
PACKAGE BODY - PA_PROGRESS_UTILS
PACKAGE BODY - PA_RP_UTIL
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_FM_PLAN_CAL_RLPS
PACKAGE BODY - PJI_FM_PLAN_CAL_RLPS_T
PACKAGE BODY - PJI_FM_PLAN_MAINT_PVT
PACKAGE BODY - PJI_FM_PLAN_MAINT_T_PVT
PACKAGE BODY - PJI_FM_SUM_PSI
PACKAGE BODY - PJI_FM_XBS_ACCUM_UTILS
PACKAGE BODY - PJI_PJP_SUM_MAIN
PACKAGE BODY - PJI_PJP_SUM_ROLLUP
VIEW - PJI_PRD_ACT_CMT_BY_RSRC_V
VIEW - PJI_PRD_ACT_CMT_BY_TASK_V
VIEW - PJI_PRD_ACT_CMT_PG_TASK_V
VIEW - PJI_PRD_PLN_BY_RSRC_V
VIEW - PJI_PRD_PLN_BY_TASK_V
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_MEASURE_UTIL
PACKAGE BODY - PJI_REP_UTIL
PACKAGE BODY - PJI_UTILS
VIEW - PJI_XTD_ACT_CMT_BY_RSRC_V
VIEW - PJI_XTD_ACT_CMT_BY_TASK_V
VIEW - PJI_XTD_PLN_BY_RSRC_V
VIEW - PJI_XTD_PLN_BY_TASK_V
[top of page]
View: PJI_TIME_CAL_QTR_V
[top of page]
APPS.PJI_TIME_CAL_QTR_V references the following:
APPS
SYNONYM - PJI_TIME_CAL_QTR
APPS.PJI_TIME_CAL_QTR_V is referenced by following:
APPS
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_FM_PLAN_MAINT_T_PVT
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_UTIL
[top of page]
View: PJI_TIME_CAL_RPT_STRUCT_V
[top of page]
APPS.PJI_TIME_CAL_RPT_STRUCT_V references the following:
APPS
SYNONYM - PJI_TIME_CAL_RPT_STRUCT
APPS.PJI_TIME_CAL_RPT_STRUCT_V is referenced by following:
APPS
VIEW - PJI_XTD_ACT_CMT_BY_RSRC_V
VIEW - PJI_XTD_ACT_CMT_BY_TASK_V
VIEW - PJI_XTD_PLN_BY_RSRC_V
VIEW - PJI_XTD_PLN_BY_TASK_V
[top of page]
View: PJI_TIME_CAL_YEAR_V
[top of page]
APPS.PJI_TIME_CAL_YEAR_V references the following:
APPS
SYNONYM - PJI_TIME_CAL_YEAR
APPS.PJI_TIME_CAL_YEAR_V is referenced by following:
APPS
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_FM_PLAN_MAINT_T_PVT
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_UTIL
[top of page]
View: PJI_TIME_ENT_PERIOD_V
[top of page]
APPS.PJI_TIME_ENT_PERIOD_V references the following:
APPS
SYNONYM - PJI_TIME_ENT_PERIOD
APPS.PJI_TIME_ENT_PERIOD_V is referenced by following:
APPS
PACKAGE BODY - PA_RP_UTIL
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_EXTRACTION_UTIL
PACKAGE BODY - PJI_FM_PLAN_CAL_RLPS
PACKAGE BODY - PJI_FM_PLAN_CAL_RLPS_T
PACKAGE BODY - PJI_FM_PLAN_MAINT_T_PVT
PACKAGE BODY - PJI_FM_SUM_PSI
PACKAGE BODY - PJI_PJP_SUM_ROLLUP
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_MEASURE_UTIL
PACKAGE BODY - PJI_REP_UTIL
PACKAGE BODY - PJI_UTILS
[top of page]
View: PJI_TIME_ENT_QTR_V
[top of page]
APPS.PJI_TIME_ENT_QTR_V references the following:
APPS
SYNONYM - PJI_TIME_ENT_QTR
APPS.PJI_TIME_ENT_QTR_V is referenced by following:
APPS
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_UTIL
[top of page]
View: PJI_TIME_ENT_YEAR_V
[top of page]
APPS.PJI_TIME_ENT_YEAR_V references the following:
APPS
SYNONYM - PJI_TIME_ENT_YEAR
APPS.PJI_TIME_ENT_YEAR_V is referenced by following:
APPS
PACKAGE BODY - PJI_COMPLETION_GRAPH
PACKAGE BODY - PJI_EV_UTIL
PACKAGE BODY - PJI_REP_DFLT_DRILLDOWN_TXN
PACKAGE BODY - PJI_REP_UTIL
[top of page]
View: PJI_TIME_PA_PERIOD_V
[top of page]
APPS.PJI_TIME_PA_PERIOD_V references the following:
APPS
SYNONYM - FII_TIME_CAL_PERIOD
APPS.PJI_TIME_PA_PERIOD_V is not referenced by any database object
[top of page]
View: PJI_TIME_RPT_STRUCT_V
[top of page]
APPS.PJI_TIME_RPT_STRUCT_V references the following:
APPS
SYNONYM - PJI_TIME_RPT_STRUCT
APPS.PJI_TIME_RPT_STRUCT_V is not referenced by any database object
[top of page]
View: PJI_TIME_WEEK_V
[top of page]
APPS.PJI_TIME_WEEK_V references the following:
APPS
SYNONYM - PJI_TIME_WEEK
APPS.PJI_TIME_WEEK_V is not referenced by any database object
[top of page]
View: PJI_UTIL_CATEGORIES_V
[top of page]
APPS.PJI_UTIL_CATEGORIES_V references the following:
APPS
VIEW - PA_UTIL_CATEGORIES_VL
APPS.PJI_UTIL_CATEGORIES_V is not referenced by any database object
[top of page]
View: PJI_WORK_TYPES_V
[top of page]
APPS.PJI_WORK_TYPES_V references the following:
APPS
VIEW - PA_WORK_TYPES_VL
APPS.PJI_WORK_TYPES_V is referenced by following:
APPS
PACKAGE BODY - PJI_PMV_ENGINE
[top of page]
View: PJI_XBS_PLANS_PRJ_V
[top of page]
APPS.PJI_XBS_PLANS_PRJ_V references the following:
APPS
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_PJP_WBS_HEADER
APPS.PJI_XBS_PLANS_PRJ_V is referenced by following:
APPS
VIEW - PA_STRUCT_TASKS_AMG_V
[top of page]
View: PJI_XBS_PLANS_V
[top of page]
APPS.PJI_XBS_PLANS_V references the following:
APPS
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_PJP_WBS_HEADER
APPS.PJI_XBS_PLANS_V is referenced by following:
APPS
PACKAGE BODY - PA_PROGRESS_PUB
PACKAGE BODY - PA_PROJ_TASK_STRUC_PUB
VIEW - PA_TASK_PROGRESS_AMG_V
PACKAGE BODY - PA_TASK_PUB1
PACKAGE BODY - PA_WP_EXCEPTION_UTILS
[top of page]
View: PJI_XTD_ACT_CMT_BY_RSRC_V
[top of page]
APPS.PJI_XTD_ACT_CMT_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_ORG_EXTR_INFO
VIEW - PJI_TIME_CAL_PERIOD_V
VIEW - PJI_TIME_CAL_RPT_STRUCT_V
APPS.PJI_XTD_ACT_CMT_BY_RSRC_V is not referenced by any database object
[top of page]
View: PJI_XTD_ACT_CMT_BY_TASK_V
[top of page]
APPS.PJI_XTD_ACT_CMT_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_ORG_EXTR_INFO
VIEW - PJI_TIME_CAL_PERIOD_V
VIEW - PJI_TIME_CAL_RPT_STRUCT_V
APPS.PJI_XTD_ACT_CMT_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_XTD_PLN_BY_RSRC_V
[top of page]
APPS.PJI_XTD_PLN_BY_RSRC_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_ORG_EXTR_INFO
VIEW - PJI_TIME_CAL_PERIOD_V
VIEW - PJI_TIME_CAL_RPT_STRUCT_V
APPS.PJI_XTD_PLN_BY_RSRC_V is not referenced by any database object
[top of page]
View: PJI_XTD_PLN_BY_TASK_V
[top of page]
APPS.PJI_XTD_PLN_BY_TASK_V references the following:
APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PJI_FP_XBS_ACCUM_F
SYNONYM - PJI_ORG_EXTR_INFO
VIEW - PJI_TIME_CAL_PERIOD_V
VIEW - PJI_TIME_CAL_RPT_STRUCT_V
APPS.PJI_XTD_PLN_BY_TASK_V is not referenced by any database object
[top of page]
View: PJI_YES_NO_V
[top of page]
APPS.PJI_YES_NO_V references the following:
APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
APPS.PJI_YES_NO_V is not referenced by any database object
[top of page]