iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_REPT_ITEM_DEMANDS_V

DROP VIEW APPS.MRP_AD_REPT_ITEM_DEMANDS_V;

/* Formatted on 2015/2/1 下午 04:51:00 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_REPT_ITEM_DEMANDS_V
(
   WIP_ENTITY_ID,
   REPETITIVE_SCHEDULE_ID,
   INVENTORY_ITEM_ID,
   OPERATION_SEQ_NUM,
   ORIGINATION_TYPE,
   RN
)
AS
   SELECT WIP_ENTITY_ID * 2 wip_entity_id,
          REPETITIVE_SCHEDULE_ID,
          INVENTORY_ITEM_ID,
          OPERATION_SEQ_NUM,
          4 Origination_Type,
          RN
     FROM MRP_AD_REPT_ITEM_DEMANDS;