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_TRAN_DETAIL dependencies on FII_AR_UTIL_PKG

Line 34: fii_ar_util_pkg.reset_globals;

30:
31:
32: BEGIN
33:
34: fii_ar_util_pkg.reset_globals;
35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
37: fii_ar_util_pkg.populate_summary_gt_tables;
38:

Line 35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

31:
32: BEGIN
33:
34: fii_ar_util_pkg.reset_globals;
35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
37: fii_ar_util_pkg.populate_summary_gt_tables;
38:
39: IF fii_ar_util_pkg.g_party_id = '-111' THEN

Line 36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';

32: BEGIN
33:
34: fii_ar_util_pkg.reset_globals;
35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
37: fii_ar_util_pkg.populate_summary_gt_tables;
38:
39: IF fii_ar_util_pkg.g_party_id = '-111' THEN
40: l_party_where := ' ';

Line 37: fii_ar_util_pkg.populate_summary_gt_tables;

33:
34: fii_ar_util_pkg.reset_globals;
35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
37: fii_ar_util_pkg.populate_summary_gt_tables;
38:
39: IF fii_ar_util_pkg.g_party_id = '-111' THEN
40: l_party_where := ' ';
41: ELSE

Line 39: IF fii_ar_util_pkg.g_party_id = '-111' THEN

35: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
36: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
37: fii_ar_util_pkg.populate_summary_gt_tables;
38:
39: IF fii_ar_util_pkg.g_party_id = '-111' THEN
40: l_party_where := ' ';
41: ELSE
42: IF fii_ar_util_pkg.g_count_parent_party_id > 1 THEN
43: l_party_where := ' AND hz_cust.party_id IN ('||fii_ar_util_pkg.g_party_id||') AND hz_cust.party_id = gt.party_id ';

Line 42: IF fii_ar_util_pkg.g_count_parent_party_id > 1 THEN

38:
39: IF fii_ar_util_pkg.g_party_id = '-111' THEN
40: l_party_where := ' ';
41: ELSE
42: IF fii_ar_util_pkg.g_count_parent_party_id > 1 THEN
43: l_party_where := ' AND hz_cust.party_id IN ('||fii_ar_util_pkg.g_party_id||') AND hz_cust.party_id = gt.party_id ';
44: ELSE
45: l_party_where := ' AND hz_cust.party_id = :PARTY_ID AND hz_cust.party_id =
46: gt.party_id ';

Line 43: l_party_where := ' AND hz_cust.party_id IN ('||fii_ar_util_pkg.g_party_id||') AND hz_cust.party_id = gt.party_id ';

39: IF fii_ar_util_pkg.g_party_id = '-111' THEN
40: l_party_where := ' ';
41: ELSE
42: IF fii_ar_util_pkg.g_count_parent_party_id > 1 THEN
43: l_party_where := ' AND hz_cust.party_id IN ('||fii_ar_util_pkg.g_party_id||') AND hz_cust.party_id = gt.party_id ';
44: ELSE
45: l_party_where := ' AND hz_cust.party_id = :PARTY_ID AND hz_cust.party_id =
46: gt.party_id ';
47: END IF;

Line 51: IF fii_ar_util_pkg.g_collector_id = '-111' THEN

47: END IF;
48: END IF;
49:
50:
51: IF fii_ar_util_pkg.g_collector_id = '-111' THEN
52: l_collector_where := ' ';
53: l_collector_from := ' ';
54: ELSE
55: l_collector_from := ' ,fii_collectors coll ';

Line 62: IF fii_ar_util_pkg.g_industry_id = '-111' THEN

58: AND coll.cust_account_id = f.bill_to_customer_id ';
59:
60: END IF;
61:
62: IF fii_ar_util_pkg.g_industry_id = '-111' THEN
63: l_industry_where := ' ';
64: l_industry_from := ' ';
65: ELSE
66: l_industry_from := ' ,fii_party_mkt_class ind ';

Line 73: IF fii_ar_util_pkg.g_cust_account IS NULL OR

69: AND hz_cust.cust_account_id = f.bill_to_customer_id ';
70:
71: END IF;
72:
73: IF fii_ar_util_pkg.g_cust_account IS NULL OR
74: fii_ar_util_pkg.g_cust_account = '-111' THEN
75: l_cust_acc_where := ' ';
76: ELSE
77: l_cust_acc_where := ' AND f.bill_to_customer_id= :CUST_ACCOUNT ';

Line 74: fii_ar_util_pkg.g_cust_account = '-111' THEN

70:
71: END IF;
72:
73: IF fii_ar_util_pkg.g_cust_account IS NULL OR
74: fii_ar_util_pkg.g_cust_account = '-111' THEN
75: l_cust_acc_where := ' ';
76: ELSE
77: l_cust_acc_where := ' AND f.bill_to_customer_id= :CUST_ACCOUNT ';
78: END IF;

Line 82: IF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_REC_DTL' THEN

78: END IF;
79:
80: l_inag_rng := 'NULL ';
81:
82: IF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_REC_DTL' THEN
83: /* Open Receivables Detail*/
84: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
85:
86: l_bal_select :=

Line 87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

83: /* Open Receivables Detail*/
84: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
85:
86: l_bal_select :=
87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

84: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
85:
86: l_bal_select :=
87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
92:

Line 89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

85:
86: l_bal_select :=
87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
92:
93: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';

Line 90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

86: l_bal_select :=
87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
92:
93: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
94:

Line 91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

87: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
88: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
89: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
90: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
92:
93: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
94:
95: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_PDUE_REC_DTL' THEN

Line 95: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_PDUE_REC_DTL' THEN

91: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
92:
93: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
94:
95: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_PDUE_REC_DTL' THEN
96: /* Past Due Receivable Detail */
97: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
98:
99: l_inag_rng := '

Line 100: SUM(r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

96: /* Past Due Receivable Detail */
97: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
98:
99: l_inag_rng := '
100: SUM(r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
101: +r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
102: +r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||
104: ') ';

Line 101: +r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

97: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
98:
99: l_inag_rng := '
100: SUM(r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
101: +r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
102: +r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||
104: ') ';
105:

Line 102: +r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

98:
99: l_inag_rng := '
100: SUM(r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
101: +r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
102: +r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||
104: ') ';
105:
106: l_bal_select :=

Line 103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||

99: l_inag_rng := '
100: SUM(r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
101: +r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
102: +r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||
104: ') ';
105:
106: l_bal_select :=
107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

Line 107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

103: +r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||
104: ') ';
105:
106: l_bal_select :=
107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

104: ') ';
105:
106: l_bal_select :=
107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
112:

Line 109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

105:
106: l_bal_select :=
107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
112:
113: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';

Line 110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

106: l_bal_select :=
107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
112:
113: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
114:

Line 111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

107: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
108: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
109: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
110: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
112:
113: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
114:
115: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_CURR_REC_DTL' THEN

Line 115: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_CURR_REC_DTL' THEN

111: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
112:
113: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
114:
115: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_CURR_REC_DTL' THEN
116: /* Current Receivable Detail */
117: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
118:
119: l_inag_rng := '

Line 120: SUM(r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

116: /* Current Receivable Detail */
117: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
118:
119: l_inag_rng := '
120: SUM(r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
121: + r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||
122: ') ';
123:
124: l_bal_select :=

Line 121: + r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||

117: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
118:
119: l_inag_rng := '
120: SUM(r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
121: + r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||
122: ') ';
123:
124: l_bal_select :=
125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

Line 125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

121: + r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||
122: ') ';
123:
124: l_bal_select :=
125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

122: ') ';
123:
124: l_bal_select :=
125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
130:

Line 127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

123:
124: l_bal_select :=
125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
130:
131: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';

Line 128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

124: l_bal_select :=
125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
130:
131: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
132:

Line 129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

125: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
126: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
127: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
128: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
130:
131: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
132:
133: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_PDUE_BUCKET' THEN

Line 133: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_PDUE_BUCKET' THEN

129: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
130:
131: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
132:
133: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_PDUE_BUCKET' THEN
134:
135: l_bucket := fii_ar_util_pkg.g_bucket_num;
136:
137: /* Receivable Bucket X Days Past Due*/

Line 135: l_bucket := fii_ar_util_pkg.g_bucket_num;

131: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <>0 ';
132:
133: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_PDUE_BUCKET' THEN
134:
135: l_bucket := fii_ar_util_pkg.g_bucket_num;
136:
137: /* Receivable Bucket X Days Past Due*/
138: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
139: l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 139: l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

135: l_bucket := fii_ar_util_pkg.g_bucket_num;
136:
137: /* Receivable Bucket X Days Past Due*/
138: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
139: l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
140:
141: l_bal_select :=
142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

Line 142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

138: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
139: l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
140:
141: l_bal_select :=
142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

139: l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
140:
141: l_bal_select :=
142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
147:

Line 144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

140:
141: l_bal_select :=
142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
147:
148: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';

Line 145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

141: l_bal_select :=
142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
147:
148: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
149:

Line 146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

142: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
143: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
144: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
145: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
147:
148: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
149:
150: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_DUE_BUCKET' THEN

Line 150: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_DUE_BUCKET' THEN

146: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
147:
148: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
149:
150: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_DUE_BUCKET' THEN
151:
152: l_bucket := fii_ar_util_pkg.g_bucket_num;
153:
154: /* Receivable Due in Bucket X Days*/

Line 152: l_bucket := fii_ar_util_pkg.g_bucket_num;

148: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
149:
150: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_REC_DUE_BUCKET' THEN
151:
152: l_bucket := fii_ar_util_pkg.g_bucket_num;
153:
154: /* Receivable Due in Bucket X Days*/
155: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
156: l_inag_rng := ' SUM(r.current_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 156: l_inag_rng := ' SUM(r.current_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

152: l_bucket := fii_ar_util_pkg.g_bucket_num;
153:
154: /* Receivable Due in Bucket X Days*/
155: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
156: l_inag_rng := ' SUM(r.current_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
157:
158: l_bal_select :=
159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

Line 159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

155: l_func_where := ' AND f.class IN (''INV'',''DM'',''CB'',''DEP'',''BR'') ';
156: l_inag_rng := ' SUM(r.current_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
157:
158: l_bal_select :=
159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

156: l_inag_rng := ' SUM(r.current_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
157:
158: l_bal_select :=
159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
164:

Line 161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

157:
158: l_bal_select :=
159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
164:
165: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';

Line 162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

158: l_bal_select :=
159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
164:
165: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
166:

Line 163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

159: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
160: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
161: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
162: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
164:
165: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
166:
167: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_INV_DTL' THEN

Line 167: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_INV_DTL' THEN

163: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
164:
165: l_bal_where := ' AND FII_AR_INAGE_RNG_AMT <> 0 ';
166:
167: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_INV_DTL' THEN
168: /* Invoices Detail */
169:
170: l_func_where := ' AND f.class = ''INV'' ';
171:

Line 172: --l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

168: /* Invoices Detail */
169:
170: l_func_where := ' AND f.class = ''INV'' ';
171:
172: --l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
173:
174: l_bal_select :=
175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

Line 175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

171:
172: --l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
173:
174: l_bal_select :=
175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

172: --l_inag_rng := ' SUM(r.past_due_bucket_'||l_bucket||'_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
173:
174: l_bal_select :=
175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
180:

Line 177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

173:
174: l_bal_select :=
175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
180:
181: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';

Line 178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

174: l_bal_select :=
175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
180:
181: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
182:

Line 179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

175: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
176: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
177: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
178: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
180:
181: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
182:
183: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_DM_DTL' THEN

Line 183: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_DM_DTL' THEN

179: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
180:
181: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
182:
183: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_DM_DTL' THEN
184: /* Debit Memo Detail */
185:
186: l_func_where :=' AND f.class = ''DM'' ';
187:

Line 189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

185:
186: l_func_where :=' AND f.class = ''DM'' ';
187:
188: l_bal_select :=
189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

186: l_func_where :=' AND f.class = ''DM'' ';
187:
188: l_bal_select :=
189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
194:

Line 191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

187:
188: l_bal_select :=
189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
194:
195: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';

Line 192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

188: l_bal_select :=
189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
194:
195: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
196:

Line 193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

189: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
190: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
191: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
192: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
194:
195: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
196:
197: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_CB_DTL' THEN

Line 197: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_CB_DTL' THEN

193: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
194:
195: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
196:
197: ELSIF fii_ar_util_pkg.g_function_name = 'FII_AR_OPEN_CB_DTL' THEN
198: /* Charge Back Detail */
199: l_func_where := ' AND f.class = ''CB'' ';
200:
201: l_bal_select :=

Line 202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

198: /* Charge Back Detail */
199: l_func_where := ' AND f.class = ''CB'' ';
200:
201: l_bal_select :=
202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

Line 203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

199: l_func_where := ' AND f.class = ''CB'' ';
200:
201: l_bal_select :=
202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
207:

Line 204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

200:
201: l_bal_select :=
202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
207:
208: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';

Line 205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'

201: l_bal_select :=
202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
207:
208: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
209:

Line 206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';

202: ' (r.current_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.current_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
203: +r.current_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_1_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
204: +r.past_due_bucket_2_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_3_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
205: +r.past_due_bucket_4_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_5_amount'||fii_ar_util_pkg.g_col_curr_suffix||'
206: +r.past_due_bucket_6_amount'||fii_ar_util_pkg.g_col_curr_suffix||'+r.past_due_bucket_7_amount'||fii_ar_util_pkg.g_col_curr_suffix||') ';
207:
208: l_bal_where := ' AND FII_AR_BALANCE_AMT <>0 ';
209:
210: ELSE

Line 251: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 AND

247: from oe_order_headers_all ooh
248: where f.order_ref_number =
249: to_char(ooh.order_number) and rownum=1 ) ) ';
250:
251: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 AND
252: INSTR(SUBSTR(fii_ar_util_pkg.g_order_by,1,25),'FII_AR_BALANCE_AMT DESC') <> 0 THEN
253:
254: l_order_by := 'ORDER BY NVL(FII_AR_BALANCE_AMT, -999999999) DESC';
255:

Line 252: INSTR(SUBSTR(fii_ar_util_pkg.g_order_by,1,25),'FII_AR_BALANCE_AMT DESC') <> 0 THEN

248: where f.order_ref_number =
249: to_char(ooh.order_number) and rownum=1 ) ) ';
250:
251: IF INSTR(fii_ar_util_pkg.g_order_by,',') <> 0 AND
252: INSTR(SUBSTR(fii_ar_util_pkg.g_order_by,1,25),'FII_AR_BALANCE_AMT DESC') <> 0 THEN
253:
254: l_order_by := 'ORDER BY NVL(FII_AR_BALANCE_AMT, -999999999) DESC';
255:
256: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN

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

252: INSTR(SUBSTR(fii_ar_util_pkg.g_order_by,1,25),'FII_AR_BALANCE_AMT DESC') <> 0 THEN
253:
254: l_order_by := 'ORDER BY NVL(FII_AR_BALANCE_AMT, -999999999) DESC';
255:
256: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
257: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
258:
259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN

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

253:
254: l_order_by := 'ORDER BY NVL(FII_AR_BALANCE_AMT, -999999999) DESC';
255:
256: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
257: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
258:
259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';

Line 259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND

255:
256: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
257: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
258:
259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,

Line 260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN

256: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
257: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
258:
259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,
264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -

Line 262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN

258:
259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,
264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -
265: INSTR(fii_ar_util_pkg.g_order_by,'FII'));
266: l_order_by := 'ORDER BY NVL(' || l_order_column || ', '' '') DESC';

Line 263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,

259: IF INSTR(fii_ar_util_pkg.g_order_by,'DATE') = 0 AND
260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,
264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -
265: INSTR(fii_ar_util_pkg.g_order_by,'FII'));
266: l_order_by := 'ORDER BY NVL(' || l_order_column || ', '' '') DESC';
267: ELSE

Line 264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -

260: INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') = 0 THEN
261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,
264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -
265: INSTR(fii_ar_util_pkg.g_order_by,'FII'));
266: l_order_by := 'ORDER BY NVL(' || l_order_column || ', '' '') DESC';
267: ELSE
268: l_order_by := 'ORDER BY '|| l_order_column ||' DESC';

Line 265: INSTR(fii_ar_util_pkg.g_order_by,'FII'));

261: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
262: ELSIF INSTR(fii_ar_util_pkg.g_order_by, 'BINARY') <> 0 THEN
263: l_order_column := SUBSTR(fii_ar_util_pkg.g_order_by,
264: INSTR(fii_ar_util_pkg.g_order_by,'FII'), INSTR(fii_ar_util_pkg.g_order_by,',') -
265: INSTR(fii_ar_util_pkg.g_order_by,'FII'));
266: l_order_by := 'ORDER BY NVL(' || l_order_column || ', '' '') DESC';
267: ELSE
268: l_order_by := 'ORDER BY '|| l_order_column ||' DESC';
269: END IF;

Line 354: then f.amount_due_original'||fii_ar_util_pkg.g_col_curr_suffix||'

350: f.invoice_currency_code||'' ''||TO_CHAR(SUM(case when aging_flag = ''N'' and action = ''Transaction''
351: then f.amount_due_original_trx
352: else 0 end),''999,999,999,999'') FII_AR_TRAN_AMT,
353: SUM(case when aging_flag = ''N'' and action = ''Transaction''
354: then f.amount_due_original'||fii_ar_util_pkg.g_col_curr_suffix||'
355: else 0 end) FII_AR_ORIG_AMT,
356: '||l_inag_rng||' FII_AR_INAGE_RNG_AMT,
357: SUM( '||l_bal_select||') FII_AR_BALANCE_AMT,
358: f.term_id,

Line 395: fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, tran_detail_sql, tran_detail_output);

391: AND f.org_id=rsource.org_id
392: ) '||l_order_by||'
393: ';
394:
395: fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, tran_detail_sql, tran_detail_output);
396:
397: END get_tran_detail;
398:
399: END FII_AR_TRAN_DETAIL;