Home » RDBMS Server » Server Administration » I need an PL/SQL algorithm to hand combination searching
I need an PL/SQL algorithm to hand combination searching [message #370497] Mon, 06 December 1999 16:22
older-wheel-user
Messages: 2
Registered: December 1999
Junior Member
AP matching algorithm

I had a task to write an algorithm which will be able to match following cases:

I had 6 receipts with the 4 fields: PO, PO line, part id and unit of purchase match a single invoice record with same above 4 fields (except one quantity field). But the total line quantities for the 3 receipts totals more than the invoice quantity, then I have to check to see if the sum of 2 or more of quantity of the above 6 receipts will equal the invoice quantity. If so, then mark the receipts as been matched to the invoice.

Basically, I need an algorithm to handle the combination search in PL/SQL script. I do not like to reinvent the wheel since I assume somebody already done it or due day is pressing me to hard. I can not use the AP interface since our client do not have oracle financial staff.

Good luck to myself.

thanks
Previous Topic: Re: CLOB to VARCHAR2
Next Topic: trigger with warning message
Goto Forum:
  


Current Time: Wed Oct 28 06:58:23 CDT 2020