iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AD_ONHAND_SUPPLIES_V

DROP VIEW APPS.MRP_AD_ONHAND_SUPPLIES_V;

/* Formatted on 2015/2/1 下午 04:47:38 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AD_ONHAND_SUPPLIES_V
(
   ORGANIZATION_ID,
   INVENTORY_ITEM_ID,
   SUBINVENTORY_CODE,
   LOT_NUMBER,
   RN
)
AS
   SELECT Organization_ID,
          Inventory_Item_ID,
          Subinventory_Code,
          Lot_Number,
          RN
     FROM mrp_ad_oh_qtys
   UNION ALL
   SELECT Organization_ID,
          Inventory_Item_ID,
          Subinventory_Code,
          TO_CHAR (NULL) lot_number,
          RN
     FROM mrp_ad_mtrx_tmp;