How to validate the data?
Hi Team,
I have small doubt, can you please provide PL/SQL. logic
process
--------------
we need to transferred all pick confirm data to thrid party system. At their side they do the ship confirm and then we will do it oracle ship confirm .
validation
In case ,
1) if we do back order in oracle in that case we need to remove the data in third party system.based on delivery (done)
2) If we have same data in both systems and if delivery is open, we need to check fields like Quantity,delivery detail id,UOM in both systems.
Here , I have taken cursor but while comparing fields based on delivery how can i check all four fields data is same in both systems.if it is same no need to update on third party tables in case of