iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_RESOURCE_REQUIREMENTS_V

DROP VIEW APPS.MRP_AD_RESOURCE_REQUIREMENTS_V;

/* Formatted on 2015/2/1 下午 04:53:18 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_RESOURCE_REQUIREMENTS_V
(
   WIP_ENTITY_ID,
   WIP_JOB_TYPE,
   OPERATION_SEQ_NUM,
   WJS_NET_QTY_FLAG,
   WJS_MPS_NET_QTY_FLAG,
   RN
)
AS
   SELECT WIP_ENTITY_ID * 2 wip_entity_id,
          JOB_TYPE WIP_JOB_TYPE,
          Operation_Seq_Num,
          WJS_NET_QTY_FLAG,
          WJS_MPS_NET_QTY_FLAG,
          RN
     FROM MRP_AD_RESOURCE_REQUIREMENTS;