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 8681: from ams_list_queries_all

8677: l_table_char table_char;
8678:
8679: cursor c_query(l_query_id number) is select
8680: nvl(PARAMETERIZED_FLAG ,'N')
8681: from ams_list_queries_all
8682: where list_query_id = l_query_id ;
8683:
8684: cursor c_param_values(l_query_id in number) is
8685: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name

Line 12640: FROM ams_list_queries_all

12636: -- workbook_name.
12637: ------------------------------------------------------------------------------
12638: cursor cur_sql is
12639: SELECT query, primary_key, source_object_name
12640: FROM ams_list_queries_all
12641: WHERE (list_query_id = p_incl_object_id )
12642: or (parent_list_query_id = p_incl_object_id )
12643: order by sequence_order;
12644:

Line 12648: FROM ams_list_queries_all

12644:
12645: /* sql_string column is obsolete: bug 4604653
12646: cursor cur_old_sql is
12647: SELECT sql_string, primary_key, source_object_name
12648: FROM ams_list_queries_all
12649: WHERE (list_query_id = p_incl_object_id )
12650: or (parent_list_query_id = p_incl_object_id )
12651: order by sequence_order;
12652: */

Line 12656: FROM ams_list_queries_all lq,

12652: */
12653:
12654: cursor cur_primary_key_sql is
12655: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
12656: FROM ams_list_queries_all lq,
12657: ams_list_headers_all lh,
12658: ams_list_src_types lc
12659: WHERE lq.list_query_id = p_incl_object_id
12660: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'