| Re: How Order Release is linked with Buy Shipment and Sell Shipment?
Here is the query (Replace RELEASE1 in the below query with your Order Release ID).
SELECT S.SHIPMENT_GID FROM SHIPMENT S, SHIPMENT_STOP_D SD, S_SHIP_UNIT_LINE SL WHERE S.SHIPMENT_GID = SD.SHIPMENT_GID AND SD.S_SHIP_UNIT_GID = SL.S_SHIP_UNIT_GID AND SL.ORDER_RELEASE_GID ='RELEASE1' AND SD.STOP_NUM = 1 |