264760
264760 PA-7RHJWK CN Load plan report by Area and status
Version :
|
Copyright OBS Logistics © 2009
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
Functional Overview
Client Requirement
Selection Parameters: Order Status - add UNSCHEDULED and ALL to criteria. Booked Status: add ALL to selection.Rename Report to: CN ORDER STATUS REPORT
Added by ss - The report to be changed is CN Load Planning The reports mentioned below are not to be deleted. These can be removed from user view via access control if need be
Solution
Create a copy of the existing report and rename the report ‘CN Order Status Report’.
Create the relevant report records in the following tables
REP_REPORT
REP_REPORT_PARAM
In REP_REPORT create a record for the new report so that is available for selection in the Reports form.
Records added to the REP_REPORT_PARAM table will control which parameters are associated with the new report and the data which will be available to select in the parameters. We must create a record for each parameter which is available in the old report and amend the SQL string field for the Status fields so that the new values are available for selection.
In the new report, amend the data model to select based on the parameter values or the parameter value equals ALL.
Eg (ORDER_STATUS = :P_ORDER_STATUS OR :P_ORDER_STATUS = ‘ALL’)
Ensure the report format is not changed when the user selects ALL for either of the parameters.
Set-up
Data
New records in table REP_REPORT and REP_REPORT_PARAM will be added for report ‘CN Order Status Report’
Functional Description
The CN Load Planning report will be copied and renamed CN Order Status Report.
New entries will be added to REP_REPORT and REP_REPORT_PARAMS will be added for the new report.
The REP_REPORT_PARAMS records will be copied from the existing params for the CN Load Planning report, but with a change to the SQL string. The string for Order Status will be changed to include UNSCHEDULED and ALL, the Booking status will include ALL.
Report to be renamed CN Order Status
Order status will include UNSCHEDULED and ALL. Booking status will include ALL
The layout of the report will remain unchanged. However the data model will be altered to accommodate the new parameter options.
The options will be added to the main query Q_ORD_INFO.
References
| 264760 PA-7RHJWK CN Load Plan Report by Area and Stat v1.0.doc |
|
Document History
| Initial version | ||||
| Reviewed and Issued |
|
Authorised By
| Matt Crisford | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
