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.GCS_BUILD_EPB_DATA_TR_PKG dependencies on GCS_EPB_DIM_MAPS

Line 87: FROM GCS_EPB_DIM_MAPS

83: -- Set the required flags
84: begin
85: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
86: INTO l_felm_req, l_felm_tab
87: FROM GCS_EPB_DIM_MAPS
88: WHERE gcs_column = 'FINANCIAL_ELEM_ID';
89: exception
90: when no_data_found then
91: l_felm_req := 'N';

Line 111: FROM GCS_EPB_DIM_MAPS

107:
108: begin
109: SELECT enabled_flag
110: INTO l_cctr_req
111: FROM GCS_EPB_DIM_MAPS
112: WHERE gcs_column = 'COMPANY_COST_CENTER_ORG_ID';
113: exception
114: when no_data_found then
115: l_cctr_req := 'N';

Line 121: FROM GCS_EPB_DIM_MAPS

117:
118: begin
119: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
120: INTO l_interco_req, l_interco_tab
121: FROM GCS_EPB_DIM_MAPS
122: WHERE gcs_column = 'INTERCOMPANY_ID';
123: exception
124: when no_data_found then
125: l_interco_req := 'N';

Line 144: FROM GCS_EPB_DIM_MAPS

140:
141: begin
142: SELECT enabled_flag
143: INTO l_prd_req
144: FROM GCS_EPB_DIM_MAPS
145: WHERE gcs_column = 'PRODUCT_ID';
146: exception
147: when no_data_found then
148: l_prd_req := 'N' ;

Line 154: FROM GCS_EPB_DIM_MAPS

150:
151: begin
152: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
153: INTO l_na_req, l_na_tab
154: FROM GCS_EPB_DIM_MAPS
155: WHERE gcs_column = 'NATURAL_ACCOUNT_ID';
156: exception
157: when no_data_found then
158: l_na_req := 'N' ;

Line 177: FROM GCS_EPB_DIM_MAPS

173:
174: begin
175: SELECT enabled_flag
176: INTO l_chl_req
177: FROM GCS_EPB_DIM_MAPS
178: WHERE gcs_column = 'CHANNEL_ID';
179: exception
180: when no_data_found then
181: l_chl_req := 'N' ;

Line 187: FROM GCS_EPB_DIM_MAPS

183:
184: begin
185: SELECT enabled_flag
186: INTO l_prj_req
187: FROM GCS_EPB_DIM_MAPS
188: WHERE gcs_column = 'PROJECT_ID';
189: exception
190: when no_data_found then
191: l_prj_req := 'N' ;

Line 197: FROM GCS_EPB_DIM_MAPS

193:
194: begin
195: SELECT enabled_flag
196: INTO l_cst_req
197: FROM GCS_EPB_DIM_MAPS
198: WHERE gcs_column = 'CUSTOMER_ID';
199: exception
200: when no_data_found then
201: l_cst_req := 'N' ;

Line 207: FROM GCS_EPB_DIM_MAPS

203:
204: begin
205: SELECT enabled_flag
206: INTO l_tsk_req
207: FROM GCS_EPB_DIM_MAPS
208: WHERE gcs_column = 'TASK_ID';
209: exception
210: when no_data_found then
211: l_tsk_req := 'N' ;

Line 217: FROM GCS_EPB_DIM_MAPS

213:
214: begin
215: SELECT enabled_flag
216: INTO l_ud1_req
217: FROM GCS_EPB_DIM_MAPS
218: WHERE gcs_column = 'USER_DIM1_ID';
219: exception
220: when no_data_found then
221: l_ud1_req := 'N' ;

Line 227: FROM GCS_EPB_DIM_MAPS

223:
224: begin
225: SELECT enabled_flag
226: INTO l_ud2_req
227: FROM GCS_EPB_DIM_MAPS
228: WHERE gcs_column = 'USER_DIM2_ID';
229: exception
230: when no_data_found then
231: l_ud2_req := 'N' ;

Line 237: FROM GCS_EPB_DIM_MAPS

233:
234: begin
235: SELECT enabled_flag
236: INTO l_ud3_req
237: FROM GCS_EPB_DIM_MAPS
238: WHERE gcs_column = 'USER_DIM3_ID';
239: exception
240: when no_data_found then
241: l_ud3_req := 'N' ;

Line 247: FROM GCS_EPB_DIM_MAPS

243:
244: begin
245: SELECT enabled_flag
246: INTO l_ud4_req
247: FROM GCS_EPB_DIM_MAPS
248: WHERE gcs_column = 'USER_DIM4_ID';
249: exception
250: when no_data_found then
251: l_ud4_req := 'N' ;

Line 257: FROM GCS_EPB_DIM_MAPS

253:
254: begin
255: SELECT enabled_flag
256: INTO l_ud5_req
257: FROM GCS_EPB_DIM_MAPS
258: WHERE gcs_column = 'USER_DIM5_ID';
259: exception
260: when no_data_found then
261: l_ud5_req := 'N' ;

Line 267: FROM GCS_EPB_DIM_MAPS

263:
264: begin
265: SELECT enabled_flag
266: INTO l_ud6_req
267: FROM GCS_EPB_DIM_MAPS
268: WHERE gcs_column = 'USER_DIM6_ID';
269: exception
270: when no_data_found then
271: l_ud6_req := 'N' ;

Line 277: FROM GCS_EPB_DIM_MAPS

273:
274: begin
275: SELECT enabled_flag
276: INTO l_ud7_req
277: FROM GCS_EPB_DIM_MAPS
278: WHERE gcs_column = 'USER_DIM7_ID';
279: exception
280: when no_data_found then
281: l_ud7_req := 'N' ;

Line 287: FROM GCS_EPB_DIM_MAPS

283:
284: begin
285: SELECT enabled_flag
286: INTO l_ud8_req
287: FROM GCS_EPB_DIM_MAPS
288: WHERE gcs_column = 'USER_DIM8_ID';
289: exception
290: when no_data_found then
291: l_ud8_req := 'N' ;

Line 297: FROM GCS_EPB_DIM_MAPS

293:
294: begin
295: SELECT enabled_flag
296: INTO l_ud9_req
297: FROM GCS_EPB_DIM_MAPS
298: WHERE gcs_column = 'USER_DIM9_ID';
299: exception
300: when no_data_found then
301: l_ud9_req := 'N' ;

Line 307: FROM GCS_EPB_DIM_MAPS

303:
304: begin
305: SELECT enabled_flag
306: INTO l_ud10_req
307: FROM GCS_EPB_DIM_MAPS
308: WHERE gcs_column = 'USER_DIM10_ID';
309: exception
310: when no_data_found then
311: l_ud10_req := 'N' ;

Line 317: FROM GCS_EPB_DIM_MAPS

313:
314: begin
315: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
316: INTO l_category_req, l_category_tab
317: FROM GCS_EPB_DIM_MAPS
318: --Bugfix 4291225: The column name is CREATED_BY_OBJECT_ID
319: WHERE gcs_column = 'CREATED_BY_OBJECT_ID';
320: exception
321: when no_data_found then