01.SELECT t.* FROM (
02.SELECT ROW_NUMBER() OVER(ORDER BY b.booking_no) AS rownum,
03. b.flight_booking_seq as flightBookingSeq,
04. b.booking_no as bookingNo,
05. isnull(b.first_name,'')+' '+isnull(b.last_name,'') as bookName,
06. b.mobile_phone as mobilePhone,
07. b.work_phone as workPhone,
08. (SELECT COUNT(ck.check_in_seq)
09. FROM ka_check_in ck
10. WHERE ck.passenger_type <> 'I'
11. AND ck.flight_itinerary_seq = i.flight_itinerary_seq) as passengerNo,
12. ei.item_desc as bookingStatus,
13. i.flight_itinerary_seq as flightItinerarySeq,
14. case b.round_trip
15. when 'Y' then 'true'
16. else 'false'
17. end as roundTrip,
18. b.booking_note as bookingNote,
19. b.email as email,
20. dbo.get_check_in_status(i.flight_itinerary_seq) as checkInStatus,
21. b.booking_status,
22. isnull(dbo.get_count_bag_booking(i.flight_itinerary_seq),'') as bagNoBook,
23. dbo.get_booking_by(b.flight_booking_seq) as bookingBy
24.from ka_flight_sche s , ka_flight_itinerary i , ka_flight_booking b , sc_entry_item ei
25.where s.flight_sche_seq = i.flight_sche_seq
26. and i.flight_booking_seq = b.flight_booking_seq
27. and s.flight_sche_seq = '5179'
28. and ei.param_code = 'KA0001'
29. and ei.entry_code = '1'
30. and ei.item_code = b.booking_status
31. and b.booking_status = 'N'
32.
33.) as t
