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.BIM_SEGMENT_DENORM_PKG dependencies on AMS_CELLS_ALL_B

Line 276: FROM ams_cells_all_b a

272:
273: DELETE bim_i_sgmt_denorm
274: WHERE segment_id IN
275: (SELECT cell_id
276: FROM ams_cells_all_b a
277: WHERE last_update_date > l_temp_start_date
278: );
279:
280: /* This Delete Statement for the objects that had an update somewhere in their hierarachy chain.*/

Line 286: FROM ams_cells_all_b a

282: DELETE bim_i_sgmt_denorm
283: WHERE segment_id IN (SELECT segment_id
284: FROM bim_i_sgmt_denorm
285: WHERE parent_segment_id in (SELECT b.segment_id
286: FROM ams_cells_all_b a
287: ,bim_i_sgmt_denorm b
288: WHERE b.segment_id = a.cell_id
289: AND a.last_update_date > l_temp_start_date
290: )

Line 305: FROM ams_cells_all_b a

301:
302: UPDATE bim_i_sgmt_denorm
303: SET leaf_node_flag = 'N'
304: WHERE segment_id IN (SELECT parent_cell_id
305: FROM ams_cells_all_b a
306: WHERE NOT EXISTS (SELECT 1 FROM bim_i_sgmt_denorm b WHERE b.segment_id = a.cell_id)
307: AND object_level = 1
308: AND a.last_update_date > l_temp_start_date
309: );

Line 351: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||

347: ' ,decode(parent_cell_id,NULL,''Y'',decode(level,2,''Y'',''N'')) immediate_parent_flag ' ||
348: ' ,parent_cell_id immediate_parent_id ' ||
349: ' ,LEVEL object_level ' ||
350: ' ,decode(parent_cell_id, NULL,''Y'',''N'') top_node_flag ' ||
351: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||
352: ' FROM (SELECT a.cell_id , a.parent_cell_id ' ||
353: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||
354: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
355: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||

Line 353: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||

349: ' ,LEVEL object_level ' ||
350: ' ,decode(parent_cell_id, NULL,''Y'',''N'') top_node_flag ' ||
351: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||
352: ' FROM (SELECT a.cell_id , a.parent_cell_id ' ||
353: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||
354: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
355: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
356: ' AND b.list_query_id = d.sql_id ' ||
357: ' AND d.source_name = c.source_type_code ' ||

Line 363: ' FROM ams_cells_all_b a,ams_list_src_types b,ams_act_discoverer_all c,ams_discoverer_sql d ' ||

359: ' AND a.sel_type =''SQL'' ' ||
360: ' AND a.status_code IN (''AVAILABLE'',''CANCELLED'') ' ||
361: ' UNION ALL ' ||
362: ' SELECT a.cell_id , a.parent_cell_id ' ||
363: ' FROM ams_cells_all_b a,ams_list_src_types b,ams_act_discoverer_all c,ams_discoverer_sql d ' ||
364: ' WHERE c.act_discoverer_used_by_id = a.cell_id ' ||
365: ' AND c.arc_act_discoverer_used_by =''CELL'' ' ||
366: ' AND c.discoverer_sql_id = d.discoverer_sql_id ' ||
367: ' AND d.source_type_code = b.source_object_name ' ||

Line 375: ' )x, ams_cells_all_b s ' ||

371: ' ) a ' ||
372: ' WHERE NOT EXISTS ( SELECT 1 FROM bim_i_sgmt_denorm b ' ||
373: ' WHERE b.segment_id = a.cell_id ) ' ||
374: ' CONNECT BY PRIOR cell_id = parent_cell_id ' ||
375: ' )x, ams_cells_all_b s ' ||
376: ' WHERE s.cell_id = x.parent_segment_id' ;
377:
378: Execute Immediate ' DROP TABLE source_query_sgdb ';
379:

Line 424: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||

420: ' ,decode(parent_cell_id,NULL,''Y'',decode(level,2,''Y'',''N'')) immediate_parent_flag ' ||
421: ' ,parent_cell_id immediate_parent_id ' ||
422: ' ,LEVEL object_level ' ||
423: ' ,decode(parent_cell_id, NULL,''Y'',''N'') top_node_flag ' ||
424: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||
425: ' FROM (SELECT a.cell_id , a.parent_cell_id ' ||
426: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||
427: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
428: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||

Line 426: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||

422: ' ,LEVEL object_level ' ||
423: ' ,decode(parent_cell_id, NULL,''Y'',''N'') top_node_flag ' ||
424: ' ,DECODE((SELECT COUNT(1) FROM ams_cells_all_b c WHERE parent_cell_id = a.cell_id),0,''Y'',''N'') leaf_node_flag ' ||
425: ' FROM (SELECT a.cell_id , a.parent_cell_id ' ||
426: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgdb d ' ||
427: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
428: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
429: ' AND b.list_query_id = d.sql_id ' ||
430: ' AND d.source_name = c.source_type_code ' ||

Line 436: ' FROM ams_cells_all_b a,ams_list_src_types b,ams_act_discoverer_all c,ams_discoverer_sql d ' ||

432: ' AND a.sel_type =''SQL'' ' ||
433: ' AND a.status_code IN (''AVAILABLE'',''CANCELLED'') ' ||
434: ' UNION ALL ' ||
435: ' SELECT a.cell_id , a.parent_cell_id ' ||
436: ' FROM ams_cells_all_b a,ams_list_src_types b,ams_act_discoverer_all c,ams_discoverer_sql d ' ||
437: ' WHERE c.act_discoverer_used_by_id = a.cell_id ' ||
438: ' AND c.arc_act_discoverer_used_by =''CELL'' ' ||
439: ' AND c.discoverer_sql_id = d.discoverer_sql_id ' ||
440: ' AND d.source_type_code = b.source_object_name ' ||

Line 446: ' )x, ams_cells_all_b s ' ||

442: ' AND a.sel_type=''DIWB'' ' ||
443: ' AND a.status_code IN (''AVAILABLE'',''CANCELLED'') ' ||
444: ' ) a ' ||
445: ' CONNECT BY PRIOR a.cell_id = a.parent_cell_id ' ||
446: ' )x, ams_cells_all_b s ' ||
447: ' WHERE s.cell_id = x.parent_segment_id' ;
448: /* UNION ALL
449: NOTE:-additional UNION ALL for unassigned values
450: SELECT