APEX

How do I create a matrix report in pl dynamic content region like below image in Oracle Apex 19.2 ?

Someone help

thanks

Pallab

SQL QUERY :

for r in
(
Select
distinct h.SECTION_NO,(select SECTION_NAME from SECTION_SETUP i where i.SECTION_NO=h.SECTION_NO )SECTION_NAME
from
(
SELECT ALL EMPLOYEE.EMPNO,
EMPLOYEE.EMPLOYEE_NAME,
EMPLOYEE.SECTION_NO, EMPLOYEE.DESIGNATION_NAME, ATTENDANCE_DETAILS.ATT_DATE, EMPLOYEE.DEPT_NAME,
ATTENDANCE_DETAILS.OTHOUR2, ATTENDANCE_DETAILS.EXTRAOT
FROM ATTENDANCE_DETAILS, EMPLOYEE
WHERE ATT_DATE BETWEEN :P49_FDATE AND :P49_TO_DATE
AND EMPLOYEE.COMPANY_ID=:P49_COMPANY
AND EMPLOYEE.RESIGNED_DATE IS NULL
And EMPLOYEE.STATUS='Active'

) h
)
loop
htp.p(' <table class="Table1" align="left" width="100%" border="1" >
<tr>
<td width="100%"; style=" text-align: left; "> '||r.SECTION_NAME||' </td>
</tr>
</table> ');

for i in
( select distinct TO_CHAR(ATT_DATE, 'DD') AS ATT_MONTH from ATTENDANCE_DETAILS
where ATT_DATE BETWEEN :P49_FDATE AND :P49_TO_DATE order by TO_CHAR(ATT_DATE, 'DD') asc )
loop
htp.p(' <table class="Table1" align="left" width="100%" border="1" >
<tr>
<td width="10%"; style=" text-align: center; "> Emp No </td>
<td width="20%"; style=" text-align: center; ">Name Of Employee</td>
<td width="70%"; style=" text-align: center; "> '||i.ATT_MONTH||' </td>
</tr>
</table> ');

for e in
( SELECT ALL EMPLOYEE.EMPNO,
EMPLOYEE.EMPLOYEE_NAME ,
EMPLOYEE.SECTION_NAME, ATTENDANCE_DETAILS.ATT_DATE, EMPLOYEE.DEPT_NAME,
ATTENDANCE_DETAILS.OTHOUR, ATTENDANCE_DETAILS.EXTRAOT
FROM ATTENDANCE_DETAILS, EMPLOYEE

WHERE
attendance_details.empno=EMPLOYEE.EMPNO

AND ATT_DATE BETWEEN :P49_FDATE AND :P49_TO_DATE

And EMPLOYEE.COMPANY_ID=:P49_COMPANY
AND EMPLOYEE.RESIGNED_DATE IS NULL
And EMPLOYEE.STATUS='Active'
AND EMPLOYEE.SECTION_NO=r.SECTION_NO
)
loop
htp.p(' <table class="Table1" align="left" width="100%" border="1" >
<tr>

       \<td width="70%"; style=" text-align: center; ">    '||e.EMPNO||'   \</td>   
       \<td width="70%"; style=" text-align: center; ">    '||e.EMPLOYEE\_NAME||'   \</td>  
       \<td width="70%"; style=" text-align: center; ">    '||e.OTHOUR||'   \</td>  
   \</tr>  

</table> ');

end loop;

end loop;
end loop;