Supplier address query in r12

Supplier address query in r12

In this post , We will be discuss about Supplier address query in r12. This supplier address query will help to extract the supplier addresses maintained for each supplier site in oracle apps r12. We will get the supplier site level address detail in oracle apps r12. This query will also help to extract the others important supplier detail including supplier addresses in r12. Please find below the detail about Supplier address query in r12.

Supplier address query in r12

Important Tables used by Supplier address query in r12

1.AP_SUPPLIERS

2.AP_SUPPLIER_SITES_ALL

Detail Supplier address query in r12

select a2.vendor_name,apss.vendor_site_code,

apss.ADDRESS_LINE1||' '||apss.ADDRESS_LINE2||' '||apss.ADDRESS_LINE3||' '||apss.city||' '||apss.state||' '||apss.zip||' '||(SELECT TERRITORY_SHORT_NAME FROM APPS.FND_TERRITORIES_TL

WHERE TERRITORY_CODE=apss.country) "Supplier Address"

from apps.ap_suppliers a2,apps.ap_supplier_sites_all apss

where a2.vendor_id=apss.vendor_id

order by 5

Supplier address query in r12