APPS.PSA_MFAR_RECEIPTS dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 701: From ra_customer_trx_lines_all trx_line,

697: trx_line.link_to_cust_trx_line_id link_trx_line_id,
698: -- column below changed by RM for 1604281
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

Line 711: AND EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x

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
709: And mf_trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id
710: and trx_line.customer_trx_line_id = nvl (p_cust_trx_line_id,trx_line.customer_trx_line_id)
711: AND EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x
712: WHERE x.customer_trx_line_id = trx_line.customer_trx_line_id
713: AND NVL(extended_amount, 0) <> 0)
714: ORDER BY 2 DESC;
715:

Line 720: ra_customer_trx_lines_all trx_line,

716: Cursor c_cash Is
717: Select trx_dist.code_combination_id rev_ccid,
718: trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id
719: From ra_customer_trx_all trx,
720: ra_customer_trx_lines_all trx_line,
721: ra_cust_trx_line_gl_dist_all trx_dist
722: Where trx.customer_trx_id = p_cust_trx_id
723: And trx.customer_trx_id = trx_line.customer_trx_id
724: And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id

Line 872: FROM ra_customer_trx_lines_all

868: SELECT 1
869: INTO l_zero_amt_flag
870: FROM DUAL
871: WHERE EXISTS (SELECT 1
872: FROM ra_customer_trx_lines_all
873: WHERE customer_trx_id = p_cust_trx_id
874: AND extended_amount <> 0 );
875: EXCEPTION
876: WHEN NO_DATA_FOUND THEN

Line 897: FROM ra_customer_trx_lines_all trx_line,

893: decode (l_zero_amt_flag,1,sum(mf_balances.amount_due_original),
894: sum(mf_balances.amount_due_remaining)) sum_amt_due_rem
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

Line 949: ' And EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x ' ||

945: ' And trx_dist.cust_trx_line_gl_dist_id = mf_trx_dist.cust_trx_line_gl_dist_id ' ||
946: ' And mf_trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id ' ||
947: ' And trx_line.customer_trx_line_id = nvl(:p_cust_trx_line_id,trx_line.customer_trx_line_id) ';
948: /* ' ||
949: ' And EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x ' ||
950: ' WHERE x.customer_trx_line_id = trx_line.customer_trx_line_id AND NVL(extended_amount, 0) <> 0) '; */
951:
952: l_c_cash_stmt :=
953: 'Select trx_dist.code_combination_id rcv_ccid, ' ||

Line 968: ' And EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x ' ||

964: ' And trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id ' ||
965: ' And trx_dist.account_class <> '''||'REC'||''' ' ||
966: ' And trx_line.customer_trx_line_id = nvl(:p_cust_trx_line_id,trx_line.customer_trx_line_id) ';
967: /* ' ||
968: ' And EXISTS (SELECT 1 FROM ra_customer_trx_lines_all x ' ||
969: ' WHERE x.customer_trx_line_id = trx_line.customer_trx_line_id AND NVL(extended_amount, 0) <> 0) '; */
970:
971:
972: IF l_total_amount_due < 0 THEN

Line 1522: FROM ra_customer_trx_lines_all trx_line,

1518: sum(mf_balances.amount_due_original)) total_amount_due,
1519: sum(mf_balances.amount_due_original) sum_amt_due_rem
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