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

Line 122: ra_customer_trx t,

118: balance on the invoice */
119: SELECT SUM(NVL(d.amount,0)) amount
120: INTO l_cm_amount
121: FROM ra_cust_trx_line_gl_dist d,
122: ra_customer_trx t,
123: ar_payment_schedules p
124: WHERE p.payment_schedule_id = p_payment_schedule_id
125: AND p.customer_trx_id = t.previous_customer_trx_id
126: AND d.customer_trx_id = t.customer_trx_id

Line 490: ra_customer_trx_lines ctl

486: ard.ref_account_class,
487: ard.activity_bucket,
488: ctl.line_type
489: FROM ar_distributions ard,
490: ra_customer_trx_lines ctl
491: WHERE ctl.customer_trx_id = p_customer_trx_id
492: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id
493: AND (ctl.customer_trx_line_id = p_customer_trx_line_id
494: OR

Line 508: ra_customer_trx_lines ctll

504: (SELECT SUM(ctlgd.AMOUNT) sum_orig,
505: SUM(ctlgd.ACCTD_AMOUNT) sum_acctd_orig,
506: ctlgd.customer_trx_line_id
507: FROM ra_cust_trx_line_gl_dist ctlgd,
508: ra_customer_trx_lines ctll
509: WHERE ctlgd.customer_trx_id = p_customer_trx_id
510: AND ctlgd.customer_trx_line_id = ctll.customer_trx_line_id
511: AND (ctll.customer_trx_line_id = p_customer_trx_line_id
512: OR

Line 518: ra_customer_trx_lines ctl1

514: AND ctll.line_type = 'TAX'
515: )
516: )
517: GROUP BY ctlgd.customer_trx_line_id) b,
518: ra_customer_trx_lines ctl1
519: WHERE a.ref_customer_trx_line_id (+) = b.customer_trx_line_id
520: and b.customer_trx_line_id=ctl1.customer_trx_line_id
521: GROUP BY b.customer_trx_line_id,
522: b.sum_orig,

Line 527: FROM ra_customer_trx_lines

523: b.sum_acctd_orig, ctl1.line_type;
524:
525: /* CURSOR cu_line_tax (p_customer_trx_id IN NUMBER, p_customer_trx_line_id IN NUMBER) IS
526: SELECT customer_trx_line_id
527: FROM ra_customer_trx_lines
528: WHERE customer_trx_line_id = p_customer_trx_id
529: AND (customer_trx_line_id = p_customer_trx_line_id
530: OR
531: (link_to_cust_trx_line_id = p_customer_trx_line_id

Line 618: ra_customer_trx_lines ctl

614: INTO l_term_ratio,
615: l_line_original
616: FROM ra_terms_lines tl,
617: ra_terms t,
618: ra_customer_trx_lines ctl
619: WHERE p_ps_rec.term_id = t.term_id
620: AND t.term_id = tl.term_id
621: AND p_ps_rec.terms_sequence_number = tl.sequence_num
622: AND ctl.customer_trx_line_id =

Line 627: FROM ra_customer_trx_lines ctl

623: p_adj_rec.customer_trx_line_id;
624: ELSE */ /* 1909312 Code Added begins */
625: /* SELECT ctl.extended_amount
626: INTO l_line_original
627: FROM ra_customer_trx_lines ctl
628: WHERE ctl.customer_trx_line_id =
629: p_adj_rec.customer_trx_line_id;
630: l_term_ratio := 1;
631: END IF; */ /* 1909312 Code Added Ends */

Line 636: FROM ra_customer_trx_lines ctl

632:
633: --Add for 13538911
634: /* SELECT NVL(SUM(ctl.extended_amount),0)
635: INTO l_line_tax
636: FROM ra_customer_trx_lines ctl
637: WHERE ctl.link_to_cust_trx_line_id=
638: p_adj_rec.customer_trx_line_id;
639:
640: SELECT NVL(SUM(amount),0)

Line 656: FROM ra_customer_trx_lines ctl

652: ),
653: p_ps_rec.invoice_currency_code
654: )
655: INTO l_line_credited
656: FROM ra_customer_trx_lines ctl
657: WHERE ctl.previous_customer_trx_line_id =
658: p_adj_rec.customer_trx_line_id;
659: */
660: /*

Line 1185: l_customer_trx ra_customer_trx%ROWTYPE;

1181: l_line_id NUMBER;
1182: v_cont NUMBER;
1183: v_claim_amt varchar2(100);
1184:
1185: l_customer_trx ra_customer_trx%ROWTYPE;
1186: l_gl_account_source ar_receivables_trx.gl_account_source%type;
1187: l_tax_code_source ar_receivables_trx.tax_code_source%type;
1188: BEGIN
1189:

Line 1252: FROM ra_customer_trx rct,

1248:
1249: BEGIN
1250:
1251: SELECT ps.amount_due_remaining-ofc.amount+p_adj_rec.amount,ofc.amount into v_cont,v_claim_amt ---Modified for the bug 14500887
1252: FROM ra_customer_trx rct,
1253: ar_payment_schedules ps,
1254: ar_receivable_applications ra,
1255: ozf_claims ofc
1256: WHERE rct.customer_trx_id=ps.customer_trx_id

Line 1762: select * into l_customer_trx from ra_customer_trx

1758: /*---------------------+
1759: | post-insert logic |
1760: +---------------------*/
1761: begin
1762: select * into l_customer_trx from ra_customer_trx
1763: where customer_trx_id= p_adj_rec.customer_trx_id;
1764: exception
1765: when others then
1766: null;

Line 2179: from ra_customer_trx ct, ra_cust_trx_types ctt

2175: BEGIN
2176:
2177: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
2178: into l_adj_post_to_gl
2179: from ra_customer_trx ct, ra_cust_trx_types ctt
2180: where ct.customer_trx_id = l_adj_rec.customer_trx_id
2181: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
2182:
2183: IF PG_DEBUG in ('Y', 'C') THEN

Line 3100: from ra_customer_trx ct, ra_cust_trx_types ctt

3096: /* 7699796 */
3097:
3098: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
3099: into l_adj_post_to_gl
3100: from ra_customer_trx ct, ra_cust_trx_types ctt
3101: where ct.customer_trx_id = l_adj_rec.customer_trx_id
3102: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
3103:
3104: IF PG_DEBUG in ('Y', 'C') THEN

Line 3617: from ra_customer_trx ct, ra_cust_trx_types ctt

3613: BEGIN
3614:
3615: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
3616: into l_adj_post_to_gl
3617: from ra_customer_trx ct, ra_cust_trx_types ctt
3618: where ct.customer_trx_id = p_adj_rec.customer_trx_id
3619: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
3620:
3621: IF PG_DEBUG in ('Y', 'C') THEN

Line 3834: | ra_customer_Trx_lines for Line Level |

3830: | calculate prorated amounts for activity|
3831: | tax code |
3832: | 17-AUG-05 Debbie Jancis Added customer_Trx_line_id for LLCA |
3833: | and selected the balances from |
3834: | ra_customer_Trx_lines for Line Level |
3835: +===========================================================================*/
3836:
3837: PROCEDURE cal_prorated_amounts( p_adj_amount IN number,
3838: p_payment_schedule_id IN number,

Line 3888: FROM ra_customer_Trx trx,

3884:
3885: IF (arp_legal_entity_util.Is_LE_Subscriber) THEN
3886: SELECT trx.legal_entity_id
3887: INTO l_le_id
3888: FROM ra_customer_Trx trx,
3889: ar_payment_schedules ps
3890: where ps.payment_schedule_id = p_payment_schedule_id
3891: and ps.customer_trx_id = trx.customer_trx_id;
3892:

Line 3944: FROM ra_customer_trx ct,

3940: max(ct.invoice_currency_code) -- curr code
3941: INTO l_line_remaining,
3942: l_tax_remaining,
3943: l_invoice_currency_code
3944: FROM ra_customer_trx ct,
3945: ra_customer_trx_lines lines
3946: WHERE (lines.customer_Trx_line_id = p_cust_trx_line_id or
3947: lines.link_to_cust_trx_line_id = p_cust_trx_line_id)
3948: AND ct.customer_Trx_id = lines.customer_trx_id;

Line 3945: ra_customer_trx_lines lines

3941: INTO l_line_remaining,
3942: l_tax_remaining,
3943: l_invoice_currency_code
3944: FROM ra_customer_trx ct,
3945: ra_customer_trx_lines lines
3946: WHERE (lines.customer_Trx_line_id = p_cust_trx_line_id or
3947: lines.link_to_cust_trx_line_id = p_cust_trx_line_id)
3948: AND ct.customer_Trx_id = lines.customer_trx_id;
3949: END IF;

Line 3977: FROM ra_customer_Trx trx,

3973: IF l_tax_code_source = 'ACTIVITY' THEN
3974:
3975: SELECT trx.legal_entity_id
3976: INTO l_le_id
3977: FROM ra_customer_Trx trx,
3978: ar_payment_schedules ps
3979: WHERE ps.payment_schedule_id = p_payment_schedule_id
3980: AND ps.customer_trx_id = trx.customer_trx_id;
3981: