iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_SALES_ORDERS_V

DROP VIEW APPS.MRP_AD_SALES_ORDERS_V;

/* Formatted on 2015/2/1 下午 04:58:40 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_SALES_ORDERS_V
(
   DEMAND_ID,
   PARENT_DEMAND_ID,
   RN
)
AS
   SELECT md.Line_ID Demand_ID, 0 Parent_Demand_ID, md.RN
     FROM MRP_AD_ORDER_LINES_ALL md;