DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on BOM_CALENDARS

Line 161: description bom_calendars.description%Type,

157: site_status_code_meaning rrs_lookups_v.meaning%TYPE,
158: brandname_code rrs_sites_b.brandname_code%TYPE,
159: brandname_code_meaning rrs_lookups_v.meaning%TYPE,
160: calendar_code rrs_sites_b.calendar_code%TYPE,
161: description bom_calendars.description%Type,
162: location_id rrs_sites_b.location_id%TYPE,
163: site_party_id rrs_sites_b.site_party_id%TYPE,
164: party_site_id rrs_sites_b.party_site_id%TYPE,
165: le_party_site_id rrs_sites_b.le_party_id%TYPE,

Line 249: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP

245: RST.NAME
246: Bulk Collect
247: INTO l_site_header_details
248: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
249: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
250: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
251: and RSB.SITE_ID = RST.SITE_ID
252: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'
253: and LKUP1.LOOKUP_CODE = RSB.SITE_TYPE_CODE