otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Order Processing
Reload this Page

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


Order Processing Shipment planning and order processing - including data requirements, line items, ship units, order bases and order releases.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old March 21st, 2008, 16:42
Junior Member
 
Join Date: Feb 2008
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gashoks is on a distinguished road
How Order Release is linked with Buy Shipment and Sell Shipment?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old March 21st, 2008, 19:29
Junior Member
 
Join Date: Sep 2006
Posts: 18
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 5 Times in 5 Posts
Rep Power: 0
hrishikesh1976 is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

shipments are related to order release in view table view_shipment_order_release
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old March 21st, 2008, 23:15
Member
 
Join Date: Jun 2007
Posts: 32
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 7 Times in 7 Posts
Rep Power: 0
oliver is on a distinguished road
Send a message via AIM to oliver Send a message via Skype™ to oliver
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

try the "view_shipment_order_release table"

Rgds
Oliver
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old March 22nd, 2008, 09:15
Senior Member and Blogger
 
Join Date: May 2007
Posts: 200
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 4
Thanked 36 Times in 35 Posts
Rep Power: 3
bmj_23 will become famous soon enough
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old March 24th, 2008, 19:07
Junior Member
 
Join Date: Feb 2008
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gashoks is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old March 24th, 2008, 22:00
Senior Member and Blogger
 
Join Date: May 2007
Posts: 200
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 4
Thanked 36 Times in 35 Posts
Rep Power: 3
bmj_23 will become famous soon enough
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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 ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old March 26th, 2008, 20:57
Junior Member
 
Join Date: Feb 2008
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gashoks is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old March 27th, 2008, 05:25
Senior Member
 
Join Date: May 2007
Posts: 119
Groans: 2
Groaned at 0 Times in 0 Posts
Thanks: 23
Thanked 8 Times in 7 Posts
Rep Power: 3
krishna.kk is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old March 27th, 2008, 05:34
Senior Member
 
Join Date: May 2007
Posts: 119
Groans: 2
Groaned at 0 Times in 0 Posts
Thanks: 23
Thanked 8 Times in 7 Posts
Rep Power: 3
krishna.kk is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old March 27th, 2008, 13:43
Junior Member
 
Join Date: Feb 2008
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gashoks is on a distinguished road
Re: How Order Release is linked with Buy Shipment and Sell Shipment?

Hi Krishna,

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

Regards

Ashok G
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Archiving Of Data Other Than Shipment / Order Release / Order Base / Items ianlo Database Administration 10 March 4th, 2010 08:36
Unassign Order Release from a GS Shipment bluesdude Planning 2 June 25th, 2009 09:02
Agent to Link Order release to shipment shengkaigong Planning 2 January 12th, 2009 14:19
Managing more than one sell side shipment per order release garofalof Settlement 2 March 13th, 2008 20:41
Agents-refnumber From Order Release To Shipment krishna.kk Planning 3 January 21st, 2008 22:55



All times are GMT. The time now is 23:34.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40