iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AP_BILL_OF_RESOURCES_V

DROP VIEW APPS.MRP_AP_BILL_OF_RESOURCES_V;

/* Formatted on 2015/2/1 下午 05:03:35 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AP_BILL_OF_RESOURCES_V
(
   BILL_OF_RESOURCES,
   ORGANIZATION_ID,
   DESCRIPTION,
   DISABLE_DATE,
   ROLLUP_START_DATE,
   ROLLUP_COMPLETION_DATE,
   RN2,
   RN1
)
AS
   SELECT x.BILL_OF_RESOURCES,
          x.ORGANIZATION_ID,
          x.DESCRIPTION,
          x.DISABLE_DATE,
          x.ROLLUP_START_DATE,
          x.ROLLUP_COMPLETION_DATE,
          0 RN2,
          0 RN1
     FROM CRP_BILLS_OF_RESOURCES x;