[Home] [Help] [Dependency Information]
Object Name: | MRP_DAILY_SCHEDULES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_DAILY_SCHEDULES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|