APPS.FII_AR_OPEN_REC_PDUE SQL Statements

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

Line: 19

l_select		VARCHAR2(10000);

Line: 24

l_party_select		VARCHAR2(50);

Line: 54

l_party_select := ' ';

Line: 99

	l_party_select := ' t.party_id party_id, ';

Line: 142

l_select :=
' SELECT  inline_view.viewby  viewby,
viewby_id    VIEWBYID,
(FII_AR_PRIOR_PDUE_REC/NULLIF(abs(FII_AR_PRIOR_OPEN_REC),0))*100 FII_AR_PERC_PRIOR_OPEN_REC,
(FII_AR_PDUE_REC/NULLIF(abs(FII_AR_OPEN_REC),0))*100 FII_AR_PERC_OPEN_REC_G,
(FII_AR_PDUE_REC/NULLIF(abs(FII_AR_OPEN_REC),0))*100 FII_AR_PERC_OPEN_REC,
FII_AR_PDUE_REC,
FII_AR_OPEN_REC,
FII_AR_PRIOR_PDUE_REC,
FII_AR_PRIOR_OPEN_REC,
'||l_open_rec_drill||' FII_AR_OPEN_REC_DRILL,
'||l_past_due_rec_drill||' FII_AR_PDUE_REC_DRILL,
'||l_cust_self_drill||' FII_AR_CUST_SELF_DRILL,
SUM(FII_AR_PDUE_REC) over() FII_AR_PDUE_REC_GT,
SUM(FII_AR_OPEN_REC) over() FII_AR_OPEN_REC_GT,
CASE WHEN SUM(FII_AR_OPEN_REC) over() = 0 THEN NULL
ELSE (SUM(FII_AR_PDUE_REC) over()/SUM(FII_AR_OPEN_REC) over()) *100 END FII_AR_PERC_OPEN_REC_GT
FROM (
SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
t.is_leaf_flag,
'||l_self||'
t.viewby viewby,
viewby_code viewby_id ,
'||l_party_select||'
SUM(DECODE(t.report_date, :ASOF_DATE , past_due_open_amount , NULL ) )   FII_AR_PDUE_REC,
SUM(DECODE(t.report_date, :ASOF_DATE, total_open_amount, NULL ) )   FII_AR_OPEN_REC,
SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, past_due_open_amount, NULL ) )   FII_AR_PRIOR_PDUE_REC,
SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, total_open_amount, NULL ) )   FII_AR_PRIOR_OPEN_REC
FROM FII_AR_NET_REC'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
( SELECT  /*+ no_merge '||l_gt_hint|| ' */ *
	FROM 	fii_time_structures cal, '||fii_ar_util_pkg.get_from_statement||' gt
	WHERE report_date in (:ASOF_DATE,  :PREVIOUS_ASOF_DATE)
	AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
	AND '  ||fii_ar_util_pkg.get_where_statement||' ) t
WHERE  f.time_id = t.time_id
AND f.period_type_id = t.period_type_id
AND f.org_id = t.org_id
AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_parent_party_where||l_party_where||l_collector_where|| l_cust_acct_where||'
GROUP BY '||l_self||' t.is_leaf_flag, t.viewby, viewby_code'||l_party_groupby||')  inline_view
GROUP BY '||l_group_by||', FII_AR_OPEN_REC,FII_AR_PDUE_REC, FII_AR_PRIOR_OPEN_REC, FII_AR_PRIOR_PDUE_REC
'||l_order_by||' ';

Line: 184

fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, open_rec_sql, open_rec_output);