VIEW: APPS.HRI_CL_DGN_DATA_SUBSECTION_V

Source

View Text - Preformatted

SELECT stp.object_name id ,hri_oltp_view_message.get_message (NVL(stp.object_name_msg_name, stp.object_type_msg_name)) value ,stp.seq_num order_by ,stp.functional_area_cd owning_area_cd ,stp.object_type section_code ,CASE WHEN stp.default_mode = 'DETAIL_RESTRICT' OR stp.default_mode = 'DETAIL_RESTRICT_COUNT' THEN 'Y' ELSE 'N' END restrict_option_flag FROM hri_adm_dgnstc_setup stp WHERE stp.enabled_flag = 'Y' AND stp.report_type IN ('DATA','ALERT') UNION ALL SELECT 'NA_EDW' ,hri_oltp_view_message.get_all_msg ,to_number(null) ,'NA_EDW' ,'NA_EDW' ,'NA_EDW' FROM dual

View Text - HTML Formatted

SELECT STP.OBJECT_NAME ID
, HRI_OLTP_VIEW_MESSAGE.GET_MESSAGE (NVL(STP.OBJECT_NAME_MSG_NAME
, STP.OBJECT_TYPE_MSG_NAME)) VALUE
, STP.SEQ_NUM ORDER_BY
, STP.FUNCTIONAL_AREA_CD OWNING_AREA_CD
, STP.OBJECT_TYPE SECTION_CODE
, CASE WHEN STP.DEFAULT_MODE = 'DETAIL_RESTRICT' OR STP.DEFAULT_MODE = 'DETAIL_RESTRICT_COUNT' THEN 'Y' ELSE 'N' END RESTRICT_OPTION_FLAG
FROM HRI_ADM_DGNSTC_SETUP STP
WHERE STP.ENABLED_FLAG = 'Y'
AND STP.REPORT_TYPE IN ('DATA'
, 'ALERT') UNION ALL SELECT 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_ALL_MSG
, TO_NUMBER(NULL)
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
FROM DUAL