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_RECEIPTS dependencies on PSA_MF_TRX_DIST_ALL

Line 703: psa_mf_trx_dist_all mf_trx_dist,

699: decode (sum_adr, 0, mf_balances.amount_due_original,
700: mf_balances.amount_due_remaining) amount_due
701: From ra_customer_trx_lines_all trx_line,
702: ra_cust_trx_line_gl_dist_all trx_dist,
703: psa_mf_trx_dist_all mf_trx_dist,
704: psa_mf_balances_view mf_balances
705: Where trx_line.customer_trx_id = p_cust_trx_id
706: And mf_balances.customer_trx_id = p_cust_trx_id
707: And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id

Line 940: ' psa_mf_trx_dist_all mf_trx_dist, ' ||

936: ' trx_line.link_to_cust_trx_line_id link_trx_line_id, ' ||
937: ' decode (:l_zero_amt_flag, 1, mf_balances.amount_due_original, mf_balances.amount_due_remaining) amount_due ' ||
938: ' From ra_customer_trx_lines trx_line, ' ||
939: ' ra_cust_trx_line_gl_dist trx_dist, ' ||
940: ' psa_mf_trx_dist_all mf_trx_dist, ' ||
941: ' psa_mf_balances_view mf_balances ' ||
942: ' Where trx_line.customer_trx_id = :p_cust_trx_id_1 ' ||
943: ' And mf_balances.customer_trx_id = :p_cust_trx_id_2 ' ||
944: ' And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id ' ||

Line 1578: ' psa_mf_trx_dist_all mf_trx_dist, ' ||

1574: ' decode (:sum_adr, 0, mf_balances.amount_due_original, mf_balances.amount_due_original) amount_due, '||
1575: ' trx_dist.account_class account_class ' ||
1576: ' From ra_customer_trx_lines trx_line, ' ||
1577: ' ra_cust_trx_line_gl_dist trx_dist, ' ||
1578: ' psa_mf_trx_dist_all mf_trx_dist, ' ||
1579: ' psa_mf_balances_view mf_balances ' ||
1580: ' Where trx_line.customer_trx_id = :p_cust_trx_id_1 ' ||
1581: ' And mf_balances.customer_trx_id = :p_cust_trx_id_2 ' ||
1582: ' And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id ' ||

Line 1636: psa_mf_trx_dist_all mf_trx_dist

1632: SELECT count(1)
1633: INTO l_count
1634: FROM ra_customer_trx_lines trx_line,
1635: ra_cust_trx_line_gl_dist trx_dist,
1636: psa_mf_trx_dist_all mf_trx_dist
1637: WHERE trx_line.customer_trx_id = p_cust_trx_id
1638: AND trx_dist.account_class = 'REV'
1639: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
1640: AND trx_dist.cust_trx_line_gl_dist_id = mf_trx_dist.cust_trx_line_gl_dist_id