How Order Release is linked with Buy Shipment and Sell Shipment?

gashoks · #1 (**permalink**) March 21st, 2008, 16:42

Hi,

I was working through getting Buy Shipment and Sell Shipment data for a particular Order Release, but unable to link.

Kindly advice.

Ashok G

hrishikesh1976 · #2 (**permalink**) March 21st, 2008, 19:29

shipments are related to order release in view table view_shipment_order_release

oliver · #3 (**permalink**) March 21st, 2008, 23:15

try the "view_shipment_order_release table"

Rgds
Oliver

bmj_23 · #4 (**permalink**) March 22nd, 2008, 09:15

That view obviously provides that information.

Otherwise, take a look at the s_ship_unit_line table. That has the link from the shipment ship unit (the ship unit on a shipment) and the associated order base, order release and order release line. The ship unit line is associated with a ship unit which is linked to a shipment equipment which in turn is linked to a shipment.

gashoks · #5 (**permalink**) March 24th, 2008, 19:07

I checked the S_SHIP_UNIT_LINE and VIEW_SHIPMENT_ORDER_RELEASE, but it is not useful for my requirement.

My Problem is a order release will be having both SELL_SHIPMENT and BUY_SHIPMENT.

When i get a SELL_SHIPMENT, I should be able to obtain the Order relase detail and the orders BUY_SHIPMENT. and also the vice versa that if i have a BUY_SHIPMENT ID, I should be able to find the SELL_SHIPMENT Details.

bmj_23 · #6 (**permalink**) March 24th, 2008, 22:00

So what exactly are you looking for ? The sql code to find the buy and sell shipment ID's for a particular order release ID ?

gashoks · #7 (**permalink**) March 26th, 2008, 20:57

Its like, I will provide the status of an Sell Shipment, based on the status, we have to fetch the orders whose sell shipment has those status and then its Order Release and its Buy Shipment.

krishna.kk · #8 (**permalink**) March 27th, 2008, 05:25

Ashok,

Try creating a job from the oreder relese it will show you complete details of the buy and sellshipments that are build from the order release .

Rgds
kishore

krishna.kk · #9 (**permalink**) March 27th, 2008, 05:34

Ashok,

Sorry i got you wrong .

Use the smart links i.e after searching the sell shipments by a statys use the smartlinks(Right click + symbol near the shipment there you can find the option view releated order release that will tkae you to the order release and again go to the smartlinks of the order release u can find the option view releated buy shipments .

Rgds

gashoks · #10 (**permalink**) March 27th, 2008, 13:43

Hi Krishna,

Thanks for the info. But my problem is how to retrive the data from back-end.

Regards

Ashok G