SELECT
rcta.trx_number,
rcta.trx_date,
rcta.creation_date,
apsa.amount_due_original,
apsa.amount_line_items_original,
apsa.tax_original
FROM
ra_customer_trx_all rcta,
ar_payment_schedules_all apsa
WHERE
1 = 1
AND rcta.customer_trx_id = apsa.customer_trx_id
AND rcta.trx_number = '70682380'
;
rcta.trx_number,
rcta.trx_date,
rcta.creation_date,
apsa.amount_due_original,
apsa.amount_line_items_original,
apsa.tax_original
FROM
ra_customer_trx_all rcta,
ar_payment_schedules_all apsa
WHERE
1 = 1
AND rcta.customer_trx_id = apsa.customer_trx_id
AND rcta.trx_number = '70682380'
;
No comments:
Post a Comment