Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case work_code_std.work_code_std_category_id
- when 2 then null
- else decode (RANK() OVER (PARTITION BY pd_day.pd_day_id ORDER BY decode(DECODE(short_code,'HRP_N','UR','HRP_D','UR', 'HRP_NWCO','UR','HS','OU',short_code), 'UR', 1, 2), pd_trf_day_id), 1,
- nvl2 (NULLIF(pd_day.declared_vehicle_km, 0), 'G', nvl2(NULLIF(pd_day.declared_bicycle_km,0), 'F', nvl2 (NULLIF(pd_day.declared_private_km,0), 'P', null))), null)
- end as mob_code,
- case work_code_std.work_code_std_category_id
- when 2 then null
- else decode (RANK() OVER (PARTITION BY pd_day.pd_day_id ORDER BY decode(DECODE(short_code,'HRP_N','UR','HRP_D','UR', 'HRP_NWCO','UR','HS','OU',short_code), 'UR', 1, 2), pd_trf_day_id), 1,
- nvl (NULLIF(pd_day.declared_vehicle_km,0), nvl (NULLIF(pd_day.declared_bicycle_km, 0), NULLIF(pd_day.declared_private_km, 0))), null)
- end as KM,
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement