eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on RRS_SITES_B

Line 152: site_id rrs_sites_b.site_id%TYPE,

148: l_complete_address varchar2(1000);
149:
150:
151: TYPE local_rrs_site_header_rec is RECORD (
152: site_id rrs_sites_b.site_id%TYPE,
153: site_identification_number rrs_sites_b.site_identification_number%TYPE,
154: site_type_code rrs_sites_b.site_type_code%TYPE,
155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
156: site_status_code rrs_sites_b.site_status_code%TYPE,

Line 153: site_identification_number rrs_sites_b.site_identification_number%TYPE,

149:
150:
151: TYPE local_rrs_site_header_rec is RECORD (
152: site_id rrs_sites_b.site_id%TYPE,
153: site_identification_number rrs_sites_b.site_identification_number%TYPE,
154: site_type_code rrs_sites_b.site_type_code%TYPE,
155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
156: site_status_code rrs_sites_b.site_status_code%TYPE,
157: site_status_code_meaning rrs_lookups_v.meaning%TYPE,

Line 154: site_type_code rrs_sites_b.site_type_code%TYPE,

150:
151: TYPE local_rrs_site_header_rec is RECORD (
152: site_id rrs_sites_b.site_id%TYPE,
153: site_identification_number rrs_sites_b.site_identification_number%TYPE,
154: site_type_code rrs_sites_b.site_type_code%TYPE,
155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
156: site_status_code rrs_sites_b.site_status_code%TYPE,
157: site_status_code_meaning rrs_lookups_v.meaning%TYPE,
158: brandname_code rrs_sites_b.brandname_code%TYPE,

Line 156: site_status_code rrs_sites_b.site_status_code%TYPE,

152: site_id rrs_sites_b.site_id%TYPE,
153: site_identification_number rrs_sites_b.site_identification_number%TYPE,
154: site_type_code rrs_sites_b.site_type_code%TYPE,
155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
156: site_status_code rrs_sites_b.site_status_code%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,

Line 158: brandname_code rrs_sites_b.brandname_code%TYPE,

154: site_type_code rrs_sites_b.site_type_code%TYPE,
155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
156: site_status_code rrs_sites_b.site_status_code%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,

Line 160: calendar_code rrs_sites_b.calendar_code%TYPE,

156: site_status_code rrs_sites_b.site_status_code%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,

Line 162: location_id rrs_sites_b.location_id%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,
166: party_name hz_parties.party_name%Type,

Line 163: site_party_id rrs_sites_b.site_party_id%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,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,

Line 164: party_site_id rrs_sites_b.party_site_id%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,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,

Line 165: le_party_site_id rrs_sites_b.le_party_id%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,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,

Line 167: property_location_id rrs_sites_b.property_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,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );

Line 168: start_date rrs_sites_b.start_date%TYPE,

164: party_site_id rrs_sites_b.party_site_id%TYPE,
165: le_party_site_id rrs_sites_b.le_party_id%TYPE,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );
172:

Line 169: end_date rrs_sites_b.end_date%TYPE,

165: le_party_site_id rrs_sites_b.le_party_id%TYPE,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );
172:
173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;

Line 248: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2

244: RSB.END_DATE,
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'

Line 383: RRS_SITES_B RSB,

379: --,LKUP2.MEANING AS IS_PRIMARY_FLAG_MEANING
380: BULK COLLECT
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

Line 586: FROM RRS_SITES_B RSB

582: Select RSB.SITE_ID
583: ,RSB.LOCATION_ID
584: INTO l_site_id
585: ,l_location_id
586: FROM RRS_SITES_B RSB
587: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
588: Exception
589: When NO_DATA_FOUND Then
590: raise_application_error(-20101, ' Check the Site ID please');

Line 855: FROM RRS_SITES_B RSB

851: Select RSB.SITE_ID
852: ,RSB.LOCATION_ID
853: INTO l_site_id
854: ,l_location_id
855: FROM RRS_SITES_B RSB
856: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
857: Exception
858: When NO_DATA_FOUND Then
859: raise_application_error(-20101, ' Check the Site ID please');

Line 1078: FROM RRS_SITES_B RSB

1074: Select RSB.SITE_ID
1075: ,RSB.LOCATION_ID
1076: INTO l_site_id
1077: ,l_location_id
1078: FROM RRS_SITES_B RSB
1079: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1080: Exception
1081: When NO_DATA_FOUND Then
1082: raise_application_error(-20101, ' Check the Site ID please');

Line 1339: FROM RRS_SITES_B RSB

1335: RSB.SITE_PARTY_ID
1336: INTO l_site_id,
1337: l_location_id,
1338: l_site_party_id
1339: FROM RRS_SITES_B RSB
1340: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1341: Exception
1342: When NO_DATA_FOUND Then
1343: raise_application_error(-20101, ' Check the Site ID please');

Line 1357: rrs_sites_b site,

1353: HAOU.NAME ORGANIZATION_DESCRIPTION
1354: BULK Collect
1355: INTO l_property_details
1356: from
1357: rrs_sites_b site,
1358: HR_ALL_ORGANIZATION_UNITS HAOU,
1359: MTL_PARAMETERS MP
1360: where MP.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1361: and site.ORGANIZATION_ID = HAOU.ORGANIZATION_ID

Line 1768: FROM RRS_SITES_B RSB

1764: Select RSB.SITE_ID,
1765: RSB.SITE_PARTY_ID
1766: INTO l_site_id,
1767: l_site_party_id
1768: FROM RRS_SITES_B RSB
1769: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1770: Exception
1771: When NO_DATA_FOUND Then
1772: raise_application_error(-20101, ' Check the Site ID please');

Line 2338: FROM RRS_SITES_B RSB

2334:
2335: begin
2336: Select RSB.SITE_ID
2337: INTO l_site_id
2338: FROM RRS_SITES_B RSB
2339: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
2340: Exception
2341: When NO_DATA_FOUND Then
2342: raise_application_error(-20101, ' Check the Site ID please');

Line 2510: FROM RRS_SITES_B RSB

2506:
2507: begin
2508: Select RSB.SITE_ID
2509: INTO l_site_id
2510: FROM RRS_SITES_B RSB
2511: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
2512: Exception
2513: When NO_DATA_FOUND Then
2514: raise_application_error(-20101, ' Check the Site ID please');

Line 2530: ,RRS_SITES_B sites

2526: ,csiiv.ACTIVE_START_DATE StartDate
2527: BULK COLLECT
2528: INTO l_asset_details
2529: FROM CSI_INSTANCE_SEARCH_V csiiv
2530: ,RRS_SITES_B sites
2531: WHERE csiiv.LOCATION_TYPE_CODE ='HZ_PARTY_SITES'
2532: AND csiiv.LOCATION_ID = sites.PARTY_SITE_ID
2533: AND not (csiiv.INSTANCE_STATUS_ID = 1 )
2534: AND nvl(csiiv.ACTIVE_END_DATE, sysdate+1 ) > sysdate