VIEW: APPS.ZPB_BUSAREA_HIERARCHIES_VL

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.VERSION_ID, A.HIERARCHY_ID, A.LOGICAL_DIM_ID, B.DIMENSION_ID, D.MEANING HIERARCHY_TYPE, B.MULTI_TOP_FLAG, C.OBJECT_NAME NAME, C.DESCRIPTION, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN from ZPB_BUSAREA_HIERARCHIES A, FEM_HIERARCHIES B, FEM_OBJECT_CATALOG_VL C, FEM_LOOKUP_VALUES_VL D WHERE A.HIERARCHY_ID = B.HIERARCHY_OBJ_ID and B.HIERARCHY_OBJ_ID = C.OBJECT_ID and B.PERSONAL_FLAG = 'N' and B.GROUP_SEQUENCE_ENFORCED_CODE = D.LOOKUP_CODE and D.LOOKUP_TYPE = 'FEM_GROUP_SEQ_ENFORCED_DSC'

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.VERSION_ID
, A.HIERARCHY_ID
, A.LOGICAL_DIM_ID
, B.DIMENSION_ID
, D.MEANING HIERARCHY_TYPE
, B.MULTI_TOP_FLAG
, C.OBJECT_NAME NAME
, C.DESCRIPTION
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM ZPB_BUSAREA_HIERARCHIES A
, FEM_HIERARCHIES B
, FEM_OBJECT_CATALOG_VL C
, FEM_LOOKUP_VALUES_VL D
WHERE A.HIERARCHY_ID = B.HIERARCHY_OBJ_ID
AND B.HIERARCHY_OBJ_ID = C.OBJECT_ID
AND B.PERSONAL_FLAG = 'N'
AND B.GROUP_SEQUENCE_ENFORCED_CODE = D.LOOKUP_CODE
AND D.LOOKUP_TYPE = 'FEM_GROUP_SEQ_ENFORCED_DSC'