iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_WIP_JOB_SUPPLIES_V

DROP VIEW APPS.MRP_AD_WIP_JOB_SUPPLIES_V;

/* Formatted on 2015/2/1 下午 05:01:08 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_WIP_JOB_SUPPLIES_V
(
   WIP_ENTITY_ID,
   WIP_JOB_TYPE,
   ORDER_TYPE,
   WJS_NET_QTY_FLAG,
   WJS_MPS_NET_QTY_FLAG,
   RN
)
AS
   SELECT WIP_ENTITY_ID * 2 wip_entity_id,
          JOB_TYPE WIP_JOB_TYPE,
          DECODE (JOB_TYPE, 1, 3, 7) ORDER_TYPE,
          WJS_NET_QTY_FLAG,
          WJS_MPS_NET_QTY_FLAG,
          RN
     FROM MRP_AD_DSCR_JOBS
   UNION ALL
   SELECT WIP_ENTITY_ID * 2 wip_entity_id,
          4 WIP_JOB_TYPE,
          27 ORDER_TYPE,
          WJS_NET_QTY_FLAG,
          TO_NUMBER (NULL) WJS_MPS_NET_QTY_FLAG,
          RN
     FROM MRP_AD_FLOW_SCHDS;