[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_source_code_where_clause := ' AND mv.campaign_id in (select source_code_for_id from
ams_source_codes where source_code_id IN (:l_source_code_id) and arc_source_code_for=''CAMP'' and active_flag=''Y'') ';
SELECT meaning BIX_PMV_AO_OUTCOME,
sum(pper) BIX_PMV_AO_PPER,
sum(cper) BIX_PMV_AO_CPER
FROM (
SELECT lookup.meaning meaning,
nvl(sum(decode(cal.report_date,&BIS_PREVIOUS_ASOF_DATE,
decode(lookup.lookup_code,
''PR'', AGENTCALL_PR_COUNT,
''TR'', AGENTCALL_ORR_COUNT,
0),
0)),0) PPER,
nvl(sum(decode(cal.report_date,&BIS_CURRENT_ASOF_DATE,
decode(lookup.lookup_code,
''PR'', AGENTCALL_PR_COUNT,
''TR'', AGENTCALL_ORR_COUNT,
0),
0)),0) CPER
FROM bix_ao_call_details_mv mv,
fii_time_rpt_struct cal,
(
select lookup_code,meaning
from fnd_lookup_values_vl
where lookup_type = :l_lookup_type
)
lookup
WHERE mv.time_id = cal.time_id
AND mv.row_type = :l_row_type
AND mv.period_type_id = cal.period_type_id
AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN) =
cal.record_type_id
AND cal.report_date IN (&BIS_CURRENT_ASOF_DATE,
&BIS_PREVIOUS_ASOF_DATE) ';
select meaning,0,0
from fnd_lookup_values_vl
where lookup_type = :l_lookup_type )
)
GROUP BY meaning '
;