iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_OPERATION_RESOURCES_V

DROP VIEW APPS.MRP_AD_OPERATION_RESOURCES_V;

/* Formatted on 2015/2/1 下午 04:49:18 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_OPERATION_RESOURCES_V
(
   ROUTING_SEQUENCE_ID,
   OPERATION_SEQUENCE_ID,
   RESOURCE_SEQ_NUM,
   RESOURCE_ID,
   ALTERNATE_NUMBER,
   RN
)
AS
   SELECT Routing_Sequence_ID * 2 Routing_Sequence_ID,
          Operation_Sequence_ID * 2 Operation_Sequence_ID,
          Resource_Seq_Num,
          Resource_ID * 2 Resource_ID,
          1 Alternate_Number,
          RN
     FROM MRP_AD_OPR_RESS;