[Home] [Help] [Dependency Information]
Object Name: | PJI_RBS_DENORM |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_RBS_DENORM |
Subobject Name: | |
Status: | VALID |
This table stores normalized resource breakdown structure information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_RBS_DENORM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
STRUCT_VERSION_ID
SUP_ID SUB_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STRUCT_VERSION_ID | NUMBER | (15) | Yes | Identifier for RBS structure version |
SUP_ID | NUMBER | (15) | Yes | Parent RBS version/element identifier |
SUBRO_ID | NUMBER | (15) | Immediate Child Identifier | |
SUB_ID | NUMBER | (15) | Yes | Child RBS version/element identifier |
SUP_LEVEL | NUMBER | (15) | Yes | Parent Level |
SUB_LEVEL | NUMBER | (15) | Yes | Child Level |
SUB_LEAF_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the current parent has any children who are leaf nodes. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT STRUCT_VERSION_ID
, SUP_ID
, SUBRO_ID
, SUB_ID
, SUP_LEVEL
, SUB_LEVEL
, SUB_LEAF_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PJI.PJI_RBS_DENORM;
PJI.PJI_RBS_DENORM does not reference any database object
PJI.PJI_RBS_DENORM is referenced by following:
|
|
|