select
avv.VENDOR_NAME 供應商,pvsa.VENDOR_SITE_CODE 地點,pha.SEGMENT1 po,
rt.TRANSACTION_DATE 交易日期,rt.TRANSACTION_TYPE 型態,msib.SEGMENT1 料號,plv.ITEM_DESCRIPTION 料號描述,
rt.QUANTITY 數量,
rt.UNIT_OF_MEASURE 單位,
rt.PO_UNIT_PRICE 採購單價,
rt.CURRENCY_CODE 幣別,
rt.SOURCE_DOCUMENT_CODE 來源,
rt.DESTINATION_TYPE_CODE 來源狀態,
rt.QUANTITY*rt.PO_UNIT_PRICE 金額
from rcv_transactionsrt,PO_LINES_V plv ,po_headers_all pha,
AP_VENDORS_V Avv,
po_vendor_sites_all pvsa,
mtl_system_items_bmsib
where rt.ORGANIZATION_ID=125
and rt.TRANSACTION_DATE
BETWEENto_date('01-01-2006 00:00:00','DD-MM-YYYY HH24:MI:SS')
AND to_date('31-01-2006 23:59:59','DD-MM-YYYY HH24:MI:SS')
and rt.PO_LINE_ID=plv.PO_LINE_ID
and rt.PO_HEADER_ID=plv.PO_HEADER_ID
and pha.PO_HEADER_ID=plv.PO_HEADER_ID
and pha.VENDOR_ID=avv.VENDOR_ID
and pvsa.VENDOR_SITE_ID=pha.VENDOR_SITE_ID
and plv.ITEM_ID=msib.INVENTORY_ITEM_ID
order by 4,3
|