[vsevs]

Hi,
We are trying to extract the shipment information from SHIPMENT and s_ship_units. But where can we find the link between shipment_gid and s_ship_unit_gid?

We want to extract both shipment and ship_unit of that shipment.

Thanks,
Venkat.

[josephliang]

There are paths to link shipment and s_ship_unit
1. shipment -> shipment_stop_d -> s_ship_unit

2. shipment -> shipment_s_equipment_join -> s_equipment_s_ship_unit_join -> s_ship_unit