Post date: Jan 15, 2020 6:4:3 AM
SELECT DISTINCT
ccd.organization_id,
mp.organization_code,
cldr.period_desc,period_name,
gl_prd.period_year||decode(length(gl_prd.period_num),1,0||gl_prd.period_num,gl_prd.period_num) as period_range
FROM
cm_cmpt_dtl ccd,
mtl_parameters mp,
cm_cldr_dtl cldr,
gmf_period_statuses gps,
(select period_name, period_year, period_num from gl_periods_v
where period_set_name = 'NFI_CALENDAR') gl_prd
WHERE
ccd.organization_id = mp.organization_id
AND cldr.calendar_code = gps.calendar_code
AND cldr.period_code = gps.period_code
AND gps.period_id = ccd.period_id
and cldr.period_desc = gl_prd.period_name (+)
and mp.organization_code <> 'PLA'
--and ((gl_prd.period_year||decode(length(gl_prd.period_num),1,0||gl_prd.period_num,gl_prd.period_num)) between '12-19' and '12-19')