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: APPS.MRP_ORDERS_V

Object Details

Object Name:	MRP_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_ORDERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE_TABLE	VARCHAR2	(22)	Source table
ROW_ID	ROWID	(10)	Rowid
TRANSACTION_ID	NUMBER		Transaction identifier
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
ORGANIZATION_ID	NUMBER		Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	MPS, MRP or DRP plan identifier
NEW_DUE_DATE	DATE		Order suggested due date
OLD_DUE_DATE	DATE		Old order due date
NEW_START_DATE	DATE		Suggested start date
DISPOSITION_ID	NUMBER		Order identifier
ORDER_NUMBER	VARCHAR2	(240)	Order number
DISPOSITION_STATUS_TYPE	NUMBER		Disposition type code
ORDER_TYPE	NUMBER		Order type code
ORDER_TYPE_TEXT	VARCHAR2	(80)	Order type text
VENDOR_ID	NUMBER		Supplier identifier
VENDOR_NAME	VARCHAR2	(0)	Supplier name
QUANTITY_RATE	NUMBER		Order quantity
OLD_ORDER_QUANTITY	NUMBER		Old order quantity
NEW_ORDER_DATE	DATE		Suggested order date
FIRM_PLANNED_TYPE	NUMBER		Firm flag
RESCHEDULED_FLAG	NUMBER		Flag indicating if this row been rescheduled using the Planner Workbench form
NEW_PROCESSING_DAYS	NUMBER		Repetitive schedule processing days
IMPLEMENTED_QUANTITY	NUMBER		Planned order implemented quantity
LAST_UNIT_COMPLETION_DATE	DATE		Last unit completion date for recommended repetitive schedules
FIRST_UNIT_START_DATE	DATE		First unit start date for repetitive schedules
LAST_UNIT_START_DATE	DATE		Last unit start date for repetitive schedules
NEW_DOCK_DATE	DATE		Suggested dock date
QUANTITY_IN_PROCESS	NUMBER		Quantity being processed by the WIP/PO interface processes
FIRM_QUANTITY	NUMBER		Firm planned quantity
FIRM_DATE	DATE		Firm planned order date
REPETITIVE_LINE	NUMBER		Repetitive line identifier
LINE_CODE	VARCHAR2	(10)	Repetitive line
IMPLEMENT_DEMAND_CLASS	VARCHAR2	(30)	Implement Demand Classs
ITEM_SEGMENTS	VARCHAR2	(40)	Item segments
IMPLEMENT_DATE	DATE		Implement due date
IMPLEMENT_QUANTITY_RATE	NUMBER		Implement quantity
IMPLEMENT_FIRM	NUMBER		Implement firm type
IMPLEMENT_PROCESSING_DAYS	NUMBER		Implement processing days
IMPLEMENT_WIP_CLASS_CODE	VARCHAR2	(10)	Implement WIP job class code
IMPLEMENT_JOB_NAME	VARCHAR2	(240)	Implement job name
IMPLEMENT_LINE_ID	NUMBER		Implement repetitive line identifier
IMPLEMENT_DOCK_DATE	DATE		Implement dock date
IMPLEMENT_STATUS_CODE	NUMBER		Implement job status code
IMPLEMENT_EMPLOYEE_ID	NUMBER		Implement employee identifier
IMPLEMENT_UOM_CODE	VARCHAR2	(3)	Implement UOM code
IMPLEMENT_LOCATION_ID	NUMBER		Implement location identifier
RELEASE_STATUS	NUMBER		Realease status
LOAD_TYPE	NUMBER		Load program to execute
IMPLEMENT_AS	NUMBER		Implement order type
IMPLEMENT_AS_TEXT	VARCHAR2	(80)	Implement order type text
PLANNER_CODE	VARCHAR2	(10)	Planner code
USING_ASSEMBLY_ITEM_ID	NUMBER		Using assembly identifier
CATEGORY	NUMBER		Category name
MRP_PLANNING_CODE	NUMBER		MRP planning code
REPETITIVE_TYPE	NUMBER		Is this item built repetitively?
BUILD_IN_WIP_FLAG	NUMBER		Flag to indicate if this item can be built in WIP
PURCHASING_ENABLED_FLAG	NUMBER		Purchasing enabled flag
PLANNING_MAKE_BUY_CODE	NUMBER		Make or Buy code text
DAYS_FROM_TODAY	NUMBER		Days from today to order date
BOM_ITEM_TYPE	NUMBER		Bom item type
BASE_ITEM_ID	NUMBER		Base model for this configuration
WIP_SUPPLY_TYPE	NUMBER		WIP supply type
SOURCE_ORGANIZATION_CODE	VARCHAR2	(3)	Source organization name
STATUS_CODE	NUMBER		Status code
USING_ASSEMBLY_ITEM_NAME	VARCHAR2	(40)	Using assembly name
FULL_PEGGING	NUMBER		Is this item full pegged
SCHEDULE_COMPRESSION_DAYS	NUMBER		Order Schedule Compression Days

Query Text

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


SELECT SOURCE_TABLE
,      ROW_ID
,      TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      NEW_DUE_DATE
,      OLD_DUE_DATE
,      NEW_START_DATE
,      DISPOSITION_ID
,      ORDER_NUMBER
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      VENDOR_ID
,      VENDOR_NAME
,      QUANTITY_RATE
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_DATE
,      FIRM_PLANNED_TYPE
,      RESCHEDULED_FLAG
,      NEW_PROCESSING_DAYS
,      IMPLEMENTED_QUANTITY
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      NEW_DOCK_DATE
,      QUANTITY_IN_PROCESS
,      FIRM_QUANTITY
,      FIRM_DATE
,      REPETITIVE_LINE
,      LINE_CODE
,      IMPLEMENT_DEMAND_CLASS
,      ITEM_SEGMENTS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY_RATE
,      IMPLEMENT_FIRM
,      IMPLEMENT_PROCESSING_DAYS
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_LINE_ID
,      IMPLEMENT_DOCK_DATE
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_EMPLOYEE_ID
,      IMPLEMENT_UOM_CODE
,      IMPLEMENT_LOCATION_ID
,      RELEASE_STATUS
,      LOAD_TYPE
,      IMPLEMENT_AS
,      IMPLEMENT_AS_TEXT
,      PLANNER_CODE
,      USING_ASSEMBLY_ITEM_ID
,      CATEGORY
,      MRP_PLANNING_CODE
,      REPETITIVE_TYPE
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      DAYS_FROM_TODAY
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      WIP_SUPPLY_TYPE
,      SOURCE_ORGANIZATION_CODE
,      STATUS_CODE
,      USING_ASSEMBLY_ITEM_NAME
,      FULL_PEGGING
,      SCHEDULE_COMPRESSION_DAYS
FROM APPS.MRP_ORDERS_V;

Dependencies

[top of page]

APPS.MRP_ORDERS_V references the following:

APPS: MFG_LOOKUPS; MRP_GROSS_REQUIREMENTS; MRP_ITEM_PURCHASE_ORDERS; MRP_ITEM_WIP_ENTITIES; MRP_RECOMMENDATIONS; MRP_SCHEDULE_DATES; MRP_SUGG_REP_SCHEDULES; MRP_SYSTEM_ITEMS; MTL_ITEM_FLEXFIELDS; MTL_PARAMETERS; MTL_SALES_ORDERS; WIP_ENTITIES; WIP_LINES

APPS.MRP_ORDERS_V is not referenced by any database object