Inventory Management - EBS (MOSC)

MOSC Banner

PO Receiving Value

Hi

Please explain how to get PO receiving value with condition unit of measure PO and unit of measure receiving is different and master convertion rate has been change after that transaction.

I use query bellow, but the problem it will use the new connvertion rate.

SELECc gcc.segment4, 'Purchase' sumber, rsh.receipt_num grn_no,TO_CHAR (rt.transaction_date, 'DD-MON-RRRR') grn_date, pha.segment1 po_number,sum(inv_convert.inv_um_convert (pla.item_id,4,case when rt.transaction_type = 'RECEIVE' then rt.primary_quantity else rt.primary_quantity*-1 end ,null,null,rt.primary_unit_of_measure,rt.SOURCE_DOC_UNIT_OF_MEASURE)*rt.po_unit_price*nvl(rt.currency_conversion_rate,1)) grn_amount FROM rcv_shipment_headers rsh inner join rcv_transactions rt on rt.shipment_header_id = rsh.shipment_header_id inner join po_distributions_all pda on pda.po_distribution_id = rt.po_distribution_id inner join po_lines_all pla on pla.po_line_id = pda.po_line_id inner join po_headers_all pha on pda.po_header_id = pha.po_header_id inner join gl_code_combinations_kfv gcc on gcc.code_combination_id = pda.accrual_account_id WHERE 1=1 and rsh.receipt_num = '210211100017' AND rt.transaction_type in('RECEIVE','RETURN TO VENDOR') group by gcc.segment4,rsh.receipt_num, TO_CHAR (rt.transaction_date, 'DD-MON-RRRR'), pha.segment1

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