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

Line 67: fii_ar_util_pkg.reset_globals;

63:
64:
65:
66: /* Reset Global Variables */
67: fii_ar_util_pkg.reset_globals;
68:
69:
70:
71:

Line 73: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

69:
70:
71:
72: /* Get the parameters that the user has selected */
73: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
74:
75:
76: /* Populate the dimension combination(s) that the user has access to */
77: fii_ar_util_pkg.populate_summary_gt_tables;

Line 77: fii_ar_util_pkg.populate_summary_gt_tables;

73: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
74:
75:
76: /* Populate the dimension combination(s) that the user has access to */
77: fii_ar_util_pkg.populate_summary_gt_tables;
78:
79:
80:
81: -- Get the view by

Line 82: l_view_by := fii_ar_util_pkg.g_view_by;

78:
79:
80:
81: -- Get the view by
82: l_view_by := fii_ar_util_pkg.g_view_by;
83:
84: /* Check whether join on party is is reqd. or not */
85: IF (fii_ar_util_pkg.g_party_id <> '-111' OR l_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
86: l_child_party_where := ' AND f.party_id = gt.party_id ';

Line 85: IF (fii_ar_util_pkg.g_party_id <> '-111' OR l_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN

81: -- Get the view by
82: l_view_by := fii_ar_util_pkg.g_view_by;
83:
84: /* Check whether join on party is is reqd. or not */
85: IF (fii_ar_util_pkg.g_party_id <> '-111' OR l_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
86: l_child_party_where := ' AND f.party_id = gt.party_id ';
87: END IF;
88:
89: -- Check whether we need a filter for parent_party_id. This is applicable only if the Ct. dimension is hierarchial and view by

Line 91: IF fii_ar_util_pkg.g_is_hierarchical_flag = 'Y' and l_view_by = 'CUSTOMER+FII_CUSTOMERS' THEN

87: END IF;
88:
89: -- Check whether we need a filter for parent_party_id. This is applicable only if the Ct. dimension is hierarchial and view by
90: -- is customer.
91: IF fii_ar_util_pkg.g_is_hierarchical_flag = 'Y' and l_view_by = 'CUSTOMER+FII_CUSTOMERS' THEN
92: l_customer_where := ' and f.parent_party_id = gt.parent_party_id';
93: l_view_by_flag :=2; -- for Customer
94: END IF;
95:

Line 112: ELSIF fii_ar_util_pkg.g_industry_id <> '-111' OR l_view_by = 'FII_TRADING_PARTNER_CLASS+FII_TRADING_PARTNER_MKT_CLASS' THEN

108:
109: /* Check whether industry filter is reqd or not */
110: IF l_view_by = 'CUSTOMER+FII_CUSTOMERS' THEN
111: l_industry_where := NULL;
112: ELSIF fii_ar_util_pkg.g_industry_id <> '-111' OR l_view_by = 'FII_TRADING_PARTNER_CLASS+FII_TRADING_PARTNER_MKT_CLASS' THEN
113: l_industry_where := ' and f.class_code=gt.class_code and f.class_category=gt.class_category';
114: END IF;
115:
116: -- The below mentioned variable will make the code easy to understand.

Line 128: -- IF (l_view_by = 'CUSTOMER+FII_CUSTOMERS' and fii_ar_util_pkg.g_is_hierarchical_flag='Y' ) THEN

124: IF (l_view_by_flag = 2 ) /* View by is ct. and implementation is heirarchial */ THEN
125: --vkazhipu changed
126: l_bill_act_amt_drill := 'pFunctionName=FII_AR_BILLING_ACTIVITY&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID';
127: l_open_rec_drill := 'pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID';
128: -- IF (l_view_by = 'CUSTOMER+FII_CUSTOMERS' and fii_ar_util_pkg.g_is_hierarchical_flag='Y' ) THEN
129: -- l_view_by_flag:=2;
130: l_customer_drill:= 'pFunctionName=FII_AR_BILLING_ACTIVITY&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y';
131: -- END IF;
132: END IF;

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

131: -- END IF;
132: END IF;
133: IF l_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' OR
134: l_view_by = 'FII_TRADING_PARTNER_CLASS+FII_TRADING_PARTNER_MKT_CLASS' THEN
135: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
136: l_bill_act_amt_drill := 'pFunctionName=FII_AR_BILLING_ACTIVITY&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID';
137: l_open_rec_drill := 'pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID';
138: ELSE
139: --l_bill_act_amt_drill := 'pFunctionName=FII_AR_BILLING_ACTIVITY&VIEW_BY=CUSTOMER+FII_CUSTOMERS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID';

Line 178: l_dso_period := fiI_ar_util_pkg.g_dso_period;

174: ELSE
175: l_cust_acct_or_leaf_rec_drill := 'pFunctionName=FII_AR_OPEN_REC_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
176: END IF;
177:
178: l_dso_period := fiI_ar_util_pkg.g_dso_period;
179:
180:
181: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
182: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;

Line 181: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;

177:
178: l_dso_period := fiI_ar_util_pkg.g_dso_period;
179:
180:
181: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
182: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
183:
184:
185: /* Get the transaction classes based on DSO setup */

Line 182: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;

178: l_dso_period := fiI_ar_util_pkg.g_dso_period;
179:
180:
181: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
182: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
183:
184:
185: /* Get the transaction classes based on DSO setup */
186: fii_ar_util_pkg.get_dso_table_values;

Line 186: fii_ar_util_pkg.get_dso_table_values;

182: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
183:
184:
185: /* Get the transaction classes based on DSO setup */
186: fii_ar_util_pkg.get_dso_table_values;
187:
188: l_class_inclusion := 0;
189:
190:

Line 191: For i in fii_ar_util_pkg.g_dso_table.FIRST..fii_ar_util_pkg.g_dso_table.LAST LOOP

187:
188: l_class_inclusion := 0;
189:
190:
191: For i in fii_ar_util_pkg.g_dso_table.FIRST..fii_ar_util_pkg.g_dso_table.LAST LOOP
192:
193: IF fii_ar_util_pkg.g_dso_table(i).dso_value = 'Y' THEN
194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN
195: l_class_inclusion := l_class_inclusion ||'+ f.INV_AMOUNT';

Line 193: IF fii_ar_util_pkg.g_dso_table(i).dso_value = 'Y' THEN

189:
190:
191: For i in fii_ar_util_pkg.g_dso_table.FIRST..fii_ar_util_pkg.g_dso_table.LAST LOOP
192:
193: IF fii_ar_util_pkg.g_dso_table(i).dso_value = 'Y' THEN
194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN
195: l_class_inclusion := l_class_inclusion ||'+ f.INV_AMOUNT';
196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN
197: l_class_inclusion := l_class_inclusion ||'+ f.DM_AMOUNT';

Line 194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN

190:
191: For i in fii_ar_util_pkg.g_dso_table.FIRST..fii_ar_util_pkg.g_dso_table.LAST LOOP
192:
193: IF fii_ar_util_pkg.g_dso_table(i).dso_value = 'Y' THEN
194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN
195: l_class_inclusion := l_class_inclusion ||'+ f.INV_AMOUNT';
196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN
197: l_class_inclusion := l_class_inclusion ||'+ f.DM_AMOUNT';
198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN

Line 196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN

192:
193: IF fii_ar_util_pkg.g_dso_table(i).dso_value = 'Y' THEN
194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN
195: l_class_inclusion := l_class_inclusion ||'+ f.INV_AMOUNT';
196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN
197: l_class_inclusion := l_class_inclusion ||'+ f.DM_AMOUNT';
198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN
199: l_class_inclusion := l_class_inclusion ||'+ f.CB_AMOUNT';
200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN

Line 198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN

194: IF fii_ar_util_pkg.g_dso_table(i).dso_type = 'INV' THEN
195: l_class_inclusion := l_class_inclusion ||'+ f.INV_AMOUNT';
196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN
197: l_class_inclusion := l_class_inclusion ||'+ f.DM_AMOUNT';
198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN
199: l_class_inclusion := l_class_inclusion ||'+ f.CB_AMOUNT';
200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN
201: l_class_inclusion := l_class_inclusion ||'+ f.BR_AMOUNT';
202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN

Line 200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN

196: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DM' THEN
197: l_class_inclusion := l_class_inclusion ||'+ f.DM_AMOUNT';
198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN
199: l_class_inclusion := l_class_inclusion ||'+ f.CB_AMOUNT';
200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN
201: l_class_inclusion := l_class_inclusion ||'+ f.BR_AMOUNT';
202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN
203: l_class_inclusion := l_class_inclusion ||'+ f. DEP_AMOUNT';
204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN

Line 202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN

198: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CB' THEN
199: l_class_inclusion := l_class_inclusion ||'+ f.CB_AMOUNT';
200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN
201: l_class_inclusion := l_class_inclusion ||'+ f.BR_AMOUNT';
202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN
203: l_class_inclusion := l_class_inclusion ||'+ f. DEP_AMOUNT';
204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN
205: l_class_inclusion := l_class_inclusion ||'+ f.ON_ACCOUNT_CREDIT_AMOUNT';
206: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNDEP' THEN

Line 204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN

200: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'BR' THEN
201: l_class_inclusion := l_class_inclusion ||'+ f.BR_AMOUNT';
202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN
203: l_class_inclusion := l_class_inclusion ||'+ f. DEP_AMOUNT';
204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN
205: l_class_inclusion := l_class_inclusion ||'+ f.ON_ACCOUNT_CREDIT_AMOUNT';
206: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNDEP' THEN
207: l_class_inclusion := l_class_inclusion ||'- f.UNAPP_DEP_AMOUNT';
208: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNREC' THEN

Line 206: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNDEP' THEN

202: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'DEP' THEN
203: l_class_inclusion := l_class_inclusion ||'+ f. DEP_AMOUNT';
204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN
205: l_class_inclusion := l_class_inclusion ||'+ f.ON_ACCOUNT_CREDIT_AMOUNT';
206: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNDEP' THEN
207: l_class_inclusion := l_class_inclusion ||'- f.UNAPP_DEP_AMOUNT';
208: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNREC' THEN
209: -- l_class_inclusion := l_class_inclusion ||'- f.UNAPP_AMOUNT';
210: l_unapp_amount := '- f.UNAPP_AMOUNT';

Line 208: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNREC' THEN

204: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'CM' THEN
205: l_class_inclusion := l_class_inclusion ||'+ f.ON_ACCOUNT_CREDIT_AMOUNT';
206: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNDEP' THEN
207: l_class_inclusion := l_class_inclusion ||'- f.UNAPP_DEP_AMOUNT';
208: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNREC' THEN
209: -- l_class_inclusion := l_class_inclusion ||'- f.UNAPP_AMOUNT';
210: l_unapp_amount := '- f.UNAPP_AMOUNT';
211: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OACB' THEN
212: l_class_inclusion := l_class_inclusion ||'- f.ON_ACCOUNT_CASH_AMOUNT';

Line 211: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OACB' THEN

207: l_class_inclusion := l_class_inclusion ||'- f.UNAPP_DEP_AMOUNT';
208: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'UNREC' THEN
209: -- l_class_inclusion := l_class_inclusion ||'- f.UNAPP_AMOUNT';
210: l_unapp_amount := '- f.UNAPP_AMOUNT';
211: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OACB' THEN
212: l_class_inclusion := l_class_inclusion ||'- f.ON_ACCOUNT_CASH_AMOUNT';
213: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OCB' THEN
214: l_class_inclusion := l_class_inclusion ||'- f.CLAIM_AMOUNT ';
215: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'PREPAY' THEN

Line 213: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OCB' THEN

209: -- l_class_inclusion := l_class_inclusion ||'- f.UNAPP_AMOUNT';
210: l_unapp_amount := '- f.UNAPP_AMOUNT';
211: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OACB' THEN
212: l_class_inclusion := l_class_inclusion ||'- f.ON_ACCOUNT_CASH_AMOUNT';
213: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OCB' THEN
214: l_class_inclusion := l_class_inclusion ||'- f.CLAIM_AMOUNT ';
215: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'PREPAY' THEN
216: l_class_inclusion := l_class_inclusion ||'- f.PREPAYMENT_AMOUNT ';
217: END IF;

Line 215: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'PREPAY' THEN

211: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OACB' THEN
212: l_class_inclusion := l_class_inclusion ||'- f.ON_ACCOUNT_CASH_AMOUNT';
213: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'OCB' THEN
214: l_class_inclusion := l_class_inclusion ||'- f.CLAIM_AMOUNT ';
215: ELSIF fii_ar_util_pkg.g_dso_table(i).dso_type = 'PREPAY' THEN
216: l_class_inclusion := l_class_inclusion ||'- f.PREPAYMENT_AMOUNT ';
217: END IF;
218:
219: END IF;

Line 225: IF(instr(fii_ar_util_pkg.g_order_by,',') <> 0) THEN

221:
222:
223:
224: -- Construct the order by
225: IF(instr(fii_ar_util_pkg.g_order_by,',') <> 0) THEN
226:
227: /*This means no particular sort column is selected in the report
228: So sort on the default column in descending order
229: NVL is added to make sure the NULL values appear last*/

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

229: NVL is added to make sure the NULL values appear last*/
230:
231: l_order_by := 'ORDER BY NVL(FII_AR_BILL_ACT_AMT, -999999999) DESC';
232:
233: ELSIF(instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0)THEN
234:
235: /*This means a particular sort column is clicked to have descending order
236: in which case we would want all the NULL values to appear last in the
237: report so add an NVL to that column*/

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

235: /*This means a particular sort column is clicked to have descending order
236: in which case we would want all the NULL values to appear last in the
237: report so add an NVL to that column*/
238:
239: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
240: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
241:
242: ELSE
243:

Line 252: l_inner_from_clause := fii_ar_util_pkg.get_from_statement;

248:
249: END IF;
250:
251: IF l_view_by_flag=3 THEN /* Viewby is Ct. acct */
252: l_inner_from_clause := fii_ar_util_pkg.get_from_statement;
253: l_inner_where_clause := ' and '||fii_ar_util_pkg.get_where_statement;
254: ELSE
255: l_inner_from_clause := 'fii_ar_summary_gt ';
256: l_inner_where_clause := NULL;

Line 253: l_inner_where_clause := ' and '||fii_ar_util_pkg.get_where_statement;

249: END IF;
250:
251: IF l_view_by_flag=3 THEN /* Viewby is Ct. acct */
252: l_inner_from_clause := fii_ar_util_pkg.get_from_statement;
253: l_inner_where_clause := ' and '||fii_ar_util_pkg.get_where_statement;
254: ELSE
255: l_inner_from_clause := 'fii_ar_summary_gt ';
256: l_inner_where_clause := NULL;
257: END IF;

Line 295: or */ (l_view_by = 'CUSTOMER+FII_CUSTOMERS' and fii_ar_util_pkg.g_is_hierarchical_flag = 'N' ) THEN

291: DECODE(NVL(SUM(FII_AR_OPEN_REC_AMT),0),0,'''','''||l_open_rec_drill || ''') FII_AR_BILL_OPEN_REC_AMT_DRILL ,
292: NULL FII_AR_VIEW_BY_DRILL';
293:
294: ELSIF /*( l_view_by_flag = 3 )
295: or */ (l_view_by = 'CUSTOMER+FII_CUSTOMERS' and fii_ar_util_pkg.g_is_hierarchical_flag = 'N' ) THEN
296:
297: l_sql_stmt := l_sql_stmt ||'DECODE(NVL(SUM(FII_AR_BILL_ACT_AMT),0),0,'''','''|| l_cust_acct_or_leaf_amt_drill || ''') FII_AR_BILL_ACT_AMT_DRILL ,
298: DECODE(NVL(SUM(FII_AR_BILL_ACT_COUNT),0),0,'''','''||l_bill_act_count_drill || ''') FII_AR_BILL_ACT_COUNT_DRILL ,
299: DECODE(NVL(SUM(FII_AR_OPEN_REC_AMT),0),0,'''','''||l_cust_acct_or_leaf_rec_drill || ''') FII_AR_BILL_OPEN_REC_AMT_DRILL ,

Line 310: l_sql_stmt := l_sql_stmt || ' FROM ( select /+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)/

306: DECODE(NVL(SUM(FII_AR_OPEN_REC_AMT),0),0,'''',FII_AR_BILL_OPEN_REC_AMT_DRILL) FII_AR_BILL_OPEN_REC_AMT_DRILL,
307: FII_AR_VIEW_BY_DRILL ';
308: END IF;
309:
310: l_sql_stmt := l_sql_stmt || ' FROM ( select /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
311: CASE WHEN gt.report_date=:PREVIOUS_ASOF_DATE and BITAND(gt.record_type_id,:BITAND)= :BITAND THEN
312: f.billing_activity_amount
313: ELSE
314: NULL

Line 399: '|| l_where_clause||' and '||fii_ar_util_pkg.get_mv_where_statement;

395: OR BITAND(cal.record_type_id,:BITAND_INC_TODATE)= :BITAND_INC_TODATE
396: OR BITAND(cal.record_type_id,:DSO_BITAND)=:DSO_BITAND ) '||l_inner_where_clause ||' ) gt
397: where f.time_id = gt.time_id
398: and gt.period_type_id=f.period_type_id
399: '|| l_where_clause||' and '||fii_ar_util_pkg.get_mv_where_statement;
400: IF l_unapp_amount IS NOT NULL THEN
401: l_sql_stmt:=l_sql_stmt||' UNION ALL
402: SELECT /*+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_MV_N1)*/ NULL FII_AR_BILL_ACT_AMT_PRIOR,
403: NULL FII_AR_BILL_ACT_AMT,

Line 402: SELECT /+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_MV_N1)/ NULL FII_AR_BILL_ACT_AMT_PRIOR,

398: and gt.period_type_id=f.period_type_id
399: '|| l_where_clause||' and '||fii_ar_util_pkg.get_mv_where_statement;
400: IF l_unapp_amount IS NOT NULL THEN
401: l_sql_stmt:=l_sql_stmt||' UNION ALL
402: SELECT /*+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_MV_N1)*/ NULL FII_AR_BILL_ACT_AMT_PRIOR,
403: NULL FII_AR_BILL_ACT_AMT,
404: NULL FII_AR_BILL_ACT_COUNT,
405: NULL FII_AR_BILL_ACT_COUNT_PRIOR,
406: NULL FII_AR_OPEN_REC_AMT,

Line 438: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '|| l_where_clause;

434: OR BITAND(cal.record_type_id,:BITAND_INC_TODATE)= :BITAND_INC_TODATE
435: OR BITAND(cal.record_type_id,:DSO_BITAND)=:DSO_BITAND ) '||l_inner_where_clause ||' ) gt
436: where f.time_id = gt.time_id
437: and gt.period_type_id=f.period_type_id
438: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '|| l_where_clause;
439:
440:
441: END IF;
442:

Line 457: fii_ar_util_pkg.bind_variable(l_sql_stmt, p_page_parameter_tbl, bill_act_sum_sql, bill_sum_output);

453:
454:
455:
456: /* Pass back the pmv sql along with bind variables to PMV */
457: fii_ar_util_pkg.bind_variable(l_sql_stmt, p_page_parameter_tbl, bill_act_sum_sql, bill_sum_output);
458:
459: END get_billing_activity;
460:
461: