| FORECAST QUANTITY [message #305983] |
Wed, 12 March 2008 08:27 |
vishalaksha
Messages: 16
Registered: September 2007
|
Junior Member |
|
|
Hi
I am developing an interface for sending forecast details to some external system.
Here I want to send forecast quantity plus some other information. Forecast quantity is stored in the MRP_FORECAST_DATES table.
Here comes the problem. single record in this table corresponds to multiple forecast entries. A single record in this table is created with following column values.
FORECAST_DATE --forecast start date 26-APR-99
RATE_END_DATE --end date of the forecast 19-JULY-99
ORIGIONAL_FORECAST_QUANTITY --per bucket quantity 1000
CURRENT_FORECAST_QUANTITY --Remaining forecast quantity after consumption 1000
Now This record shows a total forecast quantity of 13000.
If I want to fetch data for specific date range for this entry then it will create problem.
Please give me some suggestion for fetching total quantity for desired period.
[Updated on: Thu, 13 March 2008 06:20] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
