APPS.ENI_DBI_COC_PKG SQL Statements

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

Line: 210

				'SELECT
					NULL AS VIEWBY,
					NULL AS ENI_MEASURE50,
					NULL AS ENI_MEASURE1,
					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_MEASURE51,
					NULL AS ENI_MEASURE52,
					NULL AS ENI_MEASURE53,
					NULL AS ENI_MEASURE54,
					NULL AS ENI_MEASURE55,
					NULL AS ENI_MEASURE56,
					NULL AS ENI_MEASURE57,
					NULL AS ENI_MEASURE58,
					NULL AS ENI_MEASURE59,
					NULL AS ENI_MEASURE60,
					NULL AS ENI_MEASURE62
				FROM
					DUAL';

Line: 243

		SELECT
			 t.VALUE as VIEWBY
			,ENI_MEASURE50
			,t.id as VIEWBYID
			,ENI_MEASURE1
			,ENI_MEASURE9
			,ENI_MEASURE93/DECODE(ENI_MEASURE89,0,NULL,ENI_MEASURE89) as ENI_MEASURE3
			,ENI_MEASURE96/DECODE(ENI_MEASURE88,0,NULL,ENI_MEASURE88) as ENI_MEASURE6
			,ENI_MEASURE97/DECODE(ENI_MEASURE1,0,NULL,ENI_MEASURE1) as ENI_MEASURE7
			,ENI_MEASURE98/DECODE(ENI_MEASURE9,0,NULL,ENI_MEASURE9) as ENI_MEASURE8
			,ENI_MEASURE16
			,ENI_MEASURE17
			,ENI_MEASURE18
			,ENI_MEASURE19';

Line: 327

			SELECT
			edcs.VALUE as VALUE
			,edcs.ID as ID
			,ENI_MEASURE50
			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	edcs.IMPLEMENTED_SUM
			ELSE	null
			END)	as ENI_MEASURE1

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_PREVIOUS_ASOF_DATE
			THEN	edcs.IMPLEMENTED_SUM
			ELSE	null
			END)	as ENI_MEASURE9

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	NVL(edcs.CREATE_TO_APPROVE_SUM,0)
			ELSE	null
			END)	as ENI_MEASURE93

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	NVL(edcs.CREATE_TO_APPROVE_CNT,0)
			ELSE	null
			END)	as ENI_MEASURE89

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	NVL(edcs.APPROVE_TO_IMPL_SUM,0)
			ELSE	null
			END)	as ENI_MEASURE96

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	NVL(edcs.APPROVE_TO_IMPL_CNT,0)
			ELSE	null
			END)	as ENI_MEASURE88

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	NVL(edcs.CYCLE_TIME_SUM,0)
			ELSE	null
			END)	as ENI_MEASURE97

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_PREVIOUS_ASOF_DATE
			THEN	NVL(edcs.CYCLE_TIME_SUM,0)
			ELSE	null
			END)	as ENI_MEASURE98

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	edcs.BUCKET1_SUM
			ELSE	null
			END)	as ENI_MEASURE16

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	edcs.BUCKET2_SUM
			ELSE	null
			END)	as ENI_MEASURE17

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	edcs.BUCKET3_SUM
			ELSE	null
			END)	as ENI_MEASURE18

			,SUM(CASE WHEN
				ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
			THEN	edcs.BUCKET4_SUM
			ELSE	null
			END)	as ENI_MEASURE19
			FROM
			(SELECT edcs.IMPLEMENTED_SUM
					,edcs.TIME_ID
					,edcs.PERIOD_TYPE_ID
					,edcs.CREATE_TO_APPROVE_SUM
					,edcs.CREATE_TO_APPROVE_CNT
					,edcs.APPROVE_TO_IMPL_SUM
					,edcs.APPROVE_TO_IMPL_CNT
					,edcs.CYCLE_TIME_SUM
					,edcs.BUCKET1_SUM
					,edcs.BUCKET2_SUM
					,edcs.BUCKET3_SUM
					,edcs.BUCKET4_SUM
					,eiv.value
					,eiv.id
					,'||l_description || '
						from ENI_DBI_CO_SUM_MV edcs
						' || l_lookup_from || '
					where 1=1
						' || l_item_where ||'
						' || l_org_where || '
						' || l_cat_where || '
						' || l_lookup_outer_where || '
				) edcs
				, fii_time_structures ftrs
				WHERE 1=1
					AND
					(
						ftrs.report_date = '|| '&' ||'BIS_CURRENT_ASOF_DATE
						OR
						ftrs.report_date  = '|| '&' ||'BIS_PREVIOUS_ASOF_DATE
					 )
					AND edcs.implemented_sum is not null
					AND edcs.time_id  = ftrs.time_id
					AND edcs.period_type_id  = ftrs.period_type_id
					AND BITAND(ftrs.record_type_id, :PERIOD ) =  :PERIOD
					GROUP BY
					edcs.value, edcs.id,ENI_MEASURE50
		) t
		GROUP BY
			t.VALUE,t.id,ENI_MEASURE1,ENI_MEASURE9,
			ENI_MEASURE89,ENI_MEASURE88,
			ENI_MEASURE16,ENI_MEASURE17,ENI_MEASURE18,ENI_MEASURE19,
			ENI_MEASURE93,ENI_MEASURE96,ENI_MEASURE97,ENI_MEASURE98,
			ENI_MEASURE50
		ORDER BY
			' ||l_order_by ;