Welcome Guest [Log In] [Register]
Welcome to [SHEPHARD FAMILY ENTERPRISE LLC]. We hope you enjoy your visit.


You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Create a Procedure to Update a Table; Update using IF - THEN - ELSE
Topic Started: Sep 7 2009, 07:34 PM (133 Views)
shephardfamilyenterprise
Member Avatar
Administrator
[ *  *  * ]
CREATE OR REPLACE PROCEDURE OPERINIT IS

hap_ar_customers.mb39action hap_ar_customers.mb39action%TYPE;
BEGIN
IF hap_ar_customers.mb39action is NOT NULL
and hap_ar_customers.mb33grmcde||hap_ar_customers.mb39grgcde =
ra_customers_interface.customer_number
THEN
Update ra_customers_interface
set customer_attribute5 =
(Select mb39grgaoi
FROM hap_ar_customers
WHERE mb39action is NOT NULL AND
mb33grmcde||mb39grgcde =
ra_customers_interface.customer_number);
ELSE
Update ra_customers_interface
set customer_attribute5 =
(select attribute5
from RA_CUSTOMERS
where ra_customers.orig_system_reference =
ra_customers_interface.orig_system_customer_ref);
END IF;
END OPERINIT;
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Oracle Financials Application · Next Topic »
Add Reply