eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_QUERY_TEMPLATE_ALL

Line 61: UPDATE ams_query_template_all

57: IF l_request_id = 0 THEN
58: RAISE FND_API.g_exc_unexpected_error;
59: end if;
60:
61: UPDATE ams_query_template_all
62: SET recalc_table_status = 'IN_PROGRESS',
63: mv_available_flag = 'N',
64: request_id = l_request_id,
65: LAST_UPDATE_DATE = SYSDATE,

Line 72: UPDATE ams_query_template_all

68: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
69: PROGRAM_UPDATE_DATE = SYSDATE
70: WHERE template_id = p_template_id;
71: ELSE
72: UPDATE ams_query_template_all
73: SET recalc_table_status = 'DRAFT',
74: mv_available_flag = 'N',
75: LAST_UPDATE_DATE = SYSDATE,
76: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 251: ams_query_template_all qtemp

247: select column_name from sys.all_tab_columns where table_name = l_view_name
248: and column_name not in (
249: select flds.source_column_name
250: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
251: ams_query_template_all qtemp
252: where alias.template_id = p_template_id
253: and alias.object_name = types.source_type_code
254: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
255: and types.MASTER_SOURCE_TYPE_FLAG = 'Y'

Line 306: ams_query_template_all qtemp

302: /*
303: cursor c_master_columns is
304: select flds.source_column_name
305: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
306: ams_query_template_all qtemp
307: where alias.template_id = p_template_id
308: and alias.object_name = types.source_type_code
309: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
310: and types.MASTER_SOURCE_TYPE_FLAG = 'Y'

Line 320: -- ams_query_template_all qtemp

316: -- In preview entries, it will join master data source.
317: cursor c_master_columns is
318: --select flds.source_column_name
319: --from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
320: -- ams_query_template_all qtemp
321: --where alias.template_id = p_template_id
322: -- and alias.object_name = types.source_type_code
323: -- and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
324: -- and flds.ENABLED_FLAG = 'Y'

Line 331: from ams_query_template_all tmp,ams_list_src_types typ

327: -- and qtemp.template_id = alias.template_id
328: -- and qtemp.list_src_type = types.source_type_code
329: --Union
330: select typ.SOURCE_OBJECT_PK_FIELD
331: from ams_query_template_all tmp,ams_list_src_types typ
332: where tmp.template_id = p_template_id
333: and tmp.list_src_type = typ.SOURCE_TYPE_CODE;
334:
335:

Line 471: -- Update the ams_query_template_all table to set mv_available_flag to N

467: begin
468: Ams_Utility_Pvt.Write_Conc_log('+++++++++++++++++++++Start CM program : AMSGMVTP.+++++++++++++++++++++');
469: Ams_Utility_Pvt.Write_Conc_log('p_template_id = '||to_char(p_template_id));
470:
471: -- Update the ams_query_template_all table to set mv_available_flag to N
472: -- so that list creation UI can grey out Recalc and Preview button
473: -- while the regeneration process is in progress
474: update ams_query_template_all
475: set MV_AVAILABLE_FLAG = 'N'

Line 474: update ams_query_template_all

470:
471: -- Update the ams_query_template_all table to set mv_available_flag to N
472: -- so that list creation UI can grey out Recalc and Preview button
473: -- while the regeneration process is in progress
474: update ams_query_template_all
475: set MV_AVAILABLE_FLAG = 'N'
476: where TEMPLATE_ID = p_template_id;
477:
478: commit;

Line 1039: -- Update the ams_query_template_all table

1035: hz_common_pub.enable_cont_source_security;
1036: Ams_Utility_Pvt.Write_Conc_log('Enable Contant Source Security ');
1037: end if;
1038: */
1039: -- Update the ams_query_template_all table
1040: update ams_query_template_all
1041: set mv_name = l_view_name,
1042: MV_AVAILABLE_FLAG = 'Y',
1043: SAMPLE_PCT = l_sample_pct,

Line 1040: update ams_query_template_all

1036: Ams_Utility_Pvt.Write_Conc_log('Enable Contant Source Security ');
1037: end if;
1038: */
1039: -- Update the ams_query_template_all table
1040: update ams_query_template_all
1041: set mv_name = l_view_name,
1042: MV_AVAILABLE_FLAG = 'Y',
1043: SAMPLE_PCT = l_sample_pct,
1044: SAMPLE_PCT_RECORDS = l_sample_records,

Line 1136: -- Update the ams_query_template_all table

1132: 'EXECUTE_STRING';
1133:
1134: Ams_Utility_Pvt.Write_Conc_log('x_return_status='||x_return_status || ' x_msg_data=' || x_msg_data);
1135:
1136: -- Update the ams_query_template_all table
1137: update ams_query_template_all
1138: set mv_name = l_view_name,
1139: MV_AVAILABLE_FLAG = 'Y',
1140: SAMPLE_PCT = l_sample_pct,

Line 1137: update ams_query_template_all

1133:
1134: Ams_Utility_Pvt.Write_Conc_log('x_return_status='||x_return_status || ' x_msg_data=' || x_msg_data);
1135:
1136: -- Update the ams_query_template_all table
1137: update ams_query_template_all
1138: set mv_name = l_view_name,
1139: MV_AVAILABLE_FLAG = 'Y',
1140: SAMPLE_PCT = l_sample_pct,
1141: SAMPLE_PCT_RECORDS = l_sample_records,

Line 1204: update ams_query_template_all

1200: Ams_Utility_Pvt.Write_Conc_log('Exception in generate_mv_for_template : '||SQLERRM);
1201: errbuf:= substr(SQLERRM,1,254);
1202: retcode:= 2;
1203:
1204: update ams_query_template_all
1205: set RECALC_TABLE_STATUS = 'FAILED'
1206: where TEMPLATE_ID = p_TEMPLATE_ID;
1207:
1208: commit;

Line 1259: select template_id, mv_name from ams_query_template_all where mv_name is not null;

1255: l_Errbuf varchar2(2000);
1256: l_Retcode varchar2(1);
1257:
1258: cursor c_all_templates is
1259: select template_id, mv_name from ams_query_template_all where mv_name is not null;
1260: begin
1261:
1262: open c_all_templates;
1263: loop

Line 1270: update ams_query_template_all

1266:
1267: l_delete_string := ' DROP MATERIALIZED VIEW '||l_mv_name;
1268: execute immediate l_delete_string;
1269:
1270: update ams_query_template_all
1271: set MV_AVAILABLE_FLAG = 'N'
1272: where TEMPLATE_ID = L_TEMPLATE_ID;
1273:
1274:

Line 1318: select nvl(SAMPLE_PCT,0),MASTER_DS_REC_NUMBERS,SAMPLE_PCT_RECORDS from ams_query_template_all

1314:
1315: l_return_status varchar2(1);
1316:
1317: cursor c_master_ds_rec_numbers is
1318: select nvl(SAMPLE_PCT,0),MASTER_DS_REC_NUMBERS,SAMPLE_PCT_RECORDS from ams_query_template_all
1319: where TEMPLATE_ID = P_TEMPLATE_ID;
1320:
1321:
1322: -- SOLIN, Bug 3696553