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_CONSINV dependencies on RA_CUSTOMER_TRX

Line 216: UPDATE ra_customer_trx

212: AND status = 'DRAFT' ;
213: -- bug2778646 end
214:
215: BEGIN
216: UPDATE ra_customer_trx
217: SET printing_original_date =
218: DECODE(printing_count,
219: 1, NULL,
220: printing_original_date),

Line 469: | 25-DEC-02 Hiroshi Yoshiahra 2700662: Removed link to ra_customer_trx

465: | 13-Dec-02 Sahana Shetty Bug2677085: Period receipt amounts |
466: | were calculated incorrectly when |
467: | receipt location was filled in after |
468: | applications were made to invoices. |
469: | 25-DEC-02 Hiroshi Yoshiahra 2700662: Removed link to ra_customer_trx
470: | table from sub-query of two insert stmts,
471: | one is for XSITE_CMREV,other is for |
472: | XSITE_CMAPP. |
473: | 09-JUN-05 V Crisostomo Bug 4367354: SSA, add org_id to inserts|

Line 574: ra_customer_trx CT,

570: PS.amount_due_original amount_due,
571: PS.tax_original tax,
572: PS.invoice_currency_code currency
573: FROM
574: ra_customer_trx CT,
575: ar_payment_schedules PS
576: WHERE
577: PS.customer_site_use_id = C_site_use_id
578: AND PS.cons_inv_id IS NULL

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

604: C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
605:
606: -- bug3039537
607: -- Calculate all tax amount and inclusive tax amount
608: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
609: TYPE tab_num IS TABLE OF NUMBER ;
610:
611: l_line_id tab_line_id ;
612: l_tax_sum tab_num ;

Line 622: FROM ra_customer_trx_lines CTL

618: IS
619: SELECT link_to_cust_trx_line_id,
620: sum(nvl(CTL.extended_amount,0)),
621: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
622: FROM ra_customer_trx_lines CTL
623: WHERE CTL.customer_trx_id = l_trx_id
624: AND CTL.line_type = 'TAX'
625: GROUP BY link_to_cust_trx_line_id;
626: -- bug3039537

Line 1020: ra_customer_trx_lines

1016: nvl (gross_extended_amount, extended_amount),
1017: 0,
1018: org_id
1019: FROM
1020: ra_customer_trx_lines
1021: WHERE
1022: customer_trx_id = L_inv_trx.trx_id
1023: AND line_type NOT IN ('TAX', 'FREIGHT');
1024:

Line 1054: ra_customer_trx_lines

1050: nvl (gross_extended_amount, extended_amount),
1051: 0,
1052: org_id
1053: FROM
1054: ra_customer_trx_lines
1055: WHERE
1056: customer_trx_id = L_inv_trx.trx_id
1057: AND line_type NOT IN ('TAX', 'FREIGHT');
1058: END IF;

Line 1065: FROM ra_customer_trx_lines CTL

1061: /* bug3039537 : Removed
1062: UPDATE ar_cons_inv_trx_lines TL
1063: set TL.tax_amount =
1064: (SELECT sum(nvl(CTL.extended_amount,0))
1065: FROM ra_customer_trx_lines CTL
1066: WHERE CTL.link_to_cust_trx_line_id =
1067: TL.customer_trx_line_id
1068: AND CTL.line_type = 'TAX')
1069: WHERE

Line 1123: ra_customer_trx_lines

1119: sum (nvl (gross_extended_amount, extended_amount)),
1120: 0,
1121: org_id
1122: FROM
1123: ra_customer_trx_lines
1124: WHERE
1125: customer_trx_id = L_inv_trx.trx_id
1126: AND line_type = 'FREIGHT'
1127: GROUP BY line_type,org_id;

Line 1473: ra_customer_trx CT

1469: ar_receivable_applications RA,
1470: ar_payment_schedules PS1,
1471: ar_payment_schedules PS2
1472: /* bug2700662 Removed
1473: ra_customer_trx CT
1474: */
1475: WHERE
1476: RA.cons_inv_id IS NULL
1477: AND RA.status = 'APP'

Line 1482: AND CT.customer_trx_id = RA.customer_trx_id

1478: AND RA.application_type = 'CM'
1479: /* bug2434295 Changed P_cutoff_date to l_real_cutoff_date */
1480: AND RA.apply_date < l_real_cutoff_date
1481: /* bug2700662 Removed
1482: AND CT.customer_trx_id = RA.customer_trx_id
1483: */
1484: AND PS1.payment_schedule_id = RA.payment_schedule_id
1485: AND PS1.customer_site_use_id = L_sites.site_id
1486: AND PS1.invoice_currency_code = P_currency

Line 1521: ra_customer_trx CT

1517: ar_receivable_applications RA,
1518: ar_payment_schedules PS1,
1519: ar_payment_schedules PS2
1520: /* bug2700662 Removed
1521: ra_customer_trx CT
1522: */
1523: WHERE
1524: RA.cons_inv_id_to IS NULL
1525: AND RA.status = 'APP'

Line 1530: AND CT.customer_trx_id = RA.customer_trx_id

1526: AND RA.application_type = 'CM'
1527: /* bug2434295 Changed P_cutoff_date to l_real_cutoff_date */
1528: AND RA.apply_date < l_real_cutoff_date
1529: /* bug2700662 Removed
1530: AND CT.customer_trx_id = RA.customer_trx_id
1531: AND CT.previous_customer_trx_id IS NULL
1532: */
1533: AND PS1.payment_schedule_id = RA.applied_payment_schedule_id
1534: AND PS1.customer_site_use_id = L_sites.site_id

Line 1728: Because ra_customer_trx was not updated after

1724:
1725: BEGIN
1726:
1727: /* bug3604391 Changed the sequence of following update stmts.
1728: Because ra_customer_trx was not updated after
1729: ar_cons_inv.print_status was changed.
1730: */
1731: UPDATE ra_customer_trx CT
1732: SET CT.printing_original_date =

Line 1731: UPDATE ra_customer_trx CT

1727: /* bug3604391 Changed the sequence of following update stmts.
1728: Because ra_customer_trx was not updated after
1729: ar_cons_inv.print_status was changed.
1730: */
1731: UPDATE ra_customer_trx CT
1732: SET CT.printing_original_date =
1733: nvl(CT.printing_original_date,sysdate),
1734: CT.printing_last_printed = sysdate,
1735: CT.printing_count = nvl(CT.printing_count,0) +