Oracle ERP--查询库存交易与成本发生情况的SQL

select distinct b.segment1,
nvl(a.PRIOR_COST,0),
nvl(b.unit_weight,0)
from apps.mtl_material_transactions a,
apps.mtl_system_items b,
apps.cst_item_costs c
where a.ORGANIZATION_ID=b.ORGANIZATION_ID
and a.inventory_item_id=b.inventory_item_id
and a.ORGANIZATION_ID=c.ORGANIZATION_ID
and a.inventory_item_id=c.inventory_item_id
and trunc(a.TRANSACTION_DATE)>=to_date('01-01-2002','MM-DD-YYYY')
and trunc(a.TRANSACTION_DATE)<=to_date('04-30-2003','MM-DD-YYYY')
and A.ORGANIZATION_ID=4
--and a.subinventory_code in ('C11','C12','C13','B11','B12','D11')
[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45641/viewspace-942835/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45641/viewspace-942835/