iDempiere 抓取 Oracle ERP View資料 APPS.MRP_AP_ATP_RULES_V

DROP VIEW APPS.MRP_AP_ATP_RULES_V;

/* Formatted on 2015/2/1 下午 05:02:56 (QP5 v5.256.13226.35538) */
CREATE OR REPLACE FORCE VIEW APPS.MRP_AP_ATP_RULES_V
(
   RULE_ID,
   RULE_NAME,
   DESCRIPTION,
   ACCUMULATE_AVAILABLE_FLAG,
   BACKWARD_CONSUMPTION_FLAG,
   FORWARD_CONSUMPTION_FLAG,
   PAST_DUE_DEMAND_CUTOFF_FENCE,
   PAST_DUE_SUPPLY_CUTOFF_FENCE,
   INFINITE_SUPPLY_FENCE_CODE,
   INFINITE_SUPPLY_TIME_FENCE,
   ACCEPTABLE_EARLY_FENCE,
   ACCEPTABLE_LATE_FENCE,
   DEFAULT_ATP_SOURCES,
   DEMAND_CLASS_ATP_FLAG,
   INCLUDE_SALES_ORDERS,
   INCLUDE_DISCRETE_WIP_DEMAND,
   INCLUDE_REP_WIP_DEMAND,
   INCLUDE_NONSTD_WIP_DEMAND,
   INCLUDE_DISCRETE_MPS,
   INCLUDE_USER_DEFINED_DEMAND,
   INCLUDE_PURCHASE_ORDERS,
   INCLUDE_DISCRETE_WIP_RECEIPTS,
   INCLUDE_REP_WIP_RECEIPTS,
   INCLUDE_NONSTD_WIP_RECEIPTS,
   INCLUDE_INTERORG_TRANSFERS,
   INCLUDE_ONHAND_AVAILABLE,
   INCLUDE_USER_DEFINED_SUPPLY,
   ACCUMULATION_WINDOW,
   INCLUDE_REP_MPS,
   INCLUDE_INTERNAL_REQS,
   INCLUDE_SUPPLIER_REQS,
   INCLUDE_INTERNAL_ORDERS,
   INCLUDE_FLOW_SCHEDULE_DEMAND,
   INCLUDE_FLOW_SCHEDULE_RECEIPTS,
   USER_ATP_SUPPLY_TABLE_NAME,
   USER_ATP_DEMAND_TABLE_NAME,
   MPS_DESIGNATOR
)
AS
   SELECT RULE_ID,
          RULE_NAME,
          DESCRIPTION,
          ACCUMULATE_AVAILABLE_FLAG,
          BACKWARD_CONSUMPTION_FLAG,
          FORWARD_CONSUMPTION_FLAG,
          PAST_DUE_DEMAND_CUTOFF_FENCE,
          PAST_DUE_SUPPLY_CUTOFF_FENCE,
          INFINITE_SUPPLY_FENCE_CODE,
          INFINITE_SUPPLY_TIME_FENCE,
          ACCEPTABLE_EARLY_FENCE,
          ACCEPTABLE_LATE_FENCE,
          DEFAULT_ATP_SOURCES,
          DEMAND_CLASS_ATP_FLAG,
          INCLUDE_SALES_ORDERS,
          INCLUDE_DISCRETE_WIP_DEMAND,
          INCLUDE_REP_WIP_DEMAND,
          INCLUDE_NONSTD_WIP_DEMAND,
          INCLUDE_DISCRETE_MPS,
          INCLUDE_USER_DEFINED_DEMAND,
          INCLUDE_PURCHASE_ORDERS,
          INCLUDE_DISCRETE_WIP_RECEIPTS,
          INCLUDE_REP_WIP_RECEIPTS,
          INCLUDE_NONSTD_WIP_RECEIPTS,
          INCLUDE_INTERORG_TRANSFERS,
          INCLUDE_ONHAND_AVAILABLE,
          INCLUDE_USER_DEFINED_SUPPLY,
          ACCUMULATION_WINDOW,
          INCLUDE_REP_MPS,
          INCLUDE_INTERNAL_REQS,
          INCLUDE_VENDOR_REQS INCLUDE_SUPPLIER_REQS,
          INCLUDE_INTERNAL_ORDERS,
          INCLUDE_FLOW_SCHEDULE_DEMAND,
          INCLUDE_FLOW_SCHEDULE_RECEIPTS,
          USER_ATP_SUPPLY_TABLE_NAME,
          USER_ATP_DEMAND_TABLE_NAME,
          MPS_DESIGNATOR
     FROM MTL_ATP_RULES;