eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FP_WEBADI_PRD_V

Source

View Text - Preformatted


SELECT a.budget_version_id budget_version_id, a.period_mask_id period_mask_id, min((decode((a.from_anchor_position- b.min_anchor +1),1,a.start_date,null))) prdsd1, min((decode((a.from_anchor_position- b.min_anchor +1),1,a.end_date,null))) prded1, min((decode((a.from_anchor_position- b.min_anchor +1),2,a.start_date,null))) prdsd2, min((decode((a.from_anchor_position- b.min_anchor +1),2,a.end_date,null))) prded2, min((decode((a.from_anchor_position- b.min_anchor +1),3,a.start_date,null))) prdsd3, min((decode((a.from_anchor_position- b.min_anchor +1),3,a.end_date,null))) prded3, min((decode((a.from_anchor_position- b.min_anchor +1),4,a.start_date,null))) prdsd4, min((decode((a.from_anchor_position- b.min_anchor +1),4,a.end_date,null))) prded4, min((decode((a.from_anchor_position- b.min_anchor +1),5,a.start_date,null))) prdsd5, min((decode((a.from_anchor_position- b.min_anchor +1),5,a.end_date,null))) prded5, min((decode((a.from_anchor_position- b.min_anchor +1),6,a.start_date,null))) prdsd6, min((decode((a.from_anchor_position- b.min_anchor +1),6,a.end_date,null))) prded6, min((decode((a.from_anchor_position- b.min_anchor +1),7,a.start_date,null))) prdsd7, min((decode((a.from_anchor_position- b.min_anchor +1),7,a.end_date,null))) prded7, min((decode((a.from_anchor_position- b.min_anchor +1),8,a.start_date,null))) prdsd8, min((decode((a.from_anchor_position- b.min_anchor +1),8,a.end_date,null))) prded8, min((decode((a.from_anchor_position- b.min_anchor +1),9,a.start_date,null))) prdsd9, min((decode((a.from_anchor_position- b.min_anchor +1),9,a.end_date,null))) prded9, min((decode((a.from_anchor_position- b.min_anchor +1),10,a.start_date,null))) prdsd10, min((decode((a.from_anchor_position- b.min_anchor +1),10,a.end_date,null))) prded10, min((decode((a.from_anchor_position- b.min_anchor +1),11,a.start_date,null))) prdsd11, min((decode((a.from_anchor_position- b.min_anchor +1),11,a.end_date,null))) prded11, min((decode((a.from_anchor_position- b.min_anchor +1),12,a.start_date,null))) prdsd12, min((decode((a.from_anchor_position- b.min_anchor +1),12,a.end_date,null))) prded12, min((decode((a.from_anchor_position- b.min_anchor +1),13,a.start_date,null))) prdsd13, min((decode((a.from_anchor_position- b.min_anchor +1),13,a.end_date,null))) prded13, min((decode((a.from_anchor_position- b.min_anchor +1),14,a.start_date,null))) prdsd14, min((decode((a.from_anchor_position- b.min_anchor +1),14,a.end_date,null))) prded14, min((decode((a.from_anchor_position- b.min_anchor +1),15,a.start_date,null))) prdsd15, min((decode((a.from_anchor_position- b.min_anchor +1),15,a.end_date,null))) prded15, min((decode((a.from_anchor_position- b.min_anchor +1),16,a.start_date,null))) prdsd16, min((decode((a.from_anchor_position- b.min_anchor +1),16,a.end_date,null))) prded16, min((decode((a.from_anchor_position- b.min_anchor +1),17,a.start_date,null))) prdsd17, min((decode((a.from_anchor_position- b.min_anchor +1),17,a.end_date,null))) prded17, min((decode((a.from_anchor_position- b.min_anchor +1),18,a.start_date,null))) prdsd18, min((decode((a.from_anchor_position- b.min_anchor +1),18,a.end_date,null))) prded18, min((decode((a.from_anchor_position- b.min_anchor +1),19,a.start_date,null))) prdsd19, min((decode((a.from_anchor_position- b.min_anchor +1),19,a.end_date,null))) prded19, min((decode((a.from_anchor_position- b.min_anchor +1),20,a.start_date,null))) prdsd20, min((decode((a.from_anchor_position- b.min_anchor +1),20,a.end_date,null))) prded20, min((decode((a.from_anchor_position- b.min_anchor +1),21,a.start_date,null))) prdsd21, min((decode((a.from_anchor_position- b.min_anchor +1),21,a.end_date,null))) prded21, min((decode((a.from_anchor_position- b.min_anchor +1),22,a.start_date,null))) prdsd22, min((decode((a.from_anchor_position- b.min_anchor +1),22,a.end_date,null))) prded22, min((decode((a.from_anchor_position- b.min_anchor +1),23,a.start_date,null))) prdsd23, min((decode((a.from_anchor_position- b.min_anchor +1),23,a.end_date,null))) prded23, min((decode((a.from_anchor_position- b.min_anchor +1),24,a.start_date,null))) prdsd24, min((decode((a.from_anchor_position- b.min_anchor +1),24,a.end_date,null))) prded24, min((decode((a.from_anchor_position- b.min_anchor +1),25,a.start_date,null))) prdsd25, min((decode((a.from_anchor_position- b.min_anchor +1),25,a.end_date,null))) prded25, min((decode((a.from_anchor_position- b.min_anchor +1),26,a.start_date,null))) prdsd26, min((decode((a.from_anchor_position- b.min_anchor +1),26,a.end_date,null))) prded26, min((decode((a.from_anchor_position- b.min_anchor +1),27,a.start_date,null))) prdsd27, min((decode((a.from_anchor_position- b.min_anchor +1),27,a.end_date,null))) prded27, min((decode((a.from_anchor_position- b.min_anchor +1),28,a.start_date,null))) prdsd28, min((decode((a.from_anchor_position- b.min_anchor +1),28,a.end_date,null))) prded28, min((decode((a.from_anchor_position- b.min_anchor +1),29,a.start_date,null))) prdsd29, min((decode((a.from_anchor_position- b.min_anchor +1),29,a.end_date,null))) prded29, min((decode((a.from_anchor_position- b.min_anchor +1),30,a.start_date,null))) prdsd30, min((decode((a.from_anchor_position- b.min_anchor +1),30,a.end_date,null))) prded30, min((decode((a.from_anchor_position- b.min_anchor +1),31,a.start_date,null))) prdsd31, min((decode((a.from_anchor_position- b.min_anchor +1),31,a.end_date,null))) prded31, min((decode((a.from_anchor_position- b.min_anchor +1),32,a.start_date,null))) prdsd32, min((decode((a.from_anchor_position- b.min_anchor +1),32,a.end_date,null))) prded32, min((decode((a.from_anchor_position- b.min_anchor +1),33,a.start_date,null))) prdsd33, min((decode((a.from_anchor_position- b.min_anchor +1),33,a.end_date,null))) prded33, min((decode((a.from_anchor_position- b.min_anchor +1),34,a.start_date,null))) prdsd34, min((decode((a.from_anchor_position- b.min_anchor +1),34,a.end_date,null))) prded34, min((decode((a.from_anchor_position- b.min_anchor +1),35,a.start_date,null))) prdsd35, min((decode((a.from_anchor_position- b.min_anchor +1),35,a.end_date,null))) prded35, min((decode((a.from_anchor_position- b.min_anchor +1),36,a.start_date,null))) prdsd36, min((decode((a.from_anchor_position- b.min_anchor +1),36,a.end_date,null))) prded36, min((decode((a.from_anchor_position- b.min_anchor +1),37,a.start_date,null))) prdsd37, min((decode((a.from_anchor_position- b.min_anchor +1),37,a.end_date,null))) prded37, min((decode((a.from_anchor_position- b.min_anchor +1),38,a.start_date,null))) prdsd38, min((decode((a.from_anchor_position- b.min_anchor +1),38,a.end_date,null))) prded38, min((decode((a.from_anchor_position- b.min_anchor +1),39,a.start_date,null))) prdsd39, min((decode((a.from_anchor_position- b.min_anchor +1),39,a.end_date,null))) prded39, min((decode((a.from_anchor_position- b.min_anchor +1),40,a.start_date,null))) prdsd40, min((decode((a.from_anchor_position- b.min_anchor +1),40,a.end_date,null))) prded40, min((decode((a.from_anchor_position- b.min_anchor +1),41,a.start_date,null))) prdsd41, min((decode((a.from_anchor_position- b.min_anchor +1),41,a.end_date,null))) prded41, min((decode((a.from_anchor_position- b.min_anchor +1),42,a.start_date,null))) prdsd42, min((decode((a.from_anchor_position- b.min_anchor +1),42,a.end_date,null))) prded42, min((decode((a.from_anchor_position- b.min_anchor +1),43,a.start_date,null))) prdsd43, min((decode((a.from_anchor_position- b.min_anchor +1),43,a.end_date,null))) prded43, min((decode((a.from_anchor_position- b.min_anchor +1),44,a.start_date,null))) prdsd44, min((decode((a.from_anchor_position- b.min_anchor +1),44,a.end_date,null))) prded44, min((decode((a.from_anchor_position- b.min_anchor +1),45,a.start_date,null))) prdsd45, min((decode((a.from_anchor_position- b.min_anchor +1),45,a.end_date,null))) prded45, min((decode((a.from_anchor_position- b.min_anchor +1),46,a.start_date,null))) prdsd46, min((decode((a.from_anchor_position- b.min_anchor +1),46,a.end_date,null))) prded46, min((decode((a.from_anchor_position- b.min_anchor +1),47,a.start_date,null))) prdsd47, min((decode((a.from_anchor_position- b.min_anchor +1),47,a.end_date,null))) prded47, min((decode((a.from_anchor_position- b.min_anchor +1),48,a.start_date,null))) prdsd48, min((decode((a.from_anchor_position- b.min_anchor +1),48,a.end_date,null))) prded48, min((decode((a.from_anchor_position- b.min_anchor +1),49,a.start_date,null))) prdsd49, min((decode((a.from_anchor_position- b.min_anchor +1),49,a.end_date,null))) prded49, min((decode((a.from_anchor_position- b.min_anchor +1),50,a.start_date,null))) prdsd50, min((decode((a.from_anchor_position- b.min_anchor +1),50,a.end_date,null))) prded50, min((decode((a.from_anchor_position- b.min_anchor +1),51,a.start_date,null))) prdsd51, min((decode((a.from_anchor_position- b.min_anchor +1),51,a.end_date,null))) prded51, min((decode((a.from_anchor_position- b.min_anchor +1),52,a.start_date,null))) prdsd52, min((decode((a.from_anchor_position- b.min_anchor +1),52,a.end_date,null))) prded52 from (select pfo.fin_plan_version_id budget_version_id, pmd.period_mask_id, glsd.start_date, gled.end_date, glcp.period_type, decode(glsd.period_name, gled.period_name,gled.period_name, glsd.period_name ||' To '||gled.period_name) period_name, pmd.from_anchor_position from_anchor_position from pa_fp_periods_v glsd, pa_fp_periods_v gled, pa_fp_periods_v glcp, pa_period_mask_details pmd, pa_proj_fp_options pfo, pa_projects_all ppa WHERE pfo.fin_plan_version_id is not null and ppa.project_id = pfo.project_id and pmd.period_mask_id=nvl(pfo.COST_PERIOD_MASK_ID,nvl(REV_PERIOD_MASK_ID,ALL_PERIOD_MASK_ID)) and glcp.period_name=nvl(pfo.cost_current_planning_period,nvl(rev_current_planning_period,all_current_planning_period)) and glcp.org_id = ppa.org_id and glsd.org_id = glcp.org_id and gled.org_id = glcp.org_id and glsd.row_num=pmd.from_anchor_start+glcp.row_num and gled.row_num=pmd.from_anchor_end+glcp.row_num and pmd.from_anchor_position not in (9999,-9999) and glcp.period_type=decode(nvl(pfo.COST_TIME_PHASED_CODE,nvl(pfo.REVENUE_TIME_PHASED_CODE,pfo.ALL_TIME_PHASED_CODE)),'P',glcp.pa_period_type,'G',glcp.accounted_period_type) and glsd.period_type=glcp.period_type and gled.period_type=glsd.period_type) a, (SELECT period_mask_id,min(from_anchor_position) min_anchor FROM pa_period_mask_details pmd2 WHERE pmd2.from_anchor_position not in (9999,-99999) GROUP BY pmd2.period_mask_id ) b where a.period_mask_id=b.period_mask_id GROUP BY a.budget_version_id,a.period_mask_id

View Text - HTML Formatted

SELECT A.BUDGET_VERSION_ID BUDGET_VERSION_ID
, A.PERIOD_MASK_ID PERIOD_MASK_ID
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 1
, A.START_DATE
, NULL))) PRDSD1
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 1
, A.END_DATE
, NULL))) PRDED1
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 2
, A.START_DATE
, NULL))) PRDSD2
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 2
, A.END_DATE
, NULL))) PRDED2
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 3
, A.START_DATE
, NULL))) PRDSD3
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 3
, A.END_DATE
, NULL))) PRDED3
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 4
, A.START_DATE
, NULL))) PRDSD4
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 4
, A.END_DATE
, NULL))) PRDED4
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 5
, A.START_DATE
, NULL))) PRDSD5
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 5
, A.END_DATE
, NULL))) PRDED5
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 6
, A.START_DATE
, NULL))) PRDSD6
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 6
, A.END_DATE
, NULL))) PRDED6
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 7
, A.START_DATE
, NULL))) PRDSD7
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 7
, A.END_DATE
, NULL))) PRDED7
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 8
, A.START_DATE
, NULL))) PRDSD8
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 8
, A.END_DATE
, NULL))) PRDED8
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 9
, A.START_DATE
, NULL))) PRDSD9
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 9
, A.END_DATE
, NULL))) PRDED9
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 10
, A.START_DATE
, NULL))) PRDSD10
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 10
, A.END_DATE
, NULL))) PRDED10
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 11
, A.START_DATE
, NULL))) PRDSD11
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 11
, A.END_DATE
, NULL))) PRDED11
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 12
, A.START_DATE
, NULL))) PRDSD12
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 12
, A.END_DATE
, NULL))) PRDED12
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 13
, A.START_DATE
, NULL))) PRDSD13
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 13
, A.END_DATE
, NULL))) PRDED13
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 14
, A.START_DATE
, NULL))) PRDSD14
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 14
, A.END_DATE
, NULL))) PRDED14
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 15
, A.START_DATE
, NULL))) PRDSD15
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 15
, A.END_DATE
, NULL))) PRDED15
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 16
, A.START_DATE
, NULL))) PRDSD16
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 16
, A.END_DATE
, NULL))) PRDED16
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 17
, A.START_DATE
, NULL))) PRDSD17
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 17
, A.END_DATE
, NULL))) PRDED17
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 18
, A.START_DATE
, NULL))) PRDSD18
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 18
, A.END_DATE
, NULL))) PRDED18
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 19
, A.START_DATE
, NULL))) PRDSD19
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 19
, A.END_DATE
, NULL))) PRDED19
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 20
, A.START_DATE
, NULL))) PRDSD20
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 20
, A.END_DATE
, NULL))) PRDED20
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 21
, A.START_DATE
, NULL))) PRDSD21
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 21
, A.END_DATE
, NULL))) PRDED21
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 22
, A.START_DATE
, NULL))) PRDSD22
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 22
, A.END_DATE
, NULL))) PRDED22
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 23
, A.START_DATE
, NULL))) PRDSD23
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 23
, A.END_DATE
, NULL))) PRDED23
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 24
, A.START_DATE
, NULL))) PRDSD24
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 24
, A.END_DATE
, NULL))) PRDED24
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 25
, A.START_DATE
, NULL))) PRDSD25
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 25
, A.END_DATE
, NULL))) PRDED25
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 26
, A.START_DATE
, NULL))) PRDSD26
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 26
, A.END_DATE
, NULL))) PRDED26
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 27
, A.START_DATE
, NULL))) PRDSD27
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 27
, A.END_DATE
, NULL))) PRDED27
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 28
, A.START_DATE
, NULL))) PRDSD28
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 28
, A.END_DATE
, NULL))) PRDED28
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 29
, A.START_DATE
, NULL))) PRDSD29
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 29
, A.END_DATE
, NULL))) PRDED29
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 30
, A.START_DATE
, NULL))) PRDSD30
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 30
, A.END_DATE
, NULL))) PRDED30
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 31
, A.START_DATE
, NULL))) PRDSD31
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 31
, A.END_DATE
, NULL))) PRDED31
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 32
, A.START_DATE
, NULL))) PRDSD32
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 32
, A.END_DATE
, NULL))) PRDED32
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 33
, A.START_DATE
, NULL))) PRDSD33
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 33
, A.END_DATE
, NULL))) PRDED33
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 34
, A.START_DATE
, NULL))) PRDSD34
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 34
, A.END_DATE
, NULL))) PRDED34
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 35
, A.START_DATE
, NULL))) PRDSD35
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 35
, A.END_DATE
, NULL))) PRDED35
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 36
, A.START_DATE
, NULL))) PRDSD36
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 36
, A.END_DATE
, NULL))) PRDED36
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 37
, A.START_DATE
, NULL))) PRDSD37
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 37
, A.END_DATE
, NULL))) PRDED37
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 38
, A.START_DATE
, NULL))) PRDSD38
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 38
, A.END_DATE
, NULL))) PRDED38
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 39
, A.START_DATE
, NULL))) PRDSD39
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 39
, A.END_DATE
, NULL))) PRDED39
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 40
, A.START_DATE
, NULL))) PRDSD40
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 40
, A.END_DATE
, NULL))) PRDED40
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 41
, A.START_DATE
, NULL))) PRDSD41
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 41
, A.END_DATE
, NULL))) PRDED41
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 42
, A.START_DATE
, NULL))) PRDSD42
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 42
, A.END_DATE
, NULL))) PRDED42
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 43
, A.START_DATE
, NULL))) PRDSD43
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 43
, A.END_DATE
, NULL))) PRDED43
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 44
, A.START_DATE
, NULL))) PRDSD44
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 44
, A.END_DATE
, NULL))) PRDED44
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 45
, A.START_DATE
, NULL))) PRDSD45
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 45
, A.END_DATE
, NULL))) PRDED45
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 46
, A.START_DATE
, NULL))) PRDSD46
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 46
, A.END_DATE
, NULL))) PRDED46
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 47
, A.START_DATE
, NULL))) PRDSD47
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 47
, A.END_DATE
, NULL))) PRDED47
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 48
, A.START_DATE
, NULL))) PRDSD48
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 48
, A.END_DATE
, NULL))) PRDED48
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 49
, A.START_DATE
, NULL))) PRDSD49
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 49
, A.END_DATE
, NULL))) PRDED49
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 50
, A.START_DATE
, NULL))) PRDSD50
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 50
, A.END_DATE
, NULL))) PRDED50
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 51
, A.START_DATE
, NULL))) PRDSD51
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 51
, A.END_DATE
, NULL))) PRDED51
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 52
, A.START_DATE
, NULL))) PRDSD52
, MIN((DECODE((A.FROM_ANCHOR_POSITION- B.MIN_ANCHOR +1)
, 52
, A.END_DATE
, NULL))) PRDED52
FROM (SELECT PFO.FIN_PLAN_VERSION_ID BUDGET_VERSION_ID
, PMD.PERIOD_MASK_ID
, GLSD.START_DATE
, GLED.END_DATE
, GLCP.PERIOD_TYPE
, DECODE(GLSD.PERIOD_NAME
, GLED.PERIOD_NAME
, GLED.PERIOD_NAME
, GLSD.PERIOD_NAME ||' TO '||GLED.PERIOD_NAME) PERIOD_NAME
, PMD.FROM_ANCHOR_POSITION FROM_ANCHOR_POSITION
FROM PA_FP_PERIODS_V GLSD
, PA_FP_PERIODS_V GLED
, PA_FP_PERIODS_V GLCP
, PA_PERIOD_MASK_DETAILS PMD
, PA_PROJ_FP_OPTIONS PFO
, PA_PROJECTS_ALL PPA
WHERE PFO.FIN_PLAN_VERSION_ID IS NOT NULL
AND PPA.PROJECT_ID = PFO.PROJECT_ID
AND PMD.PERIOD_MASK_ID=NVL(PFO.COST_PERIOD_MASK_ID
, NVL(REV_PERIOD_MASK_ID
, ALL_PERIOD_MASK_ID))
AND GLCP.PERIOD_NAME=NVL(PFO.COST_CURRENT_PLANNING_PERIOD
, NVL(REV_CURRENT_PLANNING_PERIOD
, ALL_CURRENT_PLANNING_PERIOD))
AND GLCP.ORG_ID = PPA.ORG_ID
AND GLSD.ORG_ID = GLCP.ORG_ID
AND GLED.ORG_ID = GLCP.ORG_ID
AND GLSD.ROW_NUM=PMD.FROM_ANCHOR_START+GLCP.ROW_NUM
AND GLED.ROW_NUM=PMD.FROM_ANCHOR_END+GLCP.ROW_NUM
AND PMD.FROM_ANCHOR_POSITION NOT IN (9999
, -9999)
AND GLCP.PERIOD_TYPE=DECODE(NVL(PFO.COST_TIME_PHASED_CODE
, NVL(PFO.REVENUE_TIME_PHASED_CODE
, PFO.ALL_TIME_PHASED_CODE))
, 'P'
, GLCP.PA_PERIOD_TYPE
, 'G'
, GLCP.ACCOUNTED_PERIOD_TYPE)
AND GLSD.PERIOD_TYPE=GLCP.PERIOD_TYPE
AND GLED.PERIOD_TYPE=GLSD.PERIOD_TYPE) A
, (SELECT PERIOD_MASK_ID
, MIN(FROM_ANCHOR_POSITION) MIN_ANCHOR
FROM PA_PERIOD_MASK_DETAILS PMD2
WHERE PMD2.FROM_ANCHOR_POSITION NOT IN (9999
, -99999) GROUP BY PMD2.PERIOD_MASK_ID ) B
WHERE A.PERIOD_MASK_ID=B.PERIOD_MASK_ID GROUP BY A.BUDGET_VERSION_ID
, A.PERIOD_MASK_ID