263: LOC.ADDRESS1
264: INTO V_VALUE
265: FROM
266: HZ_CUST_SITE_USES_ALL CUST_SITE,
267: HZ_PARTY_SITES PARTY_SITE,
268: HZ_LOCATIONS LOC,
269: HZ_CUST_ACCT_SITES ACCT_SITE
270: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
271: AND CUST_SITE.SITE_USE_ID = SHIP_TO_ORG_ID3
288: LOC.ADDRESS1
289: INTO V_VALUE
290: FROM
291: HZ_CUST_SITE_USES_ALL CUST_SITE,
292: HZ_PARTY_SITES PARTY_SITE,
293: HZ_LOCATIONS LOC,
294: HZ_CUST_ACCT_SITES ACCT_SITE
295: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
296: AND CUST_SITE.SITE_USE_ID = INTMED_SHIP_TO_ORG_ID