VIEW: APPS.CSI_CP_ADDRESSES_V

Source

View Text - Preformatted

SELECT /*+ FIRST_ROWS */ party_site.party_site_id Location, hl.description DESCRIPTION, hzp.party_name Party_Name, party_site.party_site_name PARTY_SITE_NAME, hl.address1 ADDRESS1, hl.address2 ADDRESS2, hl.address3 ADDRESS3, hl.address4 ADDRESS4, hl.city CITY, hl.state STATE, hl.postal_code ZIP, hl.country COUNTRY, hzp.party_id PARTY_ID, hca.cust_account_id CUST_ACCOUNT_ID, party_site.party_site_number site_number FROM hz_locations hl, hz_parties hzp, hz_party_sites party_site, hz_cust_accounts hca WHERE hl.location_id = party_site.location_id and party_site.party_id = hca.party_id and party_site.party_id = hzp.party_id and party_site.status = 'A'

View Text - HTML Formatted

SELECT /*+ FIRST_ROWS */ PARTY_SITE.PARTY_SITE_ID LOCATION
, HL.DESCRIPTION DESCRIPTION
, HZP.PARTY_NAME PARTY_NAME
, PARTY_SITE.PARTY_SITE_NAME PARTY_SITE_NAME
, HL.ADDRESS1 ADDRESS1
, HL.ADDRESS2 ADDRESS2
, HL.ADDRESS3 ADDRESS3
, HL.ADDRESS4 ADDRESS4
, HL.CITY CITY
, HL.STATE STATE
, HL.POSTAL_CODE ZIP
, HL.COUNTRY COUNTRY
, HZP.PARTY_ID PARTY_ID
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY_SITE.PARTY_SITE_NUMBER SITE_NUMBER
FROM HZ_LOCATIONS HL
, HZ_PARTIES HZP
, HZ_PARTY_SITES PARTY_SITE
, HZ_CUST_ACCOUNTS HCA
WHERE HL.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND PARTY_SITE.PARTY_ID = HCA.PARTY_ID
AND PARTY_SITE.PARTY_ID = HZP.PARTY_ID
AND PARTY_SITE.STATUS = 'A'