PJI Views (70)

PJI - Project Intelligence(Obsolete) — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`PJI_ACCUM_RL_ACT_V`
`PJI_ACCUM_WBS_ACT_V`
`PJI_ACT_CMT_BY_PERIOD_V`	PJI_ACT_CMT_BY_PERIOD_V is a view that displays actual cost, revenue totals, and commitment for lowest level tasks and resources by PA, and
`PJI_AC_ACT_CMT_BY_RSRC_V`	This view displays actual costs, revenue, and commitments for PA and GL periods by task and resources. The view is used by external project
`PJI_AC_ACT_CMT_BY_TASK_V`	This view displays actual costs, revenue, and commitments for PA and GL periods by task. The view is used by external project management sys
`PJI_AC_PLN_BY_RSRC_V`	This view displays budgeted cost and revenue for PA and GL periods by task and resources. The view is used by external project management sy
`PJI_AC_PLN_BY_TASK_V`	This view displays budgeted cost and revenue for PA and GL periods by task. The view is used by external project management systems that imp
`PJI_AC_XBS_ACCUM_F_V`	This view stores Project Intelligence numbers for activity data at the project level
`PJI_AVL_DAYS_V`	This is an internal summarization view.
`PJI_AVL_THRESHOLDS_V`	This is an internal summarization view.
`PJI_AVL_TYPES_V`	This is an internal summarization view.
`PJI_CLASS_CATEGORIES_V`	This is an internal summarization view.
`PJI_CLASS_CODES_V`	This is an internal summarization view.
`PJI_CURRENCY_TYPES_V`	This is an internal summarization view.
`PJI_DEFAULT_PERIOD_SETTINGS_V`	This is an internal summarization view.
`PJI_DIS_MGRRES_V`	Discoverer view of manager resource utilization data.
`PJI_DIS_MGRWT_V`	Discoverer view of manager work type utilization data.
`PJI_DIS_ORGJOB_V`	Discoverer view of organization job utilization data.
`PJI_DIS_ORGRES_V`	Discoverer view of organization resource utilization data.
`PJI_DIS_ORGWT_V`	Discoverer view of organization work type utilization data.
`PJI_DIS_ORG_HRCHY_V`	Discoverer view of organization hierarchy data.
`PJI_DIS_ORG_ROHRCHY_V`	Discoverer view of organization hierarchy data with subordinate rollup data.
`PJI_DIS_ORG_V`	Discoverer view of organization utilization data.
`PJI_DIS_PERSON_V`	Discoverer view of resource utilization data.
`PJI_DIS_RESWT_V`	Discoverer view of resource work type utilization data.
`PJI_DIS_SEC_ORGZ_V`	Discoverer view of organizations viewable by the current user.
`PJI_DIS_SEC_ORG_V`	Discoverer view of operating units viewable by the currency user.
`PJI_DIS_SUP_HRCHY_V`	Discoverer view of resource hierarchy data.
`PJI_DIS_SUP_ROHRCHY_V`	Discoverer view of resource hierarchy data with subordinate rollup data.
`PJI_DIS_WORK_TYPES_V`	Discoverer view of work type data.
`PJI_EXP_CATEGORIES_V`	This is an internal summarization view.
`PJI_EXP_EVT_TYPES_V`	This is an internal summarization view.
`PJI_EXP_TYPES_V`	This is an internal summarization view.
`PJI_FP_XBS_ACCUM_F_V`	This table stores project reporting data
`PJI_JOBS_V`	This is an internal summarization view.
`PJI_JOB_LEVELS_V`	This is an internal summarization view.
`PJI_LOOKUPS`	This view contains constant values that are displayed to users and can be translated.
`PJI_MT_MEASURES_V`
`PJI_MT_MEASURES_VL`	This table stores the definition of the measures used for reporting in oracle projects
`PJI_MT_MEASURE_SETS_VL`	This table stores information about measure sets used for reporting in Oracle Projects
`PJI_MT_ROWSET_VL`	This table stores the measures defined for a row set
`PJI_OPERATING_UNITS_V`	This is an internal summarization view.
`PJI_ORGANIZATIONS_V`	This is an internal summarization view.
`PJI_PERIOD_TYPES_V`	This is an internal summarization view.
`PJI_PRD_ACT_CMT_BY_RSRC_V`	PJI_PRD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PA, and GL periods by task, and resources. The view is main
`PJI_PRD_ACT_CMT_BY_TASK_V`	PJI_PRD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task. The view is m
`PJI_PRD_ACT_CMT_PG_TASK_V`	PJI_PRD_ACT_CMT_PG_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task at Program Lev
`PJI_PRD_PLN_BY_RSRC_V`	This new PSI view is to provide PSI functionality using new summarization model.Full Description :PJI_PRD_PLN_BY_RSRC_V is a view that displ
`PJI_PRD_PLN_BY_TASK_V`	PJI_PRD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PA, and GL periods by task. The view is mainly used by exte
`PJI_PROJECTS_V`	This is an internal summarization view.
`PJI_REVENUE_CATEGORIES_V`	This is an internal summarization view.
`PJI_TIME_CAL_PERIOD_V`	This table stores period definition for fiscal calendar
`PJI_TIME_CAL_QTR_V`	This table stores quarter definition for fiscal calendar
`PJI_TIME_CAL_RPT_STRUCT_V`	This table stores fiscal time dimension information in a special format required for project performance reports
`PJI_TIME_CAL_YEAR_V`	This table stores year definition for fiscal calendar
`PJI_TIME_ENT_PERIOD_V`	This table stores period definition for enterprise calendar
`PJI_TIME_ENT_QTR_V`	This table stores quarter definition for enterprise calendar
`PJI_TIME_ENT_YEAR_V`	This table stores year definition for enterprise calendar
`PJI_TIME_PA_PERIOD_V`	View of Project Accounting periods.
`PJI_TIME_RPT_STRUCT_V`	This table stores enterprise time dimension information in a special format required for project performance reports
`PJI_TIME_WEEK_V`	This table stores week definition for enterprise calendar
`PJI_UTIL_CATEGORIES_V`	This is an internal summarization view.
`PJI_WORK_TYPES_V`	This is an internal summarization view.
`PJI_XBS_PLANS_PRJ_V`
`PJI_XBS_PLANS_V`
`PJI_XTD_ACT_CMT_BY_RSRC_V`	PJI_XTD_ACT_CMT_BY_RSRC_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task, and resou
`PJI_XTD_ACT_CMT_BY_TASK_V`	PJI_XTD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task. The view
`PJI_XTD_PLN_BY_RSRC_V`	PJI_XTD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task, and resource. The view is m
`PJI_XTD_PLN_BY_TASK_V`	PJI_XTD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task. The view is mainly used by
`PJI_YES_NO_V`	View of lookup values for Yes No lists of values.