[Home] [Help]
185: postal_code hz_locations.postal_code%TYPE,
186: country hz_locations.country%TYPE,
187: country_name fnd_territories_vl.territory_short_name%Type,
188: address varchar2(1000),
189: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
190: geometry_source hz_locations.geometry_source%Type,
191: geometry_source_meaning rrs_lookups_v.meaning%Type,
192: longitude number,
193: latitude number
1644: postal_code hz_locations.postal_code%TYPE,
1645: country hz_locations.country%TYPE,
1646: country_name fnd_territories_vl.territory_short_name%Type,
1647: address varchar2(1000),
1648: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
1649: site_purpose ar_lookups.meaning%type --Bug 7871825
1650: );
1651: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1652: l_site_party_dets local_rrs_site_address_tab;
1793: BULK COLLECT
1794: INTO l_site_party_dets
1795: FROM HZ_LOCATIONS HL
1796: ,FND_TERRITORIES_VL FTV
1797: ,HZ_PARTY_SITES HPS
1798: WHERE COUNTRY = FTV.TERRITORY_CODE
1799: AND HL.LOCATION_ID = HPS.LOCATION_ID
1800: AND HPS.PARTY_ID = l_site_party_id;
1801:
1820: BULK COLLECT
1821: INTO l_site_party_dets
1822: FROM HZ_LOCATIONS HL
1823: ,FND_TERRITORIES_VL FTV
1824: ,HZ_PARTY_SITES HPS
1825: , HZ_PARTY_SITE_USES PSU
1826: WHERE COUNTRY = FTV.TERRITORY_CODE
1827: AND HL.LOCATION_ID = HPS.LOCATION_ID
1828: AND PSU.PARTY_SITE_ID(+) = HPS.PARTY_SITE_ID
2527: BULK COLLECT
2528: INTO l_asset_details
2529: FROM CSI_INSTANCE_SEARCH_V csiiv
2530: ,RRS_SITES_B sites
2531: WHERE csiiv.LOCATION_TYPE_CODE ='HZ_PARTY_SITES'
2532: AND csiiv.LOCATION_ID = sites.PARTY_SITE_ID
2533: AND not (csiiv.INSTANCE_STATUS_ID = 1 )
2534: AND nvl(csiiv.ACTIVE_END_DATE, sysdate+1 ) > sysdate
2535: AND sites.site_id = l_site_id