STEP 1 :
Modal Dialog page (151 & 152) for status update
STEP 2 :
Create Interactive Report
and SQL Query With HTML & CSS
SELECT
D.CREATE_DATE,
get_AIRBILL_NUMBER(D.ID) MAWB_NUMBER,
D.FLIGHT_NUMBER_1||' - '|| D.FLIGHT_DATE_1 First_Leg,
D.FLIGHT_NUMBER_2||' - '||D.FLIGHT_DATE_2 Second_Leg,
D.FLIGHT_DATE_1 Estimated_Date_Of_Departure,
case when d.ACTUAL_DEPARTURE_DATE is null then
'<div style="margin-bottom: 10px; text-align: center" >
<a href="'||apex_util.prepare_url('f?p='||:APP_ID||':'||151||':'||:APP_SESSION||'::::P151_ID:'||D.id) || '"
style="color:white;
background:green;
margin: 3px;
border: 2px solid;
border-radius: 15px;
padding-top: 5px;
padding-right: 25px;
padding-bottom: 5px;
padding-left: 15px;
">Pending </a> </div>'
else to_char(d.ACTUAL_DEPARTURE_DATE,'DD/MON/RR') end ACTUAL_DEPARTURE_DATE,
DECODE (ACTUAL_DEPARTURE,1,'Departed','Not Departed') Progress,
CASE
WHEN TO_CHAR (D.FLIGHT_DATE_3,'DD-MON-RR') IS NOT NULL THEN TO_CHAR(D.FLIGHT_DATE_3,'DD-MON-RR')
WHEN TO_CHAR (D.FLIGHT_DATE_2,'DD-MON-RR') IS NOT NULL THEN TO_CHAR(D.FLIGHT_DATE_2,'DD-MON-RR')
ELSE TO_CHAR (D.FLIGHT_DATE_1,'DD-MON-RR') END AS Estimated_Date_Of_Arrival,
case when D.Actual_Date_TIME_ARRIVAL is null then
'<div style="margin-bottom: 10px; text-align: center" >
<a href="'||apex_util.prepare_url('f?p='||:APP_ID||':'||155||':'||:APP_SESSION||'::::P155_ID:'||D.id) || '"
style="color:white;
background:green;
margin: 3px;
border: 2px solid;
border-radius: 15px;
padding-top: 5px;
padding-right: 25px;
padding-bottom: 5px;
padding-left: 15px;
">Pending </a> </div>'
else to_char(D.Actual_Date_TIME_ARRIVAL,'DD/MON/RR') end Actual_Date_TIME_ARRIVAL,
DECODE (D.Actual_ARRIVAL_STATUS,1,'ARRIVED','NOT ARRIVED') Progress2
FROM MAWB D;
--- You Must HTML & CSS Modify column "Escape special characters" off