Home » Applications » Oracle Fusion Apps & E-Business Suite » FORECAST QUANTITY (Oracle Apps
FORECAST QUANTITY [message #305983] Wed, 12 March 2008 08:27
Messages: 16
Registered: September 2007
Junior Member
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

Previous Topic: Workflow Email Notifications
Next Topic: Change ship to organization for approved PO
Goto Forum:

Current Time: Sat Oct 22 14:42:50 CDT 2016

Total time taken to generate the page: 0.07540 seconds