VIEW: APPS.IMC_THREE_SIXTY_COLS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.COLUMN_ID COLUMN_ID, B.QUERY_ID QUERY_ID, B.FILTER_QUERY_ID FILTER_QUERY_ID, B.COLUMN_NAME COLUMN_NAME, B.COLUMN_LENGTH COLUMN_LENGTH, B.DISPLAY_FLAG DISPLAY_FLAG, B.SORT_FLAG SORT_FLAG, B.FILTER_FLAG FILTER_FLAG, B.RANGE_FILTER_FLAG RANGE_FILTER_FLAG, B.HYPERLINK_FLAG HYPERLINK_FLAG, B.COLUMN_DATA_TYPE COLUMN_DATA_TYPE, B.SECURITY_FUNCTION SECURITY_FUNCTION, B.SEQ_NO SEQ_NO, T.COLUMN_LABEL COLUMN_LABEL, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from IMC_THREE_SIXTY_COLS_B B, IMC_THREE_SIXTY_COLS_TL T WHERE B.COLUMN_ID = T.COLUMN_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.COLUMN_ID COLUMN_ID
, B.QUERY_ID QUERY_ID
, B.FILTER_QUERY_ID FILTER_QUERY_ID
, B.COLUMN_NAME COLUMN_NAME
, B.COLUMN_LENGTH COLUMN_LENGTH
, B.DISPLAY_FLAG DISPLAY_FLAG
, B.SORT_FLAG SORT_FLAG
, B.FILTER_FLAG FILTER_FLAG
, B.RANGE_FILTER_FLAG RANGE_FILTER_FLAG
, B.HYPERLINK_FLAG HYPERLINK_FLAG
, B.COLUMN_DATA_TYPE COLUMN_DATA_TYPE
, B.SECURITY_FUNCTION SECURITY_FUNCTION
, B.SEQ_NO SEQ_NO
, T.COLUMN_LABEL COLUMN_LABEL
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM IMC_THREE_SIXTY_COLS_B B
, IMC_THREE_SIXTY_COLS_TL T
WHERE B.COLUMN_ID = T.COLUMN_ID
AND T.LANGUAGE = USERENV('LANG')