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 387: INSERT INTO msc_analysis_aggregate

383: ELSE
384: l_week_start_date := aRecord.bkt_start_date;
385: END IF;
386:
387: INSERT INTO msc_analysis_aggregate
388: (
389: plan_id,
390: record_type,
391: safety_stock_qty,

Line 877: INSERT INTO msc_analysis_aggregate

873: -- Get default category set
874: l_default_category_set_id := get_cat_set_id(p_plan_id);
875:
876: -- Do it once for MFG calendar
877: INSERT INTO msc_analysis_aggregate
878: (
879: plan_id,
880: record_type,
881: achieved_service_level_qty1,

Line 1002: INSERT INTO msc_analysis_aggregate

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

Line 1089: INSERT INTO msc_analysis_aggregate

1085: l_default_category_set_id := get_cat_set_id(p_plan_id);
1086:
1087: /*
1088: -- Do it once for MFG calendar
1089: INSERT INTO msc_analysis_aggregate
1090: (
1091: plan_id,
1092: record_type,
1093: achieved_service_level_qty1,

Line 1181: INSERT INTO msc_analysis_aggregate

1177: */
1178:
1179: -- Do it once for MFG calendar
1180: --insert the week data first
1181: INSERT INTO msc_analysis_aggregate
1182: (
1183: plan_id,
1184: record_type,
1185: achieved_service_level_qty1,

Line 1264: INSERT INTO msc_analysis_aggregate

1260: GROUP BY msd.plan_id, mpb.bkt_start_date, mpb.bucket_type, mic.category_set_id,
1261: 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;
1262:
1263: --insert the period data for MFG
1264: INSERT INTO msc_analysis_aggregate
1265: (
1266: plan_id,
1267: record_type,
1268: achieved_service_level_qty1,

Line 1340: INSERT INTO msc_analysis_aggregate

1336: GROUP BY msd.plan_id,mpsd.period_start_date, mic.category_set_id,
1337: 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;
1338:
1339: -- And once for the BIS calendar
1340: INSERT INTO msc_analysis_aggregate
1341: (
1342: plan_id,
1343: record_type,
1344: achieved_service_level_qty1,

Line 1428: INSERT INTO msc_analysis_aggregate

1424: -- Get default category set
1425: l_default_category_set_id := get_cat_set_id(p_plan_id);
1426:
1427: -- Do it once for the MFG calendar
1428: INSERT INTO msc_analysis_aggregate
1429: (
1430: plan_id,
1431: record_type,
1432: inventory_value_dollars,

Line 1514: INSERT INTO msc_analysis_aggregate

1510: 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
1511: );
1512:
1513: -- Do it again for the BIS calendar
1514: INSERT INTO msc_analysis_aggregate
1515: (
1516: plan_id,
1517: record_type,
1518: inventory_value_dollars,

Line 2474: DELETE FROM msc_analysis_aggregate WHERE plan_id = p_plan_id;

2470: END IF;
2471:
2472: g_user_id := fnd_global.user_id;
2473:
2474: DELETE FROM msc_analysis_aggregate WHERE plan_id = p_plan_id;
2475: COMMIT;
2476:
2477: schedule_aggregate_sl(p_plan_id);
2478: COMMIT;