iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_PROCESS_EFFECTIVITY_V

DROP VIEW APPS.MRP_AD_PROCESS_EFFECTIVITY_V;

/* Formatted on 2015/2/1 下午 04:50:34 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_PROCESS_EFFECTIVITY_V
(
   INVENTORY_ITEM_ID,
   ORGANIZATION_ID,
   BILL_SEQUENCE_ID,
   ROUTING_SEQUENCE_ID,
   LINE_ID,
   RN
)
AS
   SELECT INVENTORY_ITEM_ID,
          ORGANIZATION_ID,
          BILL_SEQUENCE_ID * 2 BILL_SEQUENCE_ID,
          ROUTING_SEQUENCE_ID * 2 ROUTING_SEQUENCE_ID,
          LINE_ID,
          RN
     FROM MRP_AD_PROCESS_EFFECTIVITY;