APPS.ENI_DBI_PMS_KPI_PKG SQL Statements

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

Line: 119

		SELECT
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				then
					fars.rev_prim_actual_g
				else
					0
				end
			) AS ENI_MEASURE1,
			SUM
			(
				case
					when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
				then
					fars.rev_prim_actual_g
				else
					0
				end
			) AS ENI_MEASURE2,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				then
					fars.cogs_value_g
				else
					0
				end
			) AS ENI_MEASURE5,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
				then
					fars.cogs_value_g
				else
					0
				end
			) AS ENI_MEASURE6,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				then
					fars.prim_actual_g
				else
					0
				end
			) AS ENI_MEASURE7,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
				then
					fars.prim_actual_g
				else
					0
				end
			) AS ENI_MEASURE8,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				then
					((fars.rev_prim_actual_g - (cogs_value_g + prim_actual_g))
					/decode(fars.rev_prim_actual_g, 0, null, fars.rev_prim_actual_g))*100
				else
					0
				end
			) AS ENI_MEASURE9,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
				then
					((fars.rev_prim_actual_g - (cogs_value_g + prim_actual_g))
					/decode(fars.rev_prim_actual_g, 0, null, fars.rev_prim_actual_g))*100
				else
					0
				end
			) AS ENI_MEASURE10,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				then
					fars.inv_total_value_g
				else
					0
				end
			) AS ENI_MEASURE11,
			SUM
			(
				case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
				then
					fars.inv_total_value_g
				else
					0
				end
			) AS ENI_MEASURE12
		FROM
			eni_dbi_prc_sum_c_mv fars,
			fii_time_rpt_struct ftrs
		WHERE
			fars.time_id = ftrs.time_id
			AND
			(
				ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
				OR ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
			)
			--AND BITAND(ftrs.record_type_id, ' || l_period_bitand || ') = ftrs.record_type_id
			AND BITAND(ftrs.record_type_id,:PERIODAND) = ftrs.record_type_id                 --Bug 5083911
			' || l_where_clause;