VIEW: APPS.PSP_REPORT_TEMPLATE_DATES_V

Source

View Text - Preformatted

SELECT prt.template_id, to_Date(prth.PARAMETER_VALUE_3,'DD-MON-RRRR') + 1 as period_start_date, decode( UNIT_OF_MEASURE, 'M', add_months(to_Date(prth.PARAMETER_VALUE_3,'DD-MON-RRRR'), prpf.period_duration), 'D', to_Date(prth.PARAMETER_VALUE_3,'DD-MON-RRRR') + 1 , 'W', to_Date(prth.PARAMETER_VALUE_3,'DD-MON-RRRR') + 7, 'Y', add_months(to_Date(prth.PARAMETER_VALUE_3,'DD-MON-RRRR'), 12) ) as period_end_date from psp_report_period_frequency_b prpf, psp_report_templates prt, (select * from psp_report_templates_h where REQUEST_ID in (Select max(REQUEST_ID) from psp_report_templates_h group by template_id) )prth where prt.PERIOD_FREQUENCY_ID = prpf.PERIOD_FREQUENCY_ID and prth.TEMPLATE_ID(+) = prt.TEMPLATE_ID

View Text - HTML Formatted

SELECT PRT.TEMPLATE_ID
, TO_DATE(PRTH.PARAMETER_VALUE_3
, 'DD-MON-RRRR') + 1 AS PERIOD_START_DATE
, DECODE( UNIT_OF_MEASURE
, 'M'
, ADD_MONTHS(TO_DATE(PRTH.PARAMETER_VALUE_3
, 'DD-MON-RRRR')
, PRPF.PERIOD_DURATION)
, 'D'
, TO_DATE(PRTH.PARAMETER_VALUE_3
, 'DD-MON-RRRR') + 1
, 'W'
, TO_DATE(PRTH.PARAMETER_VALUE_3
, 'DD-MON-RRRR') + 7
, 'Y'
, ADD_MONTHS(TO_DATE(PRTH.PARAMETER_VALUE_3
, 'DD-MON-RRRR')
, 12) ) AS PERIOD_END_DATE
FROM PSP_REPORT_PERIOD_FREQUENCY_B PRPF
, PSP_REPORT_TEMPLATES PRT
, (SELECT *
FROM PSP_REPORT_TEMPLATES_H
WHERE REQUEST_ID IN (SELECT MAX(REQUEST_ID)
FROM PSP_REPORT_TEMPLATES_H GROUP BY TEMPLATE_ID) )PRTH
WHERE PRT.PERIOD_FREQUENCY_ID = PRPF.PERIOD_FREQUENCY_ID
AND PRTH.TEMPLATE_ID(+) = PRT.TEMPLATE_ID