View: IMC_THREE_SIXTY_COLS_VL

Product:	IMC - Customers Online
Description:	View for imc_three_sixty_cols
Implementation/DBA Data:	APPS.IMC_THREE_SIXTY_COLS_VL

View Text

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')

Columns