Procurement - EBS (MOSC)

MOSC Banner

Is there a way to extract Ship to and Bill to Addresses that have no been used in the last X years?

edited Mar 14, 2024 2:49PM in Procurement - EBS (MOSC) 3 commentsAnswered

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",   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center