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

VIEW: APPS.FEM_BR_DIS_MBR_CONTEXTS_V

Object Details
Object Name: FEM_BR_DIS_MBR_CONTEXTS_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 manner to allow hierarchical reporting, including runtime parameters


[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
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
FROM APPS.FEM_BR_DIS_MBR_CONTEXTS_V;

Dependencies

[top of page]

APPS.FEM_BR_DIS_MBR_CONTEXTS_V references the following:

SchemaAPPS
SynonymFEM_BR_DIS_MBR_CONTEXTS
SynonymFEM_BR_DIS_MBR_REQUESTS

APPS.FEM_BR_DIS_MBR_CONTEXTS_V is not referenced by any database object