[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_WORKBENCH_DISPLAY_OPTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_WORKBENCH_DISPLAY_OPTIONS
|
| Subobject Name: | |
| Status: | VALID |
MSC_WORKBENCH_DISPLAY_OPTIONS is a table that stores the user display
preferences for the Planner Workbench. This table has a row for
every user who has defined and saved the display preferences from the
Preferences window of the Planner Workbench.
The summary columns control the display of various row types in the
Horizontal Plan window of the Planner Workbench. The orders column
filter the order types in the Supply, Demand, and Supply/Demand
windows.
This table also stores the user preferences for display in the horizontal bucketed view for
supply and demand planning on the Oracle Supply Chain Hub user interface.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_WB_DISPLAY_OPTIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 SCE_USER_ID
|
| MSC_WB_DISPLAY_OPTIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
USER_ID
PREFERENCE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| USER_ID | NUMBER | Yes | User identifier | |
| DEFAULT_FLAG | NUMBER | Default flag | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| SUMMARY_FIELD_WIDTH | NUMBER | Horizontal plan field width | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| SUMMARY_SALES_ORDERS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_FORECAST | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_DEPENDENT_DEMAND | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_SCRAP | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_INDEPENDENT_DEMAND | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_GROSS_REQUIREMENTS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_SCHEDULED_RECEIPTS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_PLANNED_ORDERS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_TOTAL_SUPPLY | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_PAB | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_SS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_ATP | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_CURRENT_RECEIPTS | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_POH | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_DISPLAY_FACTOR | NUMBER | Display control for Horizontal Plan | ||
| ORDERS_DEFAULT_JOB_STATUS | NUMBER | Default job status | ||
| SUMMARY_DECIMAL_PLACES | NUMBER | Display control for Horizontal Plan | ||
| ORDERS_RELEASE_PHANTOMS | VARCHAR2 | (1) | Display control for release phantoms | |
| ORDERS_RELEASE_CONFIGS | VARCHAR2 | (1) | Display control for release configs | |
| ORDERS_FOLDER_ID | NUMBER | Orders folder identifier | ||
| SUMMARY_BEGINNING_ON_HAND | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| ORDERS_CUTOFF_DATE | DATE | Orders cutoff date | ||
| SUMMARY_WIP | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_PO | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_REQ | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_TRANSIT | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| SUMMARY_RECEIVING | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| GROUP_BY_CODE | NUMBER | Group by code | ||
| JOB_CLASS_CODE | VARCHAR2 | (10) | Job class code | |
| SUMMARY_EXP_LOT | VARCHAR2 | (1) | Display control for Horizontal Plan | |
| IND_DEMAND_TYPE | NUMBER | Independent demand type | ||
| SOURCE_LIST | VARCHAR2 | (10) | Source list | |
| CRP_PLANNED_ORDERS | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_NON_STD_JOB_ORDERS | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_DISCRETE_JOBS | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_REPETITIVE_SCHEDULES | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_REQUIRE_HOURS | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_HOUR_AVAILABLE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_NET_HOUR_AVAILABLE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_CUM_HOUR_AVAILABLE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_ROUTING_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_CUM_ROUTING_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_HOURS_REQUIRED_PER_DAY | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_HOURS_AVAIL_PER_DAY | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_SUM_OF_CAP_CHANGES | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_CUM_SUM_OF_CHANGES | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_RESOURCE_COST | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_REQUIRED_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_AVAILABLE_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_NET_AVAILABLE_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_CUM_AVAILABLE_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_RATE_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_CUM_RATE_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_DAILY_REQUIRED_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_DAILY_AVAILABLE_RATE | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| CRP_LINE_COST | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| SUMMARY_FLOW_SCHEDULES | VARCHAR2 | (1) | Display control for flow schedules | |
| CRP_FLOW_SCHEDULES | VARCHAR2 | (1) | Display control for capacity horizontal plan | |
| ORDERS_FIRM_JOBS | VARCHAR2 | (1) | Orders firm jobs | |
| SUMMARY_PAYBACK_SUPPLY | VARCHAR2 | (1) | Display control for payback supply | |
| SUMMARY_PAYBACK_DEMAND | VARCHAR2 | (1) | Display control for payback demand | |
| SUMMARY_DISPLAY_DAYS | NUMBER | Summary display in days | ||
| SUMMARY_DISPLAY_WEEKS | NUMBER | Summary display in weeks | ||
| SUMMARY_DISPLAY_PERIODS | NUMBER | Summary displays in periods | ||
| CATEGORY_SET_ID | NUMBER | Category set identifier | ||
| RECOMMENDATION_DAYS | NUMBER | Recommendation days | ||
| SUPPLIER_PURCHASE_ORDERS | VARCHAR2 | (1) | Display control for purchase orders | |
| SUPPLIER_PURCHASE_REQS | VARCHAR2 | (1) | Display control for purchase requisitions | |
| SUPPLIER_PLANNED_ORDERS | VARCHAR2 | (1) | Display control for planned orders | |
| SUPPLIER_REQUIRED_CAP | VARCHAR2 | (1) | Display control for required capacity | |
| SUPPLIER_CAP_AVAIL | VARCHAR2 | (1) | Display control for available capacity | |
| SUPPLIER_NET_CAP_AVAIL | VARCHAR2 | (1) | Display control for net available capacity | |
| SUPPLIER_CUM_CAP_AVAIL | VARCHAR2 | (1) | Display control for cummulative available capacity | |
| SUPPLIER_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for capacity utilization | |
| SUPPLIER_CUM_CAPACITY_UTIL | VARCHAR2 | (1) | Display control for cummulative capacity utilization | |
| DEFAULT_LEFT_TAB | VARCHAR2 | (30) | Default left tab | |
| DEFAULT_RIGHT_TAB | VARCHAR2 | (240) | Default right tab | |
| TRANS_WEIGHT_CAPACITY_AVAIL | VARCHAR2 | (1) | Display control for transfortation weigth capacity availability | |
| TRANS_VOLUME_CAPACITY_AVAIL | VARCHAR2 | (1) | Display control for transfortation volume capacity availability | |
| TRANS_WEIGHT_CAPACITY_REQ | VARCHAR2 | (1) | Display control for required transfortation weigth capacity | |
| TRANS_VOLUME_CAPACITY_REQ | VARCHAR2 | (1) | Display control for required transfortation volume capacity | |
| TRANS_WEIGHT_LOAD_RATIO | VARCHAR2 | (1) | Display control for transfortation weight load ratio | |
| TRANS_VOLUME_LOAD_RATIO | VARCHAR2 | (1) | Display control for transfortation volume load ratio | |
| RETAIN_FOLDER_CRITERIA | VARCHAR2 | (1) | Flag indicating whether folder criteria is retained | |
| SHOW_GRAPH | VARCHAR2 | (1) | Show Graph | |
| RUNNING_TOTAL_DEMAND | VARCHAR2 | (1) | Display control for running total demand | |
| RUNNING_TOTAL_SUPPLY | VARCHAR2 | (1) | Display control for running total supply | |
| SUMMARY_SELLER_FORECAST | VARCHAR2 | (1) | Display control for seller forecast | |
| NAMED_SET | VARCHAR2 | (30) | Named set | |
| DEFAULT_SET | VARCHAR2 | (30) | Default set | |
| PROD_SUM_LEVEL | NUMBER | Level column for aggregation | ||
| ORG_SUM_LEVEL_TP | VARCHAR2 | (30) | Level column for aggregation | |
| ORG_SUM_LEVEL | VARCHAR2 | (30) | Level column for aggregation | |
| SUMMARY_SUPPCAP | VARCHAR2 | (1) | Display control for supplier capacity | |
| SUMMARY_ACTUAL_PRODN | VARCHAR2 | (1) | Display control for actual production | |
| SUMMARY_COMMITTED_DMD | VARCHAR2 | (1) | Display control for committed demand | |
| SORT_BY_FLAG | VARCHAR2 | (30) | Sort by flag | |
| SUMMARY_ACT_PROD_FOR_FCST | VARCHAR2 | (1) | Display control for actual production for forecast | |
| SUMMARY_ACT_PROD_FOR_DMD | VARCHAR2 | (1) | Display control for actual production for demand | |
| SUMMARY_PLANNED_PRODUCTION | VARCHAR2 | (1) | Display control for planned production | |
| SUMMARY_PL_PRODN_FOR_FCST | VARCHAR2 | (1) | Display control for planned production for forecast | |
| SUMMARY_PL_PRODN_FOR_DMD | VARCHAR2 | (1) | Display control for planned production for demand | |
| SUMMARY_HIST_SALES | VARCHAR2 | (1) | Display control for Historical Sales | |
| RUNNING_TOTAL_FORECAST | VARCHAR2 | (1) | Running Total Forecast | |
| RUNNING_TOTAL_HIST_SALES | VARCHAR2 | (1) | Display control for running total historical sales | |
| BLOCK_ZERO_RES_REQUIREMENTS | VARCHAR2 | (1) | Block zero resource requirements | |
| SUMMARY_SELL_THRO_FCST | VARCHAR2 | (1) | Sell through forecast | |
| RUNNING_TOTAL_SELL_THRO_FCST | VARCHAR2 | (1) | Running Total Sell Thro Forecast | |
| PREFERENCE_SET_TYPE | NUMBER | Preference Set Type | ||
| SUMMARY_ALLOCATED_SUPPLY | VARCHAR2 | (1) | Preference flag for allocated supply | |
| SUMMARY_PROJECTED_SS | VARCHAR2 | (1) | Preference flag for projected safety stock | |
| SUMMARY_UNALLOCATED_ONHAND | VARCHAR2 | (1) | Preference flag for unallocated on hand | |
| SUMMARY_ALLOCATED_ONHAND | VARCHAR2 | (1) | Preference flag for allocated on hand | |
| SUMMARY_UNALCT_PRJT_AVL_BAL | VARCHAR2 | (1) | Preference flag for unallocated proj avl bal | |
| SUMMARY_ALCAT_PRJT_AVL_BAL | VARCHAR2 | (1) | Preference flag for allocated proj avl bal | |
| SUMMARY_ASN | VARCHAR2 | (1) | Preference flag for ASN | |
| SUMMARY_REPLENISHMENT | VARCHAR2 | (1) | Preference flag for replenishment | |
| ORDER_SELLER_FORECAST | NUMBER | Order for seller forecast | ||
| ORDER_FORECAST | NUMBER | Ranking for forecast | ||
| ORDER_ALLOCATED_SUPPLY | NUMBER | Ranking allocated supply | ||
| ORDER_HIST_SALES | NUMBER | Ranking of historical sales | ||
| ORDER_SELL_THRO_FCST | NUMBER | Ranking of sell thru forecast | ||
| ORDER_SUPPCAP | NUMBER | Order of supplier capacity | ||
| ORDER_SS | NUMBER | Order of safety stock | ||
| ORDER_PROJECTED_SS | NUMBER | Ranking of projected safety stock | ||
| ORDER_ALLOCATED_ONHAND | NUMBER | Ranking of allocated on hand | ||
| ORDER_UNALLOCATED_ONHAND | NUMBER | Ranking unallocated on hand | ||
| ORDER_UNALCT_PRJT_AVL_BAL | NUMBER | Ranking Unallocated Proj Avl Bal | ||
| ORDER_ALCAT_PRJT_AVL_BAL | NUMBER | Ranking projected avail balance | ||
| ORDER_PO | NUMBER | Ranking purchase order | ||
| ORDER_SALES_ORDERS | NUMBER | Ranking sales orders | ||
| ORDER_ASN | NUMBER | Ranking ASN | ||
| ORDER_RECEIVING | NUMBER | Ranking receiving | ||
| ORDER_TRANSIT | NUMBER | Ranking transit | ||
| ORDER_WIP | NUMBER | Ranking WIP | ||
| ORDER_REQ | NUMBER | Ranking requisition | ||
| ORDER_REPLENISHMENT | NUMBER | Ranking replenishment | ||
| ORDER_GROSS_REQUIREMENTS | NUMBER | Ranking Gross requirements | ||
| ORDER_TOTAL_SUPPLY | NUMBER | Ranking Total Supply | ||
| ORDER_RUNNING_TOTAL_SUPPLY | NUMBER | UI display order of running total supply | ||
| ORDER_RUNNING_TOTAL_DEMAND | NUMBER | UI display order of running total demand | ||
| ORDER_RUNNING_TOTAL_FORECAST | NUMBER | UI display order of running total forecast | ||
| ORDER_RUNNING_TOTAL_HIST_SALES | NUMBER | UI display order of running total historic sales | ||
| SCE_USER_ID | NUMBER | Supplier Chain Exchange user id | ||
| GC_RESOURCE_LIMIT | NUMBER | the number of resource activities to be shown in Gantt Chart Resource Centric View at one time | ||
| GC_SUPPLY_LIMIT | NUMBER | The number of End Demands to be shown in the Gantt Chart Order Centric View at one time | ||
| GRAD_HP_LOAD | VARCHAR2 | (1) | to load Horizontal Plan data gradually or not | |
| ATP_PRCT_ALC_SUPPLY | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_DMD | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_NET | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_BACKW | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_DMDADJ | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_ADJAVAIL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_CUM | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_ADJCUM | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_ALC_PERCT | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PERCT_ALC_ACTPERCT | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_UNALC_SUPPLY | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_UNALC_DMD | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_UNALC_NET | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_UNALC_CUM | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_SUPPLY | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_SUPADJ | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_TOTSUP | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_DMD | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_NET | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_BKFWD | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMDP_ALC_CUM | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_HP_LAYOUT | VARCHAR2 | (250) | Obsoleted. To be removed. | |
| ATP_DISP_DAYS | NUMBER | Obsoleted. To be removed. | ||
| ATP_DISP_WEEKS | NUMBER | Obsoleted. To be removed. | ||
| ATP_DISP_FACTOR | NUMBER | Obsoleted. To be removed. | ||
| ATP_DISP_DECIMAL | NUMBER | Obsoleted. To be removed. | ||
| ATP_DISP_GRAPH | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| MSC_HP_LAYOUT | VARCHAR2 | (250) | Obsoleted. To be removed. | |
| HP_CAP_DISP_FACTOR | NUMBER | Obsoleted. To be removed. | ||
| HP_CAP_DISP_DECIMAL | NUMBER | Obsoleted. To be removed. | ||
| HP_CAP_DISP_GRAPH | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| HP_CAP_DAYS | NUMBER | Obsoleted. To be removed. | ||
| HP_CAP_WEEKS | NUMBER | Obsoleted. To be removed. | ||
| HP_SUP_DISP_FACTOR | NUMBER | Obsoleted. To be removed. | ||
| HP_SUP_DISP_DECIMAL | NUMBER | Obsoleted. To be removed. | ||
| HP_SUP_DISP_GRAPH | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| HP_SUP_DAYS | NUMBER | Obsoleted. To be removed. | ||
| HP_SUP_WEEKS | NUMBER | Obsoleted. To be removed. | ||
| HP_TP_DISP_FACTOR | NUMBER | Obsoleted. To be removed. | ||
| HP_TP_DISP_DECIMAL | NUMBER | Obsoleted. To be removed. | ||
| HP_TP_DISP_GRAPH | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| HP_TP_DAYS | NUMBER | Obsoleted. To be removed. | ||
| HP_TP_WEEKS | NUMBER | Obsoleted. To be removed. | ||
| ACTIONS_EXPAND_ALL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_DMD_SHOW_TOTAL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| ATP_PRCT_SHOW_TOTAL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| AUTO_PLAN_ID | NUMBER | Obsoleted. To be removed. | ||
| AUTO_QUERY_ID | NUMBER | Obsoleted. To be removed. | ||
| PLAN_TYPE | NUMBER | Obsoleted. To be removed. | ||
| PREFERENCE_NAME | VARCHAR2 | (30) | Obsoleted. To be removed. | |
| PREFERENCE_ID | NUMBER | Obsoleted. To be removed. | ||
| PREFERENCE_DESCRIPTION | VARCHAR2 | (30) | Obsoleted. To be removed. | |
| SUMMARY_ORIGINAL | VARCHAR2 | (1) | Global Forecasting Original | |
| SUMMARY_CUMULATIVE_ORIGINAL | VARCHAR2 | (1) | Global Forecasting Cumulative Original | |
| SUMMARY_CONSUMED | VARCHAR2 | (1) | Global Forecasting Consumed | |
| SUMMARY_CUMULATIVE_CONSUMED | VARCHAR2 | (1) | Global Forecasting Cumulative Consumed | |
| SUMMARY_CURRENT | VARCHAR2 | (1) | Global Forecasting Current | |
| SUMMARY_CUMULATIVE_CURRENT | VARCHAR2 | (1) | Global Forecasting Cumulative Current | |
| SUMMARY_EXPIRED_FORECAST | VARCHAR2 | (1) | Global Forecasting Expired Forecast | |
| SUMMARY_GLOBAL_FORECASTING | VARCHAR2 | (1) | Global Forecasting | |
| SUMMARY_RETURNS | VARCHAR2 | (1) | Returns | |
| SUMMARY_PF_MEMBER_DATA | VARCHAR2 | (1) | PF Member Data | |
| SUMMARY_TOTAL_NON_FORECAST | VARCHAR2 | (1) | Total Non Forecast | |
| ATP_DMDP_BUCKETED_DATA | VARCHAR2 | (1) | ATP Demand Priority Based Allocation - Bucketed Data | |
| ATP_PRCT_BUCKETED_DATA | VARCHAR2 | (1) | ATP Percentage Based Allocation Bucketed Data | |
| SUMMARY_SS_DAYS_SUPPLY | VARCHAR2 | (1) | SS days of Supply | |
| CRP_ATP_REQUIREMENTS_RTG | VARCHAR2 | (1) | ATP requirements Routing | |
| CRP_ATP_REQUIREMENTS_RATE | VARCHAR2 | (1) | ATP Requirements Rate | |
| NET_FORECAST | VARCHAR2 | (1) | Net Forecast | |
| TOTAL_SUPPLY | VARCHAR2 | (1) | Total Supply | |
| INCLUDE_SO | VARCHAR2 | (1) | Include Sales Orders releasing | |
| ORDER_PAB | NUMBER | Order of Projected Available Balance | ||
| SUMMARY_PURCHASE_PLAN | VARCHAR2 | (1) | Preference flag for Purchase order from plan | |
| SUMMARY_RELEASE_PLAN | VARCHAR2 | (1) | Preference flag for Released Planned order | |
| SUMMARY_PLAN | VARCHAR2 | (1) | Preference flag for Planned order | |
| ORDER_PURCHASE_PLAN | NUMBER | Order of Purhcase orders for plan | ||
| ORDER_RELEASE_PLAN | NUMBER | Order of Released planned order | ||
| ORDER_PLAN | NUMBER | Order of Planned Order | ||
| SHIFT_DAYS | NUMBER | Column to offset the bucketing start date in CP horizontal view | ||
| ORDER_PO_ACK | NUMBER | Order of Purchase order Acknowledgement | ||
| SUMMARY_PO_ACK | VARCHAR2 | (1) | Preference flag for Purchase order acknowledgement | |
| PUBLIC_FLAG | VARCHAR2 | (1) | Flag to make the preference set public | |
| ASCP_PLAN_ID | NUMBER | Stores ASCP Plan Id for Personal Queries | ||
| IO_PLAN_ID | NUMBER | Stores IO Plan Id for Personal Queries | ||
| DRP_PLAN_ID | NUMBER | Stores DRP Plan Id for Personal Queries | ||
| ASCP_QUERY_ID | NUMBER | Stores ASCP query Id for Personal Queries | ||
| IO_QUERY_ID | NUMBER | Stores io query Id for Personal Queries | ||
| DRP_QUERY_ID | NUMBER | Stores DRP query Id for Personal Queries | ||
| SUMMARY_DISP_PF_DETAILS | VARCHAR2 | (1) | Display flag for Product Family Details | |
| SUMMARY_PROD_FORECAST | VARCHAR2 | (1) | Display flag for Production Forecast | |
| ATP_DMDP_PF_DMD_SPREAD | VARCHAR2 | (1) | ATP Demand based PF demand Spread | |
| ATP_PRCT_PF_DMD_SPREAD | VARCHAR2 | (1) | ATP percent based Demand Spread | |
| ORDERS_RELEASE_VMI_ITEMS | VARCHAR2 | (4) | Flag to indicate whether release of VMI items is allowed | |
| SUMMARY_KIT_DEMAND | VARCHAR2 | (1) | Kit Demand | |
| SUMMARY_SHIPMENTS | VARCHAR2 | (1) | Display Shipments | |
| SUMMARY_REQ_SHIPMENTS | VARCHAR2 | (1) | Display Requested Shipments | |
| SUMMARY_UNCONST_KIT_DMD | VARCHAR2 | (1) | Display Unconstrained Kit Demand | |
| SUMMARY_UNCONST_OTH_DMD | VARCHAR2 | (1) | Display Unconstrained Other Demand | |
| SUMMARY_UNCONST_TOT_DMD | VARCHAR2 | (1) | Display Unconstrained Total Demand | |
| SUMMARY_ARRIVALS | VARCHAR2 | (1) | Display Arrivals | |
| SUMMARY_TOTAL_INTRANSIT | VARCHAR2 | (1) | Display Total Intransit | |
| SUMMARY_TOTAL_REQUISITIONS | VARCHAR2 | (1) | Display Total Requisitions | |
| SUMMARY_TOTAL_PLANNED_ORDERS | VARCHAR2 | (1) | Display Total Planned Orders | |
| SUMMARY_UNCONST_PAB | VARCHAR2 | (1) | Display Unconstrained PAB | |
| SUMMARY_MAXIMUM_QUANTITY | VARCHAR2 | (1) | Display Maximum Quantity | |
| SUMMARY_TARGET_QUANTITY | VARCHAR2 | (1) | Display Target Quantity | |
| SUMMARY_INBOUND_INTRANSIT | VARCHAR2 | (1) | Display Inbound Intransit | |
| SUMMARY_OUTBOUND_INTRANSIT | VARCHAR2 | (1) | Display Outbound Intransit | |
| SUMMARY_INTERNAL_SUPPLY | VARCHAR2 | (1) | Summary Internal Supply | |
| SUMMARY_EXTERNAL_SUPPLY | VARCHAR2 | (1) | Summary External Supply | |
| SUMMARY_OTHER_DEMAND | VARCHAR2 | (1) | Display Other Demand | |
| SUMMARY_TOTAL_DEMAND | VARCHAR2 | (1) | Display Total Demand | |
| SUMMARY_EXTERNAL_DEMAND | VARCHAR2 | (1) | Display External Demand | |
| SUMMARY_DEFAULT_DISPLAY | NUMBER | Default display | ||
| DEFAULT_TAB | NUMBER | Default tab | ||
| CATEGORY_NAME | VARCHAR2 | (250) | category name for CP user preferences. | |
| SUMMARY_REQUESTED_ARRIVALS | VARCHAR2 | (1) | Display Requested Arrivals | |
| SUMMARY_MIN_INV_LVL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| SUMMARY_MAX_INV_LVL | VARCHAR2 | (1) | Obsoleted. To be removed. | |
| PLANNER_CODE | VARCHAR2 | (10) | Obsoleted. To be removed. | |
| EXCEPTIONS_QUERY_ID | NUMBER | Obsoleted. To be removed. | ||
| SHOW_ITEM_DESC_IN_PEGGING | NUMBER | Obsoleted. To be removed. | ||
| SUMMARY_RETURNS_FORECAST | VARCHAR2 | (1) | Return Forecast Order Type in the HZ View Preference Set | |
| RETURNS_FORECAST | NUMBER | Return Forecast order number in the selected shuttle list HZ View Preference Set | ||
| SUMMARY_DEF_OUTBOUND_SHIPMENT | VARCHAR2 | (1) | Defective Outbound Shipment Order Type in the HZ View Preference Set | |
| DEF_OUTBOUND_SHIPMENT | NUMBER | Defective Outbound Shipment order number in the selected shuttle list HZ View Preference Set |
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;
MSC.MSC_WORKBENCH_DISPLAY_OPTIONS does not reference any database object
MSC.MSC_WORKBENCH_DISPLAY_OPTIONS is referenced by following:
APPS
MSC_WORKBENCH_DISPLAY_OPTIONS
|
|
|
|