iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_RESOURCE_CHANGES_V

DROP VIEW APPS.MRP_AD_RESOURCE_CHANGES_V;

/* Formatted on 2015/2/1 下午 04:52:45 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_RESOURCE_CHANGES_V
(
   DEPARTMENT_ID,
   RESOURCE_ID,
   SHIFT_NUM,
   SIMULATION_SET,
   ACTION_TYPE,
   FROM_DATE,
   TO_DATE,
   FROM_TIME,
   TO_TIME,
   RN
)
AS
   SELECT rc.DEPARTMENT_ID * 2 DEPARTMENT_ID,
          rc.RESOURCE_ID * 2 RESOURCE_ID,
          rc.SHIFT_NUM,
          rc.SIMULATION_SET,
          rc.ACTION_TYPE,
          rc.FROM_DATE,
          rc.TO_DATE,
          rc.FROM_TIME,
          rc.TO_TIME,
          rc.RN
     FROM MRP_AD_RES_CHNGS rc;