VIEW: MSC.MSC_ST_ATP_RULES#

Source

View Text - Preformatted

select RULE_ID RULE_ID, SR_INSTANCE_ID SR_INSTANCE_ID, RULE_NAME RULE_NAME, DESCRIPTION DESCRIPTION, ACCUMULATE_AVAILABLE_FLAG ACCUMULATE_AVAILABLE_FLAG, BACKWARD_CONSUMPTION_FLAG BACKWARD_CONSUMPTION_FLAG, FORWARD_CONSUMPTION_FLAG FORWARD_CONSUMPTION_FLAG, PAST_DUE_DEMAND_CUTOFF_FENCE PAST_DUE_DEMAND_CUTOFF_FENCE, PAST_DUE_SUPPLY_CUTOFF_FENCE PAST_DUE_SUPPLY_CUTOFF_FENCE, INFINITE_SUPPLY_FENCE_CODE INFINITE_SUPPLY_FENCE_CODE, INFINITE_SUPPLY_TIME_FENCE INFINITE_SUPPLY_TIME_FENCE, ACCEPTABLE_EARLY_FENCE ACCEPTABLE_EARLY_FENCE, ACCEPTABLE_LATE_FENCE ACCEPTABLE_LATE_FENCE, DEFAULT_ATP_SOURCES DEFAULT_ATP_SOURCES, INCLUDE_SALES_ORDERS INCLUDE_SALES_ORDERS, INCLUDE_DISCRETE_WIP_DEMAND INCLUDE_DISCRETE_WIP_DEMAND, INCLUDE_REP_WIP_DEMAND INCLUDE_REP_WIP_DEMAND, INCLUDE_NONSTD_WIP_DEMAND INCLUDE_NONSTD_WIP_DEMAND, INCLUDE_DISCRETE_MPS INCLUDE_DISCRETE_MPS, INCLUDE_USER_DEFINED_DEMAND INCLUDE_USER_DEFINED_DEMAND, INCLUDE_PURCHASE_ORDERS INCLUDE_PURCHASE_ORDERS, INCLUDE_DISCRETE_WIP_RECEIPTS INCLUDE_DISCRETE_WIP_RECEIPTS, INCLUDE_REP_WIP_RECEIPTS INCLUDE_REP_WIP_RECEIPTS, INCLUDE_NONSTD_WIP_RECEIPTS INCLUDE_NONSTD_WIP_RECEIPTS, INCLUDE_INTERORG_TRANSFERS INCLUDE_INTERORG_TRANSFERS, INCLUDE_ONHAND_AVAILABLE INCLUDE_ONHAND_AVAILABLE, INCLUDE_USER_DEFINED_SUPPLY INCLUDE_USER_DEFINED_SUPPLY, ACCUMULATION_WINDOW ACCUMULATION_WINDOW, INCLUDE_REP_MPS INCLUDE_REP_MPS, INCLUDE_INTERNAL_REQS INCLUDE_INTERNAL_REQS, INCLUDE_SUPPLIER_REQS INCLUDE_SUPPLIER_REQS, INCLUDE_INTERNAL_ORDERS INCLUDE_INTERNAL_ORDERS, INCLUDE_FLOW_SCHEDULE_DEMAND INCLUDE_FLOW_SCHEDULE_DEMAND, USER_ATP_SUPPLY_TABLE_NAME USER_ATP_SUPPLY_TABLE_NAME, USER_ATP_DEMAND_TABLE_NAME USER_ATP_DEMAND_TABLE_NAME, MPS_DESIGNATOR MPS_DESIGNATOR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, DEMAND_CLASS_ATP_FLAG DEMAND_CLASS_ATP_FLAG, INCLUDE_FLOW_SCHEDULE_RECEIPTS INCLUDE_FLOW_SCHEDULE_RECEIPTS, AGGREGATE_TIME_FENCE_CODE AGGREGATE_TIME_FENCE_CODE, AGGREGATE_TIME_FENCE AGGREGATE_TIME_FENCE from "MSC"."MSC_ST_ATP_RULES"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, RULE_NAME RULE_NAME
, DESCRIPTION DESCRIPTION
, ACCUMULATE_AVAILABLE_FLAG ACCUMULATE_AVAILABLE_FLAG
, BACKWARD_CONSUMPTION_FLAG BACKWARD_CONSUMPTION_FLAG
, FORWARD_CONSUMPTION_FLAG FORWARD_CONSUMPTION_FLAG
, PAST_DUE_DEMAND_CUTOFF_FENCE PAST_DUE_DEMAND_CUTOFF_FENCE
, PAST_DUE_SUPPLY_CUTOFF_FENCE PAST_DUE_SUPPLY_CUTOFF_FENCE
, INFINITE_SUPPLY_FENCE_CODE INFINITE_SUPPLY_FENCE_CODE
, INFINITE_SUPPLY_TIME_FENCE INFINITE_SUPPLY_TIME_FENCE
, ACCEPTABLE_EARLY_FENCE ACCEPTABLE_EARLY_FENCE
, ACCEPTABLE_LATE_FENCE ACCEPTABLE_LATE_FENCE
, DEFAULT_ATP_SOURCES DEFAULT_ATP_SOURCES
, INCLUDE_SALES_ORDERS INCLUDE_SALES_ORDERS
, INCLUDE_DISCRETE_WIP_DEMAND INCLUDE_DISCRETE_WIP_DEMAND
, INCLUDE_REP_WIP_DEMAND INCLUDE_REP_WIP_DEMAND
, INCLUDE_NONSTD_WIP_DEMAND INCLUDE_NONSTD_WIP_DEMAND
, INCLUDE_DISCRETE_MPS INCLUDE_DISCRETE_MPS
, INCLUDE_USER_DEFINED_DEMAND INCLUDE_USER_DEFINED_DEMAND
, INCLUDE_PURCHASE_ORDERS INCLUDE_PURCHASE_ORDERS
, INCLUDE_DISCRETE_WIP_RECEIPTS INCLUDE_DISCRETE_WIP_RECEIPTS
, INCLUDE_REP_WIP_RECEIPTS INCLUDE_REP_WIP_RECEIPTS
, INCLUDE_NONSTD_WIP_RECEIPTS INCLUDE_NONSTD_WIP_RECEIPTS
, INCLUDE_INTERORG_TRANSFERS INCLUDE_INTERORG_TRANSFERS
, INCLUDE_ONHAND_AVAILABLE INCLUDE_ONHAND_AVAILABLE
, INCLUDE_USER_DEFINED_SUPPLY INCLUDE_USER_DEFINED_SUPPLY
, ACCUMULATION_WINDOW ACCUMULATION_WINDOW
, INCLUDE_REP_MPS INCLUDE_REP_MPS
, INCLUDE_INTERNAL_REQS INCLUDE_INTERNAL_REQS
, INCLUDE_SUPPLIER_REQS INCLUDE_SUPPLIER_REQS
, INCLUDE_INTERNAL_ORDERS INCLUDE_INTERNAL_ORDERS
, INCLUDE_FLOW_SCHEDULE_DEMAND INCLUDE_FLOW_SCHEDULE_DEMAND
, USER_ATP_SUPPLY_TABLE_NAME USER_ATP_SUPPLY_TABLE_NAME
, USER_ATP_DEMAND_TABLE_NAME USER_ATP_DEMAND_TABLE_NAME
, MPS_DESIGNATOR MPS_DESIGNATOR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, DEMAND_CLASS_ATP_FLAG DEMAND_CLASS_ATP_FLAG
, INCLUDE_FLOW_SCHEDULE_RECEIPTS INCLUDE_FLOW_SCHEDULE_RECEIPTS
, AGGREGATE_TIME_FENCE_CODE AGGREGATE_TIME_FENCE_CODE
, AGGREGATE_TIME_FENCE AGGREGATE_TIME_FENCE
FROM "MSC"."MSC_ST_ATP_RULES"