Need data for Ship-to locations on AP Invoices - SQL Query for Finance reporting — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need data for Ship-to locations on AP Invoices - SQL Query for Finance reporting

edited Aug 12, 2025 7:26PM in Payables, Payments & Cash Management 7 comments

I need to capture the ship-to locations on the lines of an AP Invoice. Any feedback will be much appreciated. Below is the OTBI SQL QUERY THAT NEEDS MODIFICATION OR IF YOU HAVE A SEPARATE SQL QUERY FOR THE Ship-to locations on AP invoice please POST THAT HERE & I CAN PROBABLY INCLUDE THAT AS A SUB-QUERY IN THIS SQL Code. :

select distinct ps.segment1 supplier_number,
ps.vendor_name supplier_name,
pssv.ADDRESS_LINE1,
pssv.ADDRESS_LINE2,
pssv.city,
pssv.state,
pssv.zip ,
pscv.EMAIL_ADDRESS,
pscv.AREA_CODE||'-'||PSCV.PHONE Phone_Number,
pbc.LOOKUP_CODE,
--- pbc.STATUS,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!