VIEW: APPS.FEM_CAL_PERIOD_HIERS_VL

Source

View Text - Preformatted

SELECT B.object_definition_id ,substr(CTL.object_name||' : '||TL.display_name,1,150) display_name ,TL.description ,'Y' ENABLED_FLAG ,'Y' READ_ONLY_FLAG ,'N' PERSONAL_FLAG ,B.CREATION_DATE ,B.CREATED_BY ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN from fem_object_definition_b B, fem_object_definition_tl TL, fem_hier_definitions H, fem_object_catalog_tl CTL WHERE B.OBJECT_DEFINITION_ID = TL.OBJECT_DEFINITION_ID and TL.LANGUAGE = USERENV('LANG') and B.object_definition_id = H.hierarchy_obj_def_id and B.object_id in (select hierarchy_obj_id from fem_hierarchies where dimension_id in (select dimension_id from fem_dimensions_b where dimension_varchar_label = 'CAL_PERIOD') and personal_flag = 'N') and B.object_id = CTL.object_id and CTL.language = TL.language

View Text - HTML Formatted

SELECT B.OBJECT_DEFINITION_ID
, SUBSTR(CTL.OBJECT_NAME||' : '||TL.DISPLAY_NAME
, 1
, 150) DISPLAY_NAME
, TL.DESCRIPTION
, 'Y' ENABLED_FLAG
, 'Y' READ_ONLY_FLAG
, 'N' PERSONAL_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM FEM_OBJECT_DEFINITION_B B
, FEM_OBJECT_DEFINITION_TL TL
, FEM_HIER_DEFINITIONS H
, FEM_OBJECT_CATALOG_TL CTL
WHERE B.OBJECT_DEFINITION_ID = TL.OBJECT_DEFINITION_ID
AND TL.LANGUAGE = USERENV('LANG')
AND B.OBJECT_DEFINITION_ID = H.HIERARCHY_OBJ_DEF_ID
AND B.OBJECT_ID IN (SELECT HIERARCHY_OBJ_ID
FROM FEM_HIERARCHIES
WHERE DIMENSION_ID IN (SELECT DIMENSION_ID
FROM FEM_DIMENSIONS_B
WHERE DIMENSION_VARCHAR_LABEL = 'CAL_PERIOD')
AND PERSONAL_FLAG = 'N')
AND B.OBJECT_ID = CTL.OBJECT_ID
AND CTL.LANGUAGE = TL.LANGUAGE