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 148: site_id rrs_sites_b.site_id%TYPE,

144: l_complete_address varchar2(1000);
145:
146:
147: TYPE local_rrs_site_header_rec is RECORD (
148: site_id rrs_sites_b.site_id%TYPE,
149: site_identification_number rrs_sites_b.site_identification_number%TYPE,
150: site_type_code rrs_sites_b.site_type_code%TYPE,
151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
152: site_status_code rrs_sites_b.site_status_code%TYPE,

Line 149: site_identification_number rrs_sites_b.site_identification_number%TYPE,

145:
146:
147: TYPE local_rrs_site_header_rec is RECORD (
148: site_id rrs_sites_b.site_id%TYPE,
149: site_identification_number rrs_sites_b.site_identification_number%TYPE,
150: site_type_code rrs_sites_b.site_type_code%TYPE,
151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
152: site_status_code rrs_sites_b.site_status_code%TYPE,
153: site_status_code_meaning rrs_lookups_v.meaning%TYPE,

Line 150: site_type_code rrs_sites_b.site_type_code%TYPE,

146:
147: TYPE local_rrs_site_header_rec is RECORD (
148: site_id rrs_sites_b.site_id%TYPE,
149: site_identification_number rrs_sites_b.site_identification_number%TYPE,
150: site_type_code rrs_sites_b.site_type_code%TYPE,
151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
152: site_status_code rrs_sites_b.site_status_code%TYPE,
153: site_status_code_meaning rrs_lookups_v.meaning%TYPE,
154: brandname_code rrs_sites_b.brandname_code%TYPE,

Line 152: site_status_code rrs_sites_b.site_status_code%TYPE,

148: site_id rrs_sites_b.site_id%TYPE,
149: site_identification_number rrs_sites_b.site_identification_number%TYPE,
150: site_type_code rrs_sites_b.site_type_code%TYPE,
151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
152: site_status_code rrs_sites_b.site_status_code%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,

Line 154: brandname_code rrs_sites_b.brandname_code%TYPE,

150: site_type_code rrs_sites_b.site_type_code%TYPE,
151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,
152: site_status_code rrs_sites_b.site_status_code%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,

Line 156: calendar_code rrs_sites_b.calendar_code%TYPE,

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

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

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

Line 160: party_site_id rrs_sites_b.party_site_id%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,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,

Line 161: le_party_site_id rrs_sites_b.le_party_id%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,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,

Line 163: property_location_id rrs_sites_b.property_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,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );

Line 164: start_date rrs_sites_b.start_date%TYPE,

160: party_site_id rrs_sites_b.party_site_id%TYPE,
161: le_party_site_id rrs_sites_b.le_party_id%TYPE,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );
168:

Line 165: end_date rrs_sites_b.end_date%TYPE,

161: le_party_site_id rrs_sites_b.le_party_id%TYPE,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );
168:
169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;

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

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

Line 365: RRS_SITES_B RSB,

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

Line 568: FROM RRS_SITES_B RSB

564: Select RSB.SITE_ID
565: ,RSB.LOCATION_ID
566: INTO l_site_id
567: ,l_location_id
568: FROM RRS_SITES_B RSB
569: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
570: Exception
571: When NO_DATA_FOUND Then
572: raise_application_error(-20101, ' Check the Site ID please');

Line 837: FROM RRS_SITES_B RSB

833: Select RSB.SITE_ID
834: ,RSB.LOCATION_ID
835: INTO l_site_id
836: ,l_location_id
837: FROM RRS_SITES_B RSB
838: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
839: Exception
840: When NO_DATA_FOUND Then
841: raise_application_error(-20101, ' Check the Site ID please');

Line 1060: FROM RRS_SITES_B RSB

1056: Select RSB.SITE_ID
1057: ,RSB.LOCATION_ID
1058: INTO l_site_id
1059: ,l_location_id
1060: FROM RRS_SITES_B RSB
1061: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1062: Exception
1063: When NO_DATA_FOUND Then
1064: raise_application_error(-20101, ' Check the Site ID please');

Line 1320: FROM RRS_SITES_B RSB

1316: RSB.SITE_PARTY_ID
1317: INTO l_site_id,
1318: l_location_id,
1319: l_site_party_id
1320: FROM RRS_SITES_B RSB
1321: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1322: Exception
1323: When NO_DATA_FOUND Then
1324: raise_application_error(-20101, ' Check the Site ID please');

Line 1338: rrs_sites_b site,

1334: HAOU.NAME ORGANIZATION_DESCRIPTION
1335: BULK Collect
1336: INTO l_property_details
1337: from
1338: rrs_sites_b site,
1339: HR_ALL_ORGANIZATION_UNITS HAOU,
1340: MTL_PARAMETERS MP
1341: where MP.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1342: and site.ORGANIZATION_ID = HAOU.ORGANIZATION_ID

Line 1698: FROM RRS_SITES_B RSB

1694: Select RSB.SITE_ID,
1695: RSB.SITE_PARTY_ID
1696: INTO l_site_id,
1697: l_site_party_id
1698: FROM RRS_SITES_B RSB
1699: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
1700: Exception
1701: When NO_DATA_FOUND Then
1702: raise_application_error(-20101, ' Check the Site ID please');

Line 2265: FROM RRS_SITES_B RSB

2261:
2262: begin
2263: Select RSB.SITE_ID
2264: INTO l_site_id
2265: FROM RRS_SITES_B RSB
2266: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
2267: Exception
2268: When NO_DATA_FOUND Then
2269: raise_application_error(-20101, ' Check the Site ID please');

Line 2437: FROM RRS_SITES_B RSB

2433:
2434: begin
2435: Select RSB.SITE_ID
2436: INTO l_site_id
2437: FROM RRS_SITES_B RSB
2438: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num;
2439: Exception
2440: When NO_DATA_FOUND Then
2441: raise_application_error(-20101, ' Check the Site ID please');

Line 2457: ,RRS_SITES_B sites

2453: ,csiiv.ACTIVE_START_DATE StartDate
2454: BULK COLLECT
2455: INTO l_asset_details
2456: FROM CSI_INSTANCE_SEARCH_V csiiv
2457: ,RRS_SITES_B sites
2458: WHERE csiiv.LOCATION_TYPE_CODE ='HZ_PARTY_SITES'
2459: AND csiiv.LOCATION_ID = sites.PARTY_SITE_ID
2460: AND not (csiiv.INSTANCE_STATUS_ID = 1 )
2461: AND nvl(csiiv.ACTIVE_END_DATE, sysdate+1 ) > sysdate