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®, 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.

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

Description:

Comments

This table is mirror of PJI_AC_XBS_ACCUM_FROM used during summarization.

Columns

Name	Datatype	Length	Mandatory	Comments
WORKER_ID	NUMBER	(15)	Y	Partitioning column.
PROJECT_ID	NUMBER	(15)	Y	Identifier for the project
PROJECT_ORG_ID	NUMBER	(15)	Y	Identifier for the project operating unit
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Y	Identifier of the Project Organization
PROJECT_ELEMENT_ID	NUMBER	(15)	Y	This is the WBS element id and consists of projects and tasks.
TIME_ID	NUMBER	(15)	Y	Numeric identifier for time
PERIOD_TYPE_ID	NUMBER	(15)	Y	Numeric identifier for the period type (period, quarter, year, weeks)
CALENDAR_TYPE	VARCHAR2	(1)	Y	Specifies the calendar type (PA, GL, Enterprise)
WBS_ROLLUP_FLAG	VARCHAR2	(1)	Y	Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not.
PRG_ROLLUP_FLAG	VARCHAR2	(1)	Y	Indicates whether the amounts are rolled up by Project Hierarchy or not.
CURR_RECORD_TYPE_ID	NUMBER	(15)	Y	Identifier for the Currency record type
CURRENCY_CODE	VARCHAR2	(30)	Y	Currency Code
REVENUE	NUMBER			Accrued Revenue
INITIAL_FUNDING_AMOUNT	NUMBER			Initial Bookings Amount
INITIAL_FUNDING_COUNT	NUMBER			Initial Bookings Count
ADDITIONAL_FUNDING_AMOUNT	NUMBER			Additional Bookings Amount
ADDITIONAL_FUNDING_COUNT	NUMBER			Additional Bookings Count
CANCELLED_FUNDING_AMOUNT	NUMBER			Cancelled Bookings Amount
CANCELLED_FUNDING_COUNT	NUMBER			Cancelled Bookings Count
FUNDING_ADJUSTMENT_AMOUNT	NUMBER			Bookings Adjustments Amount
FUNDING_ADJUSTMENT_COUNT	NUMBER			Bookings Adjustments Count
REVENUE_WRITEOFF	NUMBER			Revenue Write-off
AR_INVOICE_AMOUNT	NUMBER			AR Invoiced Amount
AR_INVOICE_COUNT	NUMBER			AR Invoiced Count
AR_CASH_APPLIED_AMOUNT	NUMBER			Cash Applied Amount
AR_INVOICE_WRITE_OFF_AMOUNT	NUMBER			AR Invoice Write-off Amount
AR_INVOICE_WRITEOFF_COUNT	NUMBER			AR Invoice Write-off Count
AR_CREDIT_MEMO_AMOUNT	NUMBER			AR Credit Memo Amount
AR_CREDIT_MEMO_COUNT	NUMBER			AR Credit Memo Count
UNBILLED_RECEIVABLES	NUMBER			Unbilled Receivables
UNEARNED_REVENUE	NUMBER			Unearned Revenue
AR_UNAPPR_INVOICE_AMOUNT	NUMBER			Unapproved AR Invoices Amount
AR_UNAPPR_INVOICE_COUNT	NUMBER			Unapproved AR Invoices Count
AR_APPR_INVOICE_AMOUNT	NUMBER			Approved AR Invoices Amount
AR_APPR_INVOICE_COUNT	NUMBER			Approved AR Invoices Count
AR_AMOUNT_DUE	NUMBER			AR Invoices Due Amount
AR_COUNT_DUE	NUMBER			AR Invoices Due Count
AR_AMOUNT_OVERDUE	NUMBER			AR Invoices Overdue Amount
AR_COUNT_OVERDUE	NUMBER			AR Invoices Overdue Count
DORMANT_BACKLOG_INACTIV	NUMBER			Dormant Backlog (No activity)
DORMANT_BACKLOG_START	NUMBER			Dormant Backlog (Not started)
LOST_BACKLOG	NUMBER			Lost Backlog (Project closed)
ACTIVE_BACKLOG	NUMBER			Active Backlog
REVENUE_AT_RISK	NUMBER			Revenue at Risk

Index	Type	Tablespace	Column
I_SNAP$_PJI_AC_CLSO_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00076$ SYS_NC00077$ SYS_NC00078$ SYS_NC00079$ SYS_NC00080$ SYS_NC00081$ SYS_NC00082$ SYS_NC00083$
PJI_AC_CLSO_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID PROJECT_CLASS_ID CURR_RECORD_TYPE_ID

Index	Type	Tablespace	Column
I_SNAP$_PJI_AC_CLS_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00076$ SYS_NC00077$ SYS_NC00078$ SYS_NC00079$ SYS_NC00080$ SYS_NC00081$ SYS_NC00082$ SYS_NC00083$
PJI_AC_CLS_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID PROJECT_CLASS_ID CURR_RECORD_TYPE_ID

Index	Type	Tablespace	Column
I_SNAP$_PJI_AC_ORGO_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00075$ SYS_NC00076$ SYS_NC00077$ SYS_NC00078$ SYS_NC00079$ SYS_NC00080$ SYS_NC00081$
PJI_AC_ORGO_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE ORGANIZATION_ID CURR_RECORD_TYPE_ID

Index	Type	Tablespace	Column
I_SNAP$_PJI_AC_ORG_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00075$ SYS_NC00076$ SYS_NC00077$ SYS_NC00078$ SYS_NC00079$ SYS_NC00080$ SYS_NC00081$
PJI_AC_ORG_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE ORGANIZATION_ID CURR_RECORD_TYPE_ID

Index	Type	Tablespace	Column
PJI_AC_PROJ_F_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID
PJI_AC_PROJ_F_N2	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_ID TIME_ID CALENDAR_TYPE

Name	Datatype	Length	Mandatory	Comments
WORKER_ID	NUMBER		Y	Partitioning column
RL_ROWID	ROWID	(10)		Row id in AC reporting lines.
TMP_ROWID	ROWID	(10)		Row id in temporary 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

Index	Type	Tablespace	Column
I_SNAP$_PJI_AV_ORGO_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00031$ SYS_NC00032$ SYS_NC00033$ SYS_NC00034$ SYS_NC00035$ SYS_NC00036$ SYS_NC00037$
PJI_AV_ORGO_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE EXPENDITURE_ORGANIZATION_ID THRESHOLD

Name	Datatype	Length
CNT	NUMBER
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_ORG_ID	NUMBER	(15)
PERIOD_TYPE_ID	NUMBER	(15)
TIME_ID	NUMBER	(15)
CALENDAR_TYPE	VARCHAR2	(1)
THRESHOLD	NUMBER
AS_OF_DATE	NUMBER
BCKT_1_CS	NUMBER
BCKT_1_CS_CNT	NUMBER
BCKT_2_CS	NUMBER
BCKT_2_CS_CNT	NUMBER
BCKT_3_CS	NUMBER
BCKT_3_CS_CNT	NUMBER
BCKT_4_CS	NUMBER
BCKT_4_CS_CNT	NUMBER
BCKT_5_CS	NUMBER
BCKT_5_CS_CNT	NUMBER
BCKT_1_CM	NUMBER
BCKT_1_CM_CNT	NUMBER
BCKT_2_CM	NUMBER
BCKT_2_CM_CNT	NUMBER
BCKT_3_CM	NUMBER
BCKT_3_CM_CNT	NUMBER
BCKT_4_CM	NUMBER
BCKT_4_CM_CNT	NUMBER
BCKT_5_CM	NUMBER
BCKT_5_CM_CNT	NUMBER
TOTAL_RES_COUNT	NUMBER
TOTAL_RES_COUNT_CNT	NUMBER

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

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that incurred the charges.
EXPENDITURE_ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations of expenditure item.
PERIOD_TYPE_ID	NUMBER	(15)		Period type
TIME_ID	NUMBER	(15)		Identifier of the time.
CALENDAR_TYPE	VARCHAR2	(1)		Calendar type
THRESHOLD	NUMBER			Bucket threshold
AS_OF_DATE	NUMBER			Report date
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Y	Standard who column - user who has created this row.
LAST_UPDATE_DATE	DATE		Y	Standard who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
BCKT_1_CS	NUMBER			Availability consecutive count bucket 1
BCKT_2_CS	NUMBER			Availability consecutive count bucket 2
BCKT_3_CS	NUMBER			Availability consecutive count bucket 3
BCKT_4_CS	NUMBER			Availability consecutive count bucket 4
BCKT_5_CS	NUMBER			Availability consecutive count bucket 5
BCKT_1_CM	NUMBER			Availability cumulative count bucket 1
BCKT_2_CM	NUMBER			Availability cumulative count bucket 2
BCKT_3_CM	NUMBER			Availability cumulative count bucket 3
BCKT_4_CM	NUMBER			Availability cumulative count bucket 4
BCKT_5_CM	NUMBER			Availability cumulative count bucket 5
TOTAL_RES_COUNT	NUMBER			Total resource count

Index	Type	Tablespace	Column
I_SNAP$_PJI_CA_ORGO_F_MV	UNIQUE	APPS_TS_TX_DATA	SYS_NC00013$ SYS_NC00014$ SYS_NC00015$ SYS_NC00016$ SYS_NC00017$ SYS_NC00018$ SYS_NC00019$
PJI_CA_ORGO_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE EXPENDITURE_ORGANIZATION_ID THRESHOLD

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

Name	Datatype	Length	Mandatory	Comments
CLASS_CATEGORY	VARCHAR2	(30)	Y	Implementation-defined name that uniquely identifies the category.
RECORD_TYPE	VARCHAR2	(30)	Y	Type of class category.
NAME	VARCHAR2	(80)		Class category name
LAST_UPDATE_DATE	DATE		Y	Standard who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Y	Standard who column - user who has created this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Index	Type	Tablespace	Column
PJI_CLASS_CODES_U1	UNIQUE	APPS_TS_TX_IDX	CLASS_ID
PJI_CLASS_CODES_N1	NONUNIQUE	APPS_TS_TX_IDX	CLASS_CATEGORY CLASS_CODE

Name	Datatype	Length	Comments
WORKER_ID	NUMBER		Summarization state data
PROJECT_ID	NUMBER		Identifier of the Project
PROJECT_ORG_ID	NUMBER		Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID	NUMBER		Identifier of the Project Organization
CUSTOMER_ID	NUMBER		Identifier of the Customer
GL_TIME_ID	NUMBER		GL transaction date
PA_TIME_ID	NUMBER		PA transaction date
PRJ_REVENUE	NUMBER		Revenue by project currency
PRJ_FUNDING	NUMBER		Funding by project currency
PRJ_INITIAL_FUNDING_AMOUNT	NUMBER		Initial Funding Amount by project currency
PRJ_ADDITIONAL_FUNDING_AMOUNT	NUMBER		Additional Funding Amount by project currency
PRJ_CANCELLED_FUNDING_AMOUNT	NUMBER		Cancelled Funding Amount by project currency
PRJ_FUNDING_ADJUSTMENT_AMOUNT	NUMBER		Funding Adjustment Amount by project currency
PRJ_REVENUE_WRITEOFF	NUMBER		Revenue Writeoff by project currency
PRJ_AR_INVOICE_AMOUNT	NUMBER		AR Invoice Amount by project currency
PRJ_AR_CASH_APPLIED_AMOUNT	NUMBER		AR Cash Applied Amount by project currency
PRJ_AR_INVOICE_WRITEOFF_AMOUNT	NUMBER		AR Invoice Writeoff by project currency
PRJ_AR_CREDIT_MEMO_AMOUNT	NUMBER		AR Credit Memo Amount by project currency
PRJ_UNBILLED_RECEIVABLES	NUMBER		Unbilled Receivables by project currency
PRJ_UNEARNED_REVENUE	NUMBER		Unearned Revenue by project currency
PRJ_AR_UNAPPR_INVOICE_AMOUNT	NUMBER		AR Unapproved Invoice Amount by project currency
PRJ_AR_APPR_INVOICE_AMOUNT	NUMBER		AR Approved Invoice Amount by project currency
PRJ_AR_AMOUNT_DUE	NUMBER		AR Amount Due by project currency
PRJ_AR_AMOUNT_OVERDUE	NUMBER		AR Amount Overdue by project currency
POU_REVENUE	NUMBER		Revenue by project functional currency
POU_FUNDING	NUMBER		Funding by project functional currency
POU_INITIAL_FUNDING_AMOUNT	NUMBER		Initial Funding Amount by project functional currency
POU_ADDITIONAL_FUNDING_AMOUNT	NUMBER		Additional Funding Amount by project functional currency
POU_CANCELLED_FUNDING_AMOUNT	NUMBER		Cancelled Funding Amount by project functional currency
POU_FUNDING_ADJUSTMENT_AMOUNT	NUMBER		Funding Adjustment Amount by project functional currency
POU_REVENUE_WRITEOFF	NUMBER		Revenue Writeoff by project functional currency
POU_AR_INVOICE_AMOUNT	NUMBER		AR Invoice Amount by project functional currency
POU_AR_CASH_APPLIED_AMOUNT	NUMBER		AR Cash Applied Amount by project functional currency
POU_AR_INVOICE_WRITEOFF_AMOUNT	NUMBER		AR Invoice Writeoff by project functional currency
POU_AR_CREDIT_MEMO_AMOUNT	NUMBER		AR Credit Memo Amount by project functional currency
POU_UNBILLED_RECEIVABLES	NUMBER		Unbilled Receivables by project functional currency
POU_UNEARNED_REVENUE	NUMBER		Unearned Revenue by project functional currency
POU_AR_UNAPPR_INVOICE_AMOUNT	NUMBER		AR Unapproved Invoice Amount by project functional currency
POU_AR_APPR_INVOICE_AMOUNT	NUMBER		AR Approved Invoice Amount by project functional currency
POU_AR_AMOUNT_DUE	NUMBER		AR Amount Due by project functional currency
POU_AR_AMOUNT_OVERDUE	NUMBER		AR Amount Overdue by project functional currency
INITIAL_FUNDING_COUNT	NUMBER		Initial Funding Count
ADDITIONAL_FUNDING_COUNT	NUMBER		Additional Funding Count
CANCELLED_FUNDING_COUNT	NUMBER		Cancelled Funding Count
FUNDING_ADJUSTMENT_COUNT	NUMBER		Funding Adjustment Count
AR_INVOICE_COUNT	NUMBER		AR Invoice Count
AR_CASH_APPLIED_COUNT	NUMBER		AR Cash Applied Count
AR_INVOICE_WRITEOFF_COUNT	NUMBER		AR Invoice Writeoff Count
AR_CREDIT_MEMO_COUNT	NUMBER		AR Credit Memo Count
AR_UNAPPR_INVOICE_COUNT	NUMBER		AR Unapproved Invoice Count
AR_APPR_INVOICE_COUNT	NUMBER		AR Approved Invoice Count
AR_COUNT_DUE	NUMBER		AR Count Due
AR_COUNT_OVERDUE	NUMBER		AR Count Overdue
TASK_ID	NUMBER		Identifier of the Task
GL_PERIOD_NAME	VARCHAR2	(15)	GL Period Name
PA_PERIOD_NAME	VARCHAR2	(15)	PA Period Name
TXN_CURRENCY_CODE	VARCHAR2	(30)	Transaction Currency Code
TXN_REVENUE	NUMBER		Revenue by transaction currency
TXN_FUNDING	NUMBER		Funding by transaction currency
TXN_INITIAL_FUNDING_AMOUNT	NUMBER		Initial Funding Amount by transaction currency
TXN_ADDITIONAL_FUNDING_AMOUNT	NUMBER		Additional Funding Amount by transaction currency
TXN_CANCELLED_FUNDING_AMOUNT	NUMBER		Cancelled Funding Amount by transaction currency
TXN_FUNDING_ADJUSTMENT_AMOUNT	NUMBER		Funding Adjustment Amount by transaction currency
TXN_REVENUE_WRITEOFF	NUMBER		Revenue Writeoff by transaction currency
TXN_AR_INVOICE_AMOUNT	NUMBER		AR Invoice Amount by transaction currency
TXN_AR_CASH_APPLIED_AMOUNT	NUMBER		AR Cash Applied Amount by transaction currency
TXN_AR_INVOICE_WRITEOFF_AMOUNT	NUMBER		AR Invoice Writeoff by transaction currency
TXN_AR_CREDIT_MEMO_AMOUNT	NUMBER		AR Credit Memo Amount by transaction currency
TXN_UNBILLED_RECEIVABLES	NUMBER		Unbilled Receivables by transaction currency
TXN_UNEARNED_REVENUE	NUMBER		Unearned Revenue by transaction currency
TXN_AR_UNAPPR_INVOICE_AMOUNT	NUMBER		AR Unapproved Invoice Amount by transaction currency
TXN_AR_APPR_INVOICE_AMOUNT	NUMBER		AR Approved Invoice Amount by transaction currency
TXN_AR_AMOUNT_DUE	NUMBER		AR Amount Due by transaction currency
TXN_AR_AMOUNT_OVERDUE	NUMBER		AR Amount Overdue by transaction currency

Index	Type	Tablespace	Column
PJI_FM_AGGR_FIN7_N1	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID RECORD_TYPE
PJI_FM_AGGR_FIN7_N2	NONUNIQUE	APPS_TS_TX_IDX	TXN_ACCUM_HEADER_ID

Name	Datatype	Length	Mandatory
WORKER_ID	NUMBER		Y
CURRENCY_TYPE	VARCHAR2	(1)
PROJECT_ID	NUMBER		Y
PROJECT_ORG_ID	NUMBER		Y
PROJECT_ORGANIZATION_ID	NUMBER		Y
TIME_PHASED_TYPE_CODE	VARCHAR2	(1)
PERIOD_NAME	VARCHAR2	(20)	Y
START_DATE	DATE		Y
END_DATE	DATE		Y
CURR_BGT_REVENUE	NUMBER
CURR_BGT_RAW_COST	NUMBER
CURR_BGT_BRDN_COST	NUMBER
CURR_BGT_LABOR_HRS	NUMBER
CURR_ORIG_BGT_REVENUE	NUMBER
CURR_ORIG_BGT_RAW_COST	NUMBER
CURR_ORIG_BGT_BRDN_COST	NUMBER
CURR_ORIG_BGT_LABOR_HRS	NUMBER
CURR_FORECAST_REVENUE	NUMBER
CURR_FORECAST_RAW_COST	NUMBER
CURR_FORECAST_BRDN_COST	NUMBER
CURR_FORECAST_LABOR_HRS	NUMBER
CALENDAR_TYPE_CODE	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(30)
TIME_ID	NUMBER	(15)
PROJECT_TYPE_CLASS	VARCHAR2	(1)
CURR_RECORD_TYPE_ID	NUMBER	(15)

Name	Datatype	Length	Mandatory	Comments
EXP_TYPE_CLASS	VARCHAR2	(30)		System linkage function
RESOURCE_CLASS_ID	NUMBER	(15)		Identifier of the Resource Class

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)	Y
WORKER_ID	NUMBER		Y
PROJECT_ID	NUMBER
PROJECT_ORG_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
DRAFT_INVOICE_NUM	NUMBER
CASH_APPLIED_AMOUNT	NUMBER
AMOUNT_OVERDUE_REMAINING	NUMBER
AMOUNT_DUE_REMAINING	NUMBER
MAX_ACTUAL_DATE_CLOSED	DATE
INTER_COMPANY_BILLING_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)
BATCH_ID	NUMBER	(15)

Name	Datatype	Length	Mandatory
LINE_TYPE	VARCHAR2	(4)	Y
CALENDAR_TYPE_CODE	VARCHAR2	(10)	Y
WORKER_ID	NUMBER
BATCH_ID	NUMBER
PROJECT_ID	NUMBER
PROJECT_ORG_ID	NUMBER
PF_CURRENCY_CODE	VARCHAR2	(30)
VERSION_ID	NUMBER
PLAN_TYPE_CODE	VARCHAR2	(30)
CURRENCY_TYPE	VARCHAR2	(1)
PERIOD_ID	NUMBER
PERIOD_NAME	VARCHAR2	(100)
START_DATE	DATE
END_DATE	DATE
REVENUE	NUMBER
RAW_COST	NUMBER
BURDENED_COST	NUMBER
LABOR_HRS	NUMBER
TIME_DANGLING_FLAG	VARCHAR2	(4)
RATE_DANGLING_FLAG	VARCHAR2	(4)
RATE2_DANGLING_FLAG	VARCHAR2	(1)

Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

eTRM - PJI Tables and Views

Table: PJI_AC_AGGR_PJP0

Comments

Columns

Table: PJI_AC_AGGR_PJP1

Comments

Columns

Table: PJI_AC_CLSO_F_MV

Indexes

Columns

Table: PJI_AC_CLS_F_MV

Indexes

Columns

Table: PJI_AC_CUST_PJP0

Comments

Columns

Table: PJI_AC_ORGO_F_MV

Indexes

Columns

Table: PJI_AC_ORG_F_MV

Indexes

Columns

Table: PJI_AC_PROJ_F

Comments

Indexes

Columns

Table: PJI_AC_RMAP_ACR

Comments

Indexes

Columns

Table: PJI_AC_XBS_ACCUM_F

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PJI_AV_ORGO_F_MV

Indexes

Columns

Table: PJI_AV_ORG_F

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PJI_CA_ORGO_F_MV

Indexes

Columns

Table: PJI_CA_ORG_F

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PJI_CLASS_CATEGORIES

Primary Key: PJI_CLASS_CATEGORIES_PK

Foreign Keys to this table:

Comments

Indexes

Columns

Table: PJI_CLASS_CODES

Primary Key: PJI_CLASS_CODES_PK

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PJI_FM_AGGR_ACT1

Comments

Columns

Table: PJI_FM_AGGR_ACT2

Comments

Columns

Table: PJI_FM_AGGR_ACT3

Comments

***** Warning: Oracle Internal Use Only *****

Columns

Table: PJI_FM_AGGR_ACT4

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

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

Name	Datatype	Length
BATCH_MAP_ROWID	ROWID	(10)
PROJECT_ID	NUMBER
COST_BUDGET_C_VERSION	NUMBER
COST_BUDGET_CO_VERSION	NUMBER
REVENUE_BUDGET_C_VERSION	NUMBER
REVENUE_BUDGET_CO_VERSION	NUMBER
COST_FORECAST_C_VERSION	NUMBER
REVENUE_FORECAST_C_VERSION	NUMBER
BATCH_ID	NUMBER	(15)
WORKER_ID	NUMBER	(15)

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

Index	Type	Tablespace	Column
PJI_FM_PROJ_BATCH_MAP_U1	UNIQUE	APPS_TS_INTERFACE	PROJECT_ID
PJI_FM_PROJ_BATCH_MAP_N1	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID PROJECT_ID
PJI_FM_PROJ_BATCH_MAP_N2	NONUNIQUE	APPS_TS_INTERFACE	PLAN_EXTRACTION_STATUS
PJI_FM_PROJ_BATCH_MAP_N3	NONUNIQUE	APPS_TS_INTERFACE	BACKLOG_EXTRACTION_STATUS

Name	Datatype	Length
WORKER_ID	NUMBER
CDL_ROWID	ROWID	(10)
START_DATE	DATE
END_DATE	DATE
PROJECT_ORG_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
PROJECT_TYPE_CLASS	VARCHAR2	(1)
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)
BATCH_ID	NUMBER	(15)

Name	Datatype	Length
WORKER_ID	NUMBER
CRDL_ROWID	ROWID	(10)
PA_DATE	DATE
PA_PERIOD_NAME	VARCHAR2	(15)
GL_DATE	DATE
GL_PERIOD_NAME	VARCHAR2	(15)
PROJECT_ORG_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
LINE_SOURCE_TYPE	VARCHAR2	(1)
BILL_ANOTHER_PROJECT_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
PROJECT_TYPE_CLASS	VARCHAR2	(1)

Name	Datatype	Length	Comments
WORKER_ID	NUMBER
ERDL_ROWID	ROWID	(10)
PROJECT_ORG_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
EXP_EVT_TYPE_ID	NUMBER
EVENT_TYPE	VARCHAR2	(30)
EVENT_NUM	NUMBER
REVENUE_CATEGORY	VARCHAR2	(30)
EVENT_TYPE_CLASSIFICATION	VARCHAR2	(30)
LINE_SOURCE_TYPE	VARCHAR2	(1)
BILL_ANOTHER_PROJECT_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
TXN_DATE	DATE
PA_DATE	DATE
PA_PERIOD_NAME	VARCHAR2	(15)
GL_DATE	DATE
GL_PERIOD_NAME	VARCHAR2	(15)
PROJECT_TYPE_CLASS	VARCHAR2	(1)
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Expenditure Organization Identifier

Name	Datatype	Length
WORKER_ID	NUMBER
MAP_ROWID	ROWID	(10)
PROJECT_ID	NUMBER
FUNDING_MIN_DATE	DATE
FUNDING	NUMBER

Name	Datatype	Length
WORKER_ID	NUMBER
TMP1_ROWID	ROWID	(10)
PSI_ROWID	ROWID	(10)
TXN_ACCUM_HEADER_ID	NUMBER
PERIOD_TYPE	VARCHAR2	(2)

Index	Type	Tablespace	Column
I_SNAP$_PJI_FP_CLSO_ET_F_M	UNIQUE	APPS_TS_TX_DATA	SYS_NC00053$ SYS_NC00054$ SYS_NC00055$ SYS_NC00056$ SYS_NC00057$ SYS_NC00058$ SYS_NC00059$ SYS_NC00060$ SYS_NC00061$
PJI_FP_CLSO_ET_F_MV_N1	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID PROJECT_CLASS_ID CURR_RECORD_TYPE_ID