[Home] [Help] [Dependency Information]
Object Name: | PJI_REP_XBS_DENORM |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_REP_XBS_DENORM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_REP_XBS_DENORM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUP_PROJECT_ID
PARENT_ELEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | Yes | Project Identifier | |
PARENT_ELEMENT_ID | NUMBER | Yes | Parent Element Identifier | |
CHILD_ELEMENT_ID | NUMBER | Yes | Child Element Identifier | |
PRG_FLAG | VARCHAR2 | (1) | Yes | Program Flag |
NAME | VARCHAR2 | (240) | Yes | Element Name |
ROLLUP_FLAG | VARCHAR2 | (1) | Yes | Rollup Flag |
DISPLAY_CHILD_FLAG | VARCHAR2 | (1) | Yes | Display Child Nodes Indicator |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
SUP_PROJECT_ID | NUMBER | (15) | Yes | Project / Program Identifier |
PRG_ROLLUP_FLAG | VARCHAR2 | (1) | Yes | Project / Program Rollup Flag |
COMPLETED_PERCENTAGE | NUMBER | Completed Percent | ||
WBS_VERSION_ID | NUMBER | (15) | Yes | WBS Version ID |
DISPLAY_SEQUENCE | NUMBER | The display sequence of tasks | ||
RELATIONSHIP_TYPE | VARCHAR2 | (2) | ||
OWNER_WBS_VERSION_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PARENT_ELEMENT_ID
, CHILD_ELEMENT_ID
, PRG_FLAG
, NAME
, ROLLUP_FLAG
, DISPLAY_CHILD_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, SUP_PROJECT_ID
, PRG_ROLLUP_FLAG
, COMPLETED_PERCENTAGE
, WBS_VERSION_ID
, DISPLAY_SEQUENCE
, RELATIONSHIP_TYPE
, OWNER_WBS_VERSION_ID
FROM PJI.PJI_REP_XBS_DENORM;
PJI.PJI_REP_XBS_DENORM does not reference any database object
PJI.PJI_REP_XBS_DENORM is referenced by following:
|
|
|