select CX_CD, FLT_NO, OPNL_SFX, FLT_DT_UTC, LEG_DEP_STN_CD, LEG_DEP_NO, PLAN_LEG_ARR_STN_CD,
	(select wola.LEG_NO from DATED_TRIP_ITEMS dti, WS_OPNL_LEG_ACYS  wola
	where dti.DTRIP_SYS_ID = 204179
	and dti.DTY_SEQ_NO =  (select min(DTY_SEQ_NO) from DATED_TRIP_ITEMS
							where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
							and DTY_SEQ_NO >= 1
							and ITEM_CD = 'VS')
	and dti.ITEM_SEQ_NO =  (case when exists
							      (select 1 from DATED_TRIP_ITEMS
									where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
									and DTY_SEQ_NO = 1
									and CX_CD = 'VS')
							  then
								  (select min (ITEM_SEQ_NO) from DATED_TRIP_ITEMS
									where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
									and DTY_SEQ_NO = 1 a
									nd CX_CD = 'VS')
							  else
							      (select min (ITEM_SEQ_NO) from DATED_TRIP_ITEMS
									where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
									and DTY_SEQ_NO = dti.DTY_SEQ_NO
									and ITEM_CD = 'FLT')
							end )
	and dti.FLT_NO = wola.FLT_NO
	and dti.CX_CD = wola.CX_CD
	and dti.OPNL_SFX = wola.OPNL_SFX
	and dti.FLT_DT_UTC = wola.FLT_DT_UTC
	and dti.LEG_DEP_STN_CD = wola.DEP_STN_CD
	and dti.LEG_DEP_NO = wola.DEP_NO)
from DATED_TRIP_ITEMS dti
	where dti.DTRIP_SYS_ID = 204179
	and dti.DTY_SEQ_NO = (select min(DTY_SEQ_NO) from DATED_TRIP_ITEMS
							where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
							and DTY_SEQ_NO >= 1
							and ITEM_CD = 'FLT')
	and dti.ITEM_SEQ_NO = (case when exists
									(select 1 from DATED_TRIP_ITEMS dtit
										where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
										and DTY_SEQ_NO = 1
										and CX_CD = 'VS'
										AND EXISTS (SELECT 1 FROM WS_OPNL_LEG_ACYS
													WHERE flt_no=dtit.FLT_NO
													AND cx_cd=dtit.CX_CD
													AND opnl_sfx=dtit.OPNL_SFX
													AND flt_dt_utc=dtit.FLT_DT_UTC
													AND dep_stn_cd=dtit.LEG_DEP_STN_CD
													AND DEP_NO=dtit.LEG_DEP_NO
													AND FLT_STS_CD NOT IN ('RROF', 'RTDR'))
									)
								then
									(select min (ITEM_SEQ_NO) from DATED_TRIP_ITEMS dtit
										where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
										and DTY_SEQ_NO = 1
										and CX_CD = 'VS'
										AND EXISTS (SELECT 1 FROM WS_OPNL_LEG_ACYS
													WHERE flt_no=dtit.FLT_NO
													AND cx_cd=dtit.CX_CD
													AND opnl_sfx=dtit.OPNL_SFX
													AND flt_dt_utc=dtit.FLT_DT_UTC
													AND dep_stn_cd=dtit.LEG_DEP_STN_CD
													AND DEP_NO=dtit.LEG_DEP_NO
													AND FLT_STS_CD NOT IN ('RROF', 'RTDR'))
									)
								else
									(select min (ITEM_SEQ_NO) from DATED_TRIP_ITEMS dtit
										where DTRIP_SYS_ID = dti.DTRIP_SYS_ID
										and DTY_SEQ_NO = dti.DTY_SEQ_NO
										and ITEM_CD = 'FLT'
									)
							end )