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.MSC_PERS_QUERIES dependencies on MSC_PQ_RESULTS

Line 24: delete msc_pq_results

20: procedure delete_from_results_table(p_query_id in number,
21: p_plan_id in number) is
22: BEGIN
23: --KSA_DEBUG(SYSDATE,' p_query_id <> '||p_query_id,'delete_from_results_table');
24: delete msc_pq_results
25: where query_id = p_query_id
26: and plan_id = p_plan_id ;
27: end delete_from_results_table;
28:

Line 33: DELETE msc_pq_results

29: PROCEDURE delete_from_results_table(p_query_id IN NUMBER,
30: p_plan_id IN NUMBER,
31: p_detail_query_id IN NUMBER) IS
32: BEGIN
33: DELETE msc_pq_results
34: WHERE query_id = p_query_id
35: AND plan_id = p_plan_id
36: AND detail_query_id = p_detail_query_id;
37: END delete_from_results_table;

Line 48: l_insert_begin varchar2(1000) := 'INSERT INTO MSC_PQ_RESULTS ('

44: P_MASTER_QUERY_ID in NUMBER DEFAULT NULL,
45: p_sequence_id in NUMBER DEFAULT NULL) is
46: l_sql_stmt varchar2(32000);
47:
48: l_insert_begin varchar2(1000) := 'INSERT INTO MSC_PQ_RESULTS ('
49: || ' QUERY_ID, PLAN_ID, ORGANIZATION_ID, SR_INSTANCE_ID, SUMMARY_DATA,';
50: l_insert_end varchar2(1000) := 'created_by, creation_date, last_update_date, '||
51: ' last_updated_by, last_update_login) ';
52:

Line 372: INSERT INTO MSC_PQ_RESULTS(query_id,plan_id,sr_instance_id,

368:
369: end loop;
370: close c_excp_types;
371:
372: INSERT INTO MSC_PQ_RESULTS(query_id,plan_id,sr_instance_id,
373: organization_id, exception_type,
374: source_type, summary_data, sequence_id,
375: exception_count, groupby_org,
376: INVENTORY_ITEM_ID, --groupby_supply_item,

Line 394: FROM MSC_PQ_RESULTS

390: CUSTOMER_SITE_ID, SUPPLIER_SITE_ID,
391: fnd_global.user_id, sysdate,
392: fnd_global.user_id, SYSDATE,
393: detail_query_id,PRIORITY
394: FROM MSC_PQ_RESULTS
395: WHERE query_id = l_temp_query_id
396: AND plan_id = p_plan_id
397: AND ((detail_query_id <> query_id
398: AND detail_query_id = l_detail_query_id)

Line 530: INSERT INTO MSC_PQ_RESULTS (

526:
527: end loop;
528: close c_excp_types;
529:
530: INSERT INTO MSC_PQ_RESULTS (
531: query_id,
532: plan_id,
533: sr_instance_id,
534: organization_id,

Line 571: FROM MSC_PQ_RESULTS

567: fnd_global.user_id,
568: sysdate,
569: fnd_global.user_id,
570: sysdate
571: FROM MSC_PQ_RESULTS
572: WHERE query_id = l_temp_query_id --p_query_id
573: and plan_id = p_plan_id
574: GROUP BY query_id, plan_id, source_type,exception_type,sequence_id,
575: groupby_org, groupby_item, groupby_supply_item, groupby_category,

Line 630: from msc_pq_results

626: and sr_instance_id = p_inst;
627:
628: cursor cat_id(p_item number, p_seq number , p_org number, p_inst number, p_query_id number) IS
629: select category_id
630: from msc_pq_results
631: where query_id = p_query_id
632: and inventory_item_id = p_item
633: and organization_id = p_org
634: and sr_instance_id = p_inst

Line 654: from msc_pq_results

650: -- up overlapping items.
651:
652: select inventory_item_id, organization_id, sr_instance_id, max(sequence_id)
653: bulk collect into v_item_id, v_org_id, v_inst_id, v_seq
654: from msc_pq_results
655: where query_id = p_query_id
656: group by inventory_item_id, organization_id, sr_instance_id;
657:
658:

Line 954: where TABLE_NAME = 'MSC_PQ_RESULTS' and TABLE_OWNER= l_msc_schema;

950: end if;
951:
952: SELECT count(*) into l_count
953: from ALL_TAB_PARTITIONS
954: where TABLE_NAME = 'MSC_PQ_RESULTS' and TABLE_OWNER= l_msc_schema;
955:
956: l_sql_stmt :=
957: 'alter table '||l_msc_schema||'.msc_pq_results'||
958: ' truncate partition PQ_RESULTS_'||to_char(p_plan_id);

Line 957: 'alter table '||l_msc_schema||'.msc_pq_results'||

953: from ALL_TAB_PARTITIONS
954: where TABLE_NAME = 'MSC_PQ_RESULTS' and TABLE_OWNER= l_msc_schema;
955:
956: l_sql_stmt :=
957: 'alter table '||l_msc_schema||'.msc_pq_results'||
958: ' truncate partition PQ_RESULTS_'||to_char(p_plan_id);
959: --5768202 partition name changed from pq_results_all_ to pq_results_
960:
961: if l_share_partition = 'N' and l_count >0 then

Line 964: delete from msc_pq_results

960:
961: if l_share_partition = 'N' and l_count >0 then
962: EXECUTE IMMEDIATE l_sql_stmt;
963: else
964: delete from msc_pq_results
965: where plan_id = p_plan_id;
966: end if;
967: end purge_plan;
968:

Line 985: delete from msc_pq_results

981:
982: delete from msc_among_values
983: where folder_id = p_query_id;
984:
985: delete from msc_pq_results
986: where query_id = p_query_id;
987:
988: commit;
989: end delete_query;

Line 1023: l_insert_begin varchar2(1000) := 'INSERT INTO MSC_PQ_RESULTS ('||

1019: procedure Summarize_wklst_results( p_query_id IN NUMBER,
1020: p_plan_id IN NUMBER) IS
1021: l_sql_stmt varchar2(32000);
1022: l_Insert_stmt varchar2(32000);
1023: l_insert_begin varchar2(1000) := 'INSERT INTO MSC_PQ_RESULTS ('||
1024: ' QUERY_ID, PLAN_ID, ORGANIZATION_ID,'||
1025: ' SR_INSTANCE_ID, SUMMARY_DATA,';
1026: l_insert_end_new varchar2(1000) := 'sequence_id, created_by, creation_date,'||
1027: ' last_update_date, last_updated_by,'||

Line 1064: ' FROM msc_pq_results mpr '||

1060: 'nvl(mpr.exception_count,1) exception_count,'||
1061: 'mpr.priority'||
1062: l_new_group_by_cols1||
1063: '9999'||
1064: ' FROM msc_pq_results mpr '||
1065: ' WHERE mpr.query_id = '||p_query_id ||
1066: ' AND mpr.plan_id = '||p_plan_id ||
1067: ' AND mpr.summary_data = -99 ) mpr1 '||
1068: l_new_group_by_cols4;

Line 1070: l_Insert_stmt:= 'Insert into MSC_PQ_RESULTS ( '||

1066: ' AND mpr.plan_id = '||p_plan_id ||
1067: ' AND mpr.summary_data = -99 ) mpr1 '||
1068: l_new_group_by_cols4;
1069:
1070: l_Insert_stmt:= 'Insert into MSC_PQ_RESULTS ( '||
1071: 'query_id, plan_id,'||
1072: 'sr_instance_id, organization_id,'||
1073: 'exception_count, priority, summary_data'||
1074: l_new_group_by_cols2||