eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIS.BIS_LEVELS#

Source

View Text - Preformatted


select LEVEL_ID LEVEL_ID, SHORT_NAME SHORT_NAME, DIMENSION_ID DIMENSION_ID, LEVEL_VALUES_VIEW_NAME LEVEL_VALUES_VIEW_NAME, WHERE_CLAUSE WHERE_CLAUSE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SOURCE SOURCE, COMPARISON_LABEL_CODE COMPARISON_LABEL_CODE, ATTRIBUTE_CODE ATTRIBUTE_CODE, APPLICATION_ID APPLICATION_ID, VIEW_OBJECT_NAME VIEW_OBJECT_NAME, DEFAULT_VALUES_API DEFAULT_VALUES_API, DEFAULT_SEARCH DEFAULT_SEARCH, LONG_LOV LONG_LOV, MASTER_LEVEL MASTER_LEVEL, ENABLED ENABLED, DRILL_TO_FORM_FUNCTION DRILL_TO_FORM_FUNCTION, HIDE_IN_DESIGN HIDE_IN_DESIGN from "BIS"."BIS_LEVELS"

View Text - HTML Formatted

SELECT LEVEL_ID LEVEL_ID
, SHORT_NAME SHORT_NAME
, DIMENSION_ID DIMENSION_ID
, LEVEL_VALUES_VIEW_NAME LEVEL_VALUES_VIEW_NAME
, WHERE_CLAUSE WHERE_CLAUSE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SOURCE SOURCE
, COMPARISON_LABEL_CODE COMPARISON_LABEL_CODE
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, APPLICATION_ID APPLICATION_ID
, VIEW_OBJECT_NAME VIEW_OBJECT_NAME
, DEFAULT_VALUES_API DEFAULT_VALUES_API
, DEFAULT_SEARCH DEFAULT_SEARCH
, LONG_LOV LONG_LOV
, MASTER_LEVEL MASTER_LEVEL
, ENABLED ENABLED
, DRILL_TO_FORM_FUNCTION DRILL_TO_FORM_FUNCTION
, HIDE_IN_DESIGN HIDE_IN_DESIGN
FROM "BIS"."BIS_LEVELS"