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 151: site_type_code_meaning rrs_lookups_v.meaning%TYPE,

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

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

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

Line 196: status_code_meaning rrs_lookups_v.meaning%TYPE,

192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
196: status_code_meaning rrs_lookups_v.meaning%TYPE,
197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
199: );
200: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;

Line 198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type

194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
196: status_code_meaning rrs_lookups_v.meaning%TYPE,
197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
199: );
200: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
201: site_use_rec_details local_rrs_site_uses_tab;
202:

Line 211: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;

207: l_is_primary_flag_selector varchar2(1);
208: l_party_site_use_id number;
209: l_object_version_number number;
210:
211: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
212:
213: l_lookup_code rrs_lookups_v.lookup_code%Type;
214: l_lookup_type rrs_lookups_v.lookup_type%Type;
215:

Line 213: l_lookup_code rrs_lookups_v.lookup_code%Type;

209: l_object_version_number number;
210:
211: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
212:
213: l_lookup_code rrs_lookups_v.lookup_code%Type;
214: l_lookup_type rrs_lookups_v.lookup_type%Type;
215:
216: Begin
217:

Line 214: l_lookup_type rrs_lookups_v.lookup_type%Type;

210:
211: l_site_type_code_meaning rrs_lookups_v.meaning%TYPE;
212:
213: l_lookup_code rrs_lookups_v.lookup_code%Type;
214: l_lookup_type rrs_lookups_v.lookup_type%Type;
215:
216: Begin
217:
218: Begin

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

Line 368: -- ,RRS_LOOKUPS_V LKUP2

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

Line 369: ,RRS_LOOKUPS_V LKUP3

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

Line 549: lookup_code rrs_lookups_v.lookup_code%Type,

545: Type trade_area_id is table of number;
546: l_trade_area_ids trade_area_id;
547:
548: Type rrs_entity_rec is Record(
549: lookup_code rrs_lookups_v.lookup_code%Type,
550: meaning rrs_lookups_v.meaning%Type
551: );
552: Type rrs_entity_tab is table of rrs_entity_rec;
553: l_rrs_entity rrs_entity_tab;

Line 550: meaning rrs_lookups_v.meaning%Type

546: l_trade_area_ids trade_area_id;
547:
548: Type rrs_entity_rec is Record(
549: lookup_code rrs_lookups_v.lookup_code%Type,
550: meaning rrs_lookups_v.meaning%Type
551: );
552: Type rrs_entity_tab is table of rrs_entity_rec;
553: l_rrs_entity rrs_entity_tab;
554:

Line 555: l_rrs_entity_name rrs_lookups_v.meaning%Type;

551: );
552: Type rrs_entity_tab is table of rrs_entity_rec;
553: l_rrs_entity rrs_entity_tab;
554:
555: l_rrs_entity_name rrs_lookups_v.meaning%Type;
556:
557:
558: BEGIN
559:

Line 578: from RRS_LOOKUPS_V

574: end;
575:
576: Select meaning
577: INTO l_rrs_entity_name
578: from RRS_LOOKUPS_V
579: where LOOKUP_TYPE= 'RRS_ENTITY'
580: and LOOKUP_CODE = 'RRS_SITE';
581:
582:

Line 814: lookup_code rrs_lookups_v.lookup_code%Type,

810: l_attr_grp_name attr_grp_name;
811:
812:
813: Type rrs_entity_rec is Record(
814: lookup_code rrs_lookups_v.lookup_code%Type,
815: meaning rrs_lookups_v.meaning%Type
816: );
817: Type rrs_entity_tab is table of rrs_entity_rec;
818: l_rrs_entity rrs_entity_tab;

Line 815: meaning rrs_lookups_v.meaning%Type

811:
812:
813: Type rrs_entity_rec is Record(
814: lookup_code rrs_lookups_v.lookup_code%Type,
815: meaning rrs_lookups_v.meaning%Type
816: );
817: Type rrs_entity_tab is table of rrs_entity_rec;
818: l_rrs_entity rrs_entity_tab;
819:

Line 820: l_rrs_entity_name rrs_lookups_v.meaning%Type;

816: );
817: Type rrs_entity_tab is table of rrs_entity_rec;
818: l_rrs_entity rrs_entity_tab;
819:
820: l_rrs_entity_name rrs_lookups_v.meaning%Type;
821:
822: l_page_id number;
823: l_display_name varchar2(240);
824:

Line 847: from RRS_LOOKUPS_V

843: end;
844:
845: Select meaning
846: INTO l_rrs_entity_name
847: from RRS_LOOKUPS_V
848: where LOOKUP_TYPE= 'RRS_ENTITY'
849: and LOOKUP_CODE = 'RRS_LOCATION';
850:
851:

Line 1037: lookup_code rrs_lookups_v.lookup_code%Type,

1033: Type trade_area_id is table of number;
1034: l_trade_area_ids trade_area_id;
1035:
1036: Type rrs_entity_rec is Record(
1037: lookup_code rrs_lookups_v.lookup_code%Type,
1038: meaning rrs_lookups_v.meaning%Type
1039: );
1040: Type rrs_entity_tab is table of rrs_entity_rec;
1041: l_rrs_entity rrs_entity_tab;

Line 1038: meaning rrs_lookups_v.meaning%Type

1034: l_trade_area_ids trade_area_id;
1035:
1036: Type rrs_entity_rec is Record(
1037: lookup_code rrs_lookups_v.lookup_code%Type,
1038: meaning rrs_lookups_v.meaning%Type
1039: );
1040: Type rrs_entity_tab is table of rrs_entity_rec;
1041: l_rrs_entity rrs_entity_tab;
1042:

Line 1043: l_rrs_entity_name rrs_lookups_v.meaning%Type;

1039: );
1040: Type rrs_entity_tab is table of rrs_entity_rec;
1041: l_rrs_entity rrs_entity_tab;
1042:
1043: l_rrs_entity_name rrs_lookups_v.meaning%Type;
1044:
1045: l_page_id number;
1046: l_display_name varchar2(240);
1047:

Line 1071: from RRS_LOOKUPS_V

1067:
1068:
1069: Select meaning
1070: INTO l_rrs_entity_name
1071: from RRS_LOOKUPS_V
1072: where LOOKUP_TYPE= 'RRS_ENTITY'
1073: and LOOKUP_CODE = 'RRS_TRADE_AREA';
1074:
1075: