APPS.FII_EA_PAGE_PKG SQL Statements

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

Line: 116

   SELECT DECODE(fii_ea_util_pkg.g_region_code,'FII_EA_PAGE','FII_EA_EXP_SUM','FII_EA_EXP_BY_COMP_PORT','FII_EA_EXP_SUM','FII_PSI_EXP_SUM')
     INTO l_drill_source
     FROM DUAL;

Line: 121

	SELECT  DECODE(:G_ID, inline_view.viewby_id,DECODE('''||l_if_leaf_flag||''',''Y'',
									inline_view.viewby, inline_view.viewby||'' ''||:DIR_MSG),
			inline_view.viewby) VIEWBY,
			inline_view.viewby_id			VIEWBYID,
			SUM(FII_EA_PRIOR_XTD_EXP_G)		FII_EA_PRIOR_XTD_EXP_G,
			SUM(FII_EA_PRIOR_TOTAL_G)		FII_EA_PRIOR_TOTAL_G,
			SUM(FII_EA_XTD_EXP)                     FII_EA_XTD_EXP,
			NULL					FII_EA_CURR_TOTAL_G,
			SUM(FII_EA_PRIOR_XTD_EXP)		FII_EA_PRIOR_XTD_EXP,
			'||l_change||'
			SUM(FII_EA_BUDGET)			FII_EA_BUDGET,
			SUM(FII_EA_FORECAST)			FII_EA_FORECAST,
			SUM(SUM(FII_EA_XTD_EXP)) OVER ()        FII_EA_GT_XTD_EXP,
			SUM(SUM(FII_EA_PRIOR_XTD_EXP)) OVER ()  FII_EA_GT_PRIOR_XTD_EXP,
			'||l_gt_change||'
			SUM(SUM(FII_EA_BUDGET)) OVER ()         FII_EA_GT_BUDGET,
			SUM(SUM(FII_EA_XTD_EXP)) OVER () /
			   NULLIF(SUM(SUM(FII_EA_BUDGET)) OVER (),0) * 100 FII_EA_GT_PCNT_BUDGET,
			SUM(SUM(FII_EA_FORECAST)) OVER ()        	   FII_EA_GT_FORECAST,
			SUM(SUM(FII_EA_XTD_EXP)) OVER () /
				NULLIF(SUM(SUM(FII_EA_FORECAST)) OVER (),0) * 100 FII_EA_GT_PCNT_FORECAST,

			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='||l_drill_source||'&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')	FII_EA_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='||l_drill_source||'&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')	FII_EA_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='||l_drill_source||'&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')) FII_EA_CAT_DRILL,

			DECODE(SUM(FII_EA_XTD_EXP),0,'''',DECODE(NVL(SUM(FII_EA_XTD_EXP),-999999),-999999,'''','''||l_xtd_drill_url||''')) FII_EA_XTD_DRILL,
			DECODE(SUM(FII_EA_XTD_EXP),0,'''',DECODE(NVL(SUM(FII_EA_XTD_EXP),-999999),-999999,'''','''||l_xtd_drill_url||''')) FII_EA_XTD_PIE_DRILL

	FROM
	      (
			SELECT	'||p_aggrt_viewby_id||'     viewby_id,
		       		inner_inline_view.viewby viewby,
				inner_inline_view.sort_order sort_order,
				'||l_prior_g||',
				SUM(DECODE(inner_inline_view.report_date, :PRIOR_PERIOD_END,
				(CASE	WHEN bitand(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
					THEN f.actual_g  ELSE NULL END)))   FII_EA_PRIOR_TOTAL_G,
				SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
					(CASE	WHEN bitand(inner_inline_view.record_type_id,:ACTUAL_BITAND) = :ACTUAL_BITAND
					THEN f.actual_g  ELSE NULL END)))   FII_EA_XTD_EXP,
				'||l_prior||',
				SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
					(CASE	WHEN bitand(inner_inline_view.record_type_id,:BUDGET_BITAND) = :BUDGET_BITAND
						THEN f.budget_g  ELSE NULL END) ) )   FII_EA_BUDGET,
				SUM(DECODE(inner_inline_view.report_date, :ASOF_DATE,
					(CASE	WHEN bitand(inner_inline_view.record_type_id,:FORECAST_BITAND) = :FORECAST_BITAND
						THEN f.forecast_g  ELSE NULL END) ) )   FII_EA_FORECAST

			FROM	fii_gl_trend_sum_mv'||fii_ea_util_pkg.g_curr_view||' f,
				( SELECT 	/*+ NO_MERGE cardinality(gt 1) */ *
				  FROM 		fii_time_structures cal,
 						fii_pmv_aggrt_gt gt
				  WHERE		report_date in (:ASOF_DATE, :PREVIOUS_ASOF_DATE, :PRIOR_PERIOD_END)
						AND (	BITAND(cal.record_type_id, :ACTUAL_BITAND) = :ACTUAL_BITAND OR
							BITAND(cal.record_type_id, :BUDGET_BITAND) = :BUDGET_BITAND OR
							BITAND(cal.record_type_id, :FORECAST_BITAND) = :FORECAST_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
				'||l_budget_decode||'

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

		) 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_EA_XTD_EXP, -999999999) DESC';