DBA Data[Home] [Help]

APPS.OTAP_CMERGE dependencies on HZ_PARTY_SITES

Line 375: HZ_PARTY_SITES PARTY_SITE,

371: LOC.COUNTY||DECODE(LOC.COUNTY,NULL,'',', ')||
372: LOC.POSTAL_CODE||DECODE(LOC.POSTAL_CODE,NULL,'',', ')||
373: LOC.COUNTRY ADDRESS
374: FROM
375: HZ_PARTY_SITES PARTY_SITE,
376: HZ_LOCATIONS LOC,
377: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
378: WHERE
379: LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID