Script Cek Data Gate In/Out Container Load FCL

Script Cek Data Gate Delivery In/Out Container Load FCL
select * from service_gate_delivery
where cont_no in
(select cont_no from service_cont_load where no_ppkb='2013020029' and conT_status='FCL')
order by cont_no, no_ppkb


Script Cek Data Gate Receiving In/Out Container Load FCL
select * from service_gate_receiving
where cont_no in
(select cont_no from service_cont_load where no_ppkb='2013020029' and conT_status='FCL')
order by cont_no, no_ppkb

no_ppkb menyesuaikan kondisi.