APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 280: from ams_list_queries_all ;

276: l_query_string VARCHAR2(32767);
277:
278: cursor c_query_source is
279: select list_query_id, query
280: from ams_list_queries_all ;
281:
282: l_found VARCHAR2(1) := 'N';
283: l_master_type VARCHAR2(80);
284: l_master_type_id NUMBER;

Line 434: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||

430: ' ,min(start_date_active) start_date_active ' ||
431: ' ,max(nvl(end_date_active,TO_DATE(''31/12/2199'',''DD/MM/YYYY''))) end_date_active ' ||
432: ' FROM ams_party_market_segments a ' ||
433: ' ,(SELECT a.cell_id cell_id ' ||
434: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||
435: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
436: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
437: ' AND b.list_query_id = d.sql_id ' ||
438: ' AND d.source_name = c.source_type_code ' ||

Line 575: from ams_list_queries_all ;

571: l_query_string VARCHAR2(32767);
572:
573: cursor c_query_source is
574: select list_query_id, query
575: from ams_list_queries_all ;
576:
577: l_found VARCHAR2(1) := 'N';
578: l_master_type VARCHAR2(80);
579: l_master_type_id NUMBER;

Line 710: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||

706: ' ,parties.status status ' ||
707: ' ,(CASE WHEN parties.status IN (''I'',''A'') THEN TRUNC(parties.last_update_date) ELSE NULL END) account_closure_date ' ||
708: ' FROM ams_party_market_segments a ' ||
709: ' ,(SELECT a.cell_id ' ||
710: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||
711: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
712: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
713: ' AND b.list_query_id = d.sql_id ' ||
714: ' AND d.source_name = c.source_type_code ' ||

Line 816: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||

812: ' ,-1 ' ||
813: ' ,-1 ' ||
814: ' FROM ams_party_market_segments a ' ||
815: ' ,(SELECT a.cell_id ' ||
816: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_scfb d ' ||
817: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
818: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
819: ' AND b.list_query_id = d.sql_id ' ||
820: ' AND d.source_name = c.source_type_code ' ||