DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on AR_LOOKUPS

Line 194: site_use_type_code_meaning ar_lookups.meaning%Type,

190: TYPE local_rrs_site_use_rec is RECORD (
191: site_id rrs_site_uses.site_id%TYPE,
192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
196: status_code_meaning rrs_lookups_v.meaning%TYPE,
197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type

Line 367: AR_LOOKUPS LKUP1

363: INTO site_use_rec_details
364: FROM RRS_SITE_USES SiteUseEO,
365: RRS_SITES_B RSB,
366: HZ_PARTY_SITE_USES HPSU,
367: AR_LOOKUPS LKUP1
368: -- ,RRS_LOOKUPS_V LKUP2
369: ,RRS_LOOKUPS_V LKUP3
370: WHERE RSB.SITE_ID = SiteUseEO.SITE_ID
371: AND HPSU.PARTY_SITE_ID(+)= RSB.PARTY_SITE_ID