APPS.BIM_I_SGMT_FACTS_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 292: from ams_list_queries_all ;

288: l_query_string VARCHAR2(32767);
289:
290: cursor c_query_source is
291: select list_query_id, query
292: from ams_list_queries_all ;
293:
294: l_found VARCHAR2(1) := 'N';
295: l_master_type VARCHAR2(80);
296: l_master_type_id NUMBER;

Line 442: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||

438: ' ,0 ' ||
439: ' ,0 ' ||
440: ' ,0 ' ||
441: ' FROM (SELECT a.cell_id , a.status_code ' ||
442: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||
443: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
444: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
445: ' AND b.list_query_id = d.sql_id ' ||
446: ' AND d.source_name = c.source_type_code ' ||

Line 511: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||

507: ' FROM ' ||
508: ' oe_order_headers_all ord1 ' ||
509: ' ,bim_i_party_sgmt_facts segs1 ' ||
510: ' ,(SELECT a.cell_id cell_id ' ||
511: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||
512: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
513: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
514: ' AND b.list_query_id = d.sql_id ' ||
515: ' AND d.source_name = c.source_type_code ' ||

Line 706: from ams_list_queries_all ;

702: l_query_string VARCHAR2(32767);
703:
704: cursor c_query_source is
705: select list_query_id, query
706: from ams_list_queries_all ;
707:
708: l_found VARCHAR2(1) := 'N';
709: l_master_type VARCHAR2(80);
710: l_master_type_id NUMBER;

Line 852: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||

848: ' ,0 ' ||
849: ' ,0 ' ||
850: ' ,0 ' ||
851: ' FROM (SELECT a.cell_id , a.status_code ' ||
852: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||
853: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
854: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
855: ' AND b.list_query_id = d.sql_id ' ||
856: ' AND d.source_name = c.source_type_code ' ||

Line 903: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||

899: ' FROM ' ||
900: ' oe_order_headers_all ord1 ' ||
901: ' ,bim_i_party_sgmt_facts segs1 ' ||
902: ' ,(SELECT a.cell_id cell_id ' ||
903: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_sgfb d ' ||
904: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
905: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
906: ' AND b.list_query_id = d.sql_id ' ||
907: ' AND d.source_name = c.source_type_code ' ||