Explain the report layout (e.g column names or report items etc.) requested by user when you develop the following SQL. And for this report, what are the main DB and reference DBs and their data relationship?

 

SELECT A.CUSNO AS "CIF No.", A.CUS SNM NM AS "Name", A.LCL_BIZPSN PSNLT_C||'|| A.CUS T AS "CIF Class", A.NEW BRNO AS "Branch ID", NVL((SELECT MTRX_MNG_BRNO FROM DBOWN.UCI_MTRX_MAS F WHERE (SELECT TO CHAR(SYSDATE, "YYYYMMDD") FROM DUAL) between F.MTRX_APL_ST_DT and F.MTRX_APL_CLOSE_DT AND A.CUSNO = F.CUSNO), A.NEW BRNO) AS "Branch MG", (SELECT CUS ADR ZIPC FROM DBOWN.UCI_ADR_MAS B WHERE CUS ADR_T=CASE WHEN A.CUS_T='2' THEN 11 ELSE 21 END AND B.CUSNO=A.CUSNO) AS "Postal Code", T.dep_ltrx_dt as "Last Deposit Trx. Date", T.lon_ltrx_dt as "Last Loan Trx. Date", CASE WHEN C.GNRL_TRX_YN=1 THEN ' Daily Banking Needs' ELSE" END || CASE WHEN C.ETC_YN=1 THEN Others: ' || C.ETC CTT ELSE" END AS "Business Relationship Record" FROM (select nvl(dep.cusno, lon.cusno) cusno, dep.ltrx_dt dep_ltrx_dt, lon.ltrx_dt lon_ltrx_dt from (select cusno, max(LTRX_DT) as ltrx_dt from MISDBA.GDW_COM_DEPAC_D where STND_DT:PSTDT group by cusno) dep full outer join (select cusno, max(LAST_INT_REDEM DT) as I from MISDBA.GDW_COM_LONAC D where stnd_dt = :PSTDT group by cusno) lon on dep.cusno lon.cusno) T, DBOWN.UCI BSC_MAS A, DBOWN.UCI_NAT_INFC WHERE T.CUSNO = A.CUSNO AND A.CUSNO C.CUSNO(+) AND A.NEW BRNO = :PBR