iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_USER_SUPPLIES_V

DROP VIEW APPS.MRP_AD_USER_SUPPLIES_V;

/* Formatted on 2015/2/1 下午 05:00:11 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_USER_SUPPLIES_V
(
   TRANSACTION_ID,
   ORDER_TYPE,
   RN
)
AS
   SELECT ud.TRANSACTION_ID, 41 ORDER_TYPE, ud.RN
     FROM MRP_AD_U_SUPPLY ud;