[Home] [Help] [Dependency Information]

TABLE: MRP.MRP_WORKBENCH_DISPLAY_OPTIONS

Object Details

Object Name:	MRP_WORKBENCH_DISPLAY_OPTIONS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_WORKBENCH_DISPLAY_OPTIONS
Subobject Name:
Status:	VALID

MRP_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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_WORKBENCH_DISPLAY_OPT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_ID

Columns

Query Text

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

SELECT USER_ID
,      DEFAULT_FLAG
,      LAST_UPDATE_DATE
,      BUCKET_TYPE
,      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_WIP
,      SUMMARY_FLOW_SCHEDULES
,      SUMMARY_PO
,      SUMMARY_REQ
,      SUMMARY_TRANSIT
,      SUMMARY_RECEIVING
,      SUMMARY_CURRENT_RECEIPTS
,      SUMMARY_POH
,      SUMMARY_DISPLAY_FACTOR
,      SUMMARY_WINDOW_SIZE
,      SUMMARY_WINDOW_WIDTH
,      ORDERS_SALES_ORDERS
,      ORDERS_FORECAST
,      ORDERS_DEPENDENT_DEMAND
,      ORDERS_SCRAP
,      ORDERS_INDEPENDENT_DEMAND
,      ORDERS_SCHEDULED_RECEIPTS
,      ORDERS_PLANNED_ORDERS
,      ORDERS_DEFAULT_JOB_STATUS
,      SUMMARY_DECIMAL_PLACES
,      ORDERS_RELEASE_PHANTOMS
,      ORDERS_RELEASE_CONFIGS
,      ORDERS_FIRM_JOBS
,      ORDERS_FOLDER_ID
,      SUMMARY_BEGINNING_ON_HAND
,      ORDERS_CUTOFF_DATE
,      GROUP_BY_CODE
,      JOB_CLASS_CODE
,      SUMMARY_EXP_LOT
,      IND_DEMAND_TYPE
,      SOURCE_LIST
,      CRP_PLANNED_ORDERS
,      CRP_NON_STD_JOB_ORDERS
,      CRP_FLOW_SCHEDULES
,      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_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_PAYBACK_SUPPLY
,      SUMMARY_PAYBACK_DEMAND
,      CATEGORY_SET_ID
FROM MRP.MRP_WORKBENCH_DISPLAY_OPTIONS;

Dependencies

[top of page]

MRP.MRP_WORKBENCH_DISPLAY_OPTIONS does not reference any database object

MRP.MRP_WORKBENCH_DISPLAY_OPTIONS is referenced by following:

MRP

MRP_WORKBENCH_DISPLAY_OPTIONS#