How to Master wise Detail Report view in Oracle Apex

Check / Click and view details data..........

1. interactive grid editable report Master Report

SELECT DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID
FROM DEPARTMENTS

2. clasic Detail report with parameter


SELECT EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,
JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID
FROM EMPLOYEES
where instr(:P20_DEPARTMENT_ID, ':' ||DEPARTMENT_ID|| ':' ) > 0 ;

4. Page Items to Submit P20_DEPARTMENT_ID
5. Advance --> Static ID--> REPORTID Same As Dynamic action

6. Dynamic action in Selection Change [Interactive Grid]  Event & Execute JavaScript Action.

var i, selectedIds=":" ,
    model = this.data.model;

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
    if (i>=0) {
    selectedIds += model.getValue( this.data.selectedRecords[i], "DEPARTMENT_ID") + ":"; }  // Matching column (parameter)
    else
        {
    selectedIds += model.getValue( this.data.selectedRecords[i], "DEPARTMENT_ID"); // Matching column (parameter)
       }
}
$s("P20_DEPARTMENT_ID", selectedIds); //Master table Param
apex.region("REPORTID").refresh(); //



7. OK RUN....