[Home] [Help] [Dependency Information]
Object Name: | FEM_HIERVAL_CALP_T |
---|---|
Object Type: | TABLE |
Owner: | FEM |
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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_HIERVAL_CALP_T_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
REQUEST_ID
PARENT_ID CHILD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_HIER_T_ROWID | ROWID | (10) | Yes | ROWID of the relationship record from the source HIER_T table |
REQUEST_ID | NUMBER | Yes | Request ID of the master process under which the loader is running | |
PARENT_DEPTH_NUM | NUMBER | Yes | Depth of the parent node to the root node | |
PARENT_ID | NUMBER | Yes | Identifier of the parent member | |
CHILD_DEPTH_NUM | NUMBER | Yes | Depth of the child node to the root node | |
CHILD_ID | NUMBER | Yes | Identifier of the child member | |
DISPLAY_ORDER_NUM | NUMBER | Yes | The relative order that the child is displayed on the user-interface | |
CHILD_DIMENSION_GRP_ID | NUMBER | Yes | Dimension Group of the child member | |
WEIGHTING_PCT | NUMBER | (3) | The percentage for weighting of values received from the immediate parent | |
PARENT_DIMENSION_GRP_ID | NUMBER | Yes | Designates the Level of the Parent member |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_HIER_T_ROWID
, REQUEST_ID
, PARENT_DEPTH_NUM
, PARENT_ID
, CHILD_DEPTH_NUM
, CHILD_ID
, DISPLAY_ORDER_NUM
, CHILD_DIMENSION_GRP_ID
, WEIGHTING_PCT
, PARENT_DIMENSION_GRP_ID
FROM FEM.FEM_HIERVAL_CALP_T;
FEM.FEM_HIERVAL_CALP_T does not reference any database object
FEM.FEM_HIERVAL_CALP_T is referenced by following:
|
|
|