iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AP_BIS_PERIODS_V

DROP VIEW APPS.MRP_AP_BIS_PERIODS_V;

/* Formatted on 2015/2/1 下午 05:04:08 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AP_BIS_PERIODS_V
(
   ORGANIZATION_ID,
   PERIOD_SET_NAME,
   PERIOD_NAME,
   START_DATE,
   END_DATE,
   PERIOD_TYPE,
   PERIOD_YEAR,
   PERIOD_NUM,
   QUARTER_NUM,
   ENTERED_PERIOD_NAME,
   ADJUSTMENT_PERIOD_FLAG,
   DESCRIPTION,
   CONTEXT,
   YEAR_START_DATE,
   QUARTER_START_DATE
)
AS
   SELECT ood.ORGANIZATION_ID,
          gp.PERIOD_SET_NAME,
          gp.PERIOD_NAME,
          gp.START_DATE,
          gp.END_DATE,
          gp.PERIOD_TYPE,
          gp.PERIOD_YEAR,
          gp.PERIOD_NUM,
          gp.QUARTER_NUM,
          gp.ENTERED_PERIOD_NAME,
          gp.ADJUSTMENT_PERIOD_FLAG,
          gp.DESCRIPTION,
          gp.CONTEXT,
          gp.YEAR_START_DATE,
          gp.QUARTER_START_DATE
     FROM GL_PERIODS gp,
          ORG_ORGANIZATION_DEFINITIONS ood,
          gl_sets_of_books gsob
    WHERE     ood.set_of_books_id = gsob.set_of_books_id
          AND gsob.period_set_name = gp.period_set_name
          AND gsob.ACCOUNTED_PERIOD_TYPE = gp.PERIOD_TYPE;