SELECT
acra.receipt_number,
rcta.trx_number
FROM
ar_receivable_applications_all araa,
ar_cash_receipts_all acra,
ra_customer_trx_all rcta
WHERE
araa.status = 'APP'
AND araa.cash_receipt_id = acra.cash_receipt_id
AND araa.applied_customer_trx_id = rcta.customer_trx_id
--AND rct.customer_trx_id IN (1111111 )
AND rcta.trx_number = '1111111'
acra.receipt_number,
rcta.trx_number
FROM
ar_receivable_applications_all araa,
ar_cash_receipts_all acra,
ra_customer_trx_all rcta
WHERE
araa.status = 'APP'
AND araa.cash_receipt_id = acra.cash_receipt_id
AND araa.applied_customer_trx_id = rcta.customer_trx_id
--AND rct.customer_trx_id IN (1111111 )
AND rcta.trx_number = '1111111'
;
No comments:
Post a Comment