APPS.PSA_MFAR_RECEIPTS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 154: FROM ra_customer_trx_lines lines, ra_cust_trx_line_gl_dist dist

150:
151: CURSOR c_direct_cm (c_cust_trx_id NUMBER)
152: IS
153: SELECT distinct lines.previous_customer_trx_line_id trx_line_id
154: FROM ra_customer_trx_lines lines, ra_cust_trx_line_gl_dist dist
155: WHERE lines.customer_trx_id = c_cust_trx_id
156: AND lines.customer_trx_line_id = dist.customer_trx_line_id
157: AND dist.account_class <> 'REC'
158: AND lines.extended_amount <> 0;

Line 164: ra_cust_trx_line_gl_dist dist

160: CURSOR c_direct_cm_line_amount (c_cust_trx_id NUMBER, c_trx_line_id NUMBER)
161: IS
162: Select sum(dist.amount) line_amount
163: From ra_customer_trx_lines lines,
164: ra_cust_trx_line_gl_dist dist
165: Where lines.customer_trx_id = c_cust_trx_id
166: And lines.previous_customer_trx_line_id = c_trx_line_id
167: And lines.customer_trx_line_id = dist.customer_trx_line_id
168: And dist.account_class <> 'REC'

Line 702: ra_cust_trx_line_gl_dist_all trx_dist,

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
706: And mf_balances.customer_trx_id = p_cust_trx_id

Line 721: ra_cust_trx_line_gl_dist_all trx_dist

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
725: And trx_dist.account_class = 'REV';

Line 898: ra_cust_trx_line_gl_dist_all trx_dist,

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
902: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id

Line 939: ' ra_cust_trx_line_gl_dist trx_dist, ' ||

935: ' trx_line.customer_trx_line_id trx_line_id, ' ||
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 ' ||

Line 959: ' ra_cust_trx_line_gl_dist trx_dist, ' ||

955: ' trx_line.customer_trx_line_id trx_line_id, ' ||
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 ' ||

Line 1523: ra_cust_trx_line_gl_dist_all trx_dist,

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
1527: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id

Line 1577: ' ra_cust_trx_line_gl_dist trx_dist, ' ||

1573: -- ' decode (:sum_adr, 0, mf_balances.amount_due_original, mf_balances.amount_due_remaining) amount_due, ' ||
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 ' ||

Line 1596: ' ra_cust_trx_line_gl_dist trx_dist, ' ||

1592: -- ' decode (:sum_adr, 0, mf_balances.amount_due_original, mf_balances.amount_due_remaining) amount_due, '||
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 ' ||

Line 1635: ra_cust_trx_line_gl_dist trx_dist,

1631:
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