Versions Compared

Version Old Version 15 New Version 16
Changes made by

Adam Chang

Adam Chang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
SELECT 
a.vndr_addr_gnrtd_id,
'true' AS VALID
FROM PUR_VNDR_ADDR_T a 
WHERE 
(
 (a.VNDR_ADDR_GNRTD_ID =IN ('21626') OR 
 (a.VNDR_ADDR_GNRTD_ID =, '21627') OR 
 (a.VNDR_ADDR_GNRTD_ID =, '0000')
);

Result Schema: A list of following elements (VendorAddressValidation.java)

...