APPS.BIM_SEGMENT_DENORM_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 164: from ams_list_queries_all ;

160: l_query_string VARCHAR2(32767);
161:
162: cursor c_query_source is
163: select list_query_id, query
164: from ams_list_queries_all ;
165:
166: l_found VARCHAR2(1) := 'N';
167: l_master_type VARCHAR2(80);
168: l_master_type_id NUMBER;

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