iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_WIP_FLOW_DEMANDS_V

DROP VIEW APPS.MRP_AD_WIP_FLOW_DEMANDS_V;

/* Formatted on 2015/2/1 下午 05:00:35 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_WIP_FLOW_DEMANDS_V
(
   WIP_ENTITY_ID,
   ORIGINATION_TYPE,
   RN
)
AS
   SELECT wfs.WIP_ENTITY_ID, 25 ORIGINATION_TYPE, wfs.RN
     FROM MRP_AD_FLOW_SCHDS wfs
   UNION ALL
   SELECT wfd.WIP_ENTITY_ID, 25, wfd.RN
     FROM MRP_FLOW_DEMANDS wfd;