90: HZ_PARTIES HZP,
91: HZ_CUST_ACCOUNTS CA,
92: HZ_CUST_ACCT_SITES CAS,
93: HZ_LOCATIONS LOC,
94: HZ_PARTY_SITES PARTY_SITE,
95: FND_TERRITORIES_VL TERR
96: WHERE SEARCH_CONTEXT_ID = p_context_id
97: AND GT.PARTY_ID = HZP.PARTY_ID
98: AND GT.PARTY_ID = CA.PARTY_ID(+)