Procurement - EBS (MOSC)

MOSC Banner

Shipment billed amount <> Distribution billed amount for the same PO/same line

edited Jul 15, 2009 3:47AM in Procurement - EBS (MOSC) 3 commentsAnswered
Hi there,

We have a PO and in 2nd line shipment billed amount is not equal to distribution billed amount.   Other lines are fine.   Here is the result: 

select h.segment1

,   l.quantity line_ordered

,   ll.quantity shipment_ordered

,   ll.quantity_billed shipment_billed

,   d.quantity_ordered dist_ordered

,   d.quantity_billed dist_billed

from po.po_headers_all h

,           po.po_lines_all l

,           po.po_line_locations_all ll

,           po.po_distributions_all d

where d.set_of_books_id = 23

and h.po_header_id = l.po_header_id

and l.po_line_id = d.po_line_id

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