[Home] [Help] [Dependency Information]
Object Name: | PJI_PJP_RBS_HEADER |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_PJP_RBS_HEADER |
Subobject Name: | |
Status: | VALID |
This table tracks associations between project, plan and Resource Breakdown Structures
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 0 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_PJP_RBS_HEADER_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_VERSION_ID
PROJECT_ID |
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 |
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;
PJI.PJI_PJP_RBS_HEADER does not reference any database object
PJI.PJI_PJP_RBS_HEADER is referenced by following:
|
|
|