[Home] [Help]
View: PSP_REPORT_TEMPLATE_DATES_V
View Text
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')
, 1)
, '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
Columns
Name |
TEMPLATE_ID |
PERIOD_START_DATE |
PERIOD_END_DATE |