Oracle EBS-SQL (MRP-7):检查MRP计划运行报错原因之超大数据查询2.sql

zhu894532094

/*逐一运行检查计划运行超大数据*/

----------------------------------------------------

　　-- 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