APPS.RRS_SITE_INFO dependencies on AR_LOOKUPS

Line 202: site_use_type_code_meaning ar_lookups.meaning%Type,

198: TYPE local_rrs_site_use_rec is RECORD (
199: site_id rrs_site_uses.site_id%TYPE,
200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
204: status_code_meaning rrs_lookups_v.meaning%TYPE,
205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type

Line 385: AR_LOOKUPS LKUP1

381: INTO site_use_rec_details
382: FROM RRS_SITE_USES SiteUseEO,
383: RRS_SITES_B RSB,
384: HZ_PARTY_SITE_USES HPSU,
385: AR_LOOKUPS LKUP1
386: -- ,RRS_LOOKUPS_V LKUP2
387: ,RRS_LOOKUPS_V LKUP3
388: WHERE RSB.SITE_ID = SiteUseEO.SITE_ID
389: AND HPSU.PARTY_SITE_ID(+)= RSB.PARTY_SITE_ID

Line 1649: site_purpose ar_lookups.meaning%type --Bug 7871825

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;
1653:

Line 1817: from AR_LOOKUPS AL

1813: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1814: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1815: HPS.IDENTIFYING_ADDRESS_FLAG,
1816: ( select AL.MEANING
1817: from AR_LOOKUPS AL
1818: where AL.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
1819: AND AL.LOOKUP_CODE = PSU.SITE_USE_TYPE ) site_purpose
1820: BULK COLLECT
1821: INTO l_site_party_dets