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 RA_CUSTOMER_TRX

Line 11: TYPE TrxLinesTyp IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE

7: g_inventory_item_profile NUMBER;
8: g_run_id NUMBER;
9: l_exception_message VARCHAR2(3000);
10:
11: TYPE TrxLinesTyp IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE
12: INDEX BY BINARY_INTEGER;
13:
14: TrxLinesTab TrxLinesTyp;
15: --===========================FND_LOG.START=====================================

Line 141: FROM ra_customer_trx_all

137:
138: CURSOR c_credit_memo_type (c_cust_trx_id NUMBER)
139: IS
140: SELECT previous_customer_trx_id
141: FROM ra_customer_trx_all
142: WHERE customer_trx_id = c_cust_trx_id;
143:
144: --
145: -- Bug 2515944

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 163: From ra_customer_trx_lines lines,

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

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 719: From ra_customer_trx_all trx,

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

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 938: ' From ra_customer_trx_lines trx_line, ' ||

934: ' mf_trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id, ' ||
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 ' ||

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 958: ' From ra_customer_trx_lines trx_line, ' ||

954: ' trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id, ' ||
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 ' ||

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

Line 1576: ' From ra_customer_trx_lines trx_line, ' ||

1572: ' trx_line.link_to_cust_trx_line_id link_trx_line_id, ' ||
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 ' ||

Line 1595: ' From ra_customer_trx_lines trx_line, ' ||

1591: ' trx_line.link_to_cust_trx_line_id link_trx_line_id, ' ||
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 ' ||

Line 1634: FROM ra_customer_trx_lines trx_line,

1630: -- Get the count of REVENUE lines
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'

Line 2092: FROM ra_customer_trx trx,

2088: CURSOR c_variables
2089: IS
2090: SELECT terms.calc_discount_on_lines_flag discount_basis,
2091: trx.created_from created_from
2092: FROM ra_customer_trx trx,
2093: ra_terms_b terms
2094: WHERE trx.customer_trx_id = p_customer_trx_id
2095: AND trx.term_id = terms.term_id;
2096:

Line 2168: FROM ra_customer_trx_lines

2164:
2165: CURSOR c_manual_trx
2166: IS
2167: SELECT customer_trx_line_id, link_to_cust_trx_line_id, line_type
2168: FROM ra_customer_trx_lines
2169: WHERE customer_trx_id = p_customer_trx_id
2170: AND include_manual_line (discount_basis, link_to_cust_trx_line_id, line_type) = 'Y';
2171:
2172: l_manual_trx_rec c_manual_trx%ROWTYPE;

Line 2228: FROM ra_customer_trx_lines

2224: IS
2225: CURSOR c_tax_line
2226: IS
2227: SELECT line_type
2228: FROM ra_customer_trx_lines
2229: WHERE customer_trx_line_id = p_link_to_cust_trx_line_id;
2230:
2231: l_tax_line c_tax_line%rowtype;
2232: -- ========================= FND LOG ===========================

Line 2294: FROM ra_customer_trx_lines

2290:
2291: CURSOR c_imported_trx
2292: IS
2293: SELECT line_type, customer_trx_line_id, link_to_cust_trx_line_id, inventory_item_id
2294: FROM ra_customer_trx_lines
2295: WHERE customer_trx_id = p_customer_trx_id
2296: AND include_imported_line
2297: (p_discount_basis, link_to_cust_trx_line_id, line_type, inventory_item_id) = 'Y';
2298:

Line 2360: From ra_customer_trx_lines

2356: RETURN VARCHAR2 IS
2357:
2358: CURSOR c_inventory_item IS
2359: Select inventory_item_id
2360: From ra_customer_trx_lines
2361: Where customer_trx_line_id = p_link_to_cust_trx_line_id;
2362:
2363: CURSOR c_tax_line IS
2364: Select line_type

Line 2365: From ra_customer_trx_lines

2361: Where customer_trx_line_id = p_link_to_cust_trx_line_id;
2362:
2363: CURSOR c_tax_line IS
2364: Select line_type
2365: From ra_customer_trx_lines
2366: Where customer_trx_line_id = p_link_to_cust_trx_line_id;
2367:
2368: l_inventory_item_rec c_inventory_item%rowtype;
2369: l_tax_line_rec c_tax_line%rowtype;