Reference column in RCV_shipment_headers with PO tables
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,