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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PJI.PJI_ROLLUP_LEVEL_STATUS

Object Details

Object Name:	PJI_ROLLUP_LEVEL_STATUS
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_ROLLUP_LEVEL_STATUS
Subobject Name:
Status:	VALID

This table indicates if the resource rollup slices by the resource breakdown structure are created or not for a project and a plan

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_ROLLUP_LEVEL_STATUS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_VERSION_ID RBS_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RBS_VERSION_ID	NUMBER	(15)		RBS Structure Version Identifier
PLAN_VERSION_ID	NUMBER	(15)	Yes	Plan Version Identifier
WBS_ELEMENT_ID	NUMBER	(15)	Yes	WBS Element Identifier
RBS_AGGR_LEVEL	VARCHAR2	(1)	Yes	L - Lowest, T - Top, R - Rollup
WBS_ROLLUP_FLAG	VARCHAR2	(1)	Yes	Flag that indicates that node contains data summarized by WBS hieararchy
PRG_ROLLUP_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if project is a program (N, Y)
CURR_RECORD_TYPE_ID	NUMBER	(15)	Yes	Currency Record Type Identifier
CALENDAR_TYPE	VARCHAR2	(1)	Yes	Calendar Type Identifier
PROJECT_ID	NUMBER	(15)		Project Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Columns
CREATION_DATE	DATE		Yes	Standard Who Columns
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Columns
PLAN_TYPE_CODE	VARCHAR2	(1)		This indicates the type of plan version. Valid values are C-Cost Only , R-Revenue Only ,A-Cost and Revenue same/Actuals

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RBS_VERSION_ID
,      PLAN_VERSION_ID
,      WBS_ELEMENT_ID
,      RBS_AGGR_LEVEL
,      WBS_ROLLUP_FLAG
,      PRG_ROLLUP_FLAG
,      CURR_RECORD_TYPE_ID
,      CALENDAR_TYPE
,      PROJECT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_TYPE_CODE
FROM PJI.PJI_ROLLUP_LEVEL_STATUS;

Dependencies

[top of page]

PJI.PJI_ROLLUP_LEVEL_STATUS does not reference any database object

PJI.PJI_ROLLUP_LEVEL_STATUS is referenced by following:

PJI: PJI_ROLLUP_LEVEL_STATUS#