| Re: How Order Release is linked with Buy Shipment and Sell Shipment?
You may use this query to find the same:
SELECT SHIPMENT_GID, PERSPECTIVE FROM SHIPMENT WHERE SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM SHIPMENT_STOP_D WHERE S_SHIP_UNIT_GID IN(SELECT S_SHIP_UNIT_GID FROM S_SHIP_UNIT_LINE WHERE ORDER_RELEASE_GID LIKE 'XYZ.ABCD'))
I hope this query had been of help to you.
__________________
Regards,
Raveendranath Thalapalli |