VIEW: INV.MTL_ATP_RULES#

Source

View Text - Preformatted

select RULE_ID RULE_ID, RULE_NAME RULE_NAME, 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, 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, DEMAND_CLASS_ATP_FLAG DEMAND_CLASS_ATP_FLAG, 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, MPS_DESIGNATOR MPS_DESIGNATOR, INCLUDE_USER_DEFINED_DEMAND INCLUDE_USER_DEFINED_DEMAND, USER_ATP_DEMAND_TABLE_NAME USER_ATP_DEMAND_TABLE_NAME, 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, USER_ATP_SUPPLY_TABLE_NAME USER_ATP_SUPPLY_TABLE_NAME, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ACCUMULATION_WINDOW ACCUMULATION_WINDOW, INCLUDE_REP_MPS INCLUDE_REP_MPS, INCLUDE_INTERNAL_REQS INCLUDE_INTERNAL_REQS, INCLUDE_VENDOR_REQS INCLUDE_VENDOR_REQS, INCLUDE_INTERNAL_ORDERS INCLUDE_INTERNAL_ORDERS, INCLUDE_FLOW_SCHEDULE_DEMAND INCLUDE_FLOW_SCHEDULE_DEMAND, INCLUDE_FLOW_SCHEDULE_RECEIPTS INCLUDE_FLOW_SCHEDULE_RECEIPTS, AGGREGATE_TIME_FENCE_CODE AGGREGATE_TIME_FENCE_CODE, AGGREGATE_TIME_FENCE AGGREGATE_TIME_FENCE from "INV"."MTL_ATP_RULES"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, RULE_NAME RULE_NAME
, 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
, 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
, DEMAND_CLASS_ATP_FLAG DEMAND_CLASS_ATP_FLAG
, 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
, MPS_DESIGNATOR MPS_DESIGNATOR
, INCLUDE_USER_DEFINED_DEMAND INCLUDE_USER_DEFINED_DEMAND
, USER_ATP_DEMAND_TABLE_NAME USER_ATP_DEMAND_TABLE_NAME
, 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
, USER_ATP_SUPPLY_TABLE_NAME USER_ATP_SUPPLY_TABLE_NAME
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ACCUMULATION_WINDOW ACCUMULATION_WINDOW
, INCLUDE_REP_MPS INCLUDE_REP_MPS
, INCLUDE_INTERNAL_REQS INCLUDE_INTERNAL_REQS
, INCLUDE_VENDOR_REQS INCLUDE_VENDOR_REQS
, INCLUDE_INTERNAL_ORDERS INCLUDE_INTERNAL_ORDERS
, INCLUDE_FLOW_SCHEDULE_DEMAND INCLUDE_FLOW_SCHEDULE_DEMAND
, INCLUDE_FLOW_SCHEDULE_RECEIPTS INCLUDE_FLOW_SCHEDULE_RECEIPTS
, AGGREGATE_TIME_FENCE_CODE AGGREGATE_TIME_FENCE_CODE
, AGGREGATE_TIME_FENCE AGGREGATE_TIME_FENCE
FROM "INV"."MTL_ATP_RULES"