DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on BOM_CALENDARS

Line 157: description bom_calendars.description%Type,

153: site_status_code_meaning rrs_lookups_v.meaning%TYPE,
154: brandname_code rrs_sites_b.brandname_code%TYPE,
155: brandname_code_meaning rrs_lookups_v.meaning%TYPE,
156: calendar_code rrs_sites_b.calendar_code%TYPE,
157: description bom_calendars.description%Type,
158: location_id rrs_sites_b.location_id%TYPE,
159: site_party_id rrs_sites_b.site_party_id%TYPE,
160: party_site_id rrs_sites_b.party_site_id%TYPE,
161: le_party_site_id rrs_sites_b.le_party_id%TYPE,

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

237: RST.NAME
238: Bulk Collect
239: INTO l_site_header_details
240: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
241: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
242: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
243: and RSB.SITE_ID = RST.SITE_ID
244: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'
245: and LKUP1.LOOKUP_CODE = RSB.SITE_TYPE_CODE