iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_MDS_DEMANDS_V

DROP VIEW APPS.MRP_AD_MDS_DEMANDS_V;

/* Formatted on 2015/2/1 下午 04:46:19 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_MDS_DEMANDS_V
(
   DISPOSITION_ID,
   INVENTORY_ITEM_ID,
   ORGANIZATION_ID,
   USING_ASSEMBLY_ID,
   ORIGINATION_TYPE,
   RN
)
AS
   SELECT sd.MPS_TRANSACTION_ID DISPOSITION_ID,
          sd.INVENTORY_ITEM_ID,
          sd.ORGANIZATION_ID,
          sd.INVENTORY_ITEM_ID USING_ASSEMBLY_ID,
          DECODE (sd.SCHEDULE_ORIGINATION_TYPE,
                  1, 8,
                  3, 6,
                  2, 7,
                  8, 7,
                  4, 15,
                  11, 24,
                  7, 8,
                  NULL)
             Origination_Type,
          sd.RN
     FROM MRP_AD_SCHD_DATES sd
    WHERE sd.SUPPLY_DEMAND_TYPE = 1;