VIEW: MRP.MRP_WORKBENCH_DISPLAY_OPTIONS#

Source

View Text - Preformatted

select USER_ID USER_ID, DEFAULT_FLAG DEFAULT_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, BUCKET_TYPE BUCKET_TYPE, LAST_UPDATED_BY LAST_UPDATED_BY, SUMMARY_FIELD_WIDTH SUMMARY_FIELD_WIDTH, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUMMARY_SALES_ORDERS SUMMARY_SALES_ORDERS, SUMMARY_FORECAST SUMMARY_FORECAST, SUMMARY_DEPENDENT_DEMAND SUMMARY_DEPENDENT_DEMAND, SUMMARY_SCRAP SUMMARY_SCRAP, SUMMARY_INDEPENDENT_DEMAND SUMMARY_INDEPENDENT_DEMAND, SUMMARY_GROSS_REQUIREMENTS SUMMARY_GROSS_REQUIREMENTS, SUMMARY_SCHEDULED_RECEIPTS SUMMARY_SCHEDULED_RECEIPTS, SUMMARY_PLANNED_ORDERS SUMMARY_PLANNED_ORDERS, SUMMARY_TOTAL_SUPPLY SUMMARY_TOTAL_SUPPLY, SUMMARY_PAB SUMMARY_PAB, SUMMARY_SS SUMMARY_SS, SUMMARY_ATP SUMMARY_ATP, SUMMARY_WIP SUMMARY_WIP, SUMMARY_FLOW_SCHEDULES SUMMARY_FLOW_SCHEDULES, SUMMARY_PO SUMMARY_PO, SUMMARY_REQ SUMMARY_REQ, SUMMARY_TRANSIT SUMMARY_TRANSIT, SUMMARY_RECEIVING SUMMARY_RECEIVING, SUMMARY_CURRENT_RECEIPTS SUMMARY_CURRENT_RECEIPTS, SUMMARY_POH SUMMARY_POH, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR, SUMMARY_WINDOW_SIZE SUMMARY_WINDOW_SIZE, SUMMARY_WINDOW_WIDTH SUMMARY_WINDOW_WIDTH, ORDERS_SALES_ORDERS ORDERS_SALES_ORDERS, ORDERS_FORECAST ORDERS_FORECAST, ORDERS_DEPENDENT_DEMAND ORDERS_DEPENDENT_DEMAND, ORDERS_SCRAP ORDERS_SCRAP, ORDERS_INDEPENDENT_DEMAND ORDERS_INDEPENDENT_DEMAND, ORDERS_SCHEDULED_RECEIPTS ORDERS_SCHEDULED_RECEIPTS, ORDERS_PLANNED_ORDERS ORDERS_PLANNED_ORDERS, ORDERS_DEFAULT_JOB_STATUS ORDERS_DEFAULT_JOB_STATUS, SUMMARY_DECIMAL_PLACES SUMMARY_DECIMAL_PLACES, ORDERS_RELEASE_PHANTOMS ORDERS_RELEASE_PHANTOMS, ORDERS_RELEASE_CONFIGS ORDERS_RELEASE_CONFIGS, ORDERS_FIRM_JOBS ORDERS_FIRM_JOBS, ORDERS_FOLDER_ID ORDERS_FOLDER_ID, SUMMARY_BEGINNING_ON_HAND SUMMARY_BEGINNING_ON_HAND, ORDERS_CUTOFF_DATE ORDERS_CUTOFF_DATE, GROUP_BY_CODE GROUP_BY_CODE, JOB_CLASS_CODE JOB_CLASS_CODE, SUMMARY_EXP_LOT SUMMARY_EXP_LOT, IND_DEMAND_TYPE IND_DEMAND_TYPE, SOURCE_LIST SOURCE_LIST, CRP_PLANNED_ORDERS CRP_PLANNED_ORDERS, CRP_NON_STD_JOB_ORDERS CRP_NON_STD_JOB_ORDERS, CRP_FLOW_SCHEDULES CRP_FLOW_SCHEDULES, CRP_DISCRETE_JOBS CRP_DISCRETE_JOBS, CRP_REPETITIVE_SCHEDULES CRP_REPETITIVE_SCHEDULES, CRP_REQUIRE_HOURS CRP_REQUIRE_HOURS, CRP_HOUR_AVAILABLE CRP_HOUR_AVAILABLE, CRP_NET_HOUR_AVAILABLE CRP_NET_HOUR_AVAILABLE, CRP_CUM_HOUR_AVAILABLE CRP_CUM_HOUR_AVAILABLE, CRP_ROUTING_CAPACITY_UTIL CRP_ROUTING_CAPACITY_UTIL, CRP_CUM_ROUTING_CAPACITY_UTIL CRP_CUM_ROUTING_CAPACITY_UTIL, CRP_HOURS_REQUIRED_PER_DAY CRP_HOURS_REQUIRED_PER_DAY, CRP_HOURS_AVAIL_PER_DAY CRP_HOURS_AVAIL_PER_DAY, CRP_RESOURCE_COST CRP_RESOURCE_COST, CRP_REQUIRED_RATE CRP_REQUIRED_RATE, CRP_AVAILABLE_RATE CRP_AVAILABLE_RATE, CRP_NET_AVAILABLE_RATE CRP_NET_AVAILABLE_RATE, CRP_CUM_AVAILABLE_RATE CRP_CUM_AVAILABLE_RATE, CRP_RATE_CAPACITY_UTIL CRP_RATE_CAPACITY_UTIL, CRP_CUM_RATE_CAPACITY_UTIL CRP_CUM_RATE_CAPACITY_UTIL, CRP_DAILY_REQUIRED_RATE CRP_DAILY_REQUIRED_RATE, CRP_DAILY_AVAILABLE_RATE CRP_DAILY_AVAILABLE_RATE, CRP_LINE_COST CRP_LINE_COST, SUMMARY_PAYBACK_SUPPLY SUMMARY_PAYBACK_SUPPLY, SUMMARY_PAYBACK_DEMAND SUMMARY_PAYBACK_DEMAND, CATEGORY_SET_ID CATEGORY_SET_ID from "MRP"."MRP_WORKBENCH_DISPLAY_OPTIONS"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, DEFAULT_FLAG DEFAULT_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, BUCKET_TYPE BUCKET_TYPE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SUMMARY_FIELD_WIDTH SUMMARY_FIELD_WIDTH
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUMMARY_SALES_ORDERS SUMMARY_SALES_ORDERS
, SUMMARY_FORECAST SUMMARY_FORECAST
, SUMMARY_DEPENDENT_DEMAND SUMMARY_DEPENDENT_DEMAND
, SUMMARY_SCRAP SUMMARY_SCRAP
, SUMMARY_INDEPENDENT_DEMAND SUMMARY_INDEPENDENT_DEMAND
, SUMMARY_GROSS_REQUIREMENTS SUMMARY_GROSS_REQUIREMENTS
, SUMMARY_SCHEDULED_RECEIPTS SUMMARY_SCHEDULED_RECEIPTS
, SUMMARY_PLANNED_ORDERS SUMMARY_PLANNED_ORDERS
, SUMMARY_TOTAL_SUPPLY SUMMARY_TOTAL_SUPPLY
, SUMMARY_PAB SUMMARY_PAB
, SUMMARY_SS SUMMARY_SS
, SUMMARY_ATP SUMMARY_ATP
, SUMMARY_WIP SUMMARY_WIP
, SUMMARY_FLOW_SCHEDULES SUMMARY_FLOW_SCHEDULES
, SUMMARY_PO SUMMARY_PO
, SUMMARY_REQ SUMMARY_REQ
, SUMMARY_TRANSIT SUMMARY_TRANSIT
, SUMMARY_RECEIVING SUMMARY_RECEIVING
, SUMMARY_CURRENT_RECEIPTS SUMMARY_CURRENT_RECEIPTS
, SUMMARY_POH SUMMARY_POH
, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR
, SUMMARY_WINDOW_SIZE SUMMARY_WINDOW_SIZE
, SUMMARY_WINDOW_WIDTH SUMMARY_WINDOW_WIDTH
, ORDERS_SALES_ORDERS ORDERS_SALES_ORDERS
, ORDERS_FORECAST ORDERS_FORECAST
, ORDERS_DEPENDENT_DEMAND ORDERS_DEPENDENT_DEMAND
, ORDERS_SCRAP ORDERS_SCRAP
, ORDERS_INDEPENDENT_DEMAND ORDERS_INDEPENDENT_DEMAND
, ORDERS_SCHEDULED_RECEIPTS ORDERS_SCHEDULED_RECEIPTS
, ORDERS_PLANNED_ORDERS ORDERS_PLANNED_ORDERS
, ORDERS_DEFAULT_JOB_STATUS ORDERS_DEFAULT_JOB_STATUS
, SUMMARY_DECIMAL_PLACES SUMMARY_DECIMAL_PLACES
, ORDERS_RELEASE_PHANTOMS ORDERS_RELEASE_PHANTOMS
, ORDERS_RELEASE_CONFIGS ORDERS_RELEASE_CONFIGS
, ORDERS_FIRM_JOBS ORDERS_FIRM_JOBS
, ORDERS_FOLDER_ID ORDERS_FOLDER_ID
, SUMMARY_BEGINNING_ON_HAND SUMMARY_BEGINNING_ON_HAND
, ORDERS_CUTOFF_DATE ORDERS_CUTOFF_DATE
, GROUP_BY_CODE GROUP_BY_CODE
, JOB_CLASS_CODE JOB_CLASS_CODE
, SUMMARY_EXP_LOT SUMMARY_EXP_LOT
, IND_DEMAND_TYPE IND_DEMAND_TYPE
, SOURCE_LIST SOURCE_LIST
, CRP_PLANNED_ORDERS CRP_PLANNED_ORDERS
, CRP_NON_STD_JOB_ORDERS CRP_NON_STD_JOB_ORDERS
, CRP_FLOW_SCHEDULES CRP_FLOW_SCHEDULES
, CRP_DISCRETE_JOBS CRP_DISCRETE_JOBS
, CRP_REPETITIVE_SCHEDULES CRP_REPETITIVE_SCHEDULES
, CRP_REQUIRE_HOURS CRP_REQUIRE_HOURS
, CRP_HOUR_AVAILABLE CRP_HOUR_AVAILABLE
, CRP_NET_HOUR_AVAILABLE CRP_NET_HOUR_AVAILABLE
, CRP_CUM_HOUR_AVAILABLE CRP_CUM_HOUR_AVAILABLE
, CRP_ROUTING_CAPACITY_UTIL CRP_ROUTING_CAPACITY_UTIL
, CRP_CUM_ROUTING_CAPACITY_UTIL CRP_CUM_ROUTING_CAPACITY_UTIL
, CRP_HOURS_REQUIRED_PER_DAY CRP_HOURS_REQUIRED_PER_DAY
, CRP_HOURS_AVAIL_PER_DAY CRP_HOURS_AVAIL_PER_DAY
, CRP_RESOURCE_COST CRP_RESOURCE_COST
, CRP_REQUIRED_RATE CRP_REQUIRED_RATE
, CRP_AVAILABLE_RATE CRP_AVAILABLE_RATE
, CRP_NET_AVAILABLE_RATE CRP_NET_AVAILABLE_RATE
, CRP_CUM_AVAILABLE_RATE CRP_CUM_AVAILABLE_RATE
, CRP_RATE_CAPACITY_UTIL CRP_RATE_CAPACITY_UTIL
, CRP_CUM_RATE_CAPACITY_UTIL CRP_CUM_RATE_CAPACITY_UTIL
, CRP_DAILY_REQUIRED_RATE CRP_DAILY_REQUIRED_RATE
, CRP_DAILY_AVAILABLE_RATE CRP_DAILY_AVAILABLE_RATE
, CRP_LINE_COST CRP_LINE_COST
, SUMMARY_PAYBACK_SUPPLY SUMMARY_PAYBACK_SUPPLY
, SUMMARY_PAYBACK_DEMAND SUMMARY_PAYBACK_DEMAND
, CATEGORY_SET_ID CATEGORY_SET_ID
FROM "MRP"."MRP_WORKBENCH_DISPLAY_OPTIONS"