iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AP_ASSIGNMENT_SETS_V

DROP VIEW APPS.MRP_AP_ASSIGNMENT_SETS_V;

/* Formatted on 2015/2/1 下午 05:02:21 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AP_ASSIGNMENT_SETS_V
(
   ASSIGNMENT_SET_ID,
   ASSIGNMENT_SET_NAME,
   DESCRIPTION,
   RN1
)
AS
   SELECT mas.Assignment_Set_ID,
          mas.Assignment_Set_Name,
          mas.Description,
          0 RN1
     FROM MRP_ASSIGNMENT_SETS mas;