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]

TABLE: MRP.MRP_WORKBENCH_QUERY

Object Details

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

MRP_WORKBENCH_QUERY is used by the Planner Workbench form for
querying data populated by user exits. This table is populated by the
user exit MRP_LOAD_WORKBENCH_QUERY based on criteria specified by the
user in the Planner Workbench form. The information is later used by
the user exit MRP_LOAD_INTERFACE to insert rows selected by the user
into the WIP and PO interface tables for processing by the WIP and PO
load processes, respectively.
.
ORDER_NUMBER is a foreign key to MRP_ITEM_WIP_ENTITIES for discrete
jobs. For nonstandard jobs, it references MRP_WIP_COMPONENTS. For
purchase orders, purchase requisitions, and purchase orders in
receiving, ORDER_NUMBER and PURCH_LINE_NUM provide a foreign key to
MRP_ITEM_PURCHASE_ORDERS. ORDER_NUMBER will be equal to
MRP_RECOMMENDATIONS.TRANSACTION_ID for planned orders and suggested
repetitive schedules.
.
TRANSACTION_ID is a foreign key to MRP_RECOMMENDATIONS for
recommendations created by the planning process. TRANSACTION_ID,
LINE_ID and FIRST_UNIT_COMPLETION_DATE provide a foreign key to
MRP_SUGG_REP_SCHEDULES for suggested repetitive schedules.
.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_WORKBENCH_QUERY_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	QUERY_ID TRANSACTION_ID LINE_ID FIRST_UNIT_COMPLETION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
QUERY_ID	NUMBER		Yes	Query identifier
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
LINE_ID	NUMBER			Line identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
DESIGNATOR	VARCHAR2	(10)	Yes	Plan name
CURRENT_SCHEDULE_DATE	DATE			Schedule completion date
NEW_SCHEDULE_DATE	DATE			New schedule completion date
CURRENT_ORDER_DATE	DATE			Order date
NEW_ORDER_DATE	DATE			New order date
CURRENT_DOCK_DATE	DATE			Dock date
NEW_DOCK_DATE	DATE			New dock date
NEW_ORDER_QUANTITY	NUMBER			New order quantity
CURRENT_ORDER_QUANTITY	NUMBER			Order quantity
ORDER_NUMBER	NUMBER			Order number
ORDER_TYPE	NUMBER			Order type
DAILY_RATE	NUMBER			Repetitive daily rate
FIRST_UNIT_COMPLETION_DATE	DATE			First unit completion date for the recommended repetitive schedules
LAST_UNIT_COMPLETION_DATE	DATE			Last unit completion date for recommended repetitive schedules
STATUS_CODE	NUMBER			Job status
PROCESSING_DAYS	NUMBER			Repetitive schedule processing days
FIRM_PLANNED_TYPE	NUMBER			Firm planned status
LOAD_TYPE	NUMBER			Load program to execute
WIP_CLASS_CODE	VARCHAR2	(10)		WIP class code
DISPOSITION	VARCHAR2	(240)		WIP job name
DISPOSITION_STATUS_TYPE	NUMBER			Disposition type code
QUANTITY_IN_PROCESS	NUMBER			Quantity being processed by WIP/PO processes
OUTSTANDING_QUANTITY	NUMBER			Quantity that can be implemented by WIP/PO processes
IMPLEMENT_QUANTITY	NUMBER			Quantity to be implemented
IMPLEMENT_DATE	DATE			Completion date to be implemented
FIRM_QUANTITY	NUMBER			Firm quantity
FIRM_DATE	DATE			Firm completion date
UOM_CODE	VARCHAR2	(3)		Unit of measure
LOCATION_ID	NUMBER			Delivery location identifier
EMPLOYEE_ID	NUMBER	(9)		Employee identifier
PURCH_LINE_NUM	NUMBER			Purchase order line number
DEMAND_CLASS	VARCHAR2	(30)		Demand Class
RESCHEDULED_FLAG	NUMBER			Order rescheduled flag
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column

Query Text

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


SELECT QUERY_ID
,      TRANSACTION_ID
,      LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DESIGNATOR
,      CURRENT_SCHEDULE_DATE
,      NEW_SCHEDULE_DATE
,      CURRENT_ORDER_DATE
,      NEW_ORDER_DATE
,      CURRENT_DOCK_DATE
,      NEW_DOCK_DATE
,      NEW_ORDER_QUANTITY
,      CURRENT_ORDER_QUANTITY
,      ORDER_NUMBER
,      ORDER_TYPE
,      DAILY_RATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_COMPLETION_DATE
,      STATUS_CODE
,      PROCESSING_DAYS
,      FIRM_PLANNED_TYPE
,      LOAD_TYPE
,      WIP_CLASS_CODE
,      DISPOSITION
,      DISPOSITION_STATUS_TYPE
,      QUANTITY_IN_PROCESS
,      OUTSTANDING_QUANTITY
,      IMPLEMENT_QUANTITY
,      IMPLEMENT_DATE
,      FIRM_QUANTITY
,      FIRM_DATE
,      UOM_CODE
,      LOCATION_ID
,      EMPLOYEE_ID
,      PURCH_LINE_NUM
,      DEMAND_CLASS
,      RESCHEDULED_FLAG
,      ATTRIBUTE_CATEGORY
FROM MRP.MRP_WORKBENCH_QUERY;

Dependencies

[top of page]

MRP.MRP_WORKBENCH_QUERY does not reference any database object

MRP.MRP_WORKBENCH_QUERY is referenced by following:

APPS: MRP_WORKBENCH_QUERY