VIEW: APPS.AR_CMGT_SCORABLE_DATA_POINTS_V

Source

View Text - Preformatted

SELECT data_point_id, data_point_name, data_point_category, application_id, return_data_type, return_date_format, data_point_code, function_name FROM ar_cmgt_data_points_vl WHERE scorable_flag = 'Y' UNION SELECT data_element_id, data_element_name, 'DNB' data_point_category, application_id, return_data_type, return_date_format, null data_point_code, null function_name FROM ar_cmgt_dnb_elements_vl where scorable_flag = 'Y'

View Text - HTML Formatted

SELECT DATA_POINT_ID
, DATA_POINT_NAME
, DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, DATA_POINT_CODE
, FUNCTION_NAME
FROM AR_CMGT_DATA_POINTS_VL
WHERE SCORABLE_FLAG = 'Y' UNION SELECT DATA_ELEMENT_ID
, DATA_ELEMENT_NAME
, 'DNB' DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, NULL DATA_POINT_CODE
, NULL FUNCTION_NAME
FROM AR_CMGT_DNB_ELEMENTS_VL
WHERE SCORABLE_FLAG = 'Y'