VIEW: APPS.ZPB_BUSAREA_DIMENSIONS_VL

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.VERSION_ID, A.DIMENSION_ID, A.LOGICAL_DIM_ID, A.FUNC_DIM_SET_ID, A.AW_DIM_NAME, A.AW_DIM_PREFIX, C.MEANING DIMENSION_TYPE, E.DIMENSION_TYPE_CODE, DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99', B.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) NAME, B.DESCRIPTION, A.DEFAULT_MEMBER_ID, A.DEFAULT_MEMBER_VSET, ZPB_FEM_UTILS_PKG.GET_MEMBER_NAME (A.DIMENSION_ID, A.DEFAULT_MEMBER_ID, A.DEFAULT_MEMBER_VSET) DEFAULT_MEMBER_NAME, ZPB_FEM_UTILS_PKG.GET_MEMBER_DESC (A.DIMENSION_ID, A.DEFAULT_MEMBER_ID, A.DEFAULT_MEMBER_VSET) DEFAULT_MEMBER_DESC, A.DEFAULT_HIERARCHY_ID, D.OBJECT_NAME DEFAULT_HIERARCHY_NAME, A.EPB_LINE_DIMENSION, A.LINE_HIERARCHY, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN from ZPB_BUSAREA_DIMENSIONS A, FEM_DIMENSIONS_VL B, FND_LOOKUP_VALUES_VL C, FEM_OBJECT_CATALOG_VL D, FEM_XDIM_DIMENSIONS E, FEM_FUNC_DIM_SETS_VL FDR WHERE A.DIMENSION_ID = B.DIMENSION_ID and A.DIMENSION_ID = E.DIMENSION_ID and E.DIMENSION_TYPE_CODE = C.LOOKUP_CODE and C.LOOKUP_TYPE = 'FEM_DIMENSION_TYPE_DSC' and A.DEFAULT_HIERARCHY_ID = D.OBJECT_ID(+)

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.VERSION_ID
, A.DIMENSION_ID
, A.LOGICAL_DIM_ID
, A.FUNC_DIM_SET_ID
, A.AW_DIM_NAME
, A.AW_DIM_PREFIX
, C.MEANING DIMENSION_TYPE
, E.DIMENSION_TYPE_CODE
, DECODE(NVL(FDR.FUNC_DIM_SET_NAME
, '-99')
, '-99'
, B.DIMENSION_NAME
, FDR.FUNC_DIM_SET_NAME) NAME
, B.DESCRIPTION
, A.DEFAULT_MEMBER_ID
, A.DEFAULT_MEMBER_VSET
, ZPB_FEM_UTILS_PKG.GET_MEMBER_NAME (A.DIMENSION_ID
, A.DEFAULT_MEMBER_ID
, A.DEFAULT_MEMBER_VSET) DEFAULT_MEMBER_NAME
, ZPB_FEM_UTILS_PKG.GET_MEMBER_DESC (A.DIMENSION_ID
, A.DEFAULT_MEMBER_ID
, A.DEFAULT_MEMBER_VSET) DEFAULT_MEMBER_DESC
, A.DEFAULT_HIERARCHY_ID
, D.OBJECT_NAME DEFAULT_HIERARCHY_NAME
, A.EPB_LINE_DIMENSION
, A.LINE_HIERARCHY
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM ZPB_BUSAREA_DIMENSIONS A
, FEM_DIMENSIONS_VL B
, FND_LOOKUP_VALUES_VL C
, FEM_OBJECT_CATALOG_VL D
, FEM_XDIM_DIMENSIONS E
, FEM_FUNC_DIM_SETS_VL FDR
WHERE A.DIMENSION_ID = B.DIMENSION_ID
AND A.DIMENSION_ID = E.DIMENSION_ID
AND E.DIMENSION_TYPE_CODE = C.LOOKUP_CODE
AND C.LOOKUP_TYPE = 'FEM_DIMENSION_TYPE_DSC'
AND A.DEFAULT_HIERARCHY_ID = D.OBJECT_ID(+)