VIEW: APPS.HRI_CL_DGN_DATA_SECTION_V

Source

View Text - Preformatted

SELECT tab.id ,hri_oltp_view_message.get_message (tab.value_code) value ,tab.order_by ,tab.functional_area_cd ,tab.report_type ,DECODE(tab.restrict_option_ind, 1, 'Y', 'N') restrict_option_flag FROM (SELECT stp.functional_area_cd || '|' || stp.object_type id ,MAX(nvl(stp.object_type_msg_name,chr(1))) value_code ,'ALL' functional_area_cd ,stp.report_type report_type ,MAX(CASE WHEN stp.default_mode = 'DETAIL_RESTRICT' OR stp.default_mode = 'DETAIL_RESTRICT_COUNT' THEN 1 ELSE 0 END) restrict_option_ind ,MAX(nvl(stp.seq_num,0)) order_by FROM hri_adm_dgnstc_setup stp WHERE stp.enabled_flag = 'Y' AND stp.report_type IN ('DATA','ALERT') GROUP BY stp.object_type ,stp.functional_area_cd ,stp.report_type UNION ALL SELECT stp.functional_area_cd || '|' || stp.object_type id ,MAX(nvl(stp.object_type_msg_name,chr(1))) ,sbs.functional_area_cd functional_area_cd ,stp.report_type report_type ,MAX(CASE WHEN stp.default_mode = 'DETAIL_RESTRICT' OR stp.default_mode = 'DETAIL_RESTRICT_COUNT' THEN 1 ELSE 0 END) restrict_option_ind ,MAX(nvl(stp.seq_num,0)) order_by FROM hri_adm_dgnstc_setup stp ,hri_adm_dgnstc_sbscrb sbs WHERE stp.enabled_flag = 'Y' AND stp.report_type IN ('DATA','ALERT') AND stp.object_type = sbs.object_type AND stp.object_name = sbs.object_name GROUP BY stp.object_type ,stp.report_type ,sbs.functional_area_cd ,stp.functional_area_cd ) tab 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 TAB.ID
, HRI_OLTP_VIEW_MESSAGE.GET_MESSAGE (TAB.VALUE_CODE) VALUE
, TAB.ORDER_BY
, TAB.FUNCTIONAL_AREA_CD
, TAB.REPORT_TYPE
, DECODE(TAB.RESTRICT_OPTION_IND
, 1
, 'Y'
, 'N') RESTRICT_OPTION_FLAG
FROM (SELECT STP.FUNCTIONAL_AREA_CD || '|' || STP.OBJECT_TYPE ID
, MAX(NVL(STP.OBJECT_TYPE_MSG_NAME
, CHR(1))) VALUE_CODE
, 'ALL' FUNCTIONAL_AREA_CD
, STP.REPORT_TYPE REPORT_TYPE
, MAX(CASE WHEN STP.DEFAULT_MODE = 'DETAIL_RESTRICT' OR STP.DEFAULT_MODE = 'DETAIL_RESTRICT_COUNT' THEN 1 ELSE 0 END) RESTRICT_OPTION_IND
, MAX(NVL(STP.SEQ_NUM
, 0)) ORDER_BY
FROM HRI_ADM_DGNSTC_SETUP STP
WHERE STP.ENABLED_FLAG = 'Y'
AND STP.REPORT_TYPE IN ('DATA'
, 'ALERT') GROUP BY STP.OBJECT_TYPE
, STP.FUNCTIONAL_AREA_CD
, STP.REPORT_TYPE UNION ALL SELECT STP.FUNCTIONAL_AREA_CD || '|' || STP.OBJECT_TYPE ID
, MAX(NVL(STP.OBJECT_TYPE_MSG_NAME
, CHR(1)))
, SBS.FUNCTIONAL_AREA_CD FUNCTIONAL_AREA_CD
, STP.REPORT_TYPE REPORT_TYPE
, MAX(CASE WHEN STP.DEFAULT_MODE = 'DETAIL_RESTRICT' OR STP.DEFAULT_MODE = 'DETAIL_RESTRICT_COUNT' THEN 1 ELSE 0 END) RESTRICT_OPTION_IND
, MAX(NVL(STP.SEQ_NUM
, 0)) ORDER_BY
FROM HRI_ADM_DGNSTC_SETUP STP
, HRI_ADM_DGNSTC_SBSCRB SBS
WHERE STP.ENABLED_FLAG = 'Y'
AND STP.REPORT_TYPE IN ('DATA'
, 'ALERT')
AND STP.OBJECT_TYPE = SBS.OBJECT_TYPE
AND STP.OBJECT_NAME = SBS.OBJECT_NAME GROUP BY STP.OBJECT_TYPE
, STP.REPORT_TYPE
, SBS.FUNCTIONAL_AREA_CD
, STP.FUNCTIONAL_AREA_CD ) TAB UNION ALL SELECT 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_ALL_MSG
, TO_NUMBER(NULL)
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
FROM DUAL