eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: MRP.MRP_WORKBENCH_DISPLAY_OPTIONS#

Object Details

Object Name:	MRP_WORKBENCH_DISPLAY_OPTIONS#
Object Type:	VIEW
Owner:	MRP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
USER_ID	NUMBER		Yes
DEFAULT_FLAG	NUMBER
LAST_UPDATE_DATE	DATE
BUCKET_TYPE	NUMBER		Yes
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_WIP	VARCHAR2	(1)
SUMMARY_FLOW_SCHEDULES	VARCHAR2	(1)
SUMMARY_PO	VARCHAR2	(1)
SUMMARY_REQ	VARCHAR2	(1)
SUMMARY_TRANSIT	VARCHAR2	(1)
SUMMARY_RECEIVING	VARCHAR2	(1)
SUMMARY_CURRENT_RECEIPTS	VARCHAR2	(1)
SUMMARY_POH	VARCHAR2	(1)
SUMMARY_DISPLAY_FACTOR	NUMBER
SUMMARY_WINDOW_SIZE	NUMBER
SUMMARY_WINDOW_WIDTH	NUMBER
ORDERS_SALES_ORDERS	VARCHAR2	(1)
ORDERS_FORECAST	VARCHAR2	(1)
ORDERS_DEPENDENT_DEMAND	VARCHAR2	(1)
ORDERS_SCRAP	VARCHAR2	(1)
ORDERS_INDEPENDENT_DEMAND	VARCHAR2	(1)
ORDERS_SCHEDULED_RECEIPTS	VARCHAR2	(1)
ORDERS_PLANNED_ORDERS	VARCHAR2	(1)
ORDERS_DEFAULT_JOB_STATUS	NUMBER
SUMMARY_DECIMAL_PLACES	NUMBER
ORDERS_RELEASE_PHANTOMS	VARCHAR2	(1)
ORDERS_RELEASE_CONFIGS	VARCHAR2	(1)
ORDERS_FIRM_JOBS	VARCHAR2	(1)
ORDERS_FOLDER_ID	NUMBER
SUMMARY_BEGINNING_ON_HAND	VARCHAR2	(1)
ORDERS_CUTOFF_DATE	DATE
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_FLOW_SCHEDULES	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_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_PAYBACK_SUPPLY	VARCHAR2	(1)
SUMMARY_PAYBACK_DEMAND	VARCHAR2	(1)
CATEGORY_SET_ID	NUMBER	(38)

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# references the following:

MRP: MRP_WORKBENCH_DISPLAY_OPTIONS

MRP.MRP_WORKBENCH_DISPLAY_OPTIONS# is referenced by following:

APPS: MRP_WORKBENCH_DISPLAY_OPTIONS