APPS.ENI_DBI_COT_PKG SQL Statements

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

Line: 162

				select	null as VIEWBY,
					null as ENI_MEASURE1,
					null as ENI_MEASURE10,
					null as ENI_MEASURE9,
					null as ENI_MEASURE3,
					null as ENI_MEASURE6,
					null as ENI_MEASURE7,
					null as ENI_MEASURE8,
					null as ENI_MEASURE16,
					null as ENI_MEASURE17,
					null as ENI_MEASURE18,
					null as ENI_MEASURE19,
					null as ENI_MEASURE11,
					null as ENI_MEASURE12,
					null as ENI_MEASURE13,
					null as ENI_MEASURE21,
					null as ENI_MEASURE22,
					null as ENI_MEASURE23,
					null as ENI_MEASURE25,
					null as ENI_MEASURE26,
					null as ENI_MEASURE27,
					null as ENI_MEASURE28,
					null as ENI_MEASURE40



				from	dual';

Line: 195

	SELECT
	t.name as VIEWBY,

	SUM(CASE WHEN
			ftrs.report_date = t.c_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END)	as ENI_MEASURE1,

	nvl(SUM(CASE WHEN
			ftrs.report_date = t.c_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	0
		END),0)	as ENI_MEASURE10,

	SUM(CASE WHEN
			ftrs.report_date =t.p_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END)	as ENI_MEASURE9,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	NVL(ftrs.CREATE_TO_APPROVE_SUM,0)
		ELSE	null
		END)
	/
	decode(SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.CREATE_TO_APPROVE_CNT
		ELSE	null
		END),0,1,SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.CREATE_TO_APPROVE_CNT
		ELSE	null
		END))	 as ENI_MEASURE3,



	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	NVL(ftrs.APPROVE_TO_IMPL_SUM,0)
		ELSE	null
		END)
	/
	decode(SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.APPROVE_TO_IMPL_CNT
		ELSE	null
		END),0,1,SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.APPROVE_TO_IMPL_CNT
		ELSE	null
		END))	as ENI_MEASURE6,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.CYCLE_TIME_SUM
		ELSE	null
		END)
	/
	decode(SUM(CASE WHEN
			ftrs.report_date = t.c_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END),0,1,SUM(CASE WHEN
			ftrs.report_date = t.c_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END)) as ENI_MEASURE7,

	SUM(CASE WHEN
			ftrs.report_date =t.p_end_date
		THEN	NVL(ftrs.CYCLE_TIME_SUM,0)
		ELSE	null
		END)
	/
	decode(SUM(CASE WHEN
			ftrs.report_date =t.p_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END),0,1,SUM(CASE WHEN
			ftrs.report_date =t.p_end_date
		THEN	ftrs.IMPLEMENTED_SUM
		ELSE	null
		END)) as ENI_MEASURE8,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.BUCKET1_SUM
		ELSE	null
		END)	as ENI_MEASURE16 ,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.BUCKET2_SUM
		ELSE	null
		END)	as ENI_MEASURE17 ,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.BUCKET3_SUM
		ELSE	null
		END)	as ENI_MEASURE18 ,

	SUM(CASE WHEN
			ftrs.report_date =t.c_end_date
		THEN	ftrs.BUCKET4_SUM
		ELSE	null
		END)	as ENI_MEASURE19,

	SUM(CASE WHEN	ftrs.report_date = t.c_end_date
					and ftrs.priority_level=0
				THEN	ftrs.CYCLE_TIME_SUM
				else 0 end)
					/
			decode(sum( case when ftrs.report_date=t.c_end_date
					and ftrs.priority_level=0
					then ftrs.implemented_sum
					else 0 end ),0,1,sum( case when ftrs.report_date=t.c_end_date
					and ftrs.priority_level=0
					then ftrs.implemented_sum
					else 0 end ))
					as ENI_MEASURE11,

	SUM(CASE WHEN	ftrs.report_date = t.c_end_date
					and ftrs.priority_level=1
				THEN	ftrs.CYCLE_TIME_SUM
				else 0 end)
					/
			decode(sum( case when ftrs.report_date=t.c_end_date
					and ftrs.priority_level=1
					then ftrs.implemented_sum
					else 0 end ),0,1,sum( case when ftrs.report_date=t.c_end_date
					and ftrs.priority_level=1
					then ftrs.implemented_sum
					else 0 end ))
					as ENI_MEASURE12,

	SUM(CASE WHEN	ftrs.report_date = t.c_end_date
					and nvl(ftrs.priority_level,2) <> 0 and nvl(ftrs.priority_level,2) <> 1
				THEN	ftrs.CYCLE_TIME_SUM
				else 0 end)
					/
			decode(sum( case when ftrs.report_date=t.c_end_date
					and nvl(ftrs.priority_level,2) <> 0 and nvl(ftrs.priority_level,2) <> 1
					then ftrs.implemented_sum
					else 0 end ),0,1,sum( case when ftrs.report_date=t.c_end_date
					and  nvl(ftrs.priority_level,2) <> 0 and nvl(ftrs.priority_level,2) <> 1
					then ftrs.implemented_sum
					else 0 end ))
					as ENI_MEASURE13,
			10 as ENI_MEASURE21,
			11 as ENI_MEASURE22,
			12 as ENI_MEASURE23,
			13 as ENI_MEASURE25,
			14 as ENI_MEASURE26,
			15 as ENI_MEASURE27,
			16 as ENI_MEASURE28,
			NULL as ENI_MEASURE40

FROM
	(	SELECT edcs.*,t.c_end_date,t.p_end_date,prio.*,ftrs.report_date
		FROM ENI_DBI_CO_SUM_MV edcs,eni_chg_mgmt_priority_v prio, fii_time_structures ftrs,'||l_from_clause||'
		WHERE
		edcs.status_type is null
		' || l_item_where ||'
		' || l_org_where || '
		' || l_type_where || '
		' || l_priority_where || '
		' || l_reason_where|| '
		' || l_cat_where || '
		and edcs.priority_code is not null
		and prio.id(+)=edcs.priority_code
		and (ftrs.report_date=t.c_end_date  OR ftrs.report_date=t.p_end_date )
	  and edcs.time_id (+) = ftrs.time_id
	  and edcs.period_type_id (+) = ftrs.period_type_id
	  and bitand(ftrs.record_type_id,:PERIODAND) = :PERIODAND --Bug 5083882
	) ftrs,'||l_from_clause||'
	WHERE ftrs.c_end_date(+) = t.c_end_date
GROUP BY
	t.name,t.start_date,t.c_end_date
ORDER BY
	'||l_order_by;