APPS.ARP_PROCESS_ADJUSTMENT dependencies on RA_CUSTOMER_TRX_LINES

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 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 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;