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_ATTR_PANE dependencies on RRS_LOOKUPS_V

Line 40: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),

36: AND LK.LOOKUP_TYPE (+) = 'PARTY_SITE_USE_CODE'
37: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE (+)
38: ),
39: DESCRIPTION,
40: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
41: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
42: TO_CHAR(START_DATE, l_date_format_mask), --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
43: TO_CHAR(END_DATE, l_date_format_mask), --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
44: (HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ', ' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)

Line 41: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),

37: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE (+)
38: ),
39: DESCRIPTION,
40: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
41: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
42: TO_CHAR(START_DATE, l_date_format_mask), --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
43: TO_CHAR(END_DATE, l_date_format_mask), --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
44: (HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ', ' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)
45: ),

Line 96: FROM RRS_LOOKUPS_V LK

92: SITE_GROUP_NODE_ID,
93: NODE_IDENTIFICATION_NUMBER,
94: NAME,
95: (SELECT MEANING
96: FROM RRS_LOOKUPS_V LK
97: WHERE LK.LOOKUP_TYPE (+) = 'RRS_NODE_PURPOSE'
98: AND RSGNV.NODE_PURPOSE_CODE = LK.LOOKUP_CODE (+)
99: ),
100: DESCRIPTION,

Line 133: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),

129: AND LK.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
130: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE
131: ),
132: DESCRIPTION,
133: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
134: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
135: START_DATE,
136: END_DATE,
137: (HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ',' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)

Line 134: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),

130: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE
131: ),
132: DESCRIPTION,
133: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
134: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
135: START_DATE,
136: END_DATE,
137: (HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ',' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)
138: ),

Line 139: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_TRADE_AREA_GROUP_TYPE' AND LOOKUP_CODE = RTAGV.GROUP_TYPE_CODE),

135: START_DATE,
136: END_DATE,
137: (HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ',' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)
138: ),
139: (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_TRADE_AREA_GROUP_TYPE' AND LOOKUP_CODE = RTAGV.GROUP_TYPE_CODE),
140: NULL,
141: NULL)
142: INTO x_primary_attributes
143: FROM RRS_TRADE_AREA_GROUPS_VL RTAGV

Line 154: FROM RRS_LOOKUPS_V LK

150: SITE_GROUP_ID,
151: NULL,
152: NAME,
153: (SELECT MEANING
154: FROM RRS_LOOKUPS_V LK
155: WHERE LK.LOOKUP_TYPE(+) = 'RRS_HIERARCHY_PURPOSE'
156: AND RSGV.GROUP_PURPOSE_CODE = LK.LOOKUP_CODE (+)
157: ),
158: DESCRIPTION,