VIEW: APPS.HXC_LAYOUTS_VL

Source

View Text - Preformatted

SELECT b.layout_id ,b.layout_name ,t.display_layout_name ,b.application_id ,b.layout_type ,b.modifier_level ,b.modifier_value ,b.top_level_region_code ,b.object_version_number ,b.last_update_date ,b.last_updated_by ,b.last_update_login ,b.created_by ,b.creation_date from HXC_layouts b, HXC_layouts_tl t WHERE b.layout_id = t.layout_id and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.LAYOUT_ID
, B.LAYOUT_NAME
, T.DISPLAY_LAYOUT_NAME
, B.APPLICATION_ID
, B.LAYOUT_TYPE
, B.MODIFIER_LEVEL
, B.MODIFIER_VALUE
, B.TOP_LEVEL_REGION_CODE
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
FROM HXC_LAYOUTS B
, HXC_LAYOUTS_TL T
WHERE B.LAYOUT_ID = T.LAYOUT_ID
AND T.LANGUAGE = USERENV('LANG')