Need data for Ship-to locations on AP Invoices - SQL Query for Finance reporting
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,