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 82: UPDATE ams_query_template_all

78: IF l_request_id = 0 THEN
79: RAISE FND_API.g_exc_unexpected_error;
80: end if;
81:
82: UPDATE ams_query_template_all
83: SET recalc_table_status = 'IN_PROGRESS',
84: mv_available_flag = 'N',
85: request_id = l_request_id,
86: LAST_UPDATE_DATE = SYSDATE,

Line 93: UPDATE ams_query_template_all

89: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
90: PROGRAM_UPDATE_DATE = SYSDATE
91: WHERE template_id = p_template_id;
92: ELSE
93: UPDATE ams_query_template_all
94: SET recalc_table_status = 'DRAFT',
95: mv_available_flag = 'N',
96: LAST_UPDATE_DATE = SYSDATE,
97: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 272: ams_query_template_all qtemp

268: select column_name from sys.all_tab_columns where table_name = l_view_name
269: and column_name not in (
270: select flds.source_column_name
271: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
272: ams_query_template_all qtemp
273: where alias.template_id = p_template_id
274: and alias.object_name = types.source_type_code
275: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
276: and types.MASTER_SOURCE_TYPE_FLAG = 'Y'

Line 327: ams_query_template_all qtemp

323: /*
324: cursor c_master_columns is
325: select flds.source_column_name
326: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
327: ams_query_template_all qtemp
328: where alias.template_id = p_template_id
329: and alias.object_name = types.source_type_code
330: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
331: and types.MASTER_SOURCE_TYPE_FLAG = 'Y'

Line 341: -- ams_query_template_all qtemp

337: -- In preview entries, it will join master data source.
338: cursor c_master_columns is
339: --select flds.source_column_name
340: --from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
341: -- ams_query_template_all qtemp
342: --where alias.template_id = p_template_id
343: -- and alias.object_name = types.source_type_code
344: -- and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID
345: -- and flds.ENABLED_FLAG = 'Y'

Line 352: from ams_query_template_all tmp,ams_list_src_types typ

348: -- and qtemp.template_id = alias.template_id
349: -- and qtemp.list_src_type = types.source_type_code
350: --Union
351: select typ.SOURCE_OBJECT_PK_FIELD
352: from ams_query_template_all tmp,ams_list_src_types typ
353: where tmp.template_id = p_template_id
354: and tmp.list_src_type = typ.SOURCE_TYPE_CODE;
355:
356:

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

494: begin
495: Ams_Utility_Pvt.Write_Conc_log('+++++++++++++++++++++Start CM program : AMSGMVTP.+++++++++++++++++++++');
496: Ams_Utility_Pvt.Write_Conc_log('p_template_id = '||to_char(p_template_id));
497:
498: -- Update the ams_query_template_all table to set mv_available_flag to N
499: -- so that list creation UI can grey out Recalc and Preview button
500: -- while the regeneration process is in progress
501: update ams_query_template_all
502: set MV_AVAILABLE_FLAG = 'N'

Line 501: update ams_query_template_all

497:
498: -- Update the ams_query_template_all table to set mv_available_flag to N
499: -- so that list creation UI can grey out Recalc and Preview button
500: -- while the regeneration process is in progress
501: update ams_query_template_all
502: set MV_AVAILABLE_FLAG = 'N'
503: where TEMPLATE_ID = p_template_id;
504:
505: commit;

Line 1105: -- Update the ams_query_template_all table

1101: hz_common_pub.enable_cont_source_security;
1102: Ams_Utility_Pvt.Write_Conc_log('Enable Contant Source Security ');
1103: end if;
1104: */
1105: -- Update the ams_query_template_all table
1106: update ams_query_template_all
1107: set mv_name = l_view_name,
1108: MV_AVAILABLE_FLAG = 'Y',
1109: SAMPLE_PCT = l_sample_pct,

Line 1106: update ams_query_template_all

1102: Ams_Utility_Pvt.Write_Conc_log('Enable Contant Source Security ');
1103: end if;
1104: */
1105: -- Update the ams_query_template_all table
1106: update ams_query_template_all
1107: set mv_name = l_view_name,
1108: MV_AVAILABLE_FLAG = 'Y',
1109: SAMPLE_PCT = l_sample_pct,
1110: SAMPLE_PCT_RECORDS = l_sample_records,

Line 1202: -- Update the ams_query_template_all table

1198: 'EXECUTE_STRING';
1199:
1200: Ams_Utility_Pvt.Write_Conc_log('x_return_status='||x_return_status || ' x_msg_data=' || x_msg_data);
1201:
1202: -- Update the ams_query_template_all table
1203: update ams_query_template_all
1204: set mv_name = l_view_name,
1205: MV_AVAILABLE_FLAG = 'Y',
1206: SAMPLE_PCT = l_sample_pct,

Line 1203: update ams_query_template_all

1199:
1200: Ams_Utility_Pvt.Write_Conc_log('x_return_status='||x_return_status || ' x_msg_data=' || x_msg_data);
1201:
1202: -- Update the ams_query_template_all table
1203: update ams_query_template_all
1204: set mv_name = l_view_name,
1205: MV_AVAILABLE_FLAG = 'Y',
1206: SAMPLE_PCT = l_sample_pct,
1207: SAMPLE_PCT_RECORDS = l_sample_records,

Line 1270: update ams_query_template_all

1266: Ams_Utility_Pvt.Write_Conc_log('Exception in generate_mv_for_template : '||SQLERRM);
1267: errbuf:= substr(SQLERRM,1,254);
1268: retcode:= 2;
1269:
1270: update ams_query_template_all
1271: set RECALC_TABLE_STATUS = 'FAILED'
1272: where TEMPLATE_ID = p_TEMPLATE_ID;
1273:
1274: commit;

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

1321: l_Errbuf varchar2(2000);
1322: l_Retcode varchar2(1);
1323:
1324: cursor c_all_templates is
1325: select template_id, mv_name from ams_query_template_all where mv_name is not null;
1326: begin
1327:
1328: open c_all_templates;
1329: loop

Line 1336: update ams_query_template_all

1332:
1333: l_delete_string := ' DROP MATERIALIZED VIEW '||l_mv_name;
1334: execute immediate l_delete_string;
1335:
1336: update ams_query_template_all
1337: set MV_AVAILABLE_FLAG = 'N'
1338: where TEMPLATE_ID = L_TEMPLATE_ID;
1339:
1340:

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

1380:
1381: l_return_status varchar2(1);
1382:
1383: cursor c_master_ds_rec_numbers is
1384: select nvl(SAMPLE_PCT,0),MASTER_DS_REC_NUMBERS,SAMPLE_PCT_RECORDS from ams_query_template_all
1385: where TEMPLATE_ID = P_TEMPLATE_ID;
1386:
1387:
1388: -- SOLIN, Bug 3696553