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,
515: /* :raagixlul, */
516: sum(decode(ctl.line_type, ''CHARGES'', ctl.extended_amount, 0)),
517: ct.reversed_cash_receipt_id /* Bug3328690 */
518: FROM
519: ra_terms t,
520: ra_terms_lines tl,
521: ra_cust_trx_types ctt,
522: ra_customer_trx ct,
523: ra_cust_trx_line_gl_dist ctlgd,
516: sum(decode(ctl.line_type, ''CHARGES'', ctl.extended_amount, 0)),
517: ct.reversed_cash_receipt_id /* Bug3328690 */
518: FROM
519: ra_terms t,
520: ra_terms_lines tl,
521: ra_cust_trx_types ctt,
522: ra_customer_trx ct,
523: ra_cust_trx_line_gl_dist ctlgd,
524: fnd_currencies c,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,
3623: fnd_currencies c,
3624: ra_terms t,
3625: ra_terms_lines tl,
3626: ra_customer_trx ct_com,
3627: ra_customer_trx_lines ctl_com,
3628: ra_customer_trx ct_ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,
3623: fnd_currencies c,
3624: ra_terms t,
3625: ra_terms_lines tl,
3626: ra_customer_trx ct_com,
3627: ra_customer_trx_lines ctl_com,
3628: ra_customer_trx ct_ps,
3629: fnd_currencies c_ps,