Oracle EBS-SQL (MRP-7):检查MRP计划运行报错原因之超大数据查询2.sql
/*逐一运行检查计划运行超大数据*/
----------------------------------------------------
-- PO Requisitions
select * from PO_REQUISITION_LINES_ALL where LINE_NUM > 1000000000;
-- PO Lines
select * from PO_LINES_ALL where LINE_NUM > 1000000000;
-- Receiving Supply
SELECT * FROM PO_RCV_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Requisition Supply
SELECT * FROM PO_REQ_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- PO Supply
SELECT * FROM PO_PO_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Intransit Shipment Supply
SELECT * FROM PO_SHIP_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
-- Intransit Receiving Supply
SELECT * FROM PO_SHIP_RCV_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
-- Receiving Supply
SELECT * FROM PO_RCV_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Requisition Supply
SELECT * FROM PO_REQ_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- PO Supply
SELECT * FROM PO_PO_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Intransit Shipment Supply
SELECT * FROM PO_SHIP_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
-- Intransit Receiving Supply
SELECT * FROM PO_SHIP_RCV_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
Refer to below view when running MRP with check "Net Purchase" in
plan option.
( PO_RCV_SUPPLY_VIEW, PO_REQ_SUPPLY_VIEW, PO_PO_SUPPLY_VIEW,PO_SHIP_SUPPLY_VIEW, PO_SHIP_RCV_SUPPLY_VIEW )
SELECT * FROM MRP_PO_SUPPLY_VIEW WHERE SUPPLY_LINE_NUM > 1000000000
最新文章
- Java泛型
- 通过配置http拦截器，来进行ajax请求验证用户登录的页面跳转
- URL 学习总结
- 关于duplicate symbol _main in的解决办法
- 事件日志ID 2511：服务器服务无法重新创建 <sharename> 共享关系，因为 <address> 目录已不再存在
- Visual Studio 2012 比较好用的插件推荐
- hbase blocksize设置，与hdfs关系
- js常用函数收集
- JSON 之 SuperObject(7): 可以省略的双引号
- 文件已经加入.gitignore但是vs并没有显示文件处于ignore状态
- ELK安装配置及nginx日志分析
- css之选择器
- hdoj 3555 Bomb(DFA+dp)
- 洛谷 P1028 数的计算【递推】
- jquery.data()&jquery.extend()
- spring boot 集成Druid
- POJ1679 The Unique MST【次小生成树】
- The iOS Simulator deployment target is set to 6.0
- ubuntu下ldd,查看程序动态库信息
- prometheus+telegraf无法监控网络流量的问题