[Home] [Help]
APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on FND_TERRITORIES_VL
Line 1948: fnd_territories_vl fndt
1944: ap_supplier_sites_all aps,
1945: po_lookup_codes plc,
1946: hz_party_sites hps,
1947: hz_locations hzl,
1948: fnd_territories_vl fndt
1949: WHERE aps.party_site_id = hps.party_site_id
1950: AND hps.location_id = hzl.location_id
1951: AND nvl(hps.end_date_active, sysdate) >= sysdate
1952: AND hzl.country = fndt.territory_code