oracle concepts for you
Selasa, 19 Julai 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
Tiada ulasan:
Catat Ulasan
Catatan Terbaru
Catatan Lama
Laman utama
Langgan:
Catat Ulasan (Atom)
Tiada ulasan:
Catat Ulasan