109: hz_cust_acct_sites hzacs,
110: hz_cust_site_uses hzacus,
111: hz_parties hp,
112: hz_cust_accounts hzca,
113: csp_rs_cust_relations ccr
114: ,fnd_territories_vl t
115: where hzl.location_id =hps.location_id
116: and hzl.country = t.territory_code(+)
117: and hps.party_id=hp.party_id
1612: hl.country,
1613: t.territory_short_name,
1614: HPS.START_DATE_ACTIVE,
1615: HPS.END_DATE_ACTIVE
1616: FROM csp_rs_cust_relations csc
1617: , hz_locations hl
1618: , fnd_territories_vl t
1619: , hz_party_sites hps
1620: WHERE csc.resource_id=p_resource_id