DBA Data[Home] [Help] [Dependency Information]


VIEW: MSC.MSC_WORKBENCH_DISPLAY_OPTIONS#

Object Details
Object Name: MSC_WORKBENCH_DISPLAY_OPTIONS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes
DEFAULT_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

SUMMARY_FIELD_WIDTH NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

SUMMARY_SALES_ORDERS VARCHAR2 (1)
SUMMARY_FORECAST VARCHAR2 (1)
SUMMARY_DEPENDENT_DEMAND VARCHAR2 (1)
SUMMARY_SCRAP VARCHAR2 (1)
SUMMARY_INDEPENDENT_DEMAND VARCHAR2 (1)
SUMMARY_GROSS_REQUIREMENTS VARCHAR2 (1)
SUMMARY_SCHEDULED_RECEIPTS VARCHAR2 (1)
SUMMARY_PLANNED_ORDERS VARCHAR2 (1)
SUMMARY_TOTAL_SUPPLY VARCHAR2 (1)
SUMMARY_PAB VARCHAR2 (1)
SUMMARY_SS VARCHAR2 (1)
SUMMARY_ATP VARCHAR2 (1)
SUMMARY_CURRENT_RECEIPTS VARCHAR2 (1)
SUMMARY_POH VARCHAR2 (1)
SUMMARY_DISPLAY_FACTOR NUMBER

ORDERS_DEFAULT_JOB_STATUS NUMBER

SUMMARY_DECIMAL_PLACES NUMBER

ORDERS_RELEASE_PHANTOMS VARCHAR2 (1)
ORDERS_RELEASE_CONFIGS VARCHAR2 (1)
ORDERS_FOLDER_ID NUMBER

SUMMARY_BEGINNING_ON_HAND VARCHAR2 (1)
ORDERS_CUTOFF_DATE DATE

SUMMARY_WIP VARCHAR2 (1)
SUMMARY_PO VARCHAR2 (1)
SUMMARY_REQ VARCHAR2 (1)
SUMMARY_TRANSIT VARCHAR2 (1)
SUMMARY_RECEIVING VARCHAR2 (1)
GROUP_BY_CODE NUMBER

JOB_CLASS_CODE VARCHAR2 (10)
SUMMARY_EXP_LOT VARCHAR2 (1)
IND_DEMAND_TYPE NUMBER

SOURCE_LIST VARCHAR2 (10)
CRP_PLANNED_ORDERS VARCHAR2 (1)
CRP_NON_STD_JOB_ORDERS VARCHAR2 (1)
CRP_DISCRETE_JOBS VARCHAR2 (1)
CRP_REPETITIVE_SCHEDULES VARCHAR2 (1)
CRP_REQUIRE_HOURS VARCHAR2 (1)
CRP_HOUR_AVAILABLE VARCHAR2 (1)
CRP_NET_HOUR_AVAILABLE VARCHAR2 (1)
CRP_CUM_HOUR_AVAILABLE VARCHAR2 (1)
CRP_ROUTING_CAPACITY_UTIL VARCHAR2 (1)
CRP_CUM_ROUTING_CAPACITY_UTIL VARCHAR2 (1)
CRP_HOURS_REQUIRED_PER_DAY VARCHAR2 (1)
CRP_HOURS_AVAIL_PER_DAY VARCHAR2 (1)
CRP_SUM_OF_CAP_CHANGES VARCHAR2 (1)
CRP_CUM_SUM_OF_CHANGES VARCHAR2 (1)
CRP_RESOURCE_COST VARCHAR2 (1)
CRP_REQUIRED_RATE VARCHAR2 (1)
CRP_AVAILABLE_RATE VARCHAR2 (1)
CRP_NET_AVAILABLE_RATE VARCHAR2 (1)
CRP_CUM_AVAILABLE_RATE VARCHAR2 (1)
CRP_RATE_CAPACITY_UTIL VARCHAR2 (1)
CRP_CUM_RATE_CAPACITY_UTIL VARCHAR2 (1)
CRP_DAILY_REQUIRED_RATE VARCHAR2 (1)
CRP_DAILY_AVAILABLE_RATE VARCHAR2 (1)
CRP_LINE_COST VARCHAR2 (1)
SUMMARY_FLOW_SCHEDULES VARCHAR2 (1)
CRP_FLOW_SCHEDULES VARCHAR2 (1)
ORDERS_FIRM_JOBS VARCHAR2 (1)
SUMMARY_PAYBACK_SUPPLY VARCHAR2 (1)
SUMMARY_PAYBACK_DEMAND VARCHAR2 (1)
SUMMARY_DISPLAY_DAYS NUMBER

SUMMARY_DISPLAY_WEEKS NUMBER

SUMMARY_DISPLAY_PERIODS NUMBER

CATEGORY_SET_ID NUMBER

RECOMMENDATION_DAYS NUMBER

SUPPLIER_PURCHASE_ORDERS VARCHAR2 (1)
SUPPLIER_PURCHASE_REQS VARCHAR2 (1)
SUPPLIER_PLANNED_ORDERS VARCHAR2 (1)
SUPPLIER_REQUIRED_CAP VARCHAR2 (1)
SUPPLIER_CAP_AVAIL VARCHAR2 (1)
SUPPLIER_NET_CAP_AVAIL VARCHAR2 (1)
SUPPLIER_CUM_CAP_AVAIL VARCHAR2 (1)
SUPPLIER_CAPACITY_UTIL VARCHAR2 (1)
SUPPLIER_CUM_CAPACITY_UTIL VARCHAR2 (1)
DEFAULT_LEFT_TAB VARCHAR2 (30)
DEFAULT_RIGHT_TAB VARCHAR2 (240)
TRANS_WEIGHT_CAPACITY_AVAIL VARCHAR2 (1)
TRANS_VOLUME_CAPACITY_AVAIL VARCHAR2 (1)
TRANS_WEIGHT_CAPACITY_REQ VARCHAR2 (1)
TRANS_VOLUME_CAPACITY_REQ VARCHAR2 (1)
TRANS_WEIGHT_LOAD_RATIO VARCHAR2 (1)
TRANS_VOLUME_LOAD_RATIO VARCHAR2 (1)
RETAIN_FOLDER_CRITERIA VARCHAR2 (1)
SHOW_GRAPH VARCHAR2 (1)
RUNNING_TOTAL_DEMAND VARCHAR2 (1)
RUNNING_TOTAL_SUPPLY VARCHAR2 (1)
SUMMARY_SELLER_FORECAST VARCHAR2 (1)
NAMED_SET VARCHAR2 (30)
DEFAULT_SET VARCHAR2 (30)
PROD_SUM_LEVEL NUMBER

ORG_SUM_LEVEL_TP VARCHAR2 (30)
ORG_SUM_LEVEL VARCHAR2 (30)
SUMMARY_SUPPCAP VARCHAR2 (1)
SUMMARY_ACTUAL_PRODN VARCHAR2 (1)
SUMMARY_COMMITTED_DMD VARCHAR2 (1)
SORT_BY_FLAG VARCHAR2 (30)
SUMMARY_ACT_PROD_FOR_FCST VARCHAR2 (1)
SUMMARY_ACT_PROD_FOR_DMD VARCHAR2 (1)
SUMMARY_PLANNED_PRODUCTION VARCHAR2 (1)
SUMMARY_PL_PRODN_FOR_FCST VARCHAR2 (1)
SUMMARY_PL_PRODN_FOR_DMD VARCHAR2 (1)
SUMMARY_HIST_SALES VARCHAR2 (1)
RUNNING_TOTAL_FORECAST VARCHAR2 (1)
RUNNING_TOTAL_HIST_SALES VARCHAR2 (1)
BLOCK_ZERO_RES_REQUIREMENTS VARCHAR2 (1)
SUMMARY_SELL_THRO_FCST VARCHAR2 (1)
RUNNING_TOTAL_SELL_THRO_FCST VARCHAR2 (1)
PREFERENCE_SET_TYPE NUMBER

SUMMARY_ALLOCATED_SUPPLY VARCHAR2 (1)
SUMMARY_PROJECTED_SS VARCHAR2 (1)
SUMMARY_UNALLOCATED_ONHAND VARCHAR2 (1)
SUMMARY_ALLOCATED_ONHAND VARCHAR2 (1)
SUMMARY_UNALCT_PRJT_AVL_BAL VARCHAR2 (1)
SUMMARY_ALCAT_PRJT_AVL_BAL VARCHAR2 (1)
SUMMARY_ASN VARCHAR2 (1)
SUMMARY_REPLENISHMENT VARCHAR2 (1)
ORDER_SELLER_FORECAST NUMBER

ORDER_FORECAST NUMBER

ORDER_ALLOCATED_SUPPLY NUMBER

ORDER_HIST_SALES NUMBER

ORDER_SELL_THRO_FCST NUMBER

ORDER_SUPPCAP NUMBER

ORDER_SS NUMBER

ORDER_PROJECTED_SS NUMBER

ORDER_ALLOCATED_ONHAND NUMBER

ORDER_UNALLOCATED_ONHAND NUMBER

ORDER_UNALCT_PRJT_AVL_BAL NUMBER

ORDER_ALCAT_PRJT_AVL_BAL NUMBER

ORDER_PO NUMBER

ORDER_SALES_ORDERS NUMBER

ORDER_ASN NUMBER

ORDER_RECEIVING NUMBER

ORDER_TRANSIT NUMBER

ORDER_WIP NUMBER

ORDER_REQ NUMBER

ORDER_REPLENISHMENT NUMBER

ORDER_GROSS_REQUIREMENTS NUMBER

ORDER_TOTAL_SUPPLY NUMBER

ORDER_RUNNING_TOTAL_SUPPLY NUMBER

ORDER_RUNNING_TOTAL_DEMAND NUMBER

ORDER_RUNNING_TOTAL_FORECAST NUMBER

ORDER_RUNNING_TOTAL_HIST_SALES NUMBER

SCE_USER_ID NUMBER

GC_RESOURCE_LIMIT NUMBER

GC_SUPPLY_LIMIT NUMBER

GRAD_HP_LOAD VARCHAR2 (1)
ATP_PRCT_ALC_SUPPLY VARCHAR2 (1)
ATP_PRCT_ALC_DMD VARCHAR2 (1)
ATP_PRCT_ALC_NET VARCHAR2 (1)
ATP_PRCT_ALC_BACKW VARCHAR2 (1)
ATP_PRCT_ALC_DMDADJ VARCHAR2 (1)
ATP_PRCT_ALC_ADJAVAIL VARCHAR2 (1)
ATP_PRCT_ALC_CUM VARCHAR2 (1)
ATP_PRCT_ALC_ADJCUM VARCHAR2 (1)
ATP_PRCT_ALC_PERCT VARCHAR2 (1)
ATP_PERCT_ALC_ACTPERCT VARCHAR2 (1)
ATP_PRCT_UNALC_SUPPLY VARCHAR2 (1)
ATP_PRCT_UNALC_DMD VARCHAR2 (1)
ATP_PRCT_UNALC_NET VARCHAR2 (1)
ATP_PRCT_UNALC_CUM VARCHAR2 (1)
ATP_DMDP_ALC_SUPPLY VARCHAR2 (1)
ATP_DMDP_ALC_SUPADJ VARCHAR2 (1)
ATP_DMDP_ALC_TOTSUP VARCHAR2 (1)
ATP_DMDP_ALC_DMD VARCHAR2 (1)
ATP_DMDP_ALC_NET VARCHAR2 (1)
ATP_DMDP_ALC_BKFWD VARCHAR2 (1)
ATP_DMDP_ALC_CUM VARCHAR2 (1)
ATP_HP_LAYOUT VARCHAR2 (250)
ATP_DISP_DAYS NUMBER

ATP_DISP_WEEKS NUMBER

ATP_DISP_FACTOR NUMBER

ATP_DISP_DECIMAL NUMBER

ATP_DISP_GRAPH VARCHAR2 (1)
MSC_HP_LAYOUT VARCHAR2 (250)
HP_CAP_DISP_FACTOR NUMBER

HP_CAP_DISP_DECIMAL NUMBER

HP_CAP_DISP_GRAPH VARCHAR2 (1)
HP_CAP_DAYS NUMBER

HP_CAP_WEEKS NUMBER

HP_SUP_DISP_FACTOR NUMBER

HP_SUP_DISP_DECIMAL NUMBER

HP_SUP_DISP_GRAPH VARCHAR2 (1)
HP_SUP_DAYS NUMBER

HP_SUP_WEEKS NUMBER

HP_TP_DISP_FACTOR NUMBER

HP_TP_DISP_DECIMAL NUMBER

HP_TP_DISP_GRAPH VARCHAR2 (1)
HP_TP_DAYS NUMBER

HP_TP_WEEKS NUMBER

ACTIONS_EXPAND_ALL VARCHAR2 (1)
ATP_DMD_SHOW_TOTAL VARCHAR2 (1)
ATP_PRCT_SHOW_TOTAL VARCHAR2 (1)
AUTO_PLAN_ID NUMBER

AUTO_QUERY_ID NUMBER

PLAN_TYPE NUMBER

PREFERENCE_NAME VARCHAR2 (30)
PREFERENCE_ID NUMBER

PREFERENCE_DESCRIPTION VARCHAR2 (30)
SUMMARY_ORIGINAL VARCHAR2 (1)
SUMMARY_CUMULATIVE_ORIGINAL VARCHAR2 (1)
SUMMARY_CONSUMED VARCHAR2 (1)
SUMMARY_CUMULATIVE_CONSUMED VARCHAR2 (1)
SUMMARY_CURRENT VARCHAR2 (1)
SUMMARY_CUMULATIVE_CURRENT VARCHAR2 (1)
SUMMARY_EXPIRED_FORECAST VARCHAR2 (1)
SUMMARY_GLOBAL_FORECASTING VARCHAR2 (1)
SUMMARY_RETURNS VARCHAR2 (1)
SUMMARY_PF_MEMBER_DATA VARCHAR2 (1)
SUMMARY_TOTAL_NON_FORECAST VARCHAR2 (1)
ATP_DMDP_BUCKETED_DATA VARCHAR2 (1)
ATP_PRCT_BUCKETED_DATA VARCHAR2 (1)
SUMMARY_SS_DAYS_SUPPLY VARCHAR2 (1)
CRP_ATP_REQUIREMENTS_RTG VARCHAR2 (1)
CRP_ATP_REQUIREMENTS_RATE VARCHAR2 (1)
NET_FORECAST VARCHAR2 (1)
TOTAL_SUPPLY VARCHAR2 (1)
INCLUDE_SO VARCHAR2 (1)
ORDER_PAB NUMBER

SUMMARY_PURCHASE_PLAN VARCHAR2 (1)
SUMMARY_RELEASE_PLAN VARCHAR2 (1)
SUMMARY_PLAN VARCHAR2 (1)
ORDER_PURCHASE_PLAN NUMBER

ORDER_RELEASE_PLAN NUMBER

ORDER_PLAN NUMBER

SHIFT_DAYS NUMBER

ORDER_PO_ACK NUMBER

SUMMARY_PO_ACK VARCHAR2 (1)
PUBLIC_FLAG VARCHAR2 (1)
ASCP_PLAN_ID NUMBER

IO_PLAN_ID NUMBER

DRP_PLAN_ID NUMBER

ASCP_QUERY_ID NUMBER

IO_QUERY_ID NUMBER

DRP_QUERY_ID NUMBER

SUMMARY_DISP_PF_DETAILS VARCHAR2 (1)
SUMMARY_PROD_FORECAST VARCHAR2 (1)
ATP_DMDP_PF_DMD_SPREAD VARCHAR2 (1)
ATP_PRCT_PF_DMD_SPREAD VARCHAR2 (1)
ORDERS_RELEASE_VMI_ITEMS VARCHAR2 (4)
SUMMARY_KIT_DEMAND VARCHAR2 (1)
SUMMARY_SHIPMENTS VARCHAR2 (1)
SUMMARY_REQ_SHIPMENTS VARCHAR2 (1)
SUMMARY_UNCONST_KIT_DMD VARCHAR2 (1)
SUMMARY_UNCONST_OTH_DMD VARCHAR2 (1)
SUMMARY_UNCONST_TOT_DMD VARCHAR2 (1)
SUMMARY_ARRIVALS VARCHAR2 (1)
SUMMARY_TOTAL_INTRANSIT VARCHAR2 (1)
SUMMARY_TOTAL_REQUISITIONS VARCHAR2 (1)
SUMMARY_TOTAL_PLANNED_ORDERS VARCHAR2 (1)
SUMMARY_UNCONST_PAB VARCHAR2 (1)
SUMMARY_MAXIMUM_QUANTITY VARCHAR2 (1)
SUMMARY_TARGET_QUANTITY VARCHAR2 (1)
SUMMARY_INBOUND_INTRANSIT VARCHAR2 (1)
SUMMARY_OUTBOUND_INTRANSIT VARCHAR2 (1)
SUMMARY_INTERNAL_SUPPLY VARCHAR2 (1)
SUMMARY_EXTERNAL_SUPPLY VARCHAR2 (1)
SUMMARY_OTHER_DEMAND VARCHAR2 (1)
SUMMARY_TOTAL_DEMAND VARCHAR2 (1)
SUMMARY_EXTERNAL_DEMAND VARCHAR2 (1)
SUMMARY_DEFAULT_DISPLAY NUMBER

DEFAULT_TAB NUMBER

CATEGORY_NAME VARCHAR2 (250)
SUMMARY_REQUESTED_ARRIVALS VARCHAR2 (1)
SUMMARY_MIN_INV_LVL VARCHAR2 (1)
SUMMARY_MAX_INV_LVL VARCHAR2 (1)
PLANNER_CODE VARCHAR2 (10)
EXCEPTIONS_QUERY_ID NUMBER

SHOW_ITEM_DESC_IN_PEGGING NUMBER

SUMMARY_RETURNS_FORECAST VARCHAR2 (1)
RETURNS_FORECAST NUMBER

SUMMARY_DEF_OUTBOUND_SHIPMENT VARCHAR2 (1)
DEF_OUTBOUND_SHIPMENT NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_ID
,      DEFAULT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SUMMARY_FIELD_WIDTH
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SUMMARY_SALES_ORDERS
,      SUMMARY_FORECAST
,      SUMMARY_DEPENDENT_DEMAND
,      SUMMARY_SCRAP
,      SUMMARY_INDEPENDENT_DEMAND
,      SUMMARY_GROSS_REQUIREMENTS
,      SUMMARY_SCHEDULED_RECEIPTS
,      SUMMARY_PLANNED_ORDERS
,      SUMMARY_TOTAL_SUPPLY
,      SUMMARY_PAB
,      SUMMARY_SS
,      SUMMARY_ATP
,      SUMMARY_CURRENT_RECEIPTS
,      SUMMARY_POH
,      SUMMARY_DISPLAY_FACTOR
,      ORDERS_DEFAULT_JOB_STATUS
,      SUMMARY_DECIMAL_PLACES
,      ORDERS_RELEASE_PHANTOMS
,      ORDERS_RELEASE_CONFIGS
,      ORDERS_FOLDER_ID
,      SUMMARY_BEGINNING_ON_HAND
,      ORDERS_CUTOFF_DATE
,      SUMMARY_WIP
,      SUMMARY_PO
,      SUMMARY_REQ
,      SUMMARY_TRANSIT
,      SUMMARY_RECEIVING
,      GROUP_BY_CODE
,      JOB_CLASS_CODE
,      SUMMARY_EXP_LOT
,      IND_DEMAND_TYPE
,      SOURCE_LIST
,      CRP_PLANNED_ORDERS
,      CRP_NON_STD_JOB_ORDERS
,      CRP_DISCRETE_JOBS
,      CRP_REPETITIVE_SCHEDULES
,      CRP_REQUIRE_HOURS
,      CRP_HOUR_AVAILABLE
,      CRP_NET_HOUR_AVAILABLE
,      CRP_CUM_HOUR_AVAILABLE
,      CRP_ROUTING_CAPACITY_UTIL
,      CRP_CUM_ROUTING_CAPACITY_UTIL
,      CRP_HOURS_REQUIRED_PER_DAY
,      CRP_HOURS_AVAIL_PER_DAY
,      CRP_SUM_OF_CAP_CHANGES
,      CRP_CUM_SUM_OF_CHANGES
,      CRP_RESOURCE_COST
,      CRP_REQUIRED_RATE
,      CRP_AVAILABLE_RATE
,      CRP_NET_AVAILABLE_RATE
,      CRP_CUM_AVAILABLE_RATE
,      CRP_RATE_CAPACITY_UTIL
,      CRP_CUM_RATE_CAPACITY_UTIL
,      CRP_DAILY_REQUIRED_RATE
,      CRP_DAILY_AVAILABLE_RATE
,      CRP_LINE_COST
,      SUMMARY_FLOW_SCHEDULES
,      CRP_FLOW_SCHEDULES
,      ORDERS_FIRM_JOBS
,      SUMMARY_PAYBACK_SUPPLY
,      SUMMARY_PAYBACK_DEMAND
,      SUMMARY_DISPLAY_DAYS
,      SUMMARY_DISPLAY_WEEKS
,      SUMMARY_DISPLAY_PERIODS
,      CATEGORY_SET_ID
,      RECOMMENDATION_DAYS
,      SUPPLIER_PURCHASE_ORDERS
,      SUPPLIER_PURCHASE_REQS
,      SUPPLIER_PLANNED_ORDERS
,      SUPPLIER_REQUIRED_CAP
,      SUPPLIER_CAP_AVAIL
,      SUPPLIER_NET_CAP_AVAIL
,      SUPPLIER_CUM_CAP_AVAIL
,      SUPPLIER_CAPACITY_UTIL
,      SUPPLIER_CUM_CAPACITY_UTIL
,      DEFAULT_LEFT_TAB
,      DEFAULT_RIGHT_TAB
,      TRANS_WEIGHT_CAPACITY_AVAIL
,      TRANS_VOLUME_CAPACITY_AVAIL
,      TRANS_WEIGHT_CAPACITY_REQ
,      TRANS_VOLUME_CAPACITY_REQ
,      TRANS_WEIGHT_LOAD_RATIO
,      TRANS_VOLUME_LOAD_RATIO
,      RETAIN_FOLDER_CRITERIA
,      SHOW_GRAPH
,      RUNNING_TOTAL_DEMAND
,      RUNNING_TOTAL_SUPPLY
,      SUMMARY_SELLER_FORECAST
,      NAMED_SET
,      DEFAULT_SET
,      PROD_SUM_LEVEL
,      ORG_SUM_LEVEL_TP
,      ORG_SUM_LEVEL
,      SUMMARY_SUPPCAP
,      SUMMARY_ACTUAL_PRODN
,      SUMMARY_COMMITTED_DMD
,      SORT_BY_FLAG
,      SUMMARY_ACT_PROD_FOR_FCST
,      SUMMARY_ACT_PROD_FOR_DMD
,      SUMMARY_PLANNED_PRODUCTION
,      SUMMARY_PL_PRODN_FOR_FCST
,      SUMMARY_PL_PRODN_FOR_DMD
,      SUMMARY_HIST_SALES
,      RUNNING_TOTAL_FORECAST
,      RUNNING_TOTAL_HIST_SALES
,      BLOCK_ZERO_RES_REQUIREMENTS
,      SUMMARY_SELL_THRO_FCST
,      RUNNING_TOTAL_SELL_THRO_FCST
,      PREFERENCE_SET_TYPE
,      SUMMARY_ALLOCATED_SUPPLY
,      SUMMARY_PROJECTED_SS
,      SUMMARY_UNALLOCATED_ONHAND
,      SUMMARY_ALLOCATED_ONHAND
,      SUMMARY_UNALCT_PRJT_AVL_BAL
,      SUMMARY_ALCAT_PRJT_AVL_BAL
,      SUMMARY_ASN
,      SUMMARY_REPLENISHMENT
,      ORDER_SELLER_FORECAST
,      ORDER_FORECAST
,      ORDER_ALLOCATED_SUPPLY
,      ORDER_HIST_SALES
,      ORDER_SELL_THRO_FCST
,      ORDER_SUPPCAP
,      ORDER_SS
,      ORDER_PROJECTED_SS
,      ORDER_ALLOCATED_ONHAND
,      ORDER_UNALLOCATED_ONHAND
,      ORDER_UNALCT_PRJT_AVL_BAL
,      ORDER_ALCAT_PRJT_AVL_BAL
,      ORDER_PO
,      ORDER_SALES_ORDERS
,      ORDER_ASN
,      ORDER_RECEIVING
,      ORDER_TRANSIT
,      ORDER_WIP
,      ORDER_REQ
,      ORDER_REPLENISHMENT
,      ORDER_GROSS_REQUIREMENTS
,      ORDER_TOTAL_SUPPLY
,      ORDER_RUNNING_TOTAL_SUPPLY
,      ORDER_RUNNING_TOTAL_DEMAND
,      ORDER_RUNNING_TOTAL_FORECAST
,      ORDER_RUNNING_TOTAL_HIST_SALES
,      SCE_USER_ID
,      GC_RESOURCE_LIMIT
,      GC_SUPPLY_LIMIT
,      GRAD_HP_LOAD
,      ATP_PRCT_ALC_SUPPLY
,      ATP_PRCT_ALC_DMD
,      ATP_PRCT_ALC_NET
,      ATP_PRCT_ALC_BACKW
,      ATP_PRCT_ALC_DMDADJ
,      ATP_PRCT_ALC_ADJAVAIL
,      ATP_PRCT_ALC_CUM
,      ATP_PRCT_ALC_ADJCUM
,      ATP_PRCT_ALC_PERCT
,      ATP_PERCT_ALC_ACTPERCT
,      ATP_PRCT_UNALC_SUPPLY
,      ATP_PRCT_UNALC_DMD
,      ATP_PRCT_UNALC_NET
,      ATP_PRCT_UNALC_CUM
,      ATP_DMDP_ALC_SUPPLY
,      ATP_DMDP_ALC_SUPADJ
,      ATP_DMDP_ALC_TOTSUP
,      ATP_DMDP_ALC_DMD
,      ATP_DMDP_ALC_NET
,      ATP_DMDP_ALC_BKFWD
,      ATP_DMDP_ALC_CUM
,      ATP_HP_LAYOUT
,      ATP_DISP_DAYS
,      ATP_DISP_WEEKS
,      ATP_DISP_FACTOR
,      ATP_DISP_DECIMAL
,      ATP_DISP_GRAPH
,      MSC_HP_LAYOUT
,      HP_CAP_DISP_FACTOR
,      HP_CAP_DISP_DECIMAL
,      HP_CAP_DISP_GRAPH
,      HP_CAP_DAYS
,      HP_CAP_WEEKS
,      HP_SUP_DISP_FACTOR
,      HP_SUP_DISP_DECIMAL
,      HP_SUP_DISP_GRAPH
,      HP_SUP_DAYS
,      HP_SUP_WEEKS
,      HP_TP_DISP_FACTOR
,      HP_TP_DISP_DECIMAL
,      HP_TP_DISP_GRAPH
,      HP_TP_DAYS
,      HP_TP_WEEKS
,      ACTIONS_EXPAND_ALL
,      ATP_DMD_SHOW_TOTAL
,      ATP_PRCT_SHOW_TOTAL
,      AUTO_PLAN_ID
,      AUTO_QUERY_ID
,      PLAN_TYPE
,      PREFERENCE_NAME
,      PREFERENCE_ID
,      PREFERENCE_DESCRIPTION
,      SUMMARY_ORIGINAL
,      SUMMARY_CUMULATIVE_ORIGINAL
,      SUMMARY_CONSUMED
,      SUMMARY_CUMULATIVE_CONSUMED
,      SUMMARY_CURRENT
,      SUMMARY_CUMULATIVE_CURRENT
,      SUMMARY_EXPIRED_FORECAST
,      SUMMARY_GLOBAL_FORECASTING
,      SUMMARY_RETURNS
,      SUMMARY_PF_MEMBER_DATA
,      SUMMARY_TOTAL_NON_FORECAST
,      ATP_DMDP_BUCKETED_DATA
,      ATP_PRCT_BUCKETED_DATA
,      SUMMARY_SS_DAYS_SUPPLY
,      CRP_ATP_REQUIREMENTS_RTG
,      CRP_ATP_REQUIREMENTS_RATE
,      NET_FORECAST
,      TOTAL_SUPPLY
,      INCLUDE_SO
,      ORDER_PAB
,      SUMMARY_PURCHASE_PLAN
,      SUMMARY_RELEASE_PLAN
,      SUMMARY_PLAN
,      ORDER_PURCHASE_PLAN
,      ORDER_RELEASE_PLAN
,      ORDER_PLAN
,      SHIFT_DAYS
,      ORDER_PO_ACK
,      SUMMARY_PO_ACK
,      PUBLIC_FLAG
,      ASCP_PLAN_ID
,      IO_PLAN_ID
,      DRP_PLAN_ID
,      ASCP_QUERY_ID
,      IO_QUERY_ID
,      DRP_QUERY_ID
,      SUMMARY_DISP_PF_DETAILS
,      SUMMARY_PROD_FORECAST
,      ATP_DMDP_PF_DMD_SPREAD
,      ATP_PRCT_PF_DMD_SPREAD
,      ORDERS_RELEASE_VMI_ITEMS
,      SUMMARY_KIT_DEMAND
,      SUMMARY_SHIPMENTS
,      SUMMARY_REQ_SHIPMENTS
,      SUMMARY_UNCONST_KIT_DMD
,      SUMMARY_UNCONST_OTH_DMD
,      SUMMARY_UNCONST_TOT_DMD
,      SUMMARY_ARRIVALS
,      SUMMARY_TOTAL_INTRANSIT
,      SUMMARY_TOTAL_REQUISITIONS
,      SUMMARY_TOTAL_PLANNED_ORDERS
,      SUMMARY_UNCONST_PAB
,      SUMMARY_MAXIMUM_QUANTITY
,      SUMMARY_TARGET_QUANTITY
,      SUMMARY_INBOUND_INTRANSIT
,      SUMMARY_OUTBOUND_INTRANSIT
,      SUMMARY_INTERNAL_SUPPLY
,      SUMMARY_EXTERNAL_SUPPLY
,      SUMMARY_OTHER_DEMAND
,      SUMMARY_TOTAL_DEMAND
,      SUMMARY_EXTERNAL_DEMAND
,      SUMMARY_DEFAULT_DISPLAY
,      DEFAULT_TAB
,      CATEGORY_NAME
,      SUMMARY_REQUESTED_ARRIVALS
,      SUMMARY_MIN_INV_LVL
,      SUMMARY_MAX_INV_LVL
,      PLANNER_CODE
,      EXCEPTIONS_QUERY_ID
,      SHOW_ITEM_DESC_IN_PEGGING
,      SUMMARY_RETURNS_FORECAST
,      RETURNS_FORECAST
,      SUMMARY_DEF_OUTBOUND_SHIPMENT
,      DEF_OUTBOUND_SHIPMENT
FROM MSC.MSC_WORKBENCH_DISPLAY_OPTIONS#;

Dependencies

[top of page]

MSC.MSC_WORKBENCH_DISPLAY_OPTIONS# references the following:

SchemaMSC
TableMSC_WORKBENCH_DISPLAY_OPTIONS
MSC.MSC_WORKBENCH_DISPLAY_OPTIONS# is referenced by following:

SchemaAPPS
SynonymMSC_WORKBENCH_DISPLAY_OPTIONS