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.

APPS.FII_PSI_BUD_SUM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 62


 	SELECT  ent_year_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 70


 	SELECT  ent_qtr_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 77


 	SELECT  ent_period_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 113


	SELECT  dbi_enabled_flag INTO l_fud2_enabled_flag
	FROM    fii_financial_dimensions
	WHERE   dimension_short_name = 'FII_USER_DEFINED_2';

Line: 151


	SELECT	/*+ index(f fii_gl_agrt_sum_mv_n1) */
		'||p_aggrt_viewby_id||'   	viewby_id,
		inner_inline_view.viewby 	viewby,
		inner_inline_view.sort_order 	sort_order,
		SUM(DECODE(inner_inline_view.report_date,   :PREVIOUS_THREE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   	FII_PSI_HIST_COL1,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_TWO_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   	FII_PSI_HIST_COL2,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_ONE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL3,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL4,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_XTD,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_PRIOR,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.baseline_budget_g  ELSE NULL END) ) )   FII_PSI_ORIGINAL
	FROM	fii_gl_agrt_sum_mv_p_v f,
		'||l_fud2_from||'
 		( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
		  FROM 	fii_time_structures cal,
			fii_pmv_aggrt_gt gt
		  WHERE report_date in (:PREVIOUS_THREE_END_DATE,:PREVIOUS_TWO_END_DATE,
 					:PREVIOUS_ONE_END_DATE,:BUD_ASOF_DATE, :PREVIOUS_BUD_ASOF_DATE)
			AND (	BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND OR
				BITAND(cal.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND)
		) inner_inline_view

	WHERE 	f.time_id = inner_inline_view.time_id
		AND f.period_type_id = inner_inline_view.period_type_id
		AND f.parent_company_id = inner_inline_view.parent_company_id
		AND f.company_id = inner_inline_view.company_id
		AND f.parent_cost_center_id = inner_inline_view.parent_cc_id
		AND f.cost_center_id = inner_inline_view.cc_id
		AND f.parent_fin_category_id = inner_inline_view.parent_fin_category_id
		AND f.fin_category_id = inner_inline_view.fin_category_id
		AND f.parent_fud1_id = inner_inline_view.parent_fud1_id
		AND f.fud1_id = inner_inline_view.fud1_id
	 	'||l_fud2_where||'

      GROUP BY  '||p_aggrt_viewby_id||',
		inner_inline_view.viewby,
		inner_inline_view.sort_order ';

Line: 208


	SELECT   /*+ index(f fii_gl_base_map_mv_n1) */
		'||p_nonaggrt_viewby_id||'     viewby_id,
		inner_inline_view.viewby viewby,
		inner_inline_view.sort_order sort_order,
		SUM(DECODE(inner_inline_view.report_date,   :PREVIOUS_THREE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL1,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_TWO_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   	FII_PSI_HIST_COL2,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_ONE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL3,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL4,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_XTD,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
			  	THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_PRIOR,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.baseline_budget_g  ELSE NULL END) ) )   FII_PSI_ORIGINAL
	FROM	fii_gl_base_map_mv_p_v f,
		fii_company_hierarchies co_hier,
		fii_cost_ctr_hierarchies cc_hier,
		fii_fin_item_leaf_hiers fin_hier,
		fii_udd1_hierarchies fud1_hier,
 		'||l_fud2_from||'
		( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
		  FROM 	fii_time_structures cal,
 			fii_pmv_non_aggrt_gt gt
		  WHERE report_date in (:PREVIOUS_THREE_END_DATE, :PREVIOUS_TWO_END_DATE,
					:PREVIOUS_ONE_END_DATE, :BUD_ASOF_DATE,	:PREVIOUS_BUD_ASOF_DATE)
			AND ( BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND OR
			      BITAND(cal.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND)
		) inner_inline_view

	WHERE 	f.period_type_id = inner_inline_view.period_type_id
		AND f.time_id = inner_inline_view.time_id
	        AND f.company_id = co_hier.child_company_id
		AND f.cost_center_id = cc_hier.child_cc_id
		AND f.fin_category_id = fin_hier.child_fin_cat_id
		'||l_cat_decode||'
		'||l_fud1_decode||'
		AND f.fud1_id = fud1_hier.child_value_id
		AND co_hier.parent_company_id = inner_inline_view.company_id
		AND cc_hier.parent_cc_id = inner_inline_view.cost_center_id
		AND fin_hier.parent_fin_cat_id = inner_inline_view.fin_category_id
		AND fud1_hier.parent_value_id = inner_inline_view.fud1_id
 		'||l_fud2_where||'
      GROUP BY 	'||p_nonaggrt_viewby_id||',
		inner_inline_view.viewby,
		inner_inline_view.sort_order ';

Line: 269


	SELECT	'||p_aggrt_viewby_id||'   	viewby_id,
		inner_inline_view.viewby 	viewby,
		inner_inline_view.sort_order 	sort_order,
		SUM(DECODE(inner_inline_view.report_date,   :PREVIOUS_THREE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   	FII_PSI_HIST_COL1,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_TWO_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   	FII_PSI_HIST_COL2,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_ONE_END_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL3,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_HIST_COL4,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_XTD,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.budget_g  ELSE NULL END) ) )   FII_PSI_PRIOR,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE,
			(CASE	WHEN BITAND(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
				THEN f.baseline_budget_g  ELSE NULL END) ) )   FII_PSI_ORIGINAL
	FROM	fii_gl_trend_sum_mv_p_v f,
 		( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
		  FROM 	fii_time_structures cal,
			fii_pmv_aggrt_gt gt
		  WHERE report_date in (:PREVIOUS_THREE_END_DATE,:PREVIOUS_TWO_END_DATE,
 					:PREVIOUS_ONE_END_DATE,:BUD_ASOF_DATE, :PREVIOUS_BUD_ASOF_DATE)
			AND (	BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND OR
				BITAND(cal.record_type_id,:HIST_ACTUAL_BITAND) = :HIST_ACTUAL_BITAND)
		) inner_inline_view

	WHERE 	f.time_id = inner_inline_view.time_id
		AND f.period_type_id = inner_inline_view.period_type_id
		AND f.parent_company_id = inner_inline_view.parent_company_id
		AND f.company_id = inner_inline_view.company_id
		AND f.parent_cost_center_id = inner_inline_view.parent_cc_id
		AND f.cost_center_id = inner_inline_view.cc_id
		AND f.parent_fin_category_id = inner_inline_view.parent_fin_category_id
		AND f.fin_category_id = inner_inline_view.fin_category_id

      GROUP BY  '||p_aggrt_viewby_id||',
		inner_inline_view.viewby,
		inner_inline_view.sort_order ';

Line: 340


 sqlstmt :=' SELECT
	inline_view.viewby              VIEWBY,
	inline_view.viewby_id		VIEWBYID,
	SUM(FII_PSI_XTD)       		FII_PSI_XTD,
	SUM(FII_PSI_PRIOR)	 	FII_PSI_PRIOR,
	SUM(FII_PSI_ORIGINAL)         	FII_PSI_ORIGINAL,
	SUM(FII_PSI_HIST_COL1)			FII_PSI_HIST_COL1,
	SUM(FII_PSI_HIST_COL2)			FII_PSI_HIST_COL2,
	SUM(FII_PSI_HIST_COL3)			FII_PSI_HIST_COL3,
	SUM(FII_PSI_HIST_COL4)			FII_PSI_HIST_COL4,
        DECODE(SUM(FII_PSI_XTD), 0, NULL, NULL, NULL, '''|| l_xtd_drill_url||''') FII_PSI_XTD_DRILL,
	SUM(SUM(FII_PSI_XTD)) OVER ()       FII_PSI_GT_XTD,
	SUM(SUM(FII_PSI_PRIOR)) OVER () FII_PSI_GT_PRIOR,
	SUM(SUM(FII_PSI_ORIGINAL)) OVER ()       FII_PSI_GT_ORIGINAL,
	(SUM(SUM(FII_PSI_XTD)) over() - SUM(SUM(FII_PSI_PRIOR)) over()) / ABS(NULLIF(SUM(SUM(FII_PSI_PRIOR)) over(),0)) * 100  FII_PSI_GT_PCNT_CHANGE,
	SUM(SUM(FII_PSI_HIST_COL1)) OVER ()  FII_PSI_GT_HIST_COL1,
	SUM(SUM(FII_PSI_HIST_COL2)) OVER ()  FII_PSI_GT_HIST_COL2,
	SUM(SUM(FII_PSI_HIST_COL3)) OVER ()  FII_PSI_GT_HIST_COL3,
	SUM(SUM(FII_PSI_HIST_COL4)) OVER () FII_PSI_GT_HIST_COL4,
	DECODE((SELECT  is_leaf_flag
		FROM    fii_company_hierarchies
		WHERE	parent_company_id = inline_view.viewby_id
			AND child_company_id = inline_view.viewby_id),
			''Y'',
			'''',
			''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FII_COMPANIES+FII_COMPANIES&pParamIds=Y'') 	FII_PSI_COMP_DRILL,
	DECODE((SELECT  is_leaf_flag
		FROM    fii_cost_ctr_hierarchies
		WHERE	parent_cc_id = inline_view.viewby_id
			AND child_cc_id = inline_view.viewby_id),
			''Y'',
			'''',
			''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ORGANIZATION+HRI_CL_ORGCC&pParamIds=Y'')	FII_PSI_CC_DRILL,
	DECODE((SELECT  is_leaf_flag
		FROM    fii_fin_item_leaf_hiers
		WHERE	parent_fin_cat_id = inline_view.viewby_id
			AND child_fin_cat_id = inline_view.viewby_id),
			''Y'',
			'''',
 			DECODE(:G_ID, inline_view.viewby_id,'''',
			''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FINANCIAL ITEM+GL_FII_FIN_ITEM&pParamIds=Y''))	FII_PSI_CAT_DRILL,
	DECODE((SELECT  is_leaf_flag
		FROM    fii_udd1_hierarchies
		WHERE	parent_value_id = inline_view.viewby_id
			AND child_value_id = inline_view.viewby_id),
			''Y'',
			'''',
		 	DECODE(:G_ID, inline_view.viewby_id,'''',
			''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FII_USER_DEFINED+FII_USER_DEFINED_1&pParamIds=Y''))	FII_PSI_PROJECT_DRILL,
	DECODE((SELECT  is_leaf_flag
		FROM    fii_udd2_hierarchies
		WHERE	parent_value_id = inline_view.viewby_id
			AND child_value_id = inline_view.viewby_id),
			''Y'',
			'''',
			''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FII_USER_DEFINED+FII_USER_DEFINED_2&pParamIds=Y'')	FII_PSI_UD2_DRILL
FROM
	(
			'||l_aggrt_sql||'
			'||l_union_all||'
			'||l_non_aggrt_sql||'
		) inline_view
GROUP BY	inline_view.viewby, inline_view.viewby_id, inline_view.sort_order
ORDER BY 	NVL(inline_view.sort_order,999999) asc,
 		NVL(FII_PSI_XTD, -999999999) desc  ';

Line: 471


 	SELECT  ent_year_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 479


 	SELECT  ent_qtr_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 487


 	SELECT  ent_period_id into l_time_id
        FROM    fii_time_ent_period per
        WHERE   fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

Line: 523


	SELECT  dbi_enabled_flag INTO l_fud2_enabled_flag
	FROM    fii_financial_dimensions
	WHERE   dimension_short_name = 'FII_USER_DEFINED_2';

Line: 561


	SELECT	/*+ index(f fii_gl_agrt_sum_mv_n1) */
		'||p_aggrt_viewby_id||'   	viewby_id,
		inner_inline_view.viewby 	viewby,
		inner_inline_view.sort_order 	sort_order,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.budget_g))   FII_PSI_XTD,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE, f.budget_g))   FII_PSI_PRIOR,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.baseline_budget_g))   FII_PSI_ORIGINAL

	FROM	fii_gl_agrt_sum_mv_p_v f,
  		'||l_fud2_from||'
		( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
		  FROM 	fii_time_structures cal, fii_pmv_aggrt_gt gt
		  WHERE report_date in (:BUD_ASOF_DATE, :PREVIOUS_BUD_ASOF_DATE)
			AND ( BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND)
		) inner_inline_view

	WHERE 	f.time_id = inner_inline_view.time_id
		AND f.period_type_id = inner_inline_view.period_type_id
		AND f.parent_company_id = inner_inline_view.parent_company_id
		AND f.company_id = inner_inline_view.company_id
		AND f.parent_cost_center_id = inner_inline_view.parent_cc_id
		AND f.cost_center_id = inner_inline_view.cc_id
		AND f.parent_fin_category_id = inner_inline_view.parent_fin_category_id
		AND f.fin_category_id = inner_inline_view.fin_category_id
		AND f.parent_fud1_id = inner_inline_view.parent_fud1_id
		AND f.fud1_id = inner_inline_view.fud1_id
  		'||l_fud2_where||'

     GROUP BY	'||p_aggrt_viewby_id||',
		inner_inline_view.viewby,
		inner_inline_view.sort_order ';

Line: 598


	SELECT   /*+ index(f fii_gl_base_map_mv_n1) */
		'||p_nonaggrt_viewby_id||'     viewby_id,
		inner_inline_view.viewby viewby,
		inner_inline_view.sort_order sort_order,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.budget_g))   FII_PSI_XTD,
		SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE, f.budget_g))   FII_PSI_PRIOR,
		SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.baseline_budget_g))   FII_PSI_ORIGINAL

	FROM	fii_gl_base_map_mv_p_v f,
		fii_company_hierarchies co_hier,
		fii_cost_ctr_hierarchies cc_hier,
		fii_fin_item_leaf_hiers fin_hier,
		fii_udd1_hierarchies fud1_hier,
 		'||l_fud2_from||'
		( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
		  FROM	fii_time_structures cal,
 			fii_pmv_non_aggrt_gt gt
		 WHERE 	report_date in (:BUD_ASOF_DATE, :PREVIOUS_BUD_ASOF_DATE)
			AND ( BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND)
		) inner_inline_view

	WHERE 	f.period_type_id = inner_inline_view.period_type_id
		AND f.time_id = inner_inline_view.time_id
	        AND f.company_id = co_hier.child_company_id
		AND f.cost_center_id = cc_hier.child_cc_id
		AND f.fin_category_id = fin_hier.child_fin_cat_id
		'||l_cat_decode||'
		'||l_fud1_decode||'
		AND f.fud1_id = fud1_hier.child_value_id
		AND co_hier.parent_company_id = inner_inline_view.company_id
		AND cc_hier.parent_cc_id = inner_inline_view.cost_center_id
		AND fin_hier.parent_fin_cat_id = inner_inline_view.fin_category_id
		AND fud1_hier.parent_value_id = inner_inline_view.fud1_id
 		'||l_fud2_where||'

     GROUP BY 	'||p_nonaggrt_viewby_id||',
		inner_inline_view.viewby,
		inner_inline_view.sort_order ';

Line: 638


			SELECT	'||p_aggrt_viewby_id||'     viewby_id,
		       		inner_inline_view.viewby viewby,
				inner_inline_view.sort_order sort_order,
				SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.budget_g))   FII_PSI_XTD,
				SUM(DECODE(inner_inline_view.report_date, :PREVIOUS_BUD_ASOF_DATE, f.budget_g))   FII_PSI_PRIOR,
				SUM(DECODE(inner_inline_view.report_date, :BUD_ASOF_DATE, f.baseline_budget_g))   FII_PSI_ORIGINAL

			FROM	fii_gl_trend_sum_mv_p_v f,
				( SELECT /*+ NO_MERGE cardinality(gt 1) */ *
				  FROM 	  fii_time_structures cal,
 					  fii_pmv_aggrt_gt gt
				   WHERE  report_date in (:BUD_ASOF_DATE, :PREVIOUS_BUD_ASOF_DATE)
					  AND ( BITAND(cal.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND )
				) inner_inline_view

			WHERE 	f.time_id = inner_inline_view.time_id
				AND f.period_type_id = inner_inline_view.period_type_id
		                AND f.parent_company_id = inner_inline_view.parent_company_id
                                AND f.company_id = inner_inline_view.company_id
                                AND f.parent_cost_center_id = inner_inline_view.parent_cc_id
                                AND f.cost_center_id = inner_inline_view.cc_id
                                AND f.parent_fin_category_id = inner_inline_view.parent_fin_category_id
		                AND f.fin_category_id = inner_inline_view.fin_category_id

			GROUP BY '||p_aggrt_viewby_id||', inner_inline_view.viewby, inner_inline_view.sort_order';

Line: 686


	SELECT  inline_view.viewby              VIEWBY,
		inline_view.viewby_id			VIEWBYID,
		SUM(FII_PSI_XTD)       		FII_PSI_XTD,
		SUM(FII_PSI_PRIOR)	 	FII_PSI_PRIOR,
		SUM(FII_PSI_ORIGINAL)           FII_PSI_ORIGINAL,
		DECODE(SUM(FII_PSI_XTD), 0, NULL, NULL, NULL, '''|| l_xtd_drill_url||''') FII_PSI_XTD_DRILL,
		SUM(SUM(FII_PSI_XTD)) OVER ()       	FII_PSI_GT_XTD,
		SUM(SUM(FII_PSI_PRIOR)) OVER () 	FII_PSI_GT_PRIOR,
		SUM(SUM(FII_PSI_ORIGINAL)) OVER ()      FII_PSI_GT_ORIGINAL,
		(SUM(SUM(FII_PSI_XTD)) over() - SUM(SUM(FII_PSI_PRIOR)) OVER()) / ABS(NULLIF(SUM(SUM(FII_PSI_PRIOR)) over(),0)) * 100  FII_PSI_GT_PCNT_CHANGE,
		DECODE((SELECT  is_leaf_flag
			FROM    fii_company_hierarchies
			WHERE   parent_company_id = inline_view.viewby_id
				AND child_company_id = inline_view.viewby_id),
				''Y'',
				'''',
				''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FII_COMPANIES+FII_COMPANIES&pParamIds=Y'') FII_PSI_COMP_DRILL,
		DECODE((SELECT  is_leaf_flag
			FROM    fii_fin_item_leaf_hiers
			WHERE	parent_fin_cat_id = inline_view.viewby_id
				AND child_fin_cat_id = inline_view.viewby_id),
				''Y'',
				'''',
 				DECODE(:G_ID, inline_view.viewby_id,'''',
				''pFunctionName=FII_PSI_BUDGET_SUM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=FINANCIAL ITEM+GL_FII_FIN_ITEM&pParamIds=Y''))	FII_PSI_CAT_DRILL
	FROM
		(
			'||l_aggrt_sql||'
			'||l_union_all||'
			'||l_non_aggrt_sql||'
		) inline_view

	GROUP BY	inline_view.viewby, inline_view.viewby_id, inline_view.sort_order
	ORDER BY 	NVL(inline_view.sort_order,-999999) asc,
 			NVL(FII_PSI_XTD, -999999999) desc  ';