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@]
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博客 ” ，链接：https://blog.itpub.net/45641/viewspace-942835/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle SQL中的函数
下一篇：
没有了~
请登录后发表评论
登录
全部评论
