DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FEM_BR_DIS_MBR_CXT_REP_V

Object Details
Object Name: FEM_BR_DIS_MBR_CXT_REP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Information on business rules that contain references to disabled dimension presented in a hierarchical reporting format


[View Source]

Columns
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
REPORT_ROW_ID NUMBER
Yes System generated ID to uniquely reference a row in this table
PARENT_REPORT_ROW_ID NUMBER

Row ID of the parent component that references the object that the current row represents
OBJECT_ID NUMBER (9) Yes Rule ID
OBJECT_NAME VARCHAR2 (150) Yes Rule name
OBJECT_TYPE_CODE VARCHAR2 (30) Yes Rule type code
OBJECT_TYPE_NAME VARCHAR2 (150) Yes Rule type name
FOLDER_ID NUMBER (9) Yes Folder ID
FOLDER_NAME VARCHAR2 (150) Yes Folder name
OBJECT_DEFINITION_ID NUMBER (9) Yes Rule version ID
OBJECT_DEFINITION_NAME VARCHAR2 (150) Yes Rule version name
EFFECTIVE_START_DATE DATE
Yes Effective start date of the rule version
EFFECTIVE_END_DATE DATE
Yes Effective end date of the rule version
CONTEXT VARCHAR2 (80)
Provides the context within the rule version that contains the reference to the disabled dimension member.
DIMENSION_ID NUMBER (9)
Dimension ID
DIMENSION_NAME VARCHAR2 (150)
Dimension name
DIMENSION_MEMBER VARCHAR2 (40)
Dimension member identifier
DIMENSION_MEMBER_DC VARCHAR2 (150)
Dimension member display code
DIMENSION_MEMBER_NAME VARCHAR2 (150)
Dimension member name
VALUE_SET_ID NUMBER

Value set ID of the dimension member
VALUE_SET_NAME VARCHAR2 (150)
Value set name of the dimension member
HIERARCHICAL_COLUMN VARCHAR2 (4000)
Either the Rule Type name or Context information that contains embedded indentation to show parent/child relationships between one row and the next.
Query Text

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
,      REPORT_ROW_ID
,      PARENT_REPORT_ROW_ID
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_TYPE_CODE
,      OBJECT_TYPE_NAME
,      FOLDER_ID
,      FOLDER_NAME
,      OBJECT_DEFINITION_ID
,      OBJECT_DEFINITION_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CONTEXT
,      DIMENSION_ID
,      DIMENSION_NAME
,      DIMENSION_MEMBER
,      DIMENSION_MEMBER_DC
,      DIMENSION_MEMBER_NAME
,      VALUE_SET_ID
,      VALUE_SET_NAME
,      HIERARCHICAL_COLUMN
FROM APPS.FEM_BR_DIS_MBR_CXT_REP_V;

Dependencies

[top of page]

APPS.FEM_BR_DIS_MBR_CXT_REP_V references the following:

SchemaAPPS
SynonymFEM_BR_DIS_MBR_CONTEXTS
SynonymFEM_BR_DIS_MBR_REQUESTS

APPS.FEM_BR_DIS_MBR_CXT_REP_V is not referenced by any database object