Need to solve an Oracle Query 3 tables (Joins)

/*
drop table myAR_Invoice purge;
create table myAR_Invoice( AR_inv_no number, GL_Code number,  AR_Amount number,  AR_Date date);

insert into myAR_Invoice values(1234,11500,500.00,to_date('01/01/2015','MM/DD/YYYY'));
insert into myAR_Invoice values(2345,11500,300.00,to_date('01/02/2015','MM/DD/YYYY'));
insert into myAR_Invoice values(3456,11501,250.00,to_date('03/01/2015','MM/DD/YYYY'));
commit;

drop table myAP_Invoice purge;
create table myAP_Invoice (AP_Inv_No number, GL_Code number, AP_Amount number, AP_Date date);
insert into myAP_Invoice values(4567,12500,350.00,to_date('02/05/2015','MM/DD/YYYY'));
insert into myAP_Invoice values(5678,12500,275.00,to_date('03/04/2015','MM/DD/YYYY'));
insert into myAP_Invoice values(6789,12501,150.00,to_date('01/03/2015','MM/DD/YYYY'));
commit;


drop table myTran_Doc_No purge;
create table myTran_Doc_No(Inv_No number, GL_Code number, Reg_No char(7), Type char(1));
insert into myTran_Doc_No values(1234,11500,'ABC 122','M');
insert into myTran_Doc_No values(1234,11500,'ABC 122','F');
insert into myTran_Doc_No values(1234,11500,'ABC 122','R');
insert into myTran_Doc_No values(2345,11500,'ABC 124','F');
insert into myTran_Doc_No values(3456,11501,'ABC 121','M');
insert into myTran_Doc_No values(3456,11501,'ABC 121','F');
insert into myTran_Doc_No values(3456,11501,'ABC 121','R');
insert into myTran_Doc_No values(4567,12500,'ABC 122','M');
insert into myTran_Doc_No values(5678,12500,'ABC 124','M');
insert into myTran_Doc_No values(5678,12500,'ABC 124','R');
insert into myTran_Doc_No values(6789,12501,'ABC 127','M');
commit;
*/


select t.reg_no,
	max(r.ar_inv_no), max(r.ar_amount), max(r.ar_date),
	max(p.ap_inv_no), max(p.ap_amount), max(p.ap_date)
from (
		select distinct inv_no, gl_code, reg_no from myTran_Doc_No
	) t
	left outer join myAR_Invoice r on t.inv_no = r.ar_inv_no and t.gl_code = r.gl_code
	left outer join myAP_Invoice p on t.inv_no = p.ap_inv_no and t.gl_code = p.gl_code
where t.gl_code in (11500, 12500)
group by t.reg_no
/

Select allOpen in new window