8 Commits

Author SHA1 Message Date
andrew.hardy
c621cd7b24 Initial changes to mip_quotation.pck and mip_bulk_load.pck to support PhaseII purging requirements.
New attributes added to Schema/ext_cost.pdc,  Data/BulkLoad/BULK_LOAD.xls (as exported through Data/BulkLoad/MATERIAL_COSTS.csv).

Changes to views V_AICO.vw and V_QUOTE_DETAILS.vw to recognize the new attributes and to stop PURGING being excluded from details.


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12526 248e525c-4dfb-0310-94bc-949c084e9493
2009-09-04 16:29:42 +00:00
hardya
5fc6600a34 Added missing row_number to the select list.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3458 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-04 17:43:14 +00:00
hardya
6c4617b1c3 Bulk Load: Latest version of POSTCODES.csv.
Data/Seed and Data/Test: Correction to apau.ctl to remove duplicates.

Modules/compile.sql: Correction to 'report' query.

Schema/ext...: Check whether external tables have been defined before attempting to drop them.

Schema/v_...: Force creation of views that rely on PL/SQL code. Explicitly name the column returned by V_QUOTE_DETAILS.vw so that the comments can be applied.



git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3452 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-04 10:49:50 +00:00
PriestJ
f9672916f0 ah made changes to build scripts to fix a few errors
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3416 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-29 13:11:12 +00:00
hardya
e9b5c5a125 mip_quotation.pck - produce quotes for 'EXCHANGE'
V_QUOTE_DETAILS.vw - include hou_code

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3303 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-18 16:04:45 +00:00
mullenm
7864d2d918 Added Qmin and column comments to make it easier for other people.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3263 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-16 14:46:43 +00:00
mullenm
eb64acbad1 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3241 248e525c-4dfb-0310-94bc-949c084e9493 2008-01-15 11:20:32 +00:00
mullenm
156c554e00 Added a new view v_quote_details to display details of the quotes to end users for selection purposes.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3193 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-10 15:39:07 +00:00