The below query will  provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accoun...

SELECT DISTINCT aca.payment_method_lookup_code trans_type,                 TO_CHAR (aca.check_number) invoice_num,                 TO_CHA...

SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num,        TO_CHAR (rct.trx_date) invoice_date,        TO_CHAR (rcl...

SELECT NULL trans_type, ent.transaction_number invoice_num,        (SELECT TO_CHAR (trx_date)           FROM ra_customer_trx_all        ...

SELECT /*+ leading (ael aeh) */        aia.invoice_type_lookup_code trans_type,        ent.transaction_number invoice_num,        TO_CHA...