APPS.FII_SIZING_UTIL dependencies on RA_CUSTOMER_TRX_ALL

Line 212: ra_customer_trx_all ct

208: (SELECT count(*) cnt
209: FROM
210: ra_cust_trx_line_gl_dist_all ctlgd,
211: ra_customer_trx_lines_all ctl,
212: ra_customer_trx_all ct
213: WHERE ctlgd.account_set_flag = 'N'
214: AND ctlgd.last_update_date between p_from_date and p_to_date
215: AND ctlgd.customer_trx_line_id = ctl.customer_trx_line_id
216: AND (nvl(ctl.interface_line_context, 'xxx') NOT IN ('ORDER ENTRY', 'GEMMS OP')

Line 227: ra_customer_trx_all ct

223: UNION ALL
224: SELECT count(*)
225: FROM
226: ra_customer_trx_lines_all ctl,
227: ra_customer_trx_all ct
228: WHERE ctl.last_update_date between p_from_date and p_to_date
229: AND (nvl(ctl.interface_line_context, 'xxx') <> 'ORDER ENTRY'
230: OR (ctl.interface_line_context = 'ORDER ENTRY'
231: AND translate(ctl.interface_line_attribute6, 'z0123456789', 'z') IS NOT NULL))

Line 238: ra_customer_trx_all ct

234: UNION ALL
235: SELECT count(*)
236: FROM
237: ar_adjustments_all adj,
238: ra_customer_trx_all ct
239: WHERE adj.last_update_date between p_from_date and p_to_date
240: AND nvl(adj.status, 'A') = 'A'
241: AND nvl(adj.postable,'Y') = 'Y'
242: AND ct.customer_trx_id = adj.customer_trx_id

Line 250: ra_customer_trx_all ct

246: SELECT count(*)
247: from
248: ra_cust_trx_line_gl_dist_all ctlgd,
249: ra_customer_trx_lines_all ctl,
250: ra_customer_trx_all ct
251: WHERE ctlgd.last_update_date between p_from_date and p_to_date
252: AND ctlgd.account_set_flag = 'N'
253: AND ctlgd.customer_trx_line_id = ctl.customer_trx_line_id
254: AND ctl.customer_trx_id = ct.customer_trx_id

Line 263: ra_customer_trx_all ct

259: UNION ALL
260: SELECT count(*)
261: FROM
262: ra_customer_trx_lines_all ctl,
263: ra_customer_trx_all ct
264: WHERE ctl.last_update_date between p_from_date and p_to_date
265: AND ctl.interface_line_context = 'ORDER ENTRY'
266: AND DECODE(ctl.interface_line_attribute6, NULL, NULL,
267: translate(ctl.interface_line_attribute6, 'z0123456789', 'z')) IS NULL

Line 275: ra_customer_trx_all ct

271: SELECT count(*)
272: FROM
273: ra_cust_trx_line_gl_dist_all ctlgd,
274: ra_customer_trx_lines_all ctl,
275: ra_customer_trx_all ct
276: WHERE ctlgd.last_update_date between p_from_date and p_to_date
277: AND ctlgd.account_set_flag = 'N'
278: AND ctlgd.customer_trx_line_id = ctl.customer_trx_line_id
279: AND nvl(ctl.interface_line_context, 'xxx') IN ('GEMMS OP')

Line 307: ra_customer_trx_all ct

303: (SELECT count(*) cnt
304: FROM
305: ra_cust_trx_line_gl_dist_all ctlgd,
306: ra_customer_trx_lines_all ctl,
307: ra_customer_trx_all ct
308: WHERE ctlgd.last_update_date between p_from_date and p_to_date
309: AND ctlgd.account_class not in ('REC','UNBILL')
310: AND ctlgd.account_set_flag = 'N'
311: AND nvl(ctlgd.amount,0) <> 0

Line 322: ra_customer_trx_all ct

318: UNION ALL
319: SELECT count(*)
320: FROM
321: ra_customer_trx_lines_all ctl,
322: ra_customer_trx_all ct
323: WHERE ctl.last_update_date between p_from_date and p_to_date
324: AND (nvl(ctl.interface_line_context, 'xxx') NOT IN ('PA INVOICES', 'ORDER ENTRY')
325: OR (ctl.interface_line_context = 'ORDER ENTRY'
326: AND translate(ctl.interface_line_attribute6, 'z0123456789', 'z') IS NOT NULL))

Line 336: ra_customer_trx_all ct

332: UNION ALL
333: SELECT count(*)
334: FROM
335: ar_adjustments_all adj,
336: ra_customer_trx_all ct
337: WHERE adj.last_update_date between p_from_date and p_to_date
338: AND nvl(adj.status, 'A') = 'A'
339: AND nvl(adj.postable,'Y') = 'Y'
340: AND ct.customer_trx_id = adj.customer_trx_id

Line 376: ra_customer_trx_all ct

372: SELECT count(*)
373: from
374: ra_cust_trx_line_gl_dist_all ctlgd,
375: ra_customer_trx_lines_all ctl,
376: ra_customer_trx_all ct
377: WHERE ctlgd.last_update_date between p_from_date and p_to_date
378: AND ctlgd.account_class not in ('REC','UNBILL')
379: AND ctlgd.account_set_flag = 'N'
380: AND nvl(ctlgd.amount,0) <> 0

Line 391: ra_customer_trx_all ct

387: UNION ALL
388: SELECT count(*)
389: FROM
390: ra_customer_trx_lines_all ctl,
391: ra_customer_trx_all ct
392: WHERE ctl.last_update_date between p_from_date and p_to_date
393: AND ctl.interface_line_context = 'ORDER ENTRY'
394: AND DECODE(ctl.interface_line_attribute6, NULL, NULL,
395: translate(ctl.interface_line_attribute6, 'z0123456789', 'z')) IS NULL

Line 422: FROM ra_customer_trx_all

418: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
419:
420: CURSOR c_cnt_rows IS
421: SELECT count(*)
422: FROM ra_customer_trx_all
423: where last_update_date between p_from_date and p_to_date;
424: BEGIN
425: OPEN c_cnt_rows;
426: FETCH c_cnt_rows INTO p_num_rows;