Order Management - EBS (MOSC)

MOSC Banner

one PO line location id returns 4 shipment lines

edited Dec 26, 2013 8:21PM in Order Management - EBS (MOSC) 8 commentsAnswered
Hi,
My company using dropships for sales order type, and want to add receipt number on invoice.

This is my Query

Select  receipt_num, ool.line_id, INTERFACE_LINE_ATTRIBUTE6, rsl.* From
oe_order_headers_all ooh,
oe_order_lines_all ool,
oe_drop_ship_Sources odss,
ra_customer_trx_lines_all rctl  ,
rcv_shipment_lines rsl,
rcv_shipment_headers rsh
Where ooh.header_id = ool.header_id
AND ool.Header_id = odss.header_id
AND OOL.LINE_ID = ODSS.LINE_ID
and rctl.customer_trx_id  = 151162
and rsl.po_line_location_id = 81610
and rctl.INTERFACE_LINE_ATTRIBUTE11 = 0
and ool.line_id = rctl.INTERFACE_LINE_ATTRIBUTE6

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