Home » SQL & PL/SQL » SQL & PL/SQL » Help needed
icon9.gif  Help needed [message #218717] Fri, 09 February 2007 09:40
Corbon262
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
Hi I am new to the forum but really need some help.


A code for a mileage claim usually looks like the the following

CCCDB30306000
9ERP0000435 -- Claim amount
CCCZA80000000
9ERP0000041 -- VAT amount
CCCZA80000000
8ERP0000034 -- Number of miles

But we now have new codes that look like this, without VAT or miles info.

CCCDB30306000
9ERP0000585 -- Claim amount

These new codes are not loaded because the procedure I am working on relies on the number of miles code, to load the whole claim into a temp table. So I need to get these new records to load with out having the VAT record or number of miles. Every thing I have tried has not worked. Could someone help please.

The procedure or main section anyway is attached(sorry its a long one)

[Updated on: Fri, 09 February 2007 09:41]

Report message to a moderator

Previous Topic: ORA-00918 on UNIONS
Next Topic: Help with a Trigger (Mutating Trigger)
Goto Forum:
  


Current Time: Sat Dec 03 03:54:25 CST 2016

Total time taken to generate the page: 0.09457 seconds