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_ANALYSIS_SAFETY_STOCK_PERF dependencies on ALL_TAB_PARTITIONS

Line 2890: from all_tab_partitions

2886: lv_retval boolean;
2887:
2888: cursor c_check is
2889: select count(*)
2890: from all_tab_partitions
2891: where TABLE_NAME = 'MSC_ANALYSIS_AGGREGATE'
2892: and table_owner = lv_msc_schema
2893: and partition_name = l_partition_name;
2894: l_temp number;

Line 2969: select count(*) into l_temp from sys.all_tab_partitions where table_name = 'MSC_ANALYSIS_AGGREGATE'

2965: else
2966: g_perf_prof_on := true;
2967: end if;
2968:
2969: select count(*) into l_temp from sys.all_tab_partitions where table_name = 'MSC_ANALYSIS_AGGREGATE'
2970: AND PARTITION_NAME = 'ANALYSIS_AGGREGATE_'||P_PLAN_ID;
2971: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
2972:
2973: if (l_temp = 0 and lv_share_partition <> 'Y')then --create partition