Procurement - EBS (MOSC)

MOSC Banner

Reference column in RCV_shipment_headers with PO tables

edited May 19, 2017 5:03AM in Procurement - EBS (MOSC) 1 commentAnswered

Hi Gurus,

Can any one help? What's the reference column in RCV_shipment_headers table with Po table?

Some of our receiving transactions has not been processed to GL, becuase of requestor has choosen wrong organisation. I need a SQL query which needs to give the following datas.

Receipt No, PO No. PO Line No., PO. Unit Price, Code Cobminations (Segment from Code Combinations table), amount, quantity_received, quantity_accepted, quantity_rejected, quantity_billed

select rsh.RECEIPT_NUM,

pha.segment1,

pol.line_num,

pol.unit_price,

pol.quantity,

pda.nonrecoverable_tax,

cm.segment1,cm.segment2, cm.segment3, cm.segment4, cm.segment5, cm.segment6,

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