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

TABLE: PJI.PJI_PJP_RBS_HEADER

Object Details
Object Name: PJI_PJP_RBS_HEADER
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_PJP_RBS_HEADER
Subobject Name:
Status: VALID


This table tracks associations between project, plan and Resource Breakdown Structures


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_PJP_RBS_HEADER_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_VERSION_ID
ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
Identifier for project
PLAN_VERSION_ID NUMBER (15)
Identifier for plan version
RBS_VERSION_ID NUMBER (15)
Identifier for RBS structure version
REPORTING_USAGE_FLAG VARCHAR2 (1)
Flag that indicates the default RBS to be shown in project performance reports
PROG_REP_USAGE_FLAG VARCHAR2 (1)
Flag that indicates if the RBS is used for program reporting or not
PLAN_USAGE_FLAG VARCHAR2 (1)
Flag that indicates the default RBS for View (Work/Financial) plan pages
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 PROJECT_ID
,      PLAN_VERSION_ID
,      RBS_VERSION_ID
,      REPORTING_USAGE_FLAG
,      PROG_REP_USAGE_FLAG
,      PLAN_USAGE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_TYPE_CODE
FROM PJI.PJI_PJP_RBS_HEADER;

Dependencies

[top of page]

PJI.PJI_PJP_RBS_HEADER does not reference any database object

PJI.PJI_PJP_RBS_HEADER is referenced by following:

SchemaPJI
ViewPJI_PJP_RBS_HEADER#