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_DAILY_SCHEDULES_V

Object Details

Object Name:	MRP_DAILY_SCHEDULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_DAILY_SCHEDULES_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	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
SCHEDULE_DESIGNATOR	VARCHAR2	(10)	Yes	Master schedule identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
BUCKET_DATE	DATE		Yes	Bucket Date
SCHEDULE_DATE	DATE			Schedule date
CURRENT_QUANTITY	NUMBER			Current schedule quantity
ORIGINAL_QUANTITY	NUMBER			Original schedule quantity
SCHEDULE_LEVEL	NUMBER		Yes	Master schedule level
SALES_ORDER_QTY	NUMBER			Quantity from sales order
ORIGINAL_SALES_ORDER_QTY	NUMBER			Original quantity from sales order
FORECAST_QTY	NUMBER			Quantity from forecasts
ORIGINAL_FORECAST_QTY	NUMBER			Original quantity from forecasts
MPS_PLAN_QTY	NUMBER			Quantity from MPS plan
ORIGINAL_MPS_PLAN_QTY	NUMBER			Original quantity from MPS plan
COPIED_SCHED_QTY	NUMBER			Quantity copied from schedules
ORIGINAL_COPIED_SCHED_QTY	NUMBER			Original quantity copied from schedules
INTERORG_QTY	NUMBER			Quantity from interorg planned orders
ORIGINAL_INTERORG_QTY	NUMBER			Original quantity from interorg planned orders
EXPLODED_QTY	NUMBER			Quantity from exploded entries
ORIGINAL_EXPLODED_QTY	NUMBER			Original quantity from exploded entries
MANUAL_QTY	NUMBER			Quantity from manual entries
ORIGINAL_MANUAL_QTY	NUMBER			Original quantity from manual entries

Query Text

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


SELECT ORGANIZATION_ID
,      SCHEDULE_DESIGNATOR
,      INVENTORY_ITEM_ID
,      BUCKET_DATE
,      SCHEDULE_DATE
,      CURRENT_QUANTITY
,      ORIGINAL_QUANTITY
,      SCHEDULE_LEVEL
,      SALES_ORDER_QTY
,      ORIGINAL_SALES_ORDER_QTY
,      FORECAST_QTY
,      ORIGINAL_FORECAST_QTY
,      MPS_PLAN_QTY
,      ORIGINAL_MPS_PLAN_QTY
,      COPIED_SCHED_QTY
,      ORIGINAL_COPIED_SCHED_QTY
,      INTERORG_QTY
,      ORIGINAL_INTERORG_QTY
,      EXPLODED_QTY
,      ORIGINAL_EXPLODED_QTY
,      MANUAL_QTY
,      ORIGINAL_MANUAL_QTY
FROM APPS.MRP_DAILY_SCHEDULES_V;

Dependencies

[top of page]

APPS.MRP_DAILY_SCHEDULES_V references the following:

APPS: BOM_CALENDAR_DATES; MRP_ORGANIZATIONS_V; MRP_SCHEDULE_DATES; MRP_SCHEDULE_DESIGNATORS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B

APPS.MRP_DAILY_SCHEDULES_V is referenced by following:

APPS: MRP_SCHEDULE - show dependent code