Thread: How Order Release is linked with Buy Shipment and Sell Shipment?
View Single Post
  #16 (permalink)  
Old June 20th, 2008, 11:44
Srivathsana Srivathsana is offline
Member
  
Join Date: May 2007
Posts: 37
Thanks: 3
Thanked 3 Times in 3 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Srivathsana is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?
Hi,

Assuming you are talking about external statuses,You can get this done by joining the below tables :

SHIPMENT_STATUS - CONTAINS THE SHIPMENT STATUS (SELL AND BUY)
VIEW_SHIPMENT_ORDER_RELEASE - CONTAINS BUY AND SELL SHIPMENT ID'S
ORDER RELEASE - CONTAINS THE ORDER RELEASE DETAILS AND ORDER BASE ID'S
OB_ORDER_BASE - CONTAINS OB INSERT DATE
SHIPMENT - CONTAINS SHIPMENT INSERT DATE

Please repost should you require more help on this
__________________
Warm Regards,
Srivathsana
Last edited by Srivathsana : June 20th, 2008 at 12:08.
Reply With Quote