View: CSR_RULE_WINDOWS_V

Product:	CSR - Scheduler
Description:
Implementation/DBA Data:	APPS.CSR_RULE_WINDOWS_V

View Text

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')