VIEW: APPS.BNE_INTERFACE_COLS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B . APPLICATION_ID , B . INTERFACE_CODE , OBJECT_VERSION_NUMBER , B . SEQUENCE_NUM , INTERFACE_COL_TYPE , INTERFACE_COL_NAME , ENABLED_FLAG , REQUIRED_FLAG , DISPLAY_FLAG , READ_ONLY_FLAG , NOT_NULL_FLAG , SUMMARY_FLAG , MAPPING_ENABLED_FLAG , DATA_TYPE , FIELD_SIZE , DEFAULT_TYPE , DEFAULT_VALUE , SEGMENT_NUMBER , GROUP_NAME , OA_FLEX_CODE , OA_CONCAT_FLEX , VAL_TYPE , VAL_ID_COL , VAL_MEAN_COL , VAL_DESC_COL , VAL_OBJ_NAME , VAL_ADDL_W_C , VAL_COMPONENT_APP_ID , VAL_COMPONENT_CODE , OA_FLEX_NUM , OA_FLEX_APPLICATION_ID , DISPLAY_ORDER , UPLOAD_PARAM_LIST_ITEM_NUM , EXPANDED_SQL_QUERY , USER_HINT , PROMPT_LEFT , USER_HELP_TEXT , PROMPT_ABOVE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE, B.LOV_TYPE, B.OFFLINE_LOV_ENABLED_FLAG, B.VARIABLE_DATA_TYPE_CLASS, B.VAL_QUERY_APP_ID, B.VAL_QUERY_CODE, B.EXPANDED_SQL_QUERY_APP_ID, B.EXPANDED_SQL_QUERY_CODE, B.VIEWER_GROUP, B.EDIT_TYPE, B.DISPLAY_WIDTH FROM BNE_INTERFACE_COLS_B B , BNE_INTERFACE_COLS_TL T WHERE B . APPLICATION_ID = T . APPLICATION_ID AND B . INTERFACE_CODE = T . INTERFACE_CODE AND B . SEQUENCE_NUM = T . SEQUENCE_NUM AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B . APPLICATION_ID
, B . INTERFACE_CODE
, OBJECT_VERSION_NUMBER
, B . SEQUENCE_NUM
, INTERFACE_COL_TYPE
, INTERFACE_COL_NAME
, ENABLED_FLAG
, REQUIRED_FLAG
, DISPLAY_FLAG
, READ_ONLY_FLAG
, NOT_NULL_FLAG
, SUMMARY_FLAG
, MAPPING_ENABLED_FLAG
, DATA_TYPE
, FIELD_SIZE
, DEFAULT_TYPE
, DEFAULT_VALUE
, SEGMENT_NUMBER
, GROUP_NAME
, OA_FLEX_CODE
, OA_CONCAT_FLEX
, VAL_TYPE
, VAL_ID_COL
, VAL_MEAN_COL
, VAL_DESC_COL
, VAL_OBJ_NAME
, VAL_ADDL_W_C
, VAL_COMPONENT_APP_ID
, VAL_COMPONENT_CODE
, OA_FLEX_NUM
, OA_FLEX_APPLICATION_ID
, DISPLAY_ORDER
, UPLOAD_PARAM_LIST_ITEM_NUM
, EXPANDED_SQL_QUERY
, USER_HINT
, PROMPT_LEFT
, USER_HELP_TEXT
, PROMPT_ABOVE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.LOV_TYPE
, B.OFFLINE_LOV_ENABLED_FLAG
, B.VARIABLE_DATA_TYPE_CLASS
, B.VAL_QUERY_APP_ID
, B.VAL_QUERY_CODE
, B.EXPANDED_SQL_QUERY_APP_ID
, B.EXPANDED_SQL_QUERY_CODE
, B.VIEWER_GROUP
, B.EDIT_TYPE
, B.DISPLAY_WIDTH
FROM BNE_INTERFACE_COLS_B B
, BNE_INTERFACE_COLS_TL T
WHERE B . APPLICATION_ID = T . APPLICATION_ID
AND B . INTERFACE_CODE = T . INTERFACE_CODE
AND B . SEQUENCE_NUM = T . SEQUENCE_NUM
AND T.LANGUAGE = USERENV('LANG')