iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_MPS_SUPPLIES_V

DROP VIEW APPS.MRP_AD_MPS_SUPPLIES_V;

/* Formatted on 2015/2/1 下午 04:46:57 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_MPS_SUPPLIES_V
(
   DISPOSITION_ID,
   SCHEDULE_ORIGINATION_TYPE,
   INVENTORY_ITEM_ID,
   ORGANIZATION_ID,
   ORDER_TYPE,
   RN
)
AS
   SELECT sd.MPS_TRANSACTION_ID DISPOSITION_ID,
          sd.SCHEDULE_ORIGINATION_TYPE,
          sd.INVENTORY_ITEM_ID,
          sd.ORGANIZATION_ID,
          5 ORDER_TYPE,
          sd.RN
     FROM MRP_AD_SCHD_DATES sd
    WHERE sd.SUPPLY_DEMAND_TYPE = 2;