Is there a way to extract Ship to and Bill to Addresses that have no been used in the last X years?
As part of a data cleanup project, I am trying to extract bill to and ship to addresses that were not used in the last 4 years. I am thinking that I could probably do a full extract of all the existing bill to/ship to addresses today and then do another extract with these addresses that were used as part of PR/POs. Am I approaching this in the right way? Would like some suggestions or guidance. The following query is what I have in terms of extracting all bill-to/ship-to addresses today:
select distinct decode (hcsua.site_use_code, 'SHIP_TO', hcsua.location) "Customer Ship-To Code",