用union all後面欄位不足的用null補足

select *
from ((
	SELECT A.WORK_ORDER
	,A.PALLET_NO
	,A.SERIAL_NUMBER
	,B.PROCESS_NAME
	,'10'AS STEP
	,'QC CODE'AS ACTION
	,
		case
		when A.PROCESS_ID=C.PROCESS_ID or A.PROCESS_ID=F.RP_PROCESS_ID 
		then E.DEFECT_CODE
		else 'PASS'
		end as "DEFECT_CODE"
	,A.OUT_PROCESS_TIME "OutProcessTime"
	,
		case
		when A.PROCESS_ID=C.PROCESS_ID or A.PROCESS_ID=F.RP_PROCESS_ID 
		then NVL(F.REMARK,SAJET.sj_get_repair_remark(F.RECID))
		else null
		end as "備註(Remark/Defect Item)"
	,
		case
		when A.PROCESS_ID=F.RP_PROCESS_ID 
		then F.REPAIR_TIME
		else null
		end as "(Repair Time)"
	,
		Case
		when A.PROCESS_ID=C.PROCESS_ID or A.PROCESS_ID=F.RP_PROCESS_ID 
		then G.REASON_CODE
		else null
		end as "原因代碼(Reason Code)"
	,
		case
		when A.PROCESS_ID=C.PROCESS_ID or A.PROCESS_ID=F.RP_PROCESS_ID 
		then G.REASON_DESC
		else null
		end as "原因描述(Reason Desc)"
	,
		case
		when A.PROCESS_ID=C.PROCESS_ID or A.PROCESS_ID=F.RP_PROCESS_ID 
		then F.LOCATION
		else null
		end as "位置(Location)"
	FROM SAJET.G_SN_TRAVEL A
	,SAJET.SYS_PROCESS B 
	,SAJET.G_SN_DEFECT C 
	, SAJET.SYS_DEFECT E
	, SAJET.G_SN_REPAIR F
	, SAJET.SYS_REASON G
	, SAJET.SYS_DUTY H
	WHERE A.PROCESS_ID = B.PROCESS_ID
	AND A.SERIAL_NUMBER=C.SERIAL_NUMBER
	AND E.DEFECT_ID=C.DEFECT_ID
	AND F.RECID=C.RECID
	AND F.REASON_ID=G.REASON_ID
	AND F.DUTY_ID=H.DUTY_ID
	AND B.PROCESS_ID NOT IN '100056'
	AND A.SERIAL_NUMBER ='IXJ146088'
) union all (
	SELECT A.WORK_ORDER
	,A.PALLET_NO
	,A.SERIAL_NUMBER
	,B.PROCESS_NAME
	,'10'AS STEP
	,C.BARCODE AS ACTION
	,null
	,null
	,null
	,null
	,null
	,null
	,null
	FROM SAJET.G_SN_TRAVEL A,SAJET.SYS_PROCESS B , SAJET.G_BARCODE C
	WHERE A.PROCESS_ID = B.PROCESS_ID
	AND A.SERIAL_NUMBER = C.SERIAL_NUMBER
	AND A.PROCESS_ID ='100056'
)) as k

union all
缺的欄位用 '' 或 null 補齊