Oracle EBS-SQL (MRP-3):检查例外信息查询_建议取消_采购订单.sql
selectmsi.segment1 编码
,msi.description 描述
,mr.old_order_quantity 数量
,mr.old_schedule_date 订单需求日期
,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=1
and mr.disposition_id=mipo.transaction_id
and msi.buyer_id=ppf.person_id(+)
order by
mr.old_schedule_date
页:
[1]