iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AP_APPS_INSTANCES

DROP VIEW APPS.MRP_AP_APPS_INSTANCES;

/* Formatted on 2015/2/1 下午 05:01:41 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AP_APPS_INSTANCES
(
   INSTANCE_ID,
   LRN,
   LRD,
   INSTANCE_CODE,
   M2A_DBLINK,
   A2M_DBLINK,
   SN_STATUS,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_LOGIN,
   BOM_HOUR_UOM_CODE,
   MRP_MPS_CONSUMPTION,
   MRP_SHIP_ARRIVE_FLAG,
   CRP_SPREAD_LOAD,
   MSO_ITEM_DMD_PENALTY,
   MSO_ITEM_CAP_PENALTY,
   MSO_ORG_DMD_PENALTY,
   MSO_ORG_ITEM_PENALTY,
   MSO_ORG_RES_PENALTY,
   MSO_ORG_TRSP_PENALTY,
   MSC_AGGREG_RES_NAME,
   MSO_RES_PENALTY,
   MSO_SUP_CAP_PENALTY,
   MSC_BOM_SUBST_PRIORITY,
   MSO_TRSP_PENALTY,
   MSC_ALT_BOM_COST,
   MSC_FCST_PENALTY,
   MSO_SO_PENALTY,
   MSC_ALT_OP_RES,
   MSC_ALT_RES_PRIORITY,
   MSC_SIMUL_RES_SEQ,
   MRP_BIS_AV_DISCOUNT,
   MRP_BIS_PRICE_LIST,
   MSC_DMD_PRIORITY_FLEX_NUM,
   MSC_BATCHABLE_FLAG,
   MSC_BATCHING_WINDOW,
   MSC_MIN_CAPACITY,
   MSC_MAX_CAPACITY,
   MSC_UNIT_OF_MEASURE,
   MSC_FCST_PRIORITY_FLEX_NUM,
   ALLOW_ATP_FLAG,
   ALLOW_RELEASE_FLAG,
   MSC_SO_OFFSET_DAYS,
   ITEM_NAME_FROM_KFV
)
AS
   SELECT instance_id,
          lrn,
          lrd,
          instance_code,
          m2a_dblink,
          a2m_dblink,
          sn_status,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          bom_hour_uom_code,
          mrp_mps_consumption,
          mrp_ship_arrive_flag,
          crp_spread_load,
          mso_item_dmd_penalty,
          mso_item_cap_penalty,
          mso_org_dmd_penalty,
          mso_org_item_penalty,
          mso_org_res_penalty,
          mso_org_trsp_penalty,
          msc_aggreg_res_name,
          mso_res_penalty,
          mso_sup_cap_penalty,
          msc_bom_subst_priority,
          mso_trsp_penalty,
          msc_alt_bom_cost,
          mso_fcst_penalty,
          mso_so_penalty,
          msc_alt_op_res,
          msc_alt_res_priority,
          msc_simul_res_seq,
          mrp_bis_av_discount,
          mrp_bis_price_list,
          msc_dmd_priority_flex_num,
          msc_batchable_flag,
          msc_batching_window,
          msc_min_capacity,
          msc_max_capacity,
          msc_unit_of_measure,
          msc_fcst_priority_flex_num,
          allow_atp_flag,
          allow_release_flag,
          msc_so_offset_days,
          item_name_from_kfv
     FROM mrp_ap_apps_instances_all
    WHERE allow_atp_flag = 1;