[Home] [Help] [Dependency Information]
Object Name: | PA_CBS_HIERARCHY |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_CBS_HIERARCHY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CBS_STRUCT_LEVEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBS_STRUCT_LEVEL_ID | NUMBER | (15) | Yes | Unique identifier of the CBS structure level. |
CBS_HEADER_ID | NUMBER | (15) | Yes | Unique identifier of the CBS. |
STRUCTURE_LEVEL | NUMBER | (15) | Yes | Structure Level of the corresponding cost category added to the CBS. |
COST_CATEGORY | VARCHAR2 | (1000) | Yes | Accepted Cost category for the corresponding level of that CBS structure. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
CREATION_DATE | DATE | Yes | Standard Who Column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column. |
RECORD_VERSION_NUMBER | NUMBER | (15) | Yes | Apps Standard for locking from HTML. |
MEANING | VARCHAR2 | (240) | ||
DESCRIPTION#1 | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT CBS_STRUCT_LEVEL_ID
, CBS_HEADER_ID
, STRUCTURE_LEVEL
, COST_CATEGORY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RECORD_VERSION_NUMBER
, MEANING
, DESCRIPTION#1
FROM PA.PA_CBS_HIERARCHY;
PA.PA_CBS_HIERARCHY does not reference any database object
PA.PA_CBS_HIERARCHY is referenced by following:
|
|
|