[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_view_by_select VARCHAR2(500) ;
, p_view_by_select => l_view_by_select
, p_view_by => l_view_by
);
SELECT meaning BIX_PMV_AI_OUTCOME,
sum(pper) BIX_PMV_AI_PPER,
sum(cper) BIX_PMV_AI_CPER
FROM (
SELECT lookup.meaning meaning,
nvl(sum(decode(cal.report_date,&BIS_PREVIOUS_ASOF_DATE,
decode(lookup.lookup_code,
''SR'', AGENT_SR_CREATED,
''LEAD'', AGENT_LEADS_CREATED,
''OPP'', AGENT_OPPORTUNITIES_CREATED,
0),
0)),0) PPER,
nvl(sum(decode(cal.report_date,&BIS_CURRENT_ASOF_DATE,
decode(lookup.lookup_code,
''SR'', AGENT_SR_CREATED,
''LEAD'', AGENT_LEADS_CREATED,
''OPP'', AGENT_OPPORTUNITIES_CREATED,
0),
0)),0) CPER
FROM bix_ai_call_details_mv fact,
fii_time_rpt_struct cal,
(
select lookup_code,meaning
from fnd_lookup_values_vl
where lookup_type = :l_lookup_type
) lookup
WHERE fact.time_id = cal.time_id
AND fact.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 '
;