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.EDW_FLEX_MAPPING dependencies on GL_CODE_COMBINATIONS

Line 97: FROM gl_code_combinations

93:
94: IF (l_application_column_name = 'SEGMENT1') THEN
95: SELECT segment1
96: INTO l_segment_value
97: FROM gl_code_combinations
98: WHERE code_combination_id = p_ccid
99: AND chart_of_accounts_id = p_structure_id;
100:
101: ELSIF (l_application_column_name = 'SEGMENT2') THEN

Line 104: FROM gl_code_combinations

100:
101: ELSIF (l_application_column_name = 'SEGMENT2') THEN
102: SELECT segment2
103: INTO l_segment_value
104: FROM gl_code_combinations
105: WHERE code_combination_id = p_ccid
106: AND chart_of_accounts_id = p_structure_id;
107:
108: ELSIF (l_application_column_name = 'SEGMENT3') THEN

Line 111: FROM gl_code_combinations

107:
108: ELSIF (l_application_column_name = 'SEGMENT3') THEN
109: SELECT segment3
110: INTO l_segment_value
111: FROM gl_code_combinations
112: WHERE code_combination_id = p_ccid
113: AND chart_of_accounts_id = p_structure_id;
114:
115: ELSIF (l_application_column_name = 'SEGMENT4') THEN

Line 118: FROM gl_code_combinations

114:
115: ELSIF (l_application_column_name = 'SEGMENT4') THEN
116: SELECT segment4
117: INTO l_segment_value
118: FROM gl_code_combinations
119: WHERE code_combination_id = p_ccid
120: AND chart_of_accounts_id = p_structure_id;
121:
122: ELSIF (l_application_column_name = 'SEGMENT5') THEN

Line 125: FROM gl_code_combinations

121:
122: ELSIF (l_application_column_name = 'SEGMENT5') THEN
123: SELECT segment5
124: INTO l_segment_value
125: FROM gl_code_combinations
126: WHERE code_combination_id = p_ccid
127: AND chart_of_accounts_id = p_structure_id;
128:
129: ELSIF (l_application_column_name = 'SEGMENT6') THEN

Line 132: FROM gl_code_combinations

128:
129: ELSIF (l_application_column_name = 'SEGMENT6') THEN
130: SELECT segment6
131: INTO l_segment_value
132: FROM gl_code_combinations
133: WHERE code_combination_id = p_ccid
134: AND chart_of_accounts_id = p_structure_id;
135:
136: ELSIF (l_application_column_name = 'SEGMENT7') THEN

Line 139: FROM gl_code_combinations

135:
136: ELSIF (l_application_column_name = 'SEGMENT7') THEN
137: SELECT segment7
138: INTO l_segment_value
139: FROM gl_code_combinations
140: WHERE code_combination_id = p_ccid
141: AND chart_of_accounts_id = p_structure_id;
142:
143: ELSIF (l_application_column_name = 'SEGMENT8') THEN

Line 146: FROM gl_code_combinations

142:
143: ELSIF (l_application_column_name = 'SEGMENT8') THEN
144: SELECT segment8
145: INTO l_segment_value
146: FROM gl_code_combinations
147: WHERE code_combination_id = p_ccid
148: AND chart_of_accounts_id = p_structure_id;
149:
150: ELSIF (l_application_column_name = 'SEGMENT9') THEN

Line 153: FROM gl_code_combinations

149:
150: ELSIF (l_application_column_name = 'SEGMENT9') THEN
151: SELECT segment9
152: INTO l_segment_value
153: FROM gl_code_combinations
154: WHERE code_combination_id = p_ccid
155: AND chart_of_accounts_id = p_structure_id;
156:
157: ELSIF (l_application_column_name = 'SEGMENT10') THEN

Line 160: FROM gl_code_combinations

156:
157: ELSIF (l_application_column_name = 'SEGMENT10') THEN
158: SELECT segment10
159: INTO l_segment_value
160: FROM gl_code_combinations
161: WHERE code_combination_id = p_ccid
162: AND chart_of_accounts_id = p_structure_id;
163:
164: ELSIF (l_application_column_name = 'SEGMENT11') THEN

Line 167: FROM gl_code_combinations

163:
164: ELSIF (l_application_column_name = 'SEGMENT11') THEN
165: SELECT segment11
166: INTO l_segment_value
167: FROM gl_code_combinations
168: WHERE code_combination_id = p_ccid
169: AND chart_of_accounts_id = p_structure_id;
170:
171: ELSIF (l_application_column_name = 'SEGMENT12') THEN

Line 174: FROM gl_code_combinations

170:
171: ELSIF (l_application_column_name = 'SEGMENT12') THEN
172: SELECT segment12
173: INTO l_segment_value
174: FROM gl_code_combinations
175: WHERE code_combination_id = p_ccid
176: AND chart_of_accounts_id = p_structure_id;
177:
178: ELSIF (l_application_column_name = 'SEGMENT13') THEN

Line 181: FROM gl_code_combinations

177:
178: ELSIF (l_application_column_name = 'SEGMENT13') THEN
179: SELECT segment13
180: INTO l_segment_value
181: FROM gl_code_combinations
182: WHERE code_combination_id = p_ccid
183: AND chart_of_accounts_id = p_structure_id;
184:
185: ELSIF (l_application_column_name = 'SEGMENT14') THEN

Line 188: FROM gl_code_combinations

184:
185: ELSIF (l_application_column_name = 'SEGMENT14') THEN
186: SELECT segment14
187: INTO l_segment_value
188: FROM gl_code_combinations
189: WHERE code_combination_id = p_ccid
190: AND chart_of_accounts_id = p_structure_id;
191:
192: ELSIF (l_application_column_name = 'SEGMENT15') THEN

Line 195: FROM gl_code_combinations

191:
192: ELSIF (l_application_column_name = 'SEGMENT15') THEN
193: SELECT segment15
194: INTO l_segment_value
195: FROM gl_code_combinations
196: WHERE code_combination_id = p_ccid
197: AND chart_of_accounts_id = p_structure_id;
198:
199: ELSIF (l_application_column_name = 'SEGMENT16') THEN

Line 202: FROM gl_code_combinations

198:
199: ELSIF (l_application_column_name = 'SEGMENT16') THEN
200: SELECT segment16
201: INTO l_segment_value
202: FROM gl_code_combinations
203: WHERE code_combination_id = p_ccid
204: AND chart_of_accounts_id = p_structure_id;
205:
206: ELSIF (l_application_column_name = 'SEGMENT17') THEN

Line 209: FROM gl_code_combinations

205:
206: ELSIF (l_application_column_name = 'SEGMENT17') THEN
207: SELECT segment17
208: INTO l_segment_value
209: FROM gl_code_combinations
210: WHERE code_combination_id = p_ccid
211: AND chart_of_accounts_id = p_structure_id;
212:
213: ELSIF (l_application_column_name = 'SEGMENT18') THEN

Line 216: FROM gl_code_combinations

212:
213: ELSIF (l_application_column_name = 'SEGMENT18') THEN
214: SELECT segment18
215: INTO l_segment_value
216: FROM gl_code_combinations
217: WHERE code_combination_id = p_ccid
218: AND chart_of_accounts_id = p_structure_id;
219:
220: ELSIF (l_application_column_name = 'SEGMENT19') THEN

Line 223: FROM gl_code_combinations

219:
220: ELSIF (l_application_column_name = 'SEGMENT19') THEN
221: SELECT segment19
222: INTO l_segment_value
223: FROM gl_code_combinations
224: WHERE code_combination_id = p_ccid
225: AND chart_of_accounts_id = p_structure_id;
226:
227: ELSIF (l_application_column_name = 'SEGMENT20') THEN

Line 230: FROM gl_code_combinations

226:
227: ELSIF (l_application_column_name = 'SEGMENT20') THEN
228: SELECT segment20
229: INTO l_segment_value
230: FROM gl_code_combinations
231: WHERE code_combination_id = p_ccid
232: AND chart_of_accounts_id = p_structure_id;
233: ELSIF (l_application_column_name = 'SEGMENT21') THEN
234: SELECT segment21

Line 236: FROM gl_code_combinations

232: AND chart_of_accounts_id = p_structure_id;
233: ELSIF (l_application_column_name = 'SEGMENT21') THEN
234: SELECT segment21
235: INTO l_segment_value
236: FROM gl_code_combinations
237: WHERE code_combination_id = p_ccid
238: AND chart_of_accounts_id = p_structure_id;
239: ELSIF (l_application_column_name = 'SEGMENT22') THEN
240: SELECT segment22

Line 242: FROM gl_code_combinations

238: AND chart_of_accounts_id = p_structure_id;
239: ELSIF (l_application_column_name = 'SEGMENT22') THEN
240: SELECT segment22
241: INTO l_segment_value
242: FROM gl_code_combinations
243: WHERE code_combination_id = p_ccid
244: AND chart_of_accounts_id = p_structure_id;
245: ELSIF (l_application_column_name = 'SEGMENT23') THEN
246: SELECT segment23

Line 248: FROM gl_code_combinations

244: AND chart_of_accounts_id = p_structure_id;
245: ELSIF (l_application_column_name = 'SEGMENT23') THEN
246: SELECT segment23
247: INTO l_segment_value
248: FROM gl_code_combinations
249: WHERE code_combination_id = p_ccid
250: AND chart_of_accounts_id = p_structure_id;
251: ELSIF (l_application_column_name = 'SEGMENT24') THEN
252: SELECT segment24

Line 254: FROM gl_code_combinations

250: AND chart_of_accounts_id = p_structure_id;
251: ELSIF (l_application_column_name = 'SEGMENT24') THEN
252: SELECT segment24
253: INTO l_segment_value
254: FROM gl_code_combinations
255: WHERE code_combination_id = p_ccid
256: AND chart_of_accounts_id = p_structure_id;
257: ELSIF (l_application_column_name = 'SEGMENT25') THEN
258: SELECT segment25

Line 260: FROM gl_code_combinations

256: AND chart_of_accounts_id = p_structure_id;
257: ELSIF (l_application_column_name = 'SEGMENT25') THEN
258: SELECT segment25
259: INTO l_segment_value
260: FROM gl_code_combinations
261: WHERE code_combination_id = p_ccid
262: AND chart_of_accounts_id = p_structure_id;
263: ELSIF (l_application_column_name = 'SEGMENT26') THEN
264: SELECT segment26

Line 266: FROM gl_code_combinations

262: AND chart_of_accounts_id = p_structure_id;
263: ELSIF (l_application_column_name = 'SEGMENT26') THEN
264: SELECT segment26
265: INTO l_segment_value
266: FROM gl_code_combinations
267: WHERE code_combination_id = p_ccid
268: AND chart_of_accounts_id = p_structure_id;
269: ELSIF (l_application_column_name = 'SEGMENT27') THEN
270: SELECT segment27

Line 272: FROM gl_code_combinations

268: AND chart_of_accounts_id = p_structure_id;
269: ELSIF (l_application_column_name = 'SEGMENT27') THEN
270: SELECT segment27
271: INTO l_segment_value
272: FROM gl_code_combinations
273: WHERE code_combination_id = p_ccid
274: AND chart_of_accounts_id = p_structure_id;
275: ELSIF (l_application_column_name = 'SEGMENT28') THEN
276: SELECT segment28

Line 278: FROM gl_code_combinations

274: AND chart_of_accounts_id = p_structure_id;
275: ELSIF (l_application_column_name = 'SEGMENT28') THEN
276: SELECT segment28
277: INTO l_segment_value
278: FROM gl_code_combinations
279: WHERE code_combination_id = p_ccid
280: AND chart_of_accounts_id = p_structure_id;
281: ELSIF (l_application_column_name = 'SEGMENT29') THEN
282: SELECT segment29

Line 284: FROM gl_code_combinations

280: AND chart_of_accounts_id = p_structure_id;
281: ELSIF (l_application_column_name = 'SEGMENT29') THEN
282: SELECT segment29
283: INTO l_segment_value
284: FROM gl_code_combinations
285: WHERE code_combination_id = p_ccid
286: AND chart_of_accounts_id = p_structure_id;
287: ELSIF (l_application_column_name = 'SEGMENT30') THEN
288: SELECT segment30

Line 290: FROM gl_code_combinations

286: AND chart_of_accounts_id = p_structure_id;
287: ELSIF (l_application_column_name = 'SEGMENT30') THEN
288: SELECT segment30
289: INTO l_segment_value
290: FROM gl_code_combinations
291: WHERE code_combination_id = p_ccid
292: AND chart_of_accounts_id = p_structure_id;
293:
294: END IF;