APPS.RRS_SITE_INFO dependencies on HZ_PARTY_SITES

Line 185: identifying_address_flag hz_party_sites.identifying_address_flag%Type

181: postal_code hz_locations.postal_code%TYPE,
182: country hz_locations.country%TYPE,
183: country_name fnd_territories_vl.territory_short_name%Type,
184: address varchar2(1000),
185: identifying_address_flag hz_party_sites.identifying_address_flag%Type
186: );
187: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
188: l_site_address_details local_rrs_site_address_tab;
189:

Line 1581: identifying_address_flag hz_party_sites.identifying_address_flag%Type

1577: postal_code hz_locations.postal_code%TYPE,
1578: country hz_locations.country%TYPE,
1579: country_name fnd_territories_vl.territory_short_name%Type,
1580: address varchar2(1000),
1581: identifying_address_flag hz_party_sites.identifying_address_flag%Type
1582: );
1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1584: l_site_party_dets local_rrs_site_address_tab;
1585:

Line 1728: ,HZ_PARTY_SITES HPS

1724: BULK COLLECT
1725: INTO l_site_party_dets
1726: FROM HZ_LOCATIONS HL
1727: ,FND_TERRITORIES_VL FTV
1728: ,HZ_PARTY_SITES HPS
1729: WHERE COUNTRY = FTV.TERRITORY_CODE
1730: AND HL.LOCATION_ID = HPS.LOCATION_ID
1731: AND HPS.PARTY_ID = l_site_party_id;
1732:

Line 1752: ,HZ_PARTY_SITES HPS

1748: BULK COLLECT
1749: INTO l_site_party_dets
1750: FROM HZ_LOCATIONS HL
1751: ,FND_TERRITORIES_VL FTV
1752: ,HZ_PARTY_SITES HPS
1753: WHERE COUNTRY = FTV.TERRITORY_CODE
1754: AND HL.LOCATION_ID = HPS.LOCATION_ID
1755: AND HPS.PARTY_ID = l_site_party_id;
1756:

Line 2458: WHERE csiiv.LOCATION_TYPE_CODE ='HZ_PARTY_SITES'

2454: BULK COLLECT
2455: INTO l_asset_details
2456: FROM CSI_INSTANCE_SEARCH_V csiiv
2457: ,RRS_SITES_B sites
2458: WHERE csiiv.LOCATION_TYPE_CODE ='HZ_PARTY_SITES'
2459: AND csiiv.LOCATION_ID = sites.PARTY_SITE_ID
2460: AND not (csiiv.INSTANCE_STATUS_ID = 1 )
2461: AND nvl(csiiv.ACTIVE_END_DATE, sysdate+1 ) > sysdate
2462: AND sites.site_id = l_site_id