Customer to find from location on R12.1.3

I HAVE CUSTOM SHIP TO LOCATION, AND ITS ID NOW I HAVE TO TRACK THE CUSTOMER NAME.

SELECT * FROM HZ_LOCATIONS WHERE LOCATION_ID = 338403;

FOR RA_ADDRESSES_ALL THE VIEW
IS  DERIVED FROM :
  SELECT LOC.COUNTRY,
    ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID ,
    PROVINCE ,
    POSTAL_CODE,
    STATE ,
    LOC.COUNTRY COUNTRY_CODE,
    CITY ,
    ADDRESS1,
    ADDRESS2,
    ADDRESS3,
    ADDRESS4 ,
    CUST_ACCOUNT_ID CUSTOMER_ID
  FROM HZ_PARTY_SITES PARTY_SITE,
    HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
    HZ_LOCATIONS LOC,
    HZ_CUST_ACCT_SITES_ALL ACCT_SITE
  WHERE ACCT_SITE.PARTY_SITE_ID     = PARTY_SITE.PARTY_SITE_ID
  AND LOC.LOCATION_ID               = PARTY_SITE.LOCATION_ID
  AND LOC.LOCATION_ID               = LOC_ASSIGN.LOCATION_ID
  AND NVL ( ACCT_SITE.ORG_ID, -99 ) = NVL ( LOC_ASSIGN.ORG_ID, -99 ) NOW WE NEED TO DIG
  INTO HZ_PARTY_SITES FOR THIS LOCATION_ID
  SELECT * FROM HZ_PARTY_SITES WHERE LOCATION_ID = 338403; --the same location which we have
  THERE
IS
  PARTY_SITE_ID WHICH WHICH
IS
  USED TO GET CUSTOMER DETAILS FROM HZ_CUST_ACCT_SITES_ALL WHICH GIVEN ME CORRECT CUSTOMER_ACCT_ID.


BINGO !