Advertisement
Guest User

Untitled

a guest
Nov 15th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.32 KB | None | 0 0
  1. SELECT old.account_number,
  2.        old.attribute6,
  3.        NEW.attribute6,
  4.        old.attribute17,
  5.        NEW.attribute17
  6. FROM apps.hca_save_for_datafix old,
  7.      apps.hz_cust_accounts NEW
  8. WHERE old.cust_account_id = NEW.cust_account_id
  9.   AND (old.attribute6 != NEW.attribute6 OR old.attribute17 != NEW.attribute17)
  10. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement