eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AR_OPEN_REC_PDUE dependencies on FII_AR_UTIL_PKG

Line 29: fii_ar_util_pkg.reset_globals;

25: l_party_groupby VARCHAR2(50);
26: l_gt_hint varchar2(500);
27: BEGIN
28:
29: fii_ar_util_pkg.reset_globals;
30: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
31: fii_ar_util_pkg.populate_summary_gt_tables;
32:
33:

Line 30: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

26: l_gt_hint varchar2(500);
27: BEGIN
28:
29: fii_ar_util_pkg.reset_globals;
30: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
31: fii_ar_util_pkg.populate_summary_gt_tables;
32:
33:
34:

Line 31: fii_ar_util_pkg.populate_summary_gt_tables;

27: BEGIN
28:
29: fii_ar_util_pkg.reset_globals;
30: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
31: fii_ar_util_pkg.populate_summary_gt_tables;
32:
33:
34:
35: l_gt_hint := ' leading(gt) cardinality(gt 1) ';

Line 38: IF (fii_ar_util_pkg.g_party_id <> '-111' OR

34:
35: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
36:
37: /* Dynamically generating the where clause for PARTY_ID*/
38: IF (fii_ar_util_pkg.g_party_id <> '-111' OR
39: fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
40: l_party_where := ' AND f.party_id = t.party_id ';
41: END IF;
42:

Line 39: fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN

35: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
36:
37: /* Dynamically generating the where clause for PARTY_ID*/
38: IF (fii_ar_util_pkg.g_party_id <> '-111' OR
39: fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
40: l_party_where := ' AND f.party_id = t.party_id ';
41: END IF;
42:
43: /* Dynamically generating the where clause for PARENT_PARTY_ID */

Line 44: IF(fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN

40: l_party_where := ' AND f.party_id = t.party_id ';
41: END IF;
42:
43: /* Dynamically generating the where clause for PARENT_PARTY_ID */
44: IF(fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
45: l_parent_party_where := 'AND f.parent_party_id = t.parent_party_id ';
46: END IF;
47:
48: /* Dynamically generating the where clause for COLLECTOR_ID*/

Line 49: IF (fii_ar_util_pkg.g_collector_id <> '-111' OR

45: l_parent_party_where := 'AND f.parent_party_id = t.parent_party_id ';
46: END IF;
47:
48: /* Dynamically generating the where clause for COLLECTOR_ID*/
49: IF (fii_ar_util_pkg.g_collector_id <> '-111' OR
50: fii_ar_util_pkg.g_view_by = 'FII_COLLECTOR+FII_COLLECTOR') THEN
51: l_collector_where := 'AND f.collector_id = t.collector_id ';
52: END IF;
53:

Line 50: fii_ar_util_pkg.g_view_by = 'FII_COLLECTOR+FII_COLLECTOR') THEN

46: END IF;
47:
48: /* Dynamically generating the where clause for COLLECTOR_ID*/
49: IF (fii_ar_util_pkg.g_collector_id <> '-111' OR
50: fii_ar_util_pkg.g_view_by = 'FII_COLLECTOR+FII_COLLECTOR') THEN
51: l_collector_where := 'AND f.collector_id = t.collector_id ';
52: END IF;
53:
54: l_party_select := ' ';

Line 58: IF (fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS' AND fii_ar_util_pkg.g_is_hierarchical_flag='Y') THEN

54: l_party_select := ' ';
55: l_party_groupby := ' ';
56:
57: /* Drills */
58: IF (fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS' AND fii_ar_util_pkg.g_is_hierarchical_flag='Y') THEN
59:
60: l_self := ' t.is_self_flag,';
61:
62: l_past_due_rec_drill:=

Line 77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'

73: l_cust_self_drill :=' DECODE(inline_view.is_self_flag,''Y'','''', DECODE(inline_view.is_leaf_flag, ''Y'','''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')) ';
74:
75: l_group_by := ' inline_view.is_self_flag,inline_view.viewby,inline_view.is_leaf_flag,inline_view.viewby_id ';
76:
77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'
78: OR fii_ar_util_pkg.g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' ) THEN
79: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
80: /* Calls Open Receivables: Percent Past Due - View by Customer Account*/
81: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';

Line 78: OR fii_ar_util_pkg.g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' ) THEN

74:
75: l_group_by := ' inline_view.is_self_flag,inline_view.viewby,inline_view.is_leaf_flag,inline_view.viewby_id ';
76:
77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'
78: OR fii_ar_util_pkg.g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' ) THEN
79: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
80: /* Calls Open Receivables: Percent Past Due - View by Customer Account*/
81: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';
82:

Line 79: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN

75: l_group_by := ' inline_view.is_self_flag,inline_view.viewby,inline_view.is_leaf_flag,inline_view.viewby_id ';
76:
77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'
78: OR fii_ar_util_pkg.g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' ) THEN
79: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
80: /* Calls Open Receivables: Percent Past Due - View by Customer Account*/
81: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';
82:
83: /* Calls Open Receivables Summary - View by Customer Account*/

Line 97: ELSIF (fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMER_ACCOUNTS') THEN

93: END IF;
94: l_cust_self_drill := ''' ''';
95: l_group_by := 'inline_view.viewby, inline_view.viewby_id ';
96:
97: ELSIF (fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMER_ACCOUNTS') THEN
98: l_gt_hint := ' leading(gt.gt) cardinality(gt.gt 1) ';
99: l_party_select := ' t.party_id party_id, ';
100: l_party_groupby := ',t.party_id ';
101:

Line 131: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 THEN

127: l_group_by := 'inline_view.viewby, inline_view.viewby_id ';
128: END IF;
129:
130:
131: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
132: l_order_by := 'ORDER BY NVL(FII_AR_PERC_OPEN_REC, -999999999) DESC';
133:
134: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
135: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));

Line 134: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN

130:
131: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
132: l_order_by := 'ORDER BY NVL(FII_AR_PERC_OPEN_REC, -999999999) DESC';
133:
134: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
135: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
136: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
137: ELSE
138: l_order_by := '&ORDER_BY_CLAUSE';

Line 135: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));

131: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
132: l_order_by := 'ORDER BY NVL(FII_AR_PERC_OPEN_REC, -999999999) DESC';
133:
134: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
135: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
136: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
137: ELSE
138: l_order_by := '&ORDER_BY_CLAUSE';
139: END IF;

Line 160: SELECT /+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)/

156: SUM(FII_AR_OPEN_REC) over() FII_AR_OPEN_REC_GT,
157: CASE WHEN SUM(FII_AR_OPEN_REC) over() = 0 THEN NULL
158: ELSE (SUM(FII_AR_PDUE_REC) over()/SUM(FII_AR_OPEN_REC) over()) *100 END FII_AR_PERC_OPEN_REC_GT
159: FROM (
160: SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
161: t.is_leaf_flag,
162: '||l_self||'
163: t.viewby viewby,
164: viewby_code viewby_id ,

Line 170: FROM FII_AR_NET_REC'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,

166: SUM(DECODE(t.report_date, :ASOF_DATE , past_due_open_amount , NULL ) ) FII_AR_PDUE_REC,
167: SUM(DECODE(t.report_date, :ASOF_DATE, total_open_amount, NULL ) ) FII_AR_OPEN_REC,
168: SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, past_due_open_amount, NULL ) ) FII_AR_PRIOR_PDUE_REC,
169: SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, total_open_amount, NULL ) ) FII_AR_PRIOR_OPEN_REC
170: FROM FII_AR_NET_REC'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
171: ( SELECT /*+ no_merge '||l_gt_hint|| ' */ *
172: FROM fii_time_structures cal, '||fii_ar_util_pkg.get_from_statement||' gt
173: WHERE report_date in (:ASOF_DATE, :PREVIOUS_ASOF_DATE)
174: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE

Line 172: FROM fii_time_structures cal, '||fii_ar_util_pkg.get_from_statement||' gt

168: SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, past_due_open_amount, NULL ) ) FII_AR_PRIOR_PDUE_REC,
169: SUM(DECODE(t.report_date, :PREVIOUS_ASOF_DATE, total_open_amount, NULL ) ) FII_AR_PRIOR_OPEN_REC
170: FROM FII_AR_NET_REC'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
171: ( SELECT /*+ no_merge '||l_gt_hint|| ' */ *
172: FROM fii_time_structures cal, '||fii_ar_util_pkg.get_from_statement||' gt
173: WHERE report_date in (:ASOF_DATE, :PREVIOUS_ASOF_DATE)
174: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
175: AND ' ||fii_ar_util_pkg.get_where_statement||' ) t
176: WHERE f.time_id = t.time_id

Line 175: AND ' ||fii_ar_util_pkg.get_where_statement||' ) t

171: ( SELECT /*+ no_merge '||l_gt_hint|| ' */ *
172: FROM fii_time_structures cal, '||fii_ar_util_pkg.get_from_statement||' gt
173: WHERE report_date in (:ASOF_DATE, :PREVIOUS_ASOF_DATE)
174: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
175: AND ' ||fii_ar_util_pkg.get_where_statement||' ) t
176: WHERE f.time_id = t.time_id
177: AND f.period_type_id = t.period_type_id
178: AND f.org_id = t.org_id
179: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_parent_party_where||l_party_where||l_collector_where|| l_cust_acct_where||'

Line 179: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_parent_party_where||l_party_where||l_collector_where|| l_cust_acct_where||'

175: AND ' ||fii_ar_util_pkg.get_where_statement||' ) t
176: WHERE f.time_id = t.time_id
177: AND f.period_type_id = t.period_type_id
178: AND f.org_id = t.org_id
179: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_parent_party_where||l_party_where||l_collector_where|| l_cust_acct_where||'
180: GROUP BY '||l_self||' t.is_leaf_flag, t.viewby, viewby_code'||l_party_groupby||') inline_view
181: GROUP BY '||l_group_by||', FII_AR_OPEN_REC,FII_AR_PDUE_REC, FII_AR_PRIOR_OPEN_REC, FII_AR_PRIOR_PDUE_REC
182: '||l_order_by||' ';
183:

Line 184: fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, open_rec_sql, open_rec_output);

180: GROUP BY '||l_self||' t.is_leaf_flag, t.viewby, viewby_code'||l_party_groupby||') inline_view
181: GROUP BY '||l_group_by||', FII_AR_OPEN_REC,FII_AR_PDUE_REC, FII_AR_PRIOR_OPEN_REC, FII_AR_PRIOR_PDUE_REC
182: '||l_order_by||' ';
183:
184: fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, open_rec_sql, open_rec_output);
185:
186: END get_rec_pdue;
187:
188: END FII_AR_OPEN_REC_PDUE;