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.ARP_BF_BILL dependencies on RA_CUSTOMER_TRX

Line 5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE

1: PACKAGE BODY arp_bf_bill AS
2: /* $Header: ARPBFBIB.pls 120.51.12020000.9 2012/07/24 09:22:18 ashlkuma ship $ */
3:
4: -- define structure to store data that needs to be overridden
5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE

Line 7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE

3:
4: -- define structure to store data that needs to be overridden
5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE

Line 9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE

5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE
12: INDEX BY BINARY_INTEGER;
13:

Line 11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE

7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE
12: INDEX BY BINARY_INTEGER;
13:
14:
15: l_tab_trx_id tab_trx_id;

Line 251: UPDATE ra_customer_trx

247: nvl(P_consinv_num_high, cons_billing_number)
248: AND concurrent_request_id = nvl(P_request_id, concurrent_request_id)
249: AND status = 'DRAFT';
250:
251: UPDATE ra_customer_trx
252: SET printing_original_date =
253: DECODE(printing_count,
254: 1, NULL,
255: printing_original_date),

Line 476: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date

472: l_tab_due_date(l_tab_idx) := new_due_date;
473:
474: -- Following update statements are moved from generate procedure to here
475: -- for the bug 6488683
476: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date
477: UPDATE RA_CUSTOMER_TRX
478: SET term_id = new_term_id,
479: billing_date = new_bill_date,
480: term_due_date = new_due_date

Line 477: UPDATE RA_CUSTOMER_TRX

473:
474: -- Following update statements are moved from generate procedure to here
475: -- for the bug 6488683
476: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date
477: UPDATE RA_CUSTOMER_TRX
478: SET term_id = new_term_id,
479: billing_date = new_bill_date,
480: term_due_date = new_due_date
481: WHERE customer_trx_id = P_trx_id;

Line 651: FROM ra_customer_trx CT,

647: CT.previous_customer_trx_id prev_trx_id,
648: CT.interface_header_attribute1 trx_desc,
649: CT.ship_to_site_use_id ship_id,
650: CT.term_due_date due_date
651: FROM ra_customer_trx CT,
652: ar_payment_schedules PS
653: WHERE PS.customer_site_use_id = C_site_use_id
654: AND PS.cons_inv_id IS NULL
655: AND PS.invoice_currency_code = nvl(C_use_currency, PS.invoice_currency_code)

Line 695: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;

691:
692: /* Bug 5203710 remove detail_option as limiting criteria */
693: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
694:
695: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
696: TYPE tab_num IS TABLE OF NUMBER ;
697:
698: l_line_id tab_line_id ;
699: l_tax_sum tab_num ;

Line 708: FROM ra_customer_trx_lines CTL

704: CURSOR c_tax (l_trx_id NUMBER) IS
705: SELECT link_to_cust_trx_line_id,
706: sum(nvl(CTL.extended_amount,0)),
707: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
708: FROM ra_customer_trx_lines CTL
709: WHERE CTL.customer_trx_id = l_trx_id
710: AND CTL.line_type = 'TAX'
711: GROUP BY link_to_cust_trx_line_id;
712:

Line 1397: ra_customer_trx ct

1393: /* Bug 9392028 */
1394: SELECT count(*)
1395: INTO l_cm_flag
1396: FROM ar_payment_schedules ps,
1397: ra_customer_trx ct
1398: WHERE ps.customer_trx_id = l_inv_trx.trx_id
1399: AND ct.customer_trx_id = ps.customer_trx_id
1400: AND ps.status = 'OP'
1401: AND ct.previous_customer_trx_id IS NULL;

Line 1408: FROM RA_CUSTOMER_TRX ct,

1404: --Resetting the same flag l_cm_flag.
1405:
1406: SELECT count(*)
1407: INTO l_cm_flag
1408: FROM RA_CUSTOMER_TRX ct,
1409: AR_PAYMENT_SCHEDULES ps
1410: WHERE ct.customer_trx_id IN (Select ra.APPLIED_CUSTOMER_TRX_ID
1411: FROM ar_receivable_applications ra
1412: WHERE ra.customer_trx_id = l_inv_trx.trx_id

Line 1412: WHERE ra.customer_trx_id = l_inv_trx.trx_id

1408: FROM RA_CUSTOMER_TRX ct,
1409: AR_PAYMENT_SCHEDULES ps
1410: WHERE ct.customer_trx_id IN (Select ra.APPLIED_CUSTOMER_TRX_ID
1411: FROM ar_receivable_applications ra
1412: WHERE ra.customer_trx_id = l_inv_trx.trx_id
1413: AND ra.status = 'APP'
1414: AND ra.application_type = 'CM'
1415: AND ra.apply_date <= l_billing_date
1416: GROUP BY ra.APPLIED_CUSTOMER_TRX_ID

Line 1592: FROM ra_customer_trx_lines

1588: nvl (gross_unit_selling_price, unit_selling_price),
1589: nvl (gross_extended_amount, extended_amount),
1590: 0,
1591: org_id
1592: FROM ra_customer_trx_lines
1593: WHERE customer_trx_id = L_inv_trx.trx_id
1594: AND line_type NOT IN ('TAX', 'FREIGHT');
1595:
1596: /** now update lines with associated tax line **/

Line 1647: ra_customer_trx_lines

1643: sum (nvl (gross_extended_amount, extended_amount)),
1644: 0,
1645: org_id
1646: FROM
1647: ra_customer_trx_lines
1648: WHERE
1649: customer_trx_id = L_inv_trx.trx_id
1650: AND line_type = 'FREIGHT'
1651: GROUP BY line_type,org_id;

Line 1802: ra_customer_trx inv_trx

1798: OR (ps.amount_due_original +
1799: (SELECT nvl(SUM(nvl(ra.amount_applied_from, ra.amount_applied)), 0)
1800: FROM ar_receivable_applications ra,
1801: ar_payment_schedules ps_inv,
1802: ra_customer_trx inv_trx
1803: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1804: AND inv_trx.customer_trx_id = ra.applied_customer_trx_id
1805: AND RA.status = 'APP'
1806: AND ra.application_type = 'CASH'

Line 2263: ra_customer_trx inv_trx

2259: OR (ps.amount_due_original +
2260: (SELECT nvl(SUM(nvl(ra.amount_applied_from, ra.amount_applied)), 0)
2261: FROM ar_receivable_applications ra,
2262: ar_payment_schedules ps_inv,
2263: ra_customer_trx inv_trx
2264: WHERE ra.cash_receipt_id = cr.cash_receipt_id
2265: AND inv_trx.customer_trx_id = ra.applied_customer_trx_id
2266: AND RA.status = 'APP'
2267: AND ra.application_type = 'CASH'

Line 2372: ra_customer_trx inv_trx,

2368: ps_cash.org_id
2369: FROM
2370: ar_receivable_applications RA,
2371: ar_payment_schedules ps_cash,
2372: ra_customer_trx inv_trx,
2373: ar_payment_schedules ps_app
2374: WHERE
2375: RA.cons_inv_id IS NULL
2376: AND RA.status = 'APP'

Line 2565: -- update ra_customer_trx_all with the printing dates for all the transactions included.

2561:
2562: write_debug_and_log('Updating AR_CONS_INV');
2563:
2564: -- 6955957
2565: -- update ra_customer_trx_all with the printing dates for all the transactions included.
2566: UPDATE ra_customer_trx trx
2567: SET printing_original_date = nvl(printing_original_date, SYSDATE),
2568: printing_last_printed = nvl(printing_last_printed, SYSDATE)
2569: WHERE trx.trx_number IN

Line 2566: UPDATE ra_customer_trx trx

2562: write_debug_and_log('Updating AR_CONS_INV');
2563:
2564: -- 6955957
2565: -- update ra_customer_trx_all with the printing dates for all the transactions included.
2566: UPDATE ra_customer_trx trx
2567: SET printing_original_date = nvl(printing_original_date, SYSDATE),
2568: printing_last_printed = nvl(printing_last_printed, SYSDATE)
2569: WHERE trx.trx_number IN
2570: (SELECT trx_number

Line 2635: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');

2631: -- into ar_cons_inv_trx.
2632: /*
2633: -- Following is the update for all data overridden in TRX table
2634: IF l_tab_idx > 0 THEN
2635: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');
2636: FORALL i IN 1..l_tab_idx
2637: UPDATE RA_CUSTOMER_TRX
2638: SET term_id = l_tab_term_id(i),
2639: billing_date = l_tab_billing_date(i),

Line 2637: UPDATE RA_CUSTOMER_TRX

2633: -- Following is the update for all data overridden in TRX table
2634: IF l_tab_idx > 0 THEN
2635: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');
2636: FORALL i IN 1..l_tab_idx
2637: UPDATE RA_CUSTOMER_TRX
2638: SET term_id = l_tab_term_id(i),
2639: billing_date = l_tab_billing_date(i),
2640: term_due_date = l_tab_due_date(i)
2641: WHERE customer_trx_id = l_tab_trx_id(i);

Line 2736: Because ra_customer_trx was not updated after

2732:
2733: BEGIN
2734:
2735: /* bug3604391 Changed the sequence of following update stmts.
2736: Because ra_customer_trx was not updated after
2737: ar_cons_inv.print_status was changed.
2738: */
2739: UPDATE ra_customer_trx CT
2740: SET CT.printing_original_date =

Line 2739: UPDATE ra_customer_trx CT

2735: /* bug3604391 Changed the sequence of following update stmts.
2736: Because ra_customer_trx was not updated after
2737: ar_cons_inv.print_status was changed.
2738: */
2739: UPDATE ra_customer_trx CT
2740: SET CT.printing_original_date =
2741: nvl(CT.printing_original_date,sysdate),
2742: CT.printing_last_printed = sysdate,
2743: CT.printing_count = nvl(CT.printing_count,0) +