VIEW: APPS.FEM_BR_DIS_MBR_CONTEXTS_V

Source

View Text - Preformatted

SELECT R.REQUEST_ID,R.REQUEST_DATE,R.REQUEST_NAME,R.OBJECT_TYPE_CODE,R.OBJECT_TYPE_NAME,R.LEDGER_ID,R.LEDGER_NAME,R.EFFECTIVE_DATE,R.OBJECT_ID,R.OBJECT_NAME,R.FOLDER_ID,R.FOLDER_NAME,R.DIMENSION_ID,R.DIMENSION_NAME,C.REPORT_ROW_ID,C.PARENT_REPORT_ROW_ID,C.OBJECT_ID,C.OBJECT_NAME,C.OBJECT_TYPE_CODE,C.OBJECT_TYPE_NAME,C.FOLDER_ID,C.FOLDER_NAME,C.OBJECT_DEFINITION_ID,C.OBJECT_DEFINITION_NAME,C.EFFECTIVE_START_DATE,C.EFFECTIVE_END_DATE,C.CONTEXT,C.DIMENSION_ID,C.DIMENSION_NAME,C.DIMENSION_MEMBER,C.DIMENSION_MEMBER_DC,C.DIMENSION_MEMBER_NAME,C.VALUE_SET_ID,C.VALUE_SET_NAME FROM FEM_BR_DIS_MBR_REQUESTS R,FEM_BR_DIS_MBR_CONTEXTS C WHERE R.REQUEST_ID = C.REQUEST_ID

View Text - HTML Formatted

SELECT R.REQUEST_ID
, R.REQUEST_DATE
, R.REQUEST_NAME
, R.OBJECT_TYPE_CODE
, R.OBJECT_TYPE_NAME
, R.LEDGER_ID
, R.LEDGER_NAME
, R.EFFECTIVE_DATE
, R.OBJECT_ID
, R.OBJECT_NAME
, R.FOLDER_ID
, R.FOLDER_NAME
, R.DIMENSION_ID
, R.DIMENSION_NAME
, C.REPORT_ROW_ID
, C.PARENT_REPORT_ROW_ID
, C.OBJECT_ID
, C.OBJECT_NAME
, C.OBJECT_TYPE_CODE
, C.OBJECT_TYPE_NAME
, C.FOLDER_ID
, C.FOLDER_NAME
, C.OBJECT_DEFINITION_ID
, C.OBJECT_DEFINITION_NAME
, C.EFFECTIVE_START_DATE
, C.EFFECTIVE_END_DATE
, C.CONTEXT
, C.DIMENSION_ID
, C.DIMENSION_NAME
, C.DIMENSION_MEMBER
, C.DIMENSION_MEMBER_DC
, C.DIMENSION_MEMBER_NAME
, C.VALUE_SET_ID
, C.VALUE_SET_NAME
FROM FEM_BR_DIS_MBR_REQUESTS R
, FEM_BR_DIS_MBR_CONTEXTS C
WHERE R.REQUEST_ID = C.REQUEST_ID