Order Management - EBS (MOSC)

MOSC Banner

Jion between OE_ORDER_LINES_ALL and RCV_SHIPMENT_LINES

edited Jul 13, 2017 7:32AM in Order Management - EBS (MOSC) 7 commentsAnswered

Hi All,

We have a scenario from the Drop Shipment. Where we are creating Sales Order with Line#1.1 having Quantity as 2

so there would be one line at this time in oe_drop_ship_source for this SO line 1.1

now while creating receiving receipt, we create the shipment with quantity 1 as we received only one at first time hence this will spit the line in Order Manangment with new line#1.2 and both the line 1.1 and Line#1.2 will be having quantity as 1. this will also create new line in oe_drop_ship_source table for line# 1.2 and both line will be having different line ID but the po_line_location and po_line_id as well as po_header_id too.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center