首页 > 代码库 > Oracle EBS-SQL (QA-1):检查超出检验周期的检验数据.sql

Oracle EBS-SQL (QA-1):检查超出检验周期的检验数据.sql

 select msi.segment1                                    物料编码,
          msi.DESCRIPTION                              物料描述,
          PER.LAST_NAME                                   采购员,
          MSI.FULL_LEAD_TIME                           提前期,
          MSI.FIXED_ORDER_QUANTITY      固定订单数量,
          MSI.MINIMUM_ORDER_QUANTITY 最小订单数量,
          MSI.FIXED_DAYS_SUPPLY            固定天数供应,
          MSI.FIXED_LOT_MULTIPLIER         固定批量倍数
  from inv.MTL_SYSTEM_ITEMS_b msi,

          APPS.PER_PEOPLE_F PER
where msi.organization_id = X                                               and
         msi.INVENTORY_ITEM_STATUS_CODE not like ‘Inactive‘ AND
         MSI.ITEM_TYPE = ‘P‘                                                    AND
         (MSI.BUYER_ID IS NULL OR MSI.FULL_LEAD_TIME IS NULL OR
         MSI.MINIMUM_ORDER_QUANTITY IS NULL OR
         MSI.FIXED_DAYS_SUPPLY IS NULL OR MSI.FIXED_LOT_MULTIPLIER IS NULL) AND
         MSI.BUYER_ID = PER.PERSON_ID(+) AND MSI.SEGMENT1 NOT LIKE ‘1%‘