首页 > 代码库 > 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%‘