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.PSA_MFAR_ADJUSTMENTS dependencies on PSA_MF_BALANCES_VIEW

Line 376: psa_mf_balances_view D

372: B.percent -- panatara
373: From ra_customer_trx_lines A,
374: ra_cust_trx_line_gl_dist B,
375: psa_mf_trx_dist_all C,
376: psa_mf_balances_view D
377: Where A.customer_trx_id = g_customer_trx_id
378: and A.customer_trx_line_id = B.customer_trx_line_id
379: and B.account_class <> 'REC'
380: and B.cust_trx_line_gl_dist_id = C.cust_trx_line_gl_dist_id

Line 451: psa_mf_balances_view mf_balances

447: sum(mf_balances.amount_due_remaining) sum_amt_due_rem
448: Into l_total_amount_due, sum_amt_due_rem
449: From ra_customer_trx_lines trx_lines,
450: ra_cust_trx_line_gl_dist trx_dist,
451: psa_mf_balances_view mf_balances
452: Where trx_lines.customer_trx_id = g_customer_trx_id
453: And trx_lines.customer_trx_line_id = trx_dist.customer_trx_line_id
454: And trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id
455: And trx_lines.customer_trx_line_id = nvl(g_cust_trx_line_id, trx_dist.customer_trx_line_id)

Line 492: psa_mf_balances_view D

488: SELECT count(*) INTO l_distr_line_count
489: FROM ra_customer_trx_lines A,
490: ra_cust_trx_line_gl_dist B,
491: psa_mf_trx_dist_all C,
492: psa_mf_balances_view D
493: WHERE A.customer_trx_id = g_customer_trx_id
494: and A.customer_trx_line_id = B.customer_trx_line_id
495: and B.account_class <> 'REC'
496: and B.cust_trx_line_gl_dist_id = C.cust_trx_line_gl_dist_id