?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%'

轉載于:https://www.cnblogs.com/st-sun/p/3782072.html

總結

以上是生活随笔為你收集整理的Oracle EBS-SQL (QA-1):检查超出检验周期的检验数据.sql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。