VIEW: APPS.FEM_BR_DIS_MBR_HIER_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,H.HIERARCHY_OBJECT_ID,H.HIERARCHY_OBJECT_NAME,H.HIERARCHY_OBJ_DEF_ID,H.HIERARCHY_OBJ_DEF_NAME,H.PARENT_MEMBER_ID,H.PARENT_DISPLAY_CODE,H.PARENT_NAME,H.PARENT_VALUE_SET_ID,H.PARENT_VALUE_SET_NAME,H.CHILD_MEMBER_ID,H.CHILD_DISPLAY_CODE,H.CHILD_NAME,H.CHILD_VALUE_SET_ID,H.CHILD_VALUE_SET_NAME,H.DISABLED_FLAG FROM FEM_BR_DIS_MBR_REQUESTS R,FEM_BR_DIS_MBR_HIER H WHERE R.REQUEST_ID = H.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
, H.HIERARCHY_OBJECT_ID
, H.HIERARCHY_OBJECT_NAME
, H.HIERARCHY_OBJ_DEF_ID
, H.HIERARCHY_OBJ_DEF_NAME
, H.PARENT_MEMBER_ID
, H.PARENT_DISPLAY_CODE
, H.PARENT_NAME
, H.PARENT_VALUE_SET_ID
, H.PARENT_VALUE_SET_NAME
, H.CHILD_MEMBER_ID
, H.CHILD_DISPLAY_CODE
, H.CHILD_NAME
, H.CHILD_VALUE_SET_ID
, H.CHILD_VALUE_SET_NAME
, H.DISABLED_FLAG
FROM FEM_BR_DIS_MBR_REQUESTS R
, FEM_BR_DIS_MBR_HIER H
WHERE R.REQUEST_ID = H.REQUEST_ID