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 MSC_ANALYSIS_AGGREGATE

Line 401: INSERT INTO msc_analysis_aggregate

397: ELSE
398: l_week_start_date := aRecord.bkt_start_date;
399: END IF;
400:
401: INSERT INTO msc_analysis_aggregate
402: (
403: plan_id,
404: record_type,
405: safety_stock_qty,

Line 892: INSERT INTO msc_analysis_aggregate

888: -- Get default category set
889: l_default_category_set_id := get_cat_set_id(p_plan_id);
890:
891: -- Do it once for MFG calendar
892: INSERT INTO msc_analysis_aggregate
893: (
894: plan_id,
895: record_type,
896: achieved_service_level_qty1,

Line 1006: INSERT INTO msc_analysis_aggregate

1002: AND (mpb.bucket_type <> 3 OR GROUPING(mpb.bkt_start_date) <> 0)
1003: );
1004:
1005: -- And once for the BIS calendar
1006: INSERT INTO msc_analysis_aggregate
1007: (
1008: plan_id,
1009: record_type,
1010: achieved_service_level_qty1,

Line 1094: INSERT INTO msc_analysis_aggregate

1090: -- Get default category set
1091: l_default_category_set_id := get_cat_set_id(p_plan_id);
1092:
1093: -- Do it once for MFG calendar
1094: INSERT INTO msc_analysis_aggregate
1095: (
1096: plan_id,
1097: record_type,
1098: achieved_service_level_qty1,

Line 1219: INSERT INTO msc_analysis_aggregate

1215: AND (mpb.bucket_type <> 3 OR GROUPING(mpb.bkt_start_date) <> 0)
1216: );
1217:
1218: -- And once for the BIS calendar
1219: INSERT INTO msc_analysis_aggregate
1220: (
1221: plan_id,
1222: record_type,
1223: achieved_service_level_qty1,

Line 1307: INSERT INTO msc_analysis_aggregate

1303: l_default_category_set_id := get_cat_set_id(p_plan_id);
1304:
1305: /*
1306: -- Do it once for MFG calendar
1307: INSERT INTO msc_analysis_aggregate
1308: (
1309: plan_id,
1310: record_type,
1311: achieved_service_level_qty1,

Line 1399: INSERT INTO msc_analysis_aggregate

1395: */
1396:
1397: -- Do it once for MFG calendar
1398: --insert the week data first
1399: INSERT INTO msc_analysis_aggregate
1400: (
1401: plan_id,
1402: record_type,
1403: achieved_service_level_qty1,

Line 1482: INSERT INTO msc_analysis_aggregate

1478: GROUP BY msd.plan_id, mpb.bkt_start_date, mpb.bucket_type, mic.category_set_id,
1479: msd.inventory_item_id, msd.sr_instance_id, msd.organization_id, mic.sr_instance_id, mic.sr_category_id, mic.category_name, msd.demand_class;
1480:
1481: --insert the period data for MFG
1482: INSERT INTO msc_analysis_aggregate
1483: (
1484: plan_id,
1485: record_type,
1486: achieved_service_level_qty1,

Line 1558: INSERT INTO msc_analysis_aggregate

1554: GROUP BY msd.plan_id,mpsd.period_start_date, mic.category_set_id,
1555: msd.inventory_item_id, msd.sr_instance_id, msd.organization_id, mic.sr_instance_id, mic.sr_category_id, mic.category_name, msd.demand_class;
1556:
1557: -- And once for the BIS calendar
1558: INSERT INTO msc_analysis_aggregate
1559: (
1560: plan_id,
1561: record_type,
1562: achieved_service_level_qty1,

Line 1646: INSERT INTO msc_analysis_aggregate

1642: -- Get default category set
1643: l_default_category_set_id := get_cat_set_id(p_plan_id);
1644:
1645: -- Do it once for MFG calendar
1646: INSERT INTO msc_analysis_aggregate
1647: (
1648: plan_id,
1649: plan_name,
1650: record_type,

Line 1695: INSERT INTO msc_analysis_aggregate

1691: and nvl(period_type,0) = 1
1692: GROUP BY plan_id, plan_name, period_type,period_type, detail_level,category_set_id, category_id,category_name;
1693:
1694: -- And once for the BIS calendar
1695: INSERT INTO msc_analysis_aggregate
1696: (
1697: plan_id,
1698: plan_name,
1699: record_type,

Line 1754: INSERT INTO msc_analysis_aggregate

1750: -- Get default category set
1751: l_default_category_set_id := get_cat_set_id(p_plan_id);
1752:
1753: -- Do it once for the MFG calendar
1754: INSERT INTO msc_analysis_aggregate
1755: (
1756: plan_id,
1757: record_type,
1758: inventory_value_dollars,

Line 1840: INSERT INTO msc_analysis_aggregate

1836: GROUPING(mpo.sr_instance_id) = 0 AND GROUPING(mpo.organization_id) = 0 AND GROUPING(mic.sr_instance_id) = 0 AND GROUPING(mic.sr_category_id) = 0 AND GROUPING(mic.category_name) = 0
1837: );
1838:
1839: -- Do it again for the BIS calendar
1840: INSERT INTO msc_analysis_aggregate
1841: (
1842: plan_id,
1843: record_type,
1844: inventory_value_dollars,

Line 2891: where TABLE_NAME = 'MSC_ANALYSIS_AGGREGATE'

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;
2895:

Line 2907: l_partitioned_table :='MSC_ANALYSIS_AGGREGATE';

2903: end if;
2904:
2905: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', dummy1, dummy2, lv_msc_schema);
2906:
2907: l_partitioned_table :='MSC_ANALYSIS_AGGREGATE';
2908: l_partition_name := substr(l_partitioned_table,5)||'_'||to_char(p_plan_id);
2909:
2910: open c_check;
2911: fetch c_check into l_temp;

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

Line 2981: DELETE FROM msc_analysis_aggregate WHERE plan_id = p_plan_id;

2977: end if;
2978: put_line('partition created '|| l_part_retval);
2979: --dbms_output.put_line('partition created '|| l_part_retval);
2980: else
2981: DELETE FROM msc_analysis_aggregate WHERE plan_id = p_plan_id;
2982: end if;
2983:
2984: COMMIT;
2985: