VIEW: APPS.CSR_RULE_WINDOWS_V

Source

View Text - Preformatted

SELECT r.rule_id
       , extractValue(value(wb), 'window/@windowId')
       , wt.window_name
       , wt.description
       , to_date(to_char(extractValue(value(wb), 'window/@startTime'), 'DD-MON-YYYY HH24:MI:SS'), 'DD-MON-YYYY HH24:MI:SS')
       , to_date(to_char(extractValue(value(wb), 'window/@endTime'), 'DD-MON-YYYY HH24:MI:SS'), 'DD-MON-YYYY HH24:MI:SS')
       , to_char(extractValue(value(wb), 'window/@startTime'), 'HH24:MI')
       , to_char(extractValue(value(wb), 'window/@endTime'), 'HH24:MI')
       , to_char(extractValue(value(wb), 'window/@startTime'), 'HH24')
       , to_char(extractValue(value(wb), 'window/@startTime'), 'MI')
       , to_char(extractValue(value(wb), 'window/@endTime'), 'HH24')
       , to_char(extractValue(value(wb), 'window/@endTime'), 'MI')
       , (to_date(to_char(extractValue(value(wb), 'window/@endTime'), 'DD-MON-YYYY HH24:MI:SS'), 'DD-MON-YYYY HH24:MI:SS') - to_date(to_char(extractValue(value(wb), 'window/@startTime'), 'DD-MON-YYYY HH24:MI:SS'), 'DD-MON-YYYY HH24:MI:SS')) * 24 * 60
       , r.created_by
       , r.creation_date
       , r.last_updated_by
       , r.last_update_date
       , r.last_update_login
    FROM csr_rules_b r
       , TABLE( XMLSequence(extract(r.rule_doc, '/schedulerRule/wtpParameters/window')) ) wb
       , csr_rule_windows_tl wt
   WHERE wt.window_id = extractValue(value(wb), 'window/@windowId')
     AND wt.language = userenv('LANG')
   

View Text - HTML Formatted

SELECT R.RULE_ID
, EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@WINDOWID')
, WT.WINDOW_NAME
, WT.DESCRIPTION
, TO_DATE(TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@STARTTIME')
, 'DD-MON-YYYY HH24:MI:SS')
, 'DD-MON-YYYY HH24:MI:SS')
, TO_DATE(TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@ENDTIME')
, 'DD-MON-YYYY HH24:MI:SS')
, 'DD-MON-YYYY HH24:MI:SS')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@STARTTIME')
, 'HH24:MI')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@ENDTIME')
, 'HH24:MI')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@STARTTIME')
, 'HH24')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@STARTTIME')
, 'MI')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@ENDTIME')
, 'HH24')
, TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@ENDTIME')
, 'MI')
, (TO_DATE(TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@ENDTIME')
, 'DD-MON-YYYY HH24:MI:SS')
, 'DD-MON-YYYY HH24:MI:SS') - TO_DATE(TO_CHAR(EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@STARTTIME')
, 'DD-MON-YYYY HH24:MI:SS')
, 'DD-MON-YYYY HH24:MI:SS')) * 24 * 60
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
FROM CSR_RULES_B R
, TABLE( XMLSEQUENCE(EXTRACT(R.RULE_DOC
, '/SCHEDULERRULE/WTPPARAMETERS/WINDOW')) ) WB
, CSR_RULE_WINDOWS_TL WT
WHERE WT.WINDOW_ID = EXTRACTVALUE(VALUE(WB)
, 'WINDOW/@WINDOWID')
AND WT.LANGUAGE = USERENV('LANG')