Supplier Data

How to find the supplier master data from the data base 

 SELECT APS.VENDOR_ID,
         ASSA.VENDOR_SITE_ID,
         APS.VENDOR_NAME,
         HR.NAME ORG_NAME,
         APS.SEGMENT1,
         APS.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE,
         ASSA.VENDOR_SITE_CODE VENDOR_SITE,
         PAN_NO SITE_PAN_NO,
         GL.CONCATENATED_SEGMENTS LIABILITY_ACCT,
         (SELECT CONCATENATED_SEGMENTS
             FROM APPS.GL_CODE_COMBINATIONS_KFV GL1
                    WHERE GL1.CODE_COMBINATION_ID = ASSA.PREPAY_CODE_COMBINATION_ID)  PREPAYMENT_ACCT,
         ASSA.ADDRESS_LINE1,
         ASSA.ADDRESS_LINE2,
         ASSA.ADDRESS_LINE3,
         ASSA.CITY,
         ASSA.STATE,
         ASSA.ZIP,
         ASSA.EMAIL_ADDRESS,
         ASSA.PHONE PHONE_NO
    FROM APPS.AP_SUPPLIERS APS,
         APPS.AP_SUPPLIER_SITES_ALL ASSA,
         APPS.HR_OPERATING_UNITS HR,
         APPS.JAI_AP_TDS_VENDOR_HDRS JAI,
         APPS.GL_CODE_COMBINATIONS_KFV GL
   WHERE     1 = 1
         AND APS.VENDOR_ID = ASSA.VENDOR_ID
         AND ASSA.ORG_ID = HR.ORGANIZATION_ID
         --AND          HR.SET_OF_BOOKS_ID=2121
       --AND          JAI.VENDOR_ID=APS.VENDOR_ID
         AND JAI.VENDOR_SITE_ID(+) = ASSA.VENDOR_SITE_ID
         AND APS.END_DATE_ACTIVE IS NULL
         AND ASSA.INACTIVE_DATE IS NULL
         AND GL.CODE_COMBINATION_ID = ASSA.ACCTS_PAY_CODE_COMBINATION_ID
         --AND ASSA.ORG_ID =:P_ORG_ID
         --AND          APS.VENDOR_ID=:P_VENDOR_ID
ORDER BY 3


Let me know if any query