select
msi.segment1 编码
,msi.description 描述
,mr.old_order_quantity 数量
,mipo.po_number 请购单
,mipo.purch_line_num 订单栏
,pv.vendor_name 供应商
,ppf.last_name 采购员
from
mrp.MRP_ITEM_EXCEPTIONS mie
,apps.mfg_lookups ml
,MRP.MRP_ITEM_PURCHASE_ORDERS mipo
,po.po_vendors pv
,hr.per_all_people_f ppf
,mrp.MRP_RECOMMENDATIONS mr
,INV.MTL_SYSTEM_ITEMS_b msi
where
mie.organization_id=x
and msi.organization_id=mie.organization_id
and msi.inventory_item_id=mie.inventory_item_id
and ml.lookup_type=‘MRP_EXCEPTION_CODE_TYPE‘
and mie.exception_type=ml.lookup_code
and pv.vendor_id(+)=mr.vendor_id
and mie.exception_type=8
and mr.organization_id=mie.organization_id
and mr.inventory_item_id=mie.inventory_item_id
and mr.disposition_status_type=2
and mr.order_type=2
and mr.disposition_id=mipo.transaction_id
and msi.buyer_id=ppf.person_id
Oracle EBS-SQL (MRP-4):检查例外信息查询_建议取消_采购申请.sql,布布扣,bubuko.com