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_BALANCES_VIEW

Line 704: psa_mf_balances_view mf_balances

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
708: And trx_dist.cust_trx_line_gl_dist_id = mf_trx_dist.cust_trx_line_gl_dist_id

Line 899: psa_mf_balances_view mf_balances

895: INTO l_total_amount_due,
896: sum_amt_due_rem
897: FROM ra_customer_trx_lines_all trx_line,
898: ra_cust_trx_line_gl_dist_all trx_dist,
899: psa_mf_balances_view mf_balances
900: WHERE trx_line.customer_trx_id = p_cust_trx_id
901: AND mf_balances.customer_trx_id = p_cust_trx_id
902: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
903: AND trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id

Line 941: ' psa_mf_balances_view mf_balances ' ||

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 ' ||
945: ' And trx_dist.cust_trx_line_gl_dist_id = mf_trx_dist.cust_trx_line_gl_dist_id ' ||

Line 960: ' psa_mf_balances_view mf_balances ' ||

956: ' trx_line.link_to_cust_trx_line_id link_trx_line_id, ' ||
957: ' decode (:l_zero_amt_flag, 1, mf_balances.amount_due_original, mf_balances.amount_due_remaining) amount_due ' ||
958: ' From ra_customer_trx_lines trx_line, ' ||
959: ' ra_cust_trx_line_gl_dist trx_dist, ' ||
960: ' psa_mf_balances_view mf_balances ' ||
961: ' Where trx_line.customer_trx_id = :p_cust_trx_id_1 ' ||
962: ' And mf_balances.customer_trx_id = :p_cust_trx_id_2 ' ||
963: ' And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id ' ||
964: ' And trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id ' ||

Line 1524: psa_mf_balances_view mf_balances

1520: INTO l_total_amount_due,
1521: sum_amt_due_rem
1522: FROM ra_customer_trx_lines_all trx_line,
1523: ra_cust_trx_line_gl_dist_all trx_dist,
1524: psa_mf_balances_view mf_balances
1525: WHERE trx_line.customer_trx_id = p_cust_trx_id
1526: AND mf_balances.customer_trx_id = p_cust_trx_id
1527: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
1528: AND trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id

Line 1579: ' psa_mf_balances_view mf_balances ' ||

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 ' ||
1583: ' And trx_dist.cust_trx_line_gl_dist_id = mf_trx_dist.cust_trx_line_gl_dist_id ' ||

Line 1597: ' psa_mf_balances_view mf_balances ' ||

1593: ' decode (:sum_adr, 0, mf_balances.amount_due_original, mf_balances.amount_due_original) amount_due, '||
1594: ' trx_dist.account_class account_class' ||
1595: ' From ra_customer_trx_lines trx_line, ' ||
1596: ' ra_cust_trx_line_gl_dist trx_dist, ' ||
1597: ' psa_mf_balances_view mf_balances ' ||
1598: ' Where trx_line.customer_trx_id = :p_cust_trx_id_1 ' ||
1599: ' And mf_balances.customer_trx_id = :p_cust_trx_id_2 ' ||
1600: ' And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id ' ||
1601: ' And trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id ' ||