Oracle EBS-SQL (MRP-4):检查例外信息查询_建议取消_采购申请.sql

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