[Home] [Help] [Dependency Information]
Object Name: | FEM_BR_DIS_MBR_HIER_REP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Information on flattened Hierarchy rules that contain references to disabled dimension presented in a manner to allow hierarchical reporting, including runtime parameters
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | Unique ID to differentiate each execution of the "Check Mapping Rules for Disabled Dimension Members" Concurrent Program. This is the same number as the concurrent request ID. |
REQUEST_DATE | DATE | Yes | Execution date of the concurrent program | |
REQUEST_NAME | VARCHAR2 | (100) | Yes | Execution name given for each execution for the concurrent program |
PARAM_OBJECT_TYPE_CODE | VARCHAR2 | (30) | Yes | Rule type code parameter |
PARAM_OBJECT_TYPE_NAME | VARCHAR2 | (150) | Yes | Rule type name parameter |
PARAM_LEDGER_ID | NUMBER | Yes | Ledger ID parameter | |
PARAM_LEDGER_NAME | VARCHAR2 | (150) | Yes | Ledger name parameter |
PARAM_EFFECTIVE_DATE | DATE | Yes | Effective date parameter | |
PARAM_OBJECT_ID | NUMBER | (9) | Rule ID parameter | |
PARAM_OBJECT_NAME | VARCHAR2 | (150) | Rule name parameter | |
PARAM_FOLDER_ID | NUMBER | (9) | Folder ID parameter | |
PARAM_FOLDER_NAME | VARCHAR2 | (150) | Folder name parameter | |
PARAM_DIMENSION_ID | NUMBER | Dimension ID parameter | ||
PARAM_DIMENSION_NAME | VARCHAR2 | (150) | Dimension name parameter | |
HIERARCHY_OBJECT_ID | NUMBER | (9) | Yes | Hierarchy rule ID |
HIERARCHY_OBJECT_NAME | VARCHAR2 | (150) | Yes | Hierarchy rule name |
HIERARCHY_OBJ_DEF_ID | NUMBER | (9) | Yes | Hierarchy rule version ID |
HIERARCHY_OBJ_DEF_NAME | VARCHAR2 | (150) | Yes | Hierarchy rule version name |
PARENT_MEMBER_ID | NUMBER | Yes | ID of the parent node | |
PARENT_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Display code of the parent node |
PARENT_NAME | VARCHAR2 | (150) | Yes | Parent node name |
PARENT_VALUE_SET_ID | NUMBER | ID of the Value Set in which the parent node resides | ||
PARENT_VALUE_SET_NAME | VARCHAR2 | (150) | Name of the Value Set in which the parent node resides | |
CHILD_MEMBER_ID | NUMBER | Yes | ID of the child node | |
CHILD_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Display code of the child node |
CHILD_NAME | VARCHAR2 | (150) | Yes | Child node name |
CHILD_VALUE_SET_ID | NUMBER | ID of the Value Set in which the child node resides | ||
CHILD_VALUE_SET_NAME | VARCHAR2 | (150) | Name of the Value Set in which the child node resides | |
DISABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates if the node is a disabled dimension member |
HIERARCHICAL_COLUMN | VARCHAR2 | (4000) | Dimension name with embedded indentation to show parent/child relationships between one row and the next. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, REQUEST_DATE
, REQUEST_NAME
, PARAM_OBJECT_TYPE_CODE
, PARAM_OBJECT_TYPE_NAME
, PARAM_LEDGER_ID
, PARAM_LEDGER_NAME
, PARAM_EFFECTIVE_DATE
, PARAM_OBJECT_ID
, PARAM_OBJECT_NAME
, PARAM_FOLDER_ID
, PARAM_FOLDER_NAME
, PARAM_DIMENSION_ID
, PARAM_DIMENSION_NAME
, HIERARCHY_OBJECT_ID
, HIERARCHY_OBJECT_NAME
, HIERARCHY_OBJ_DEF_ID
, HIERARCHY_OBJ_DEF_NAME
, PARENT_MEMBER_ID
, PARENT_DISPLAY_CODE
, PARENT_NAME
, PARENT_VALUE_SET_ID
, PARENT_VALUE_SET_NAME
, CHILD_MEMBER_ID
, CHILD_DISPLAY_CODE
, CHILD_NAME
, CHILD_VALUE_SET_ID
, CHILD_VALUE_SET_NAME
, DISABLED_FLAG
, HIERARCHICAL_COLUMN
FROM APPS.FEM_BR_DIS_MBR_HIER_REP_V;
APPS.FEM_BR_DIS_MBR_HIER_REP_V is not referenced by any database object
|
|
|