VIEW: APPS.FEM_CAL_PERIOD_HIERS_TL_V

Source

View Text - Preformatted

SELECT B.object_definition_id ,substr(CTL.object_name||' : '||TL.display_name,1,150) display_name ,TL.description ,TL.language ,TL.source_lang ,TL.CREATION_DATE ,TL.CREATED_BY ,TL.LAST_UPDATED_BY ,TL.LAST_UPDATE_DATE ,TL.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 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 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
, TL.LANGUAGE
, TL.SOURCE_LANG
, TL.CREATION_DATE
, TL.CREATED_BY
, TL.LAST_UPDATED_BY
, TL.LAST_UPDATE_DATE
, TL.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 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 B.OBJECT_ID = CTL.OBJECT_ID
AND CTL.LANGUAGE = TL.LANGUAGE