VIEW: APPS.FEM_BR_DIS_MBR_CXT_REP_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, LPAD(' ', 5*LEVEL-1)||nvl(C.context,C.object_type_name) RULE_TYPE_OR_CONTEXT FROM FEM_BR_DIS_MBR_REQUESTS R, FEM_BR_DIS_MBR_CONTEXTS C WHERE R.REQUEST_ID = C.REQUEST_ID START WITH C.parent_report_row_id IS NULL CONNECT BY PRIOR C.report_row_id = C.parent_report_row_id AND PRIOR C.request_id = C.request_id ORDER SIBLINGS BY C.request_id, C.object_name

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
, LPAD(' '
, 5*LEVEL-1)||NVL(C.CONTEXT
, C.OBJECT_TYPE_NAME) RULE_TYPE_OR_CONTEXT
FROM FEM_BR_DIS_MBR_REQUESTS R
, FEM_BR_DIS_MBR_CONTEXTS C
WHERE R.REQUEST_ID = C.REQUEST_ID START WITH C.PARENT_REPORT_ROW_ID IS NULL CONNECT BY PRIOR C.REPORT_ROW_ID = C.PARENT_REPORT_ROW_ID
AND PRIOR C.REQUEST_ID = C.REQUEST_ID ORDER SIBLINGS BY C.REQUEST_ID
, C.OBJECT_NAME