Actions
Task #15856
closedBug: TO FIX RETRIEVE OF FLIGHTS IMPORT for legs MRU
Status:
Closed
Priority:
Normal
Assignee:
-
GitLab ID:
2268
GitLab Milestone:
GitLab Ticket Number:
475
GitLab Time Logged:
3600
Lock Timeline Date:
No
gitlab project trace:
Description
Fixed AIRCCS_COMMON.PKG_COMMON_MAIN.SP_RET_MAINTENANCE_FLIGHT_IMP to fetch legs of tupe IMPORT despite same flight having depport 'MRU'. This change was necessary following fix made in #474 FFM Integration issue for TK161
by modifying this line
sql_ := 'SELECT F.*,FH.FLIGHT_REFERENCE,FH.REPORTNO,FH.INTERNAL_FLIGHT_REFERENCE AS ATP
FROM FLIGHTDETAILS F ,FLIGHTHEADER FH
WHERE F.LEGSEQUENCENO = 1 AND FH.DEPPORT <> ''MRU'' AND FH.FLIGHTID=F.FLIGHTID '||SQL_PARAM;
TO
sql_ := 'SELECT F.*,FH.FLIGHT_REFERENCE,FH.REPORTNO,FH.INTERNAL_FLIGHT_REFERENCE AS ATP
FROM FLIGHTDETAILS F ,FLIGHTHEADER FH
WHERE F.ARRPORT = ''MRU'' -- FETCH IMPORT LEG ONLY
AND FH.FLIGHTID = F.FLIGHTID '||SQL_PARAM;
GitLab Sync Log
[{"id": "18914", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-03-24T06:53:39.304Z", "log_date": "2025-03-24", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-03-24T06:53:39.304Z: 1h-(1.0)h spend at: 2025-03-24", "status": "active", "deleted_by": "", "redmine_entry_id": 7672}]
Actions