VIEW: MSC.MSC_WORKBENCH_DISPLAY_OPTIONS#

Source

View Text - Preformatted

select USER_ID USER_ID, DEFAULT_FLAG DEFAULT_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, 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_CURRENT_RECEIPTS SUMMARY_CURRENT_RECEIPTS, SUMMARY_POH SUMMARY_POH, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR, 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_FOLDER_ID ORDERS_FOLDER_ID, SUMMARY_BEGINNING_ON_HAND SUMMARY_BEGINNING_ON_HAND, ORDERS_CUTOFF_DATE ORDERS_CUTOFF_DATE, SUMMARY_WIP SUMMARY_WIP, SUMMARY_PO SUMMARY_PO, SUMMARY_REQ SUMMARY_REQ, SUMMARY_TRANSIT SUMMARY_TRANSIT, SUMMARY_RECEIVING SUMMARY_RECEIVING, 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_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_SUM_OF_CAP_CHANGES CRP_SUM_OF_CAP_CHANGES, CRP_CUM_SUM_OF_CHANGES CRP_CUM_SUM_OF_CHANGES, 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_FLOW_SCHEDULES SUMMARY_FLOW_SCHEDULES, CRP_FLOW_SCHEDULES CRP_FLOW_SCHEDULES, ORDERS_FIRM_JOBS ORDERS_FIRM_JOBS, SUMMARY_PAYBACK_SUPPLY SUMMARY_PAYBACK_SUPPLY, SUMMARY_PAYBACK_DEMAND SUMMARY_PAYBACK_DEMAND, SUMMARY_DISPLAY_DAYS SUMMARY_DISPLAY_DAYS, SUMMARY_DISPLAY_WEEKS SUMMARY_DISPLAY_WEEKS, SUMMARY_DISPLAY_PERIODS SUMMARY_DISPLAY_PERIODS, CATEGORY_SET_ID CATEGORY_SET_ID, RECOMMENDATION_DAYS RECOMMENDATION_DAYS, SUPPLIER_PURCHASE_ORDERS SUPPLIER_PURCHASE_ORDERS, SUPPLIER_PURCHASE_REQS SUPPLIER_PURCHASE_REQS, SUPPLIER_PLANNED_ORDERS SUPPLIER_PLANNED_ORDERS, SUPPLIER_REQUIRED_CAP SUPPLIER_REQUIRED_CAP, SUPPLIER_CAP_AVAIL SUPPLIER_CAP_AVAIL, SUPPLIER_NET_CAP_AVAIL SUPPLIER_NET_CAP_AVAIL, SUPPLIER_CUM_CAP_AVAIL SUPPLIER_CUM_CAP_AVAIL, SUPPLIER_CAPACITY_UTIL SUPPLIER_CAPACITY_UTIL, SUPPLIER_CUM_CAPACITY_UTIL SUPPLIER_CUM_CAPACITY_UTIL, DEFAULT_LEFT_TAB DEFAULT_LEFT_TAB, DEFAULT_RIGHT_TAB DEFAULT_RIGHT_TAB, TRANS_WEIGHT_CAPACITY_AVAIL TRANS_WEIGHT_CAPACITY_AVAIL, TRANS_VOLUME_CAPACITY_AVAIL TRANS_VOLUME_CAPACITY_AVAIL, TRANS_WEIGHT_CAPACITY_REQ TRANS_WEIGHT_CAPACITY_REQ, TRANS_VOLUME_CAPACITY_REQ TRANS_VOLUME_CAPACITY_REQ, TRANS_WEIGHT_LOAD_RATIO TRANS_WEIGHT_LOAD_RATIO, TRANS_VOLUME_LOAD_RATIO TRANS_VOLUME_LOAD_RATIO, RETAIN_FOLDER_CRITERIA RETAIN_FOLDER_CRITERIA, SHOW_GRAPH SHOW_GRAPH, RUNNING_TOTAL_DEMAND RUNNING_TOTAL_DEMAND, RUNNING_TOTAL_SUPPLY RUNNING_TOTAL_SUPPLY, SUMMARY_SELLER_FORECAST SUMMARY_SELLER_FORECAST, NAMED_SET NAMED_SET, DEFAULT_SET DEFAULT_SET, PROD_SUM_LEVEL PROD_SUM_LEVEL, ORG_SUM_LEVEL_TP ORG_SUM_LEVEL_TP, ORG_SUM_LEVEL ORG_SUM_LEVEL, SUMMARY_SUPPCAP SUMMARY_SUPPCAP, SUMMARY_ACTUAL_PRODN SUMMARY_ACTUAL_PRODN, SUMMARY_COMMITTED_DMD SUMMARY_COMMITTED_DMD, SORT_BY_FLAG SORT_BY_FLAG, SUMMARY_ACT_PROD_FOR_FCST SUMMARY_ACT_PROD_FOR_FCST, SUMMARY_ACT_PROD_FOR_DMD SUMMARY_ACT_PROD_FOR_DMD, SUMMARY_PLANNED_PRODUCTION SUMMARY_PLANNED_PRODUCTION, SUMMARY_PL_PRODN_FOR_FCST SUMMARY_PL_PRODN_FOR_FCST, SUMMARY_PL_PRODN_FOR_DMD SUMMARY_PL_PRODN_FOR_DMD, SUMMARY_HIST_SALES SUMMARY_HIST_SALES, RUNNING_TOTAL_FORECAST RUNNING_TOTAL_FORECAST, RUNNING_TOTAL_HIST_SALES RUNNING_TOTAL_HIST_SALES, BLOCK_ZERO_RES_REQUIREMENTS BLOCK_ZERO_RES_REQUIREMENTS, SUMMARY_SELL_THRO_FCST SUMMARY_SELL_THRO_FCST, RUNNING_TOTAL_SELL_THRO_FCST RUNNING_TOTAL_SELL_THRO_FCST, PREFERENCE_SET_TYPE PREFERENCE_SET_TYPE, SUMMARY_ALLOCATED_SUPPLY SUMMARY_ALLOCATED_SUPPLY, SUMMARY_PROJECTED_SS SUMMARY_PROJECTED_SS, SUMMARY_UNALLOCATED_ONHAND SUMMARY_UNALLOCATED_ONHAND, SUMMARY_ALLOCATED_ONHAND SUMMARY_ALLOCATED_ONHAND, SUMMARY_UNALCT_PRJT_AVL_BAL SUMMARY_UNALCT_PRJT_AVL_BAL, SUMMARY_ALCAT_PRJT_AVL_BAL SUMMARY_ALCAT_PRJT_AVL_BAL, SUMMARY_ASN SUMMARY_ASN, SUMMARY_REPLENISHMENT SUMMARY_REPLENISHMENT, ORDER_SELLER_FORECAST ORDER_SELLER_FORECAST, ORDER_FORECAST ORDER_FORECAST, ORDER_ALLOCATED_SUPPLY ORDER_ALLOCATED_SUPPLY, ORDER_HIST_SALES ORDER_HIST_SALES, ORDER_SELL_THRO_FCST ORDER_SELL_THRO_FCST, ORDER_SUPPCAP ORDER_SUPPCAP, ORDER_SS ORDER_SS, ORDER_PROJECTED_SS ORDER_PROJECTED_SS, ORDER_ALLOCATED_ONHAND ORDER_ALLOCATED_ONHAND, ORDER_UNALLOCATED_ONHAND ORDER_UNALLOCATED_ONHAND, ORDER_UNALCT_PRJT_AVL_BAL ORDER_UNALCT_PRJT_AVL_BAL, ORDER_ALCAT_PRJT_AVL_BAL ORDER_ALCAT_PRJT_AVL_BAL, ORDER_PO ORDER_PO, ORDER_SALES_ORDERS ORDER_SALES_ORDERS, ORDER_ASN ORDER_ASN, ORDER_RECEIVING ORDER_RECEIVING, ORDER_TRANSIT ORDER_TRANSIT, ORDER_WIP ORDER_WIP, ORDER_REQ ORDER_REQ, ORDER_REPLENISHMENT ORDER_REPLENISHMENT, ORDER_GROSS_REQUIREMENTS ORDER_GROSS_REQUIREMENTS, ORDER_TOTAL_SUPPLY ORDER_TOTAL_SUPPLY, ORDER_RUNNING_TOTAL_SUPPLY ORDER_RUNNING_TOTAL_SUPPLY, ORDER_RUNNING_TOTAL_DEMAND ORDER_RUNNING_TOTAL_DEMAND, ORDER_RUNNING_TOTAL_FORECAST ORDER_RUNNING_TOTAL_FORECAST, ORDER_RUNNING_TOTAL_HIST_SALES ORDER_RUNNING_TOTAL_HIST_SALES, SCE_USER_ID SCE_USER_ID, GC_RESOURCE_LIMIT GC_RESOURCE_LIMIT, GC_SUPPLY_LIMIT GC_SUPPLY_LIMIT, GRAD_HP_LOAD GRAD_HP_LOAD, ATP_PRCT_ALC_SUPPLY ATP_PRCT_ALC_SUPPLY, ATP_PRCT_ALC_DMD ATP_PRCT_ALC_DMD, ATP_PRCT_ALC_NET ATP_PRCT_ALC_NET, ATP_PRCT_ALC_BACKW ATP_PRCT_ALC_BACKW, ATP_PRCT_ALC_DMDADJ ATP_PRCT_ALC_DMDADJ, ATP_PRCT_ALC_ADJAVAIL ATP_PRCT_ALC_ADJAVAIL, ATP_PRCT_ALC_CUM ATP_PRCT_ALC_CUM, ATP_PRCT_ALC_ADJCUM ATP_PRCT_ALC_ADJCUM, ATP_PRCT_ALC_PERCT ATP_PRCT_ALC_PERCT, ATP_PERCT_ALC_ACTPERCT ATP_PERCT_ALC_ACTPERCT, ATP_PRCT_UNALC_SUPPLY ATP_PRCT_UNALC_SUPPLY, ATP_PRCT_UNALC_DMD ATP_PRCT_UNALC_DMD, ATP_PRCT_UNALC_NET ATP_PRCT_UNALC_NET, ATP_PRCT_UNALC_CUM ATP_PRCT_UNALC_CUM, ATP_DMDP_ALC_SUPPLY ATP_DMDP_ALC_SUPPLY, ATP_DMDP_ALC_SUPADJ ATP_DMDP_ALC_SUPADJ, ATP_DMDP_ALC_TOTSUP ATP_DMDP_ALC_TOTSUP, ATP_DMDP_ALC_DMD ATP_DMDP_ALC_DMD, ATP_DMDP_ALC_NET ATP_DMDP_ALC_NET, ATP_DMDP_ALC_BKFWD ATP_DMDP_ALC_BKFWD, ATP_DMDP_ALC_CUM ATP_DMDP_ALC_CUM, ATP_HP_LAYOUT ATP_HP_LAYOUT, ATP_DISP_DAYS ATP_DISP_DAYS, ATP_DISP_WEEKS ATP_DISP_WEEKS, ATP_DISP_FACTOR ATP_DISP_FACTOR, ATP_DISP_DECIMAL ATP_DISP_DECIMAL, ATP_DISP_GRAPH ATP_DISP_GRAPH, MSC_HP_LAYOUT MSC_HP_LAYOUT, HP_CAP_DISP_FACTOR HP_CAP_DISP_FACTOR, HP_CAP_DISP_DECIMAL HP_CAP_DISP_DECIMAL, HP_CAP_DISP_GRAPH HP_CAP_DISP_GRAPH, HP_CAP_DAYS HP_CAP_DAYS, HP_CAP_WEEKS HP_CAP_WEEKS, HP_SUP_DISP_FACTOR HP_SUP_DISP_FACTOR, HP_SUP_DISP_DECIMAL HP_SUP_DISP_DECIMAL, HP_SUP_DISP_GRAPH HP_SUP_DISP_GRAPH, HP_SUP_DAYS HP_SUP_DAYS, HP_SUP_WEEKS HP_SUP_WEEKS, HP_TP_DISP_FACTOR HP_TP_DISP_FACTOR, HP_TP_DISP_DECIMAL HP_TP_DISP_DECIMAL, HP_TP_DISP_GRAPH HP_TP_DISP_GRAPH, HP_TP_DAYS HP_TP_DAYS, HP_TP_WEEKS HP_TP_WEEKS, ACTIONS_EXPAND_ALL ACTIONS_EXPAND_ALL, ATP_DMD_SHOW_TOTAL ATP_DMD_SHOW_TOTAL, ATP_PRCT_SHOW_TOTAL ATP_PRCT_SHOW_TOTAL, AUTO_PLAN_ID AUTO_PLAN_ID, AUTO_QUERY_ID AUTO_QUERY_ID, PLAN_TYPE PLAN_TYPE, PREFERENCE_NAME PREFERENCE_NAME, PREFERENCE_ID PREFERENCE_ID, PREFERENCE_DESCRIPTION PREFERENCE_DESCRIPTION, SUMMARY_ORIGINAL SUMMARY_ORIGINAL, SUMMARY_CUMULATIVE_ORIGINAL SUMMARY_CUMULATIVE_ORIGINAL, SUMMARY_CONSUMED SUMMARY_CONSUMED, SUMMARY_CUMULATIVE_CONSUMED SUMMARY_CUMULATIVE_CONSUMED, SUMMARY_CURRENT SUMMARY_CURRENT, SUMMARY_CUMULATIVE_CURRENT SUMMARY_CUMULATIVE_CURRENT, SUMMARY_EXPIRED_FORECAST SUMMARY_EXPIRED_FORECAST, SUMMARY_GLOBAL_FORECASTING SUMMARY_GLOBAL_FORECASTING, SUMMARY_RETURNS SUMMARY_RETURNS, SUMMARY_PF_MEMBER_DATA SUMMARY_PF_MEMBER_DATA, SUMMARY_TOTAL_NON_FORECAST SUMMARY_TOTAL_NON_FORECAST, ATP_DMDP_BUCKETED_DATA ATP_DMDP_BUCKETED_DATA, ATP_PRCT_BUCKETED_DATA ATP_PRCT_BUCKETED_DATA, SUMMARY_SS_DAYS_SUPPLY SUMMARY_SS_DAYS_SUPPLY, CRP_ATP_REQUIREMENTS_RTG CRP_ATP_REQUIREMENTS_RTG, CRP_ATP_REQUIREMENTS_RATE CRP_ATP_REQUIREMENTS_RATE, NET_FORECAST NET_FORECAST, TOTAL_SUPPLY TOTAL_SUPPLY, INCLUDE_SO INCLUDE_SO, ORDER_PAB ORDER_PAB, SUMMARY_PURCHASE_PLAN SUMMARY_PURCHASE_PLAN, SUMMARY_RELEASE_PLAN SUMMARY_RELEASE_PLAN, SUMMARY_PLAN SUMMARY_PLAN, ORDER_PURCHASE_PLAN ORDER_PURCHASE_PLAN, ORDER_RELEASE_PLAN ORDER_RELEASE_PLAN, ORDER_PLAN ORDER_PLAN, SHIFT_DAYS SHIFT_DAYS, ORDER_PO_ACK ORDER_PO_ACK, SUMMARY_PO_ACK SUMMARY_PO_ACK, PUBLIC_FLAG PUBLIC_FLAG, ASCP_PLAN_ID ASCP_PLAN_ID, IO_PLAN_ID IO_PLAN_ID, DRP_PLAN_ID DRP_PLAN_ID, ASCP_QUERY_ID ASCP_QUERY_ID, IO_QUERY_ID IO_QUERY_ID, DRP_QUERY_ID DRP_QUERY_ID, SUMMARY_DISP_PF_DETAILS SUMMARY_DISP_PF_DETAILS, SUMMARY_PROD_FORECAST SUMMARY_PROD_FORECAST, ATP_DMDP_PF_DMD_SPREAD ATP_DMDP_PF_DMD_SPREAD, ATP_PRCT_PF_DMD_SPREAD ATP_PRCT_PF_DMD_SPREAD, ORDERS_RELEASE_VMI_ITEMS ORDERS_RELEASE_VMI_ITEMS, SUMMARY_KIT_DEMAND SUMMARY_KIT_DEMAND, SUMMARY_SHIPMENTS SUMMARY_SHIPMENTS, SUMMARY_REQ_SHIPMENTS SUMMARY_REQ_SHIPMENTS, SUMMARY_UNCONST_KIT_DMD SUMMARY_UNCONST_KIT_DMD, SUMMARY_UNCONST_OTH_DMD SUMMARY_UNCONST_OTH_DMD, SUMMARY_UNCONST_TOT_DMD SUMMARY_UNCONST_TOT_DMD, SUMMARY_ARRIVALS SUMMARY_ARRIVALS, SUMMARY_TOTAL_INTRANSIT SUMMARY_TOTAL_INTRANSIT, SUMMARY_TOTAL_REQUISITIONS SUMMARY_TOTAL_REQUISITIONS, SUMMARY_TOTAL_PLANNED_ORDERS SUMMARY_TOTAL_PLANNED_ORDERS, SUMMARY_UNCONST_PAB SUMMARY_UNCONST_PAB, SUMMARY_MAXIMUM_QUANTITY SUMMARY_MAXIMUM_QUANTITY, SUMMARY_TARGET_QUANTITY SUMMARY_TARGET_QUANTITY, SUMMARY_INBOUND_INTRANSIT SUMMARY_INBOUND_INTRANSIT, SUMMARY_OUTBOUND_INTRANSIT SUMMARY_OUTBOUND_INTRANSIT, SUMMARY_INTERNAL_SUPPLY SUMMARY_INTERNAL_SUPPLY, SUMMARY_EXTERNAL_SUPPLY SUMMARY_EXTERNAL_SUPPLY, SUMMARY_OTHER_DEMAND SUMMARY_OTHER_DEMAND, SUMMARY_TOTAL_DEMAND SUMMARY_TOTAL_DEMAND, SUMMARY_EXTERNAL_DEMAND SUMMARY_EXTERNAL_DEMAND, SUMMARY_DEFAULT_DISPLAY SUMMARY_DEFAULT_DISPLAY, DEFAULT_TAB DEFAULT_TAB, CATEGORY_NAME CATEGORY_NAME, SUMMARY_REQUESTED_ARRIVALS SUMMARY_REQUESTED_ARRIVALS, SUMMARY_MIN_INV_LVL SUMMARY_MIN_INV_LVL, SUMMARY_MAX_INV_LVL SUMMARY_MAX_INV_LVL, PLANNER_CODE PLANNER_CODE, EXCEPTIONS_QUERY_ID EXCEPTIONS_QUERY_ID, SHOW_ITEM_DESC_IN_PEGGING SHOW_ITEM_DESC_IN_PEGGING, SUMMARY_RETURNS_FORECAST SUMMARY_RETURNS_FORECAST, RETURNS_FORECAST RETURNS_FORECAST, SUMMARY_DEF_OUTBOUND_SHIPMENT SUMMARY_DEF_OUTBOUND_SHIPMENT, DEF_OUTBOUND_SHIPMENT DEF_OUTBOUND_SHIPMENT from "MSC"."MSC_WORKBENCH_DISPLAY_OPTIONS"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, DEFAULT_FLAG DEFAULT_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, 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_CURRENT_RECEIPTS SUMMARY_CURRENT_RECEIPTS
, SUMMARY_POH SUMMARY_POH
, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR
, 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_FOLDER_ID ORDERS_FOLDER_ID
, SUMMARY_BEGINNING_ON_HAND SUMMARY_BEGINNING_ON_HAND
, ORDERS_CUTOFF_DATE ORDERS_CUTOFF_DATE
, SUMMARY_WIP SUMMARY_WIP
, SUMMARY_PO SUMMARY_PO
, SUMMARY_REQ SUMMARY_REQ
, SUMMARY_TRANSIT SUMMARY_TRANSIT
, SUMMARY_RECEIVING SUMMARY_RECEIVING
, 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_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_SUM_OF_CAP_CHANGES CRP_SUM_OF_CAP_CHANGES
, CRP_CUM_SUM_OF_CHANGES CRP_CUM_SUM_OF_CHANGES
, 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_FLOW_SCHEDULES SUMMARY_FLOW_SCHEDULES
, CRP_FLOW_SCHEDULES CRP_FLOW_SCHEDULES
, ORDERS_FIRM_JOBS ORDERS_FIRM_JOBS
, SUMMARY_PAYBACK_SUPPLY SUMMARY_PAYBACK_SUPPLY
, SUMMARY_PAYBACK_DEMAND SUMMARY_PAYBACK_DEMAND
, SUMMARY_DISPLAY_DAYS SUMMARY_DISPLAY_DAYS
, SUMMARY_DISPLAY_WEEKS SUMMARY_DISPLAY_WEEKS
, SUMMARY_DISPLAY_PERIODS SUMMARY_DISPLAY_PERIODS
, CATEGORY_SET_ID CATEGORY_SET_ID
, RECOMMENDATION_DAYS RECOMMENDATION_DAYS
, SUPPLIER_PURCHASE_ORDERS SUPPLIER_PURCHASE_ORDERS
, SUPPLIER_PURCHASE_REQS SUPPLIER_PURCHASE_REQS
, SUPPLIER_PLANNED_ORDERS SUPPLIER_PLANNED_ORDERS
, SUPPLIER_REQUIRED_CAP SUPPLIER_REQUIRED_CAP
, SUPPLIER_CAP_AVAIL SUPPLIER_CAP_AVAIL
, SUPPLIER_NET_CAP_AVAIL SUPPLIER_NET_CAP_AVAIL
, SUPPLIER_CUM_CAP_AVAIL SUPPLIER_CUM_CAP_AVAIL
, SUPPLIER_CAPACITY_UTIL SUPPLIER_CAPACITY_UTIL
, SUPPLIER_CUM_CAPACITY_UTIL SUPPLIER_CUM_CAPACITY_UTIL
, DEFAULT_LEFT_TAB DEFAULT_LEFT_TAB
, DEFAULT_RIGHT_TAB DEFAULT_RIGHT_TAB
, TRANS_WEIGHT_CAPACITY_AVAIL TRANS_WEIGHT_CAPACITY_AVAIL
, TRANS_VOLUME_CAPACITY_AVAIL TRANS_VOLUME_CAPACITY_AVAIL
, TRANS_WEIGHT_CAPACITY_REQ TRANS_WEIGHT_CAPACITY_REQ
, TRANS_VOLUME_CAPACITY_REQ TRANS_VOLUME_CAPACITY_REQ
, TRANS_WEIGHT_LOAD_RATIO TRANS_WEIGHT_LOAD_RATIO
, TRANS_VOLUME_LOAD_RATIO TRANS_VOLUME_LOAD_RATIO
, RETAIN_FOLDER_CRITERIA RETAIN_FOLDER_CRITERIA
, SHOW_GRAPH SHOW_GRAPH
, RUNNING_TOTAL_DEMAND RUNNING_TOTAL_DEMAND
, RUNNING_TOTAL_SUPPLY RUNNING_TOTAL_SUPPLY
, SUMMARY_SELLER_FORECAST SUMMARY_SELLER_FORECAST
, NAMED_SET NAMED_SET
, DEFAULT_SET DEFAULT_SET
, PROD_SUM_LEVEL PROD_SUM_LEVEL
, ORG_SUM_LEVEL_TP ORG_SUM_LEVEL_TP
, ORG_SUM_LEVEL ORG_SUM_LEVEL
, SUMMARY_SUPPCAP SUMMARY_SUPPCAP
, SUMMARY_ACTUAL_PRODN SUMMARY_ACTUAL_PRODN
, SUMMARY_COMMITTED_DMD SUMMARY_COMMITTED_DMD
, SORT_BY_FLAG SORT_BY_FLAG
, SUMMARY_ACT_PROD_FOR_FCST SUMMARY_ACT_PROD_FOR_FCST
, SUMMARY_ACT_PROD_FOR_DMD SUMMARY_ACT_PROD_FOR_DMD
, SUMMARY_PLANNED_PRODUCTION SUMMARY_PLANNED_PRODUCTION
, SUMMARY_PL_PRODN_FOR_FCST SUMMARY_PL_PRODN_FOR_FCST
, SUMMARY_PL_PRODN_FOR_DMD SUMMARY_PL_PRODN_FOR_DMD
, SUMMARY_HIST_SALES SUMMARY_HIST_SALES
, RUNNING_TOTAL_FORECAST RUNNING_TOTAL_FORECAST
, RUNNING_TOTAL_HIST_SALES RUNNING_TOTAL_HIST_SALES
, BLOCK_ZERO_RES_REQUIREMENTS BLOCK_ZERO_RES_REQUIREMENTS
, SUMMARY_SELL_THRO_FCST SUMMARY_SELL_THRO_FCST
, RUNNING_TOTAL_SELL_THRO_FCST RUNNING_TOTAL_SELL_THRO_FCST
, PREFERENCE_SET_TYPE PREFERENCE_SET_TYPE
, SUMMARY_ALLOCATED_SUPPLY SUMMARY_ALLOCATED_SUPPLY
, SUMMARY_PROJECTED_SS SUMMARY_PROJECTED_SS
, SUMMARY_UNALLOCATED_ONHAND SUMMARY_UNALLOCATED_ONHAND
, SUMMARY_ALLOCATED_ONHAND SUMMARY_ALLOCATED_ONHAND
, SUMMARY_UNALCT_PRJT_AVL_BAL SUMMARY_UNALCT_PRJT_AVL_BAL
, SUMMARY_ALCAT_PRJT_AVL_BAL SUMMARY_ALCAT_PRJT_AVL_BAL
, SUMMARY_ASN SUMMARY_ASN
, SUMMARY_REPLENISHMENT SUMMARY_REPLENISHMENT
, ORDER_SELLER_FORECAST ORDER_SELLER_FORECAST
, ORDER_FORECAST ORDER_FORECAST
, ORDER_ALLOCATED_SUPPLY ORDER_ALLOCATED_SUPPLY
, ORDER_HIST_SALES ORDER_HIST_SALES
, ORDER_SELL_THRO_FCST ORDER_SELL_THRO_FCST
, ORDER_SUPPCAP ORDER_SUPPCAP
, ORDER_SS ORDER_SS
, ORDER_PROJECTED_SS ORDER_PROJECTED_SS
, ORDER_ALLOCATED_ONHAND ORDER_ALLOCATED_ONHAND
, ORDER_UNALLOCATED_ONHAND ORDER_UNALLOCATED_ONHAND
, ORDER_UNALCT_PRJT_AVL_BAL ORDER_UNALCT_PRJT_AVL_BAL
, ORDER_ALCAT_PRJT_AVL_BAL ORDER_ALCAT_PRJT_AVL_BAL
, ORDER_PO ORDER_PO
, ORDER_SALES_ORDERS ORDER_SALES_ORDERS
, ORDER_ASN ORDER_ASN
, ORDER_RECEIVING ORDER_RECEIVING
, ORDER_TRANSIT ORDER_TRANSIT
, ORDER_WIP ORDER_WIP
, ORDER_REQ ORDER_REQ
, ORDER_REPLENISHMENT ORDER_REPLENISHMENT
, ORDER_GROSS_REQUIREMENTS ORDER_GROSS_REQUIREMENTS
, ORDER_TOTAL_SUPPLY ORDER_TOTAL_SUPPLY
, ORDER_RUNNING_TOTAL_SUPPLY ORDER_RUNNING_TOTAL_SUPPLY
, ORDER_RUNNING_TOTAL_DEMAND ORDER_RUNNING_TOTAL_DEMAND
, ORDER_RUNNING_TOTAL_FORECAST ORDER_RUNNING_TOTAL_FORECAST
, ORDER_RUNNING_TOTAL_HIST_SALES ORDER_RUNNING_TOTAL_HIST_SALES
, SCE_USER_ID SCE_USER_ID
, GC_RESOURCE_LIMIT GC_RESOURCE_LIMIT
, GC_SUPPLY_LIMIT GC_SUPPLY_LIMIT
, GRAD_HP_LOAD GRAD_HP_LOAD
, ATP_PRCT_ALC_SUPPLY ATP_PRCT_ALC_SUPPLY
, ATP_PRCT_ALC_DMD ATP_PRCT_ALC_DMD
, ATP_PRCT_ALC_NET ATP_PRCT_ALC_NET
, ATP_PRCT_ALC_BACKW ATP_PRCT_ALC_BACKW
, ATP_PRCT_ALC_DMDADJ ATP_PRCT_ALC_DMDADJ
, ATP_PRCT_ALC_ADJAVAIL ATP_PRCT_ALC_ADJAVAIL
, ATP_PRCT_ALC_CUM ATP_PRCT_ALC_CUM
, ATP_PRCT_ALC_ADJCUM ATP_PRCT_ALC_ADJCUM
, ATP_PRCT_ALC_PERCT ATP_PRCT_ALC_PERCT
, ATP_PERCT_ALC_ACTPERCT ATP_PERCT_ALC_ACTPERCT
, ATP_PRCT_UNALC_SUPPLY ATP_PRCT_UNALC_SUPPLY
, ATP_PRCT_UNALC_DMD ATP_PRCT_UNALC_DMD
, ATP_PRCT_UNALC_NET ATP_PRCT_UNALC_NET
, ATP_PRCT_UNALC_CUM ATP_PRCT_UNALC_CUM
, ATP_DMDP_ALC_SUPPLY ATP_DMDP_ALC_SUPPLY
, ATP_DMDP_ALC_SUPADJ ATP_DMDP_ALC_SUPADJ
, ATP_DMDP_ALC_TOTSUP ATP_DMDP_ALC_TOTSUP
, ATP_DMDP_ALC_DMD ATP_DMDP_ALC_DMD
, ATP_DMDP_ALC_NET ATP_DMDP_ALC_NET
, ATP_DMDP_ALC_BKFWD ATP_DMDP_ALC_BKFWD
, ATP_DMDP_ALC_CUM ATP_DMDP_ALC_CUM
, ATP_HP_LAYOUT ATP_HP_LAYOUT
, ATP_DISP_DAYS ATP_DISP_DAYS
, ATP_DISP_WEEKS ATP_DISP_WEEKS
, ATP_DISP_FACTOR ATP_DISP_FACTOR
, ATP_DISP_DECIMAL ATP_DISP_DECIMAL
, ATP_DISP_GRAPH ATP_DISP_GRAPH
, MSC_HP_LAYOUT MSC_HP_LAYOUT
, HP_CAP_DISP_FACTOR HP_CAP_DISP_FACTOR
, HP_CAP_DISP_DECIMAL HP_CAP_DISP_DECIMAL
, HP_CAP_DISP_GRAPH HP_CAP_DISP_GRAPH
, HP_CAP_DAYS HP_CAP_DAYS
, HP_CAP_WEEKS HP_CAP_WEEKS
, HP_SUP_DISP_FACTOR HP_SUP_DISP_FACTOR
, HP_SUP_DISP_DECIMAL HP_SUP_DISP_DECIMAL
, HP_SUP_DISP_GRAPH HP_SUP_DISP_GRAPH
, HP_SUP_DAYS HP_SUP_DAYS
, HP_SUP_WEEKS HP_SUP_WEEKS
, HP_TP_DISP_FACTOR HP_TP_DISP_FACTOR
, HP_TP_DISP_DECIMAL HP_TP_DISP_DECIMAL
, HP_TP_DISP_GRAPH HP_TP_DISP_GRAPH
, HP_TP_DAYS HP_TP_DAYS
, HP_TP_WEEKS HP_TP_WEEKS
, ACTIONS_EXPAND_ALL ACTIONS_EXPAND_ALL
, ATP_DMD_SHOW_TOTAL ATP_DMD_SHOW_TOTAL
, ATP_PRCT_SHOW_TOTAL ATP_PRCT_SHOW_TOTAL
, AUTO_PLAN_ID AUTO_PLAN_ID
, AUTO_QUERY_ID AUTO_QUERY_ID
, PLAN_TYPE PLAN_TYPE
, PREFERENCE_NAME PREFERENCE_NAME
, PREFERENCE_ID PREFERENCE_ID
, PREFERENCE_DESCRIPTION PREFERENCE_DESCRIPTION
, SUMMARY_ORIGINAL SUMMARY_ORIGINAL
, SUMMARY_CUMULATIVE_ORIGINAL SUMMARY_CUMULATIVE_ORIGINAL
, SUMMARY_CONSUMED SUMMARY_CONSUMED
, SUMMARY_CUMULATIVE_CONSUMED SUMMARY_CUMULATIVE_CONSUMED
, SUMMARY_CURRENT SUMMARY_CURRENT
, SUMMARY_CUMULATIVE_CURRENT SUMMARY_CUMULATIVE_CURRENT
, SUMMARY_EXPIRED_FORECAST SUMMARY_EXPIRED_FORECAST
, SUMMARY_GLOBAL_FORECASTING SUMMARY_GLOBAL_FORECASTING
, SUMMARY_RETURNS SUMMARY_RETURNS
, SUMMARY_PF_MEMBER_DATA SUMMARY_PF_MEMBER_DATA
, SUMMARY_TOTAL_NON_FORECAST SUMMARY_TOTAL_NON_FORECAST
, ATP_DMDP_BUCKETED_DATA ATP_DMDP_BUCKETED_DATA
, ATP_PRCT_BUCKETED_DATA ATP_PRCT_BUCKETED_DATA
, SUMMARY_SS_DAYS_SUPPLY SUMMARY_SS_DAYS_SUPPLY
, CRP_ATP_REQUIREMENTS_RTG CRP_ATP_REQUIREMENTS_RTG
, CRP_ATP_REQUIREMENTS_RATE CRP_ATP_REQUIREMENTS_RATE
, NET_FORECAST NET_FORECAST
, TOTAL_SUPPLY TOTAL_SUPPLY
, INCLUDE_SO INCLUDE_SO
, ORDER_PAB ORDER_PAB
, SUMMARY_PURCHASE_PLAN SUMMARY_PURCHASE_PLAN
, SUMMARY_RELEASE_PLAN SUMMARY_RELEASE_PLAN
, SUMMARY_PLAN SUMMARY_PLAN
, ORDER_PURCHASE_PLAN ORDER_PURCHASE_PLAN
, ORDER_RELEASE_PLAN ORDER_RELEASE_PLAN
, ORDER_PLAN ORDER_PLAN
, SHIFT_DAYS SHIFT_DAYS
, ORDER_PO_ACK ORDER_PO_ACK
, SUMMARY_PO_ACK SUMMARY_PO_ACK
, PUBLIC_FLAG PUBLIC_FLAG
, ASCP_PLAN_ID ASCP_PLAN_ID
, IO_PLAN_ID IO_PLAN_ID
, DRP_PLAN_ID DRP_PLAN_ID
, ASCP_QUERY_ID ASCP_QUERY_ID
, IO_QUERY_ID IO_QUERY_ID
, DRP_QUERY_ID DRP_QUERY_ID
, SUMMARY_DISP_PF_DETAILS SUMMARY_DISP_PF_DETAILS
, SUMMARY_PROD_FORECAST SUMMARY_PROD_FORECAST
, ATP_DMDP_PF_DMD_SPREAD ATP_DMDP_PF_DMD_SPREAD
, ATP_PRCT_PF_DMD_SPREAD ATP_PRCT_PF_DMD_SPREAD
, ORDERS_RELEASE_VMI_ITEMS ORDERS_RELEASE_VMI_ITEMS
, SUMMARY_KIT_DEMAND SUMMARY_KIT_DEMAND
, SUMMARY_SHIPMENTS SUMMARY_SHIPMENTS
, SUMMARY_REQ_SHIPMENTS SUMMARY_REQ_SHIPMENTS
, SUMMARY_UNCONST_KIT_DMD SUMMARY_UNCONST_KIT_DMD
, SUMMARY_UNCONST_OTH_DMD SUMMARY_UNCONST_OTH_DMD
, SUMMARY_UNCONST_TOT_DMD SUMMARY_UNCONST_TOT_DMD
, SUMMARY_ARRIVALS SUMMARY_ARRIVALS
, SUMMARY_TOTAL_INTRANSIT SUMMARY_TOTAL_INTRANSIT
, SUMMARY_TOTAL_REQUISITIONS SUMMARY_TOTAL_REQUISITIONS
, SUMMARY_TOTAL_PLANNED_ORDERS SUMMARY_TOTAL_PLANNED_ORDERS
, SUMMARY_UNCONST_PAB SUMMARY_UNCONST_PAB
, SUMMARY_MAXIMUM_QUANTITY SUMMARY_MAXIMUM_QUANTITY
, SUMMARY_TARGET_QUANTITY SUMMARY_TARGET_QUANTITY
, SUMMARY_INBOUND_INTRANSIT SUMMARY_INBOUND_INTRANSIT
, SUMMARY_OUTBOUND_INTRANSIT SUMMARY_OUTBOUND_INTRANSIT
, SUMMARY_INTERNAL_SUPPLY SUMMARY_INTERNAL_SUPPLY
, SUMMARY_EXTERNAL_SUPPLY SUMMARY_EXTERNAL_SUPPLY
, SUMMARY_OTHER_DEMAND SUMMARY_OTHER_DEMAND
, SUMMARY_TOTAL_DEMAND SUMMARY_TOTAL_DEMAND
, SUMMARY_EXTERNAL_DEMAND SUMMARY_EXTERNAL_DEMAND
, SUMMARY_DEFAULT_DISPLAY SUMMARY_DEFAULT_DISPLAY
, DEFAULT_TAB DEFAULT_TAB
, CATEGORY_NAME CATEGORY_NAME
, SUMMARY_REQUESTED_ARRIVALS SUMMARY_REQUESTED_ARRIVALS
, SUMMARY_MIN_INV_LVL SUMMARY_MIN_INV_LVL
, SUMMARY_MAX_INV_LVL SUMMARY_MAX_INV_LVL
, PLANNER_CODE PLANNER_CODE
, EXCEPTIONS_QUERY_ID EXCEPTIONS_QUERY_ID
, SHOW_ITEM_DESC_IN_PEGGING SHOW_ITEM_DESC_IN_PEGGING
, SUMMARY_RETURNS_FORECAST SUMMARY_RETURNS_FORECAST
, RETURNS_FORECAST RETURNS_FORECAST
, SUMMARY_DEF_OUTBOUND_SHIPMENT SUMMARY_DEF_OUTBOUND_SHIPMENT
, DEF_OUTBOUND_SHIPMENT DEF_OUTBOUND_SHIPMENT
FROM "MSC"."MSC_WORKBENCH_DISPLAY_OPTIONS"