44: ,upper(PARTY.party_name) party_name
45: , LOC.state state
46: , LOC.postal_code postal_code
47: , PARTY.party_id party_id
48: from HZ_PARTY_SITES SITE
49: , HZ_LOCATIONS LOC
50: , HZ_PARTIES PARTY
51: , as_accesses_all AAA
52: , as_territory_accesses ATA
67: , upper(PARTY.party_name) party_name
68: , LOC.state state
69: , LOC.postal_code postal_code
70: , PARTY.party_id party_id
71: from HZ_PARTY_SITES SITE
72: , HZ_LOCATIONS LOC
73: , HZ_PARTIES PARTY
74: , AS_LEADS_ALL LEAD
75: , as_accesses_all AAA
90: , upper(PARTY.party_name) party_name
91: , LOC.state state
92: , LOC.postal_code postal_code
93: , PARTY.party_id party_id
94: from HZ_PARTY_SITES SITE
95: , HZ_LOCATIONS LOC
96: , HZ_PARTIES PARTY
97: , as_accesses_all AAA
98: , as_territory_accesses ATA