Query for supplier list in Oracle ebs R12

 select
AP.VENDOR_NAME VENDOR_NAME,
         AP.SEGMENT1 VENDOR_NUM,
         AP.VENDOR_ID ,
         APS.VENDOR_SITE_ID SITE_ID,
         APS.VENDOR_SITE_CODE VENDOR_SITE_CODE
FROM     AP_SUPPLIERS AP,
         AP_SUPPLIER_SITES_ALL APS
WHERE    1 = 1
AND      AP.VENDOR_ID = APS.VENDOR_ID
and aps.org_id = 1285
order by 1