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_LOOKUPS_V

Line 155: site_type_code_meaning rrs_lookups_v.meaning%TYPE,

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,
159: brandname_code_meaning rrs_lookups_v.meaning%TYPE,

Line 157: site_status_code_meaning rrs_lookups_v.meaning%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,
161: description bom_calendars.description%Type,

Line 159: brandname_code_meaning rrs_lookups_v.meaning%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,
163: site_party_id rrs_sites_b.site_party_id%TYPE,

Line 191: geometry_source_meaning rrs_lookups_v.meaning%Type,

187: country_name fnd_territories_vl.territory_short_name%Type,
188: address varchar2(1000),
189: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
190: geometry_source hz_locations.geometry_source%Type,
191: geometry_source_meaning rrs_lookups_v.meaning%Type,
192: longitude number,
193: latitude number
194: );
195: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

Line 204: status_code_meaning rrs_lookups_v.meaning%TYPE,

200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
204: status_code_meaning rrs_lookups_v.meaning%TYPE,
205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
207: );
208: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;

Line 206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type

202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
204: status_code_meaning rrs_lookups_v.meaning%TYPE,
205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
207: );
208: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
209: site_use_rec_details local_rrs_site_uses_tab;
210:

Line 219: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;

215: l_is_primary_flag_selector varchar2(1);
216: l_party_site_use_id number;
217: l_object_version_number number;
218:
219: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
220:
221: l_lookup_code rrs_lookups_v.lookup_code%Type;
222: l_lookup_type rrs_lookups_v.lookup_type%Type;
223:

Line 221: l_lookup_code rrs_lookups_v.lookup_code%Type;

217: l_object_version_number number;
218:
219: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
220:
221: l_lookup_code rrs_lookups_v.lookup_code%Type;
222: l_lookup_type rrs_lookups_v.lookup_type%Type;
223:
224: Begin
225:

Line 222: l_lookup_type rrs_lookups_v.lookup_type%Type;

218:
219: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
220:
221: l_lookup_code rrs_lookups_v.lookup_code%Type;
222: l_lookup_type rrs_lookups_v.lookup_type%Type;
223:
224: Begin
225:
226: Begin

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 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

Line 334: ( SELECT rlv.meaning FROM RRS_LOOKUPS_V rlv WHERE rlv.lookup_type = 'RRS_GEO_SOURCE'

330: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
331: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
332: 'Y' as IDENTIFYING_ADDRESS_FLAG ,
333: GEOMETRY_SOURCE,
334: ( SELECT rlv.meaning FROM RRS_LOOKUPS_V rlv WHERE rlv.lookup_type = 'RRS_GEO_SOURCE'
335: AND rlv.lookup_code = HL.GEOMETRY_SOURCE ) GEOMETRY_SOURCE_MEANING,
336: ROUND(HL.geometry.SDO_POINT.X,8) Longitude,
337: ROUND(HL.geometry.SDO_POINT.Y,8) Latitude
338: Bulk Collect

Line 386: -- ,RRS_LOOKUPS_V LKUP2

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
388: WHERE RSB.SITE_ID = SiteUseEO.SITE_ID
389: AND HPSU.PARTY_SITE_ID(+)= RSB.PARTY_SITE_ID
390: AND DECODE(HPSU.PARTY_SITE_ID,null,'-999',SiteUseEO.SITE_USE_TYPE_CODE) = nvl(HPSU.SITE_USE_TYPE,'-999')

Line 387: ,RRS_LOOKUPS_V LKUP3

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
388: WHERE RSB.SITE_ID = SiteUseEO.SITE_ID
389: AND HPSU.PARTY_SITE_ID(+)= RSB.PARTY_SITE_ID
390: AND DECODE(HPSU.PARTY_SITE_ID,null,'-999',SiteUseEO.SITE_USE_TYPE_CODE) = nvl(HPSU.SITE_USE_TYPE,'-999')
391: and LKUP1.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'

Line 567: lookup_code rrs_lookups_v.lookup_code%Type,

563: Type trade_area_id is table of number;
564: l_trade_area_ids trade_area_id;
565:
566: Type rrs_entity_rec is Record(
567: lookup_code rrs_lookups_v.lookup_code%Type,
568: meaning rrs_lookups_v.meaning%Type
569: );
570: Type rrs_entity_tab is table of rrs_entity_rec;
571: l_rrs_entity rrs_entity_tab;

Line 568: meaning rrs_lookups_v.meaning%Type

564: l_trade_area_ids trade_area_id;
565:
566: Type rrs_entity_rec is Record(
567: lookup_code rrs_lookups_v.lookup_code%Type,
568: meaning rrs_lookups_v.meaning%Type
569: );
570: Type rrs_entity_tab is table of rrs_entity_rec;
571: l_rrs_entity rrs_entity_tab;
572:

Line 573: l_rrs_entity_name rrs_lookups_v.meaning%Type;

569: );
570: Type rrs_entity_tab is table of rrs_entity_rec;
571: l_rrs_entity rrs_entity_tab;
572:
573: l_rrs_entity_name rrs_lookups_v.meaning%Type;
574:
575:
576: BEGIN
577:

Line 596: from RRS_LOOKUPS_V

592: end;
593:
594: Select meaning
595: INTO l_rrs_entity_name
596: from RRS_LOOKUPS_V
597: where LOOKUP_TYPE= 'RRS_ENTITY'
598: and LOOKUP_CODE = 'RRS_SITE';
599:
600:

Line 832: lookup_code rrs_lookups_v.lookup_code%Type,

828: l_attr_grp_name attr_grp_name;
829:
830:
831: Type rrs_entity_rec is Record(
832: lookup_code rrs_lookups_v.lookup_code%Type,
833: meaning rrs_lookups_v.meaning%Type
834: );
835: Type rrs_entity_tab is table of rrs_entity_rec;
836: l_rrs_entity rrs_entity_tab;

Line 833: meaning rrs_lookups_v.meaning%Type

829:
830:
831: Type rrs_entity_rec is Record(
832: lookup_code rrs_lookups_v.lookup_code%Type,
833: meaning rrs_lookups_v.meaning%Type
834: );
835: Type rrs_entity_tab is table of rrs_entity_rec;
836: l_rrs_entity rrs_entity_tab;
837:

Line 838: l_rrs_entity_name rrs_lookups_v.meaning%Type;

834: );
835: Type rrs_entity_tab is table of rrs_entity_rec;
836: l_rrs_entity rrs_entity_tab;
837:
838: l_rrs_entity_name rrs_lookups_v.meaning%Type;
839:
840: l_page_id number;
841: l_display_name varchar2(240);
842:

Line 865: from RRS_LOOKUPS_V

861: end;
862:
863: Select meaning
864: INTO l_rrs_entity_name
865: from RRS_LOOKUPS_V
866: where LOOKUP_TYPE= 'RRS_ENTITY'
867: and LOOKUP_CODE = 'RRS_LOCATION';
868:
869:

Line 1055: lookup_code rrs_lookups_v.lookup_code%Type,

1051: Type trade_area_id is table of number;
1052: l_trade_area_ids trade_area_id;
1053:
1054: Type rrs_entity_rec is Record(
1055: lookup_code rrs_lookups_v.lookup_code%Type,
1056: meaning rrs_lookups_v.meaning%Type
1057: );
1058: Type rrs_entity_tab is table of rrs_entity_rec;
1059: l_rrs_entity rrs_entity_tab;

Line 1056: meaning rrs_lookups_v.meaning%Type

1052: l_trade_area_ids trade_area_id;
1053:
1054: Type rrs_entity_rec is Record(
1055: lookup_code rrs_lookups_v.lookup_code%Type,
1056: meaning rrs_lookups_v.meaning%Type
1057: );
1058: Type rrs_entity_tab is table of rrs_entity_rec;
1059: l_rrs_entity rrs_entity_tab;
1060:

Line 1061: l_rrs_entity_name rrs_lookups_v.meaning%Type;

1057: );
1058: Type rrs_entity_tab is table of rrs_entity_rec;
1059: l_rrs_entity rrs_entity_tab;
1060:
1061: l_rrs_entity_name rrs_lookups_v.meaning%Type;
1062:
1063: l_page_id number;
1064: l_display_name varchar2(240);
1065:

Line 1089: from RRS_LOOKUPS_V

1085:
1086:
1087: Select meaning
1088: INTO l_rrs_entity_name
1089: from RRS_LOOKUPS_V
1090: where LOOKUP_TYPE= 'RRS_ENTITY'
1091: and LOOKUP_CODE = 'RRS_TRADE_AREA';
1092:
1093: