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_SNAPSHOT_PK dependencies on MSC_DMD_SCN_METRICS

Line 2020: 'DELETE FROM MSC_DMD_SCN_METRICS WHERE PLAN_ID = ' || p_plan_id;

2016: -- Else use the truncate partition
2017: IF (lv_share_partition = 'Y' or lv_parallel_run = 'Y') THEN
2018:
2019: lv_sql_stmt :=
2020: 'DELETE FROM MSC_DMD_SCN_METRICS WHERE PLAN_ID = ' || p_plan_id;
2021:
2022: ELSE
2023:
2024: lv_part_name := 'DMD_SCN_METRICS_' || p_plan_id;

Line 2027: 'ALTER TABLE '||lv_msc_schema||'.MSC_DMD_SCN_METRICS TRUNCATE PARTITION ' || lv_part_name;

2023:
2024: lv_part_name := 'DMD_SCN_METRICS_' || p_plan_id;
2025:
2026: lv_sql_stmt :=
2027: 'ALTER TABLE '||lv_msc_schema||'.MSC_DMD_SCN_METRICS TRUNCATE PARTITION ' || lv_part_name;
2028:
2029: END IF;
2030:
2031: EXECUTE IMMEDIATE lv_sql_stmt;

Line 2033: INSERT INTO MSC_DMD_SCN_METRICS

2029: END IF;
2030:
2031: EXECUTE IMMEDIATE lv_sql_stmt;
2032:
2033: INSERT INTO MSC_DMD_SCN_METRICS
2034: (
2035: PLAN_ID,
2036: SCENARIO_ID,
2037: INVENTORY_ITEM_ID,

Line 2066: MSC_DMD_SCN_METRICS mdsm,

2062: mdsm.LAST_UPDATE_DATE LAST_UPDATE_DATE,
2063: mdsm.LAST_UPDATED_BY LAST_UPDATED_BY,
2064: mdsm.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
2065: FROM
2066: MSC_DMD_SCN_METRICS mdsm,
2067: MSC_PLAN_SCHEDULES mpsv
2068: WHERE
2069: -1 = mdsm.plan_id
2070: AND mpsv.input_schedule_id = mdsm.scenario_id