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_SIZING_UTIL dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 211: ra_customer_trx_lines_all ctl,

207: select sum(cnt) from
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

Line 226: ra_customer_trx_lines_all ctl,

222: AND ct.complete_flag = 'Y'
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'

Line 249: ra_customer_trx_lines_all ctl,

245: UNION ALL
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

Line 262: ra_customer_trx_lines_all ctl,

258: AND ct.complete_flag = 'Y'
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,

Line 274: ra_customer_trx_lines_all ctl,

270: UNION ALL
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

Line 306: ra_customer_trx_lines_all ctl,

302: select sum(cnt) from
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'

Line 321: ra_customer_trx_lines_all ctl,

317: AND ct.complete_flag = 'Y'
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'

Line 375: ra_customer_trx_lines_all ctl,

371: UNION ALL
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'

Line 390: ra_customer_trx_lines_all ctl,

386: AND ct.complete_flag = 'Y'
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,