VIEW: APPS.MSD_HIERARCHY_LEVELS_V

Source

View Text - Preformatted

SELECT mhl.ROWID, mhl.HIERARCHY_ID, mhv.HIERARCHY_NAME, mhl.LEVEL_ID, mlv1.LEVEL_NAME, mlv1.LEVEL_TYPE_CODE, mlv1.LEVEL_TYPE, mhl.PARENT_LEVEL_ID, mlv2.LEVEL_NAME, mlv2.LEVEL_TYPE_CODE, mlv2.LEVEL_TYPE, mhv.OWNING_DIMENSION_CODE, mhv.OWNING_DIMENSION, mhl.RELATIONSHIP_VIEW, mhl.LEVEL_VALUE_COLUMN, mhl.LEVEL_VALUE_PK_COLUMN, mhl.LEVEL_VALUE_DESC_COLUMN, mhl.PARENT_VALUE_COLUMN, mhl.PARENT_VALUE_PK_COLUMN, mhl.PARENT_VALUE_DESC_COLUMN, mhl.LAST_UPDATE_DATE, mhl.LAST_UPDATED_BY, mhl.CREATION_DATE, mhl.CREATED_BY, mhl.LAST_UPDATE_LOGIN, mhl.REQUEST_ID, mhl.PROGRAM_APPLICATION_ID, mhl.PROGRAM_ID, mhl.PROGRAM_UPDATE_DATE from msd_levels_v mlv1, msd_levels_v mlv2, msd_hierarchies_v mhv, msd_hierarchy_levels mhl WHERE mlv1.level_id = mhl.level_id and mlv2.level_id = mhl.parent_level_id and mhv.hierarchy_id = mhl.hierarchy_id and mhl.plan_type is NULL

View Text - HTML Formatted

SELECT MHL.ROWID
, MHL.HIERARCHY_ID
, MHV.HIERARCHY_NAME
, MHL.LEVEL_ID
, MLV1.LEVEL_NAME
, MLV1.LEVEL_TYPE_CODE
, MLV1.LEVEL_TYPE
, MHL.PARENT_LEVEL_ID
, MLV2.LEVEL_NAME
, MLV2.LEVEL_TYPE_CODE
, MLV2.LEVEL_TYPE
, MHV.OWNING_DIMENSION_CODE
, MHV.OWNING_DIMENSION
, MHL.RELATIONSHIP_VIEW
, MHL.LEVEL_VALUE_COLUMN
, MHL.LEVEL_VALUE_PK_COLUMN
, MHL.LEVEL_VALUE_DESC_COLUMN
, MHL.PARENT_VALUE_COLUMN
, MHL.PARENT_VALUE_PK_COLUMN
, MHL.PARENT_VALUE_DESC_COLUMN
, MHL.LAST_UPDATE_DATE
, MHL.LAST_UPDATED_BY
, MHL.CREATION_DATE
, MHL.CREATED_BY
, MHL.LAST_UPDATE_LOGIN
, MHL.REQUEST_ID
, MHL.PROGRAM_APPLICATION_ID
, MHL.PROGRAM_ID
, MHL.PROGRAM_UPDATE_DATE
FROM MSD_LEVELS_V MLV1
, MSD_LEVELS_V MLV2
, MSD_HIERARCHIES_V MHV
, MSD_HIERARCHY_LEVELS MHL
WHERE MLV1.LEVEL_ID = MHL.LEVEL_ID
AND MLV2.LEVEL_ID = MHL.PARENT_LEVEL_ID
AND MHV.HIERARCHY_ID = MHL.HIERARCHY_ID
AND MHL.PLAN_TYPE IS NULL