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®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, 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.
| Description: |
|---|
PJI.PJI_AC_AGGR_PJP0 does not reference any database object
PJI.PJI_AC_AGGR_PJP0 is referenced by following:
| Description: |
|---|
PJI.PJI_AC_AGGR_PJP1 does not reference any database object
PJI.PJI_AC_AGGR_PJP1 is referenced by following:
| Description: |
|---|
PJI.PJI_AC_CUST_PJP0 does not reference any database object
PJI.PJI_AC_CUST_PJP0 is referenced by following:
| Description: |
|---|
PJI.PJI_AC_RMAP_ACR does not reference any database object
PJI.PJI_AC_RMAP_ACR is referenced by following:
| Description: | This table stores summarized booking and backlog activity measures for project performance by work breakdown and program hierarchies |
|---|
| 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 |
PJI.PJI_AC_XBS_ACCUM_F does not reference any database object
PJI.PJI_AC_XBS_ACCUM_F is referenced by following:
| Description: | This is a temporary table that is used when helper batches are spawned for step 420. This is a persistent table. |
|---|
PJI.PJI_BATCH_STATUS_420 does not reference any database object
PJI.PJI_BATCH_STATUS_420 is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_AGGR_ACT1 does not reference any database object
PJI.PJI_FM_AGGR_ACT1 is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_AGGR_ACT2 does not reference any database object
PJI.PJI_FM_AGGR_ACT2 is referenced by following:
| Description: | This intermediate table stages data between PJI and Project Performance summarization. |
|---|
PJI.PJI_FM_AGGR_ACT4 does not reference any database object
PJI.PJI_FM_AGGR_ACT4 is referenced by following:
| Description: | This intermediate table contains PJI currency conversion rates during a summarization run. |
|---|
PJI.PJI_FM_AGGR_DLY_RATES does not reference any database object
PJI.PJI_FM_AGGR_DLY_RATES is referenced by following:
| Description: | This intermediate table contains PJI summarization data during a summarization run. |
|---|
PJI.PJI_FM_AGGR_FIN1 does not reference any database object
PJI.PJI_FM_AGGR_FIN1 is referenced by following:
| Description: | This intermediate table contains PJI summarization data during a summarization run. |
|---|
PJI.PJI_FM_AGGR_FIN2 does not reference any database object
PJI.PJI_FM_AGGR_FIN2 is referenced by following:
| Description: | This intermediate table is used for the first aggregation of PJP data by periods. |
|---|
PJI.PJI_FM_AGGR_FIN6 does not reference any database object
PJI.PJI_FM_AGGR_FIN6 is referenced by following:
| Description: | This intermediate table is used for staging data between PJI and PJP summarization runs. |
|---|
PJI.PJI_FM_AGGR_FIN7 does not reference any database object
PJI.PJI_FM_AGGR_FIN7 is referenced by following:
| Description: | This intermediate table is used for staging data between PJI and PJP summarization runs. |
|---|
PJI.PJI_FM_AGGR_FIN8 does not reference any database object
PJI.PJI_FM_AGGR_FIN8 is referenced by following:
| Description: | This intermediate table is used to look up Resource Class. |
|---|
PJI.PJI_FM_AGGR_RES_TYPES does not reference any database object
PJI.PJI_FM_AGGR_RES_TYPES is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_DNGL_ACT does not reference any database object
PJI.PJI_FM_DNGL_ACT is referenced by following:
| Description: | This intermediate table contains dangling PJI summarization data between summarization runs. |
|---|
PJI.PJI_FM_DNGL_FIN does not reference any database object
PJI.PJI_FM_DNGL_FIN is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_ARINV does not reference any database object
PJI.PJI_FM_EXTR_ARINV is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_DINVC does not reference any database object
PJI.PJI_FM_EXTR_DINVC is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_DINVCITM does not reference any database object
PJI.PJI_FM_EXTR_DINVCITM is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_DREVN does not reference any database object
PJI.PJI_FM_EXTR_DREVN is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_FUNDG does not reference any database object
PJI.PJI_FM_EXTR_FUNDG is referenced by following:
| Description: |
|---|
PJI.PJI_FM_EXTR_PLAN does not reference any database object
PJI.PJI_FM_EXTR_PLAN is referenced by following:
| Description: | This table stores the changes to financial plan data |
|---|
| 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 |
PJI.PJI_FM_EXTR_PLAN_LINES does not reference any database object
PJI.PJI_FM_EXTR_PLAN_LINES is referenced by following:
| Description: | This table stores the changes to financial plan data |
|---|
PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG does not reference any database object
PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_PLNVER1 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER1 is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_EXTR_PLNVER2 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER2 is referenced by following:
| Description: |
|---|
PJI.PJI_FM_EXTR_PLNVER4 does not reference any database object
PJI.PJI_FM_EXTR_PLNVER4 is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_FM_PROJ_BATCH_MAP is referenced by following:
| Description: |
|---|
PJI.PJI_FM_PROJ_BATCH_STAT does not reference any database object
PJI.PJI_FM_PROJ_BATCH_STAT is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_REXT_CDL does not reference any database object
PJI.PJI_FM_REXT_CDL is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_REXT_CRDL does not reference any database object
PJI.PJI_FM_REXT_CRDL is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_REXT_ERDL does not reference any database object
PJI.PJI_FM_REXT_ERDL is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_RMAP_ACT does not reference any database object
PJI.PJI_FM_RMAP_ACT is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_FM_RMAP_FIN does not reference any database object
PJI.PJI_FM_RMAP_FIN is referenced by following:
| Description: |
|---|
PJI.PJI_FM_RMAP_PSI does not reference any database object
PJI.PJI_FM_RMAP_PSI is referenced by following:
| Description: |
|---|
PJI.PJI_FM_XBS_ACCUM_INT does not reference any database object
PJI.PJI_FM_XBS_ACCUM_INT is referenced by following:
| Description: |
|---|
PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG does not reference any database object
PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG is referenced by following:
| Description: |
|---|
PJI.PJI_FM_XBS_ACCUM_TMP4 does not reference any database object
PJI.PJI_FM_XBS_ACCUM_TMP4 is referenced by following:
| Description: |
|---|
PJI.PJI_FP_AGGR_PJP0 does not reference any database object
PJI.PJI_FP_AGGR_PJP0 is referenced by following:
| Description: | This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization |
|---|
PJI.PJI_FP_AGGR_PJP1 does not reference any database object
PJI.PJI_FP_AGGR_PJP1 is referenced by following:
| Description: | This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization |
|---|
PJI.PJI_FP_AGGR_PJP1_T does not reference any database object
PJI.PJI_FP_AGGR_PJP1_T is referenced by following:
| Description: | This table is a mirror of PJI_FP_AGGR_PJP1 used during summarization |
|---|
PJI.PJI_FP_AGGR_PJP2 does not reference any database object
PJI.PJI_FP_AGGR_PJP2 is referenced by following:
| Description: |
|---|
PJI.PJI_FP_AGGR_RBS does not reference any database object
PJI.PJI_FP_AGGR_RBS is referenced by following:
| Description: | This table is used to build the RBS normalized table |
|---|
PJI.PJI_FP_AGGR_RBS_T does not reference any database object
PJI.PJI_FP_AGGR_RBS_T is referenced by following:
| Description: |
|---|
PJI.PJI_FP_AGGR_XBS does not reference any database object
PJI.PJI_FP_AGGR_XBS is referenced by following:
| Description: |
|---|
PJI.PJI_FP_CUST_PJP0 does not reference any database object
PJI.PJI_FP_CUST_PJP0 is referenced by following:
| Description: |
|---|
PJI.PJI_FP_RMAP_FPR does not reference any database object
PJI.PJI_FP_RMAP_FPR is referenced by following:
| Description: | This table stores summarized cost and revenue measures at project, task and periodic levels for project performance |
|---|
PJI.PJI_FP_TXN_ACCUM does not reference any database object
PJI.PJI_FP_TXN_ACCUM is referenced by following:
| Description: | This table stores summarized commitment measures at project, task and periodic levels for project performance |
|---|
PJI.PJI_FP_TXN_ACCUM1 does not reference any database object
PJI.PJI_FP_TXN_ACCUM1 is referenced by following:
| Description: | This table stores the resource attribute combinations which are used for resource breakdown structure mapping |
|---|
| 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 |
PJI.PJI_FP_TXN_ACCUM_HEADER does not reference any database object
PJI.PJI_FP_TXN_ACCUM_HEADER is referenced by following:
| Description: | This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, resource breakdown and program hierarchies |
|---|
| 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 |
PJI.PJI_FP_XBS_ACCUM_F does not reference any database object
PJI.PJI_FP_XBS_ACCUM_F is referenced by following:
| Description: | This is an temporary table that is used to spawn helper batches for step 420. This is a persistent table. |
|---|
PJI.PJI_HELPER_420 does not reference any database object
PJI.PJI_HELPER_420 is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_HELPER_BATCH_MAP does not reference any database object
PJI.PJI_HELPER_BATCH_MAP is referenced by following:
| Description: | Information for bucket values for different measures. |
|---|
PJI.PJI_MT_BUCKETS does not reference any database object
PJI.PJI_MT_BUCKETS is referenced by following:
| Description: | This table stores the definition of the measures used for reporting in oracle projects. |
|---|
PJI.PJI_MT_MEASURES_B does not reference any database object
PJI.PJI_MT_MEASURES_B is referenced by following:
| Description: | This table stores translated measure definition. |
|---|
PJI.PJI_MT_MEASURES_TL does not reference any database object
PJI.PJI_MT_MEASURES_TL is referenced by following:
| Description: | This table stores information about measure sets used for reporting in Oracle Projects. |
|---|
PJI.PJI_MT_MEASURE_SETS_B does not reference any database object
PJI.PJI_MT_MEASURE_SETS_B is referenced by following:
| Description: | This table stores translated measure set definition. |
|---|
PJI.PJI_MT_MEASURE_SETS_TL does not reference any database object
PJI.PJI_MT_MEASURE_SETS_TL is referenced by following:
| Description: | Information for process steps submitted during summarization. |
|---|
PJI.PJI_MT_PRC_STEPS does not reference any database object
PJI.PJI_MT_PRC_STEPS is referenced by following:
| Description: | This table stores the measures defined for a row set. |
|---|
PJI.PJI_MT_ROWSET_B does not reference any database object
PJI.PJI_MT_ROWSET_B is referenced by following:
| Description: | This table stores the measures defined for a row set |
|---|
PJI.PJI_MT_ROWSET_DET does not reference any database object
PJI.PJI_MT_ROWSET_DET is referenced by following:
| Description: | This table stores translated measure set definition |
|---|
PJI.PJI_MT_ROWSET_TL does not reference any database object
PJI.PJI_MT_ROWSET_TL is referenced by following:
| Description: | Information for organizations that have been extracted to project performance-reporting model. |
|---|
PJI.PJI_ORG_EXTR_INFO does not reference any database object
PJI.PJI_ORG_EXTR_INFO is referenced by following:
| Description: | Extraction status for organizations that have been extracted to project performance-reporting model. |
|---|
PJI.PJI_ORG_EXTR_STATUS does not reference any database object
PJI.PJI_ORG_EXTR_STATUS is referenced by following:
| Description: | This table is used to take a snapshot of online events. |
|---|
PJI.PJI_PA_PROJ_EVENTS_LOG does not reference any database object
PJI.PJI_PA_PROJ_EVENTS_LOG is referenced by following:
| Description: | This is an temporary table that is used to store XBS denorm data by the Refresh/Update Project Performance Data. This is a global temporary table. |
|---|
PJI.PJI_PA_XBS_DENORM_T does not reference any database object
PJI.PJI_PA_XBS_DENORM_T is referenced by following:
| Description: | This table stores PJP summarization state. |
|---|
PJI.PJI_PJP_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_PJP_PROJ_BATCH_MAP is referenced by following:
| Description: | This table stores PJP summarization state. |
|---|
PJI.PJI_PJP_PROJ_EXTR_STATUS does not reference any database object
PJI.PJI_PJP_PROJ_EXTR_STATUS is referenced by following:
| Description: | This table tracks associations between project, plan and Resource Breakdown Structures |
|---|
| 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 |
PJI.PJI_PJP_RBS_HEADER does not reference any database object
PJI.PJI_PJP_RBS_HEADER is referenced by following:
| Description: |
|---|
PJI.PJI_PJP_RMAP_ACR does not reference any database object
PJI.PJI_PJP_RMAP_ACR is referenced by following:
| Description: |
|---|
PJI.PJI_PJP_RMAP_FPR does not reference any database object
PJI.PJI_PJP_RMAP_FPR is referenced by following:
| Description: | This table tracks associations between projects and Work Breakdown Structures. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PJI_PJP_WBS_HEADER.PROJECT_ID | PA_PROJECTS_ALL |
| PJI_PJP_WBS_HEADER.PLAN_VERSION_ID | PA_BUDGET_VERSIONS |
PJI.PJI_PJP_WBS_HEADER does not reference any database object
PJI.PJI_PJP_WBS_HEADER is referenced by following:
| Description: | This is an temporary table that is used to store temporary data required for WBS Rollup by the Refresh/Update Project Performance Data. This is a global temporary table. |
|---|
PJI.PJI_PJP_WBS_HEADER_T does not reference any database object
PJI.PJI_PJP_WBS_HEADER_T is referenced by following:
| Description: |
|---|
PJI.PJI_PLAN_EXTR_TMP does not reference any database object
PJI.PJI_PLAN_EXTR_TMP is referenced by following:
| Description: | Extraction status for projects that have been extracted to project performance-reporting model. |
|---|
PJI.PJI_PROJ_EXTR_STATUS does not reference any database object
PJI.PJI_PROJ_EXTR_STATUS is referenced by following:
| Description: | This table stores normalized resource breakdown structure information |
|---|
| 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 |
PJI.PJI_RBS_DENORM does not reference any database object
PJI.PJI_RBS_DENORM is referenced by following:
| Description: |
|---|
PJI.PJI_RBS_DENORM_DELTA does not reference any database object
PJI.PJI_RBS_DENORM_DELTA is referenced by following:
| Description: | This table stores the denormalized information for project and program hierarchy |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PJI_REP_XBS_DENORM.PROJECT_ID | PA_PROJECTS_ALL |
PJI.PJI_REP_XBS_DENORM does not reference any database object
PJI.PJI_REP_XBS_DENORM is referenced by following:
| Description: | This intermediate table contains data to be loaded into PJI_RM_AGGR_RES1 when PJI RM summarization is run |
|---|
PJI.PJI_RM_AGGR_RES6 does not reference any database object
PJI.PJI_RM_AGGR_RES6 is referenced by following:
| Description: | Information about dangling records of resource summarization. |
|---|
PJI.PJI_RM_DNGL_RES does not reference any database object
PJI.PJI_RM_DNGL_RES is referenced by following:
| Description: | This table stores summarized data for utilization and availabilty measures by resources for project intelligence |
|---|
| 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 |
PJI.PJI_RM_RES_F does not reference any database object
PJI.PJI_RM_RES_F is referenced by following:
| Description: | This table stores summarized data for utilization and availabilty measures by resource and worktype for project intelligence |
|---|
| 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 |
PJI.PJI_RM_RES_WT_F does not reference any database object
PJI.PJI_RM_RES_WT_F is referenced by following:
| Description: | This is an intermediate summarization table. |
|---|
PJI.PJI_RM_REXT_FCSTITEM does not reference any database object
PJI.PJI_RM_REXT_FCSTITEM is referenced by following:
| Description: | Information about the work type. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PJI_RM_WORK_TYPE_INFO.WORK_TYPE_ID | PA_WORK_TYPES_B |
PJI.PJI_RM_WORK_TYPE_INFO does not reference any database object
PJI.PJI_RM_WORK_TYPE_INFO is referenced by following:
| 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 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 |
PJI.PJI_ROLLUP_LEVEL_STATUS does not reference any database object
PJI.PJI_ROLLUP_LEVEL_STATUS is referenced by following:
| Description: | History of the configuration of your Oracle Projects Intelligence |
|---|
PJI.PJI_SYSTEM_CONFIG_HIST does not reference any database object
PJI.PJI_SYSTEM_CONFIG_HIST is referenced by following:
| Description: | Debug messages for Projects Intelligence |
|---|
PJI.PJI_SYSTEM_DEBUG_MSG does not reference any database object
PJI.PJI_SYSTEM_DEBUG_MSG is referenced by following:
| Description: | Information about the configuration of an Oracle Projects Intelligence installation |
|---|
PJI.PJI_SYSTEM_PARAMETERS does not reference any database object
PJI.PJI_SYSTEM_PARAMETERS is referenced by following:
| Description: | Status of the steps that have been submitted |
|---|
PJI.PJI_SYSTEM_PRC_STATUS does not reference any database object
PJI.PJI_SYSTEM_PRC_STATUS is referenced by following:
| Description: | Information about the configuration of an Oracle Projects Intelligence installation |
|---|
PJI.PJI_SYSTEM_SETTINGS does not reference any database object
PJI.PJI_SYSTEM_SETTINGS is referenced by following:
| Description: | This table stores last extraction information for all calendards that have been extracted to project performance-reporting model. |
|---|
PJI.PJI_TIME_CAL_EXTR_INFO does not reference any database object
PJI.PJI_TIME_CAL_EXTR_INFO is referenced by following:
| Description: | This table stores period definition for fiscal calendar |
|---|
PJI.PJI_TIME_CAL_PERIOD does not reference any database object
PJI.PJI_TIME_CAL_PERIOD is referenced by following:
| Description: | This table stores quarter definition for fiscal calendar |
|---|
PJI.PJI_TIME_CAL_QTR does not reference any database object
PJI.PJI_TIME_CAL_QTR is referenced by following:
| Description: | This table stores fiscal time dimension information in a special format required for project performance reports |
|---|
PJI.PJI_TIME_CAL_RPT_STRUCT does not reference any database object
PJI.PJI_TIME_CAL_RPT_STRUCT is referenced by following:
| Description: | This table stores year definition for fiscal calendar |
|---|
PJI.PJI_TIME_CAL_YEAR does not reference any database object
PJI.PJI_TIME_CAL_YEAR is referenced by following:
| Description: | This table stores period definition for enterprise calendar |
|---|
PJI.PJI_TIME_ENT_PERIOD does not reference any database object
PJI.PJI_TIME_ENT_PERIOD is referenced by following:
| Description: | This table stores quarter definition for enterprise calendar |
|---|
PJI.PJI_TIME_ENT_QTR does not reference any database object
PJI.PJI_TIME_ENT_QTR is referenced by following:
| Description: | This table stores year definition for enterprise calendar |
|---|
PJI.PJI_TIME_ENT_YEAR does not reference any database object
PJI.PJI_TIME_ENT_YEAR is referenced by following:
| Description: | This table stores enterprise time dimension information in a special format required for project performance reports |
|---|
PJI.PJI_TIME_RPT_STRUCT does not reference any database object
PJI.PJI_TIME_RPT_STRUCT is referenced by following:
| Description: | This table stores week definition for enterprise calendar |
|---|
PJI.PJI_TIME_WEEK does not reference any database object
PJI.PJI_TIME_WEEK is referenced by following:
| Description: | This table stores normalized work breakdown structure and program hierarchy information |
|---|
| 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 |
PJI.PJI_XBS_DENORM does not reference any database object
PJI.PJI_XBS_DENORM is referenced by following:
| Description: | Used during PJP summarization, this table stores the difference between PA_XBS_DENORM and PJI_XBS_DENORM |
|---|
PJI.PJI_XBS_DENORM_DELTA does not reference any database object
PJI.PJI_XBS_DENORM_DELTA is referenced by following:
| Description: | This is an temporary table that is used to store XBS denorm data by the Refresh/Update Project Performance Data. This is a global temporary table. |
|---|
PJI.PJI_XBS_DENORM_T does not reference any database object
PJI.PJI_XBS_DENORM_T is referenced by following:
APPS.PJI_ACCUM_RL_ACT_V is not referenced by any database object
APPS.PJI_ACCUM_WBS_ACT_V is not referenced by any database object
APPS.PJI_ACT_CMT_BY_PERIOD_V is not referenced by any database object
APPS.PJI_AC_ACT_CMT_BY_RSRC_V is not referenced by any database object
APPS.PJI_AC_ACT_CMT_BY_TASK_V is not referenced by any database object
APPS.PJI_AC_PLN_BY_RSRC_V is not referenced by any database object
APPS.PJI_AC_PLN_BY_TASK_V is not referenced by any database object
APPS.PJI_AC_XBS_ACCUM_F_V is not referenced by any database object
APPS.PJI_DEFAULT_PERIOD_SETTINGS_V is not referenced by any database object
APPS.PJI_FP_XBS_ACCUM_F_V is not referenced by any database object
APPS.PJI_LOOKUPS is not referenced by any database object
APPS.PJI_MT_MEASURES_V is not referenced by any database object
APPS.PJI_MT_ROWSET_VL is not referenced by any database object
APPS.PJI_PRD_ACT_CMT_BY_TASK_V is not referenced by any database object
APPS.PJI_PRD_ACT_CMT_PG_TASK_V is not referenced by any database object
APPS.PJI_PRD_PLN_BY_RSRC_V is not referenced by any database object
APPS.PJI_PRD_PLN_BY_TASK_V is not referenced by any database object
APPS.PJI_TIME_CAL_QTR_V is not referenced by any database object
APPS.PJI_TIME_CAL_YEAR_V is not referenced by any database object
APPS.PJI_TIME_ENT_PERIOD_V is not referenced by any database object
APPS.PJI_TIME_ENT_QTR_V is not referenced by any database object
APPS.PJI_TIME_ENT_YEAR_V is not referenced by any database object
APPS.PJI_TIME_RPT_STRUCT_V is not referenced by any database object
APPS.PJI_XBS_PLANS_PRJ_V is not referenced by any database object
APPS.PJI_XBS_PLANS_V is not referenced by any database object
APPS.PJI_XTD_ACT_CMT_BY_RSRC_V is not referenced by any database object
APPS.PJI_XTD_ACT_CMT_BY_TASK_V is not referenced by any database object
APPS.PJI_XTD_PLN_BY_RSRC_V is not referenced by any database object
APPS.PJI_XTD_PLN_BY_TASK_V is not referenced by any database object
APPS.PJI_YES_NO_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |