Tuesday 19 July 2011

How To Find The Receipt_Value In PO

   Receipt_Value
====================


 select ( rcl.QUANTITY_RECEIVED * rt.PO_UNIT_PRICE ) "Receipt_Value"
 from rcv_shipment_lines rcl,rcv_transactions rt
 where rcl.SHIPMENT_LINE_ID = rt.SHIPMENT_LINE_ID

No comments:

Post a Comment