| Re: Link Shipment to Jobs
I think your issues is that there is a JOB_GID in the SHIPMENT Table, but this is not being used. Rather, OTM is linking shipments to a JOB via the ORDER_RELEASE or ORDER_MOVEMENT.
If you want to allow searchability, perhaps look at creating an agent that populates the JOB_GID in the SHIPMENT from the JOB_ORDER_RELEASE_JOIN table. |