APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 3454: FROM ams_list_queries_all

3450: -- workbook_name.
3451: ------------------------------------------------------------------------------
3452: cursor cur_sql is
3453: SELECT query,primary_key, source_object_name
3454: FROM ams_list_queries_all
3455: WHERE (list_query_id = p_incl_object_id )
3456: or (parent_list_query_id = p_incl_object_id )
3457: order by sequence_order;
3458:

Line 3462: FROM ams_list_queries_all

3458:
3459: /* sql_string column is obsolete: bug 4604653
3460: cursor cur_old_sql is
3461: SELECT sql_string, primary_key, source_object_name
3462: FROM ams_list_queries_all
3463: WHERE (list_query_id = p_incl_object_id )
3464: or (parent_list_query_id = p_incl_object_id )
3465: order by sequence_order;
3466: */

Line 3470: FROM ams_list_queries_all lq,

3466: */
3467:
3468: cursor cur_primary_key_sql is
3469: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
3470: FROM ams_list_queries_all lq,
3471: ams_list_headers_all lh,
3472: ams_list_src_types lc
3473: WHERE lq.list_query_id = p_incl_object_id
3474: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'

Line 3857: from ams_list_queries_all

3853: l_table_char table_char;
3854:
3855: cursor c_query(l_query_id number) is select
3856: nvl(PARAMETERIZED_FLAG ,'N')
3857: from ams_list_queries_all
3858: where list_query_id = l_query_id ;
3859:
3860: cursor c_param_values(l_query_id in number) is
3861: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name

Line 8771: from ams_list_queries_all

8767: l_table_char table_char;
8768:
8769: cursor c_query(l_query_id number) is select
8770: nvl(PARAMETERIZED_FLAG ,'N')
8771: from ams_list_queries_all
8772: where list_query_id = l_query_id ;
8773:
8774: cursor c_param_values(l_query_id in number) is
8775: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name

Line 12741: FROM ams_list_queries_all

12737: -- workbook_name.
12738: ------------------------------------------------------------------------------
12739: cursor cur_sql is
12740: SELECT query, primary_key, source_object_name
12741: FROM ams_list_queries_all
12742: WHERE (list_query_id = p_incl_object_id )
12743: or (parent_list_query_id = p_incl_object_id )
12744: order by sequence_order;
12745:

Line 12749: FROM ams_list_queries_all

12745:
12746: /* sql_string column is obsolete: bug 4604653
12747: cursor cur_old_sql is
12748: SELECT sql_string, primary_key, source_object_name
12749: FROM ams_list_queries_all
12750: WHERE (list_query_id = p_incl_object_id )
12751: or (parent_list_query_id = p_incl_object_id )
12752: order by sequence_order;
12753: */

Line 12757: FROM ams_list_queries_all lq,

12753: */
12754:
12755: cursor cur_primary_key_sql is
12756: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
12757: FROM ams_list_queries_all lq,
12758: ams_list_headers_all lh,
12759: ams_list_src_types lc
12760: WHERE lq.list_query_id = p_incl_object_id
12761: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'