81: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
82: exchange_rate NUMBER,
83: exchange_date DATE,
84: term_id NUMBER(15),
85: first_installment_code ra_terms.first_installment_code%type,
86: rec_acctd_amount NUMBER,
87: total_line_amount NUMBER,
88: total_tax_amount NUMBER,
89: total_freight_amount NUMBER,
523: /* :raagixlul, */
524: sum(decode(ctl.line_type, ''CHARGES'', ctl.extended_amount, 0)),
525: ct.reversed_cash_receipt_id /* Bug3328690 */
526: FROM
527: ra_terms t,
528: ra_terms_lines tl,
529: ra_cust_trx_types ctt,
530: ra_customer_trx ct,
531: ra_cust_trx_line_gl_dist ctlgd,
524: sum(decode(ctl.line_type, ''CHARGES'', ctl.extended_amount, 0)),
525: ct.reversed_cash_receipt_id /* Bug3328690 */
526: FROM
527: ra_terms t,
528: ra_terms_lines tl,
529: ra_cust_trx_types ctt,
530: ra_customer_trx ct,
531: ra_cust_trx_line_gl_dist ctlgd,
532: fnd_currencies c,
3628: ar_payment_schedules ps,
3629: ar_receivable_applications ra,
3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3629: ar_receivable_applications ra,
3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,