Elevate Interactive Grid

 

Step 1 :

Create Interactive Grid Region

Select Page and go to Inline : copy to paste

#GRID .a-GV-cell {
    height: 30px;
}
.wrap-cell {
    max-height: 134px;
    white-space: normal;
    overflow: hidden;
}

.a-GV-table td, .a-GV-table th {
  overflow: visible;
    overflow-wrap: break-word;
    text-overflow: ellipsis;
    white-space: normal;
}

Step 2 :

Select Grid Region And

Static ID : GRID

================================================

Cost type Wise Booking OR CONTAINER  LOV show and Calculation

Step 1 :

Select COST_TYPE and type Select List 

Step 2 :

Select  BOOKING_CONTAINER Item and type CheckBox Group

SQL Query :

Select  
'BOOKING ID : '||GET_SEABOOKING_DTL('A',C.SEAEXPORT_MST_ID)|| ', FROM : '|| GET_SEABOOKING_DTL('S',C.SEAEXPORT_MST_ID)|| ', TO : '||

GET_SEABOOKING_DTL('B',C.SEAEXPORT_MST_ID) || ', CBM : '|| SUM(C.CBM_ALLOCATED) D, C.SEAEXPORT_MST_ID R

from stuffing_plan_mst A, stuffing_plan_cont B, stuffing_plan_goods C

WHERE A.ID=B.STUFFING_PLAN_MST_ID

AND B.ID=C.STUFFING_PLAN_CONT_ID

AND A.ID=:P164_STAFFING_ID

and :COST_TYPE = 1

GROUP BY C.SEAEXPORT_MST_ID

Union all 

select  

'BOOKING ID : '||GET_SEABOOKING_DTL('A',C.SEAEXPORT_MST_ID)|| ', FROM : '|| GET_SEABOOKING_DTL('S',C.SEAEXPORT_MST_ID)|| ', TO : '||

GET_SEABOOKING_DTL('B',C.SEAEXPORT_MST_ID) || ', CBM : '|| SUM(C.CBM_ALLOCATED) D, C.SEAEXPORT_MST_ID R

from stuffing_plan_mst A, stuffing_plan_cont B, stuffing_plan_goods C

WHERE A.ID=B.STUFFING_PLAN_MST_ID

AND B.ID=C.STUFFING_PLAN_CONT_ID

AND A.ID=:P164_STAFFING_ID

and :COST_TYPE = 2

GROUP BY C.SEAEXPORT_MST_ID

Union all 

select 'Container Type : '|| DECODE  (b.CONTAINER_TYPE,1,'40FT High Cube',2,'40FT High Genarel',3,'20FT High Genarel')

      ||', Number : '||B.CONTAINER_NUMBER||', Seal No : '||B.CONTAINER_SEAL d, b.id r

from stuffing_plan_mst A, stuffing_plan_cont B

WHERE A.ID=B.STUFFING_PLAN_MST_ID

AND A.ID=:P164_STAFFING_ID

and :COST_TYPE = 3

Cascading List of Values :

Parent Column(s) : COST_TYPE

Items to Submit : COST_TYPE,P164_STAFFING_ID

Step 3 : for data count

At first Create This Function :

CREATE OR REPLACE function in_list_colon( p_string in varchar2 ) return myTableType

 as

 l_string long default p_string || ':';

 l_data myTableType := myTableType();

 n number;

 begin

 loop

 exit when l_string is null;

 n := instr( l_string, ':' );

 l_data.extend;

 l_data(l_data.count) :=

ltrim( rtrim( substr( l_string, 1, n-1 ) ) );

 l_string := substr( l_string, n+1 );

 end loop;

 return l_data;

 end;

/

Create Dynamic Action on BOOKING_CONTAINER (for Count Booking Id) 

Action : Set Value

SELECT COUNT(COLUMN_VALUE) FROM TABLE(in_list_colon(:BOOKING_CONTAINER))

Items to Submit : BOOKING_CONTAINER

Affected Elements : Column(s) : QTY