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.MSD_SALES_OPERATION_PLAN dependencies on MSD_DP_SCENARIOS

Line 1027: from msd_dp_scenarios

1023: is
1024:
1025: cursor Supply_Plans is
1026: select distinct supply_plan_id
1027: from msd_dp_scenarios
1028: where demand_plan_id = p_demand_plan_id
1029: and nvl(supply_plan_id,-1) > 0; -- For Legacy Supply Plans the Supply_Plan_Name field will be populated with the Designators.
1030: -- However, UI will populate supply_plan_id as -99.
1031:

Line 1170: msd_dp_scenarios dp_scen

1166: sup_plan_bom.disable_date,
1167: sup_plan_bom.res_comp
1168: from msd_ascp_bom_comp sup_plan_bom,
1169: msc_plans sup_plan,
1170: msd_dp_scenarios dp_scen
1171: where sup_plan_bom.cap_usg_ratio_obj = sup_plan.compile_designator
1172: and sup_plan.plan_id = dp_scen.supply_plan_id
1173: and dp_scen.demand_plan_id = p_demand_plan_id
1174: and dp_scen.supply_plan_id is not null

Line 1181: from msd_dp_scenarios

1177:
1178:
1179: cursor c_supply_plan_scenarios is
1180: select scenario_name,supply_plan_name,old_supply_plan_name
1181: from msd_dp_scenarios
1182: where demand_plan_id = p_demand_plan_id
1183: and supply_plan_name is not null; -- No need to add condition of supply_plan_id > 0 because we need to
1184: -- consider scenarios with legacy loaded streams attached.
1185:

Line 1188: from msd_dp_scenarios

1184: -- consider scenarios with legacy loaded streams attached.
1185:
1186: cursor c_if_plan_still_attached(p_supply_plan_name varchar2) is
1187: select scenario_name
1188: from msd_dp_scenarios
1189: where demand_plan_id = p_demand_plan_id
1190: and old_supply_plan_name = p_supply_plan_name
1191: AND rownum < 2;
1192:

Line 1195: from msd_dp_scenarios

1191: AND rownum < 2;
1192:
1193: cursor c_if_plan_removed_currently(p_supply_plan_name varchar2) is
1194: select scenario_name
1195: from msd_dp_scenarios
1196: where demand_plan_id = p_demand_plan_id
1197: and supply_plan_name = p_supply_plan_name
1198: AND rownum < 2;
1199:

Line 1225: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;

1221:
1222: lv_new_plan_attached BOOLEAN :=FALSE;
1223: lv_removed_plan BOOLEAN :=FALSE;
1224:
1225: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1226: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1227: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1228:
1229: l_scen_name msd_dp_scenarios.scenario_name%TYPE;

Line 1226: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;

1222: lv_new_plan_attached BOOLEAN :=FALSE;
1223: lv_removed_plan BOOLEAN :=FALSE;
1224:
1225: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1226: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1227: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1228:
1229: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1230:

Line 1227: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;

1223: lv_removed_plan BOOLEAN :=FALSE;
1224:
1225: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1226: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1227: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1228:
1229: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1230:
1231: begin

Line 1229: l_scen_name msd_dp_scenarios.scenario_name%TYPE;

1225: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1226: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1227: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1228:
1229: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1230:
1231: begin
1232:
1233: LOG_MESSAGE('***********************************************************************');

Line 1596: from msd_dp_scenarios

1592: BEGIN
1593: select nvl(min(CURR_START_DATE),to_date(null)),to_date(null) INTO l_effectivity_date,l_disable_date
1594: from msc_plans
1595: where plan_id in ( select distinct supply_plan_id
1596: from msd_dp_scenarios
1597: where demand_plan_id = p_demand_plan_id
1598: and supply_plan_id > 0 );
1599: EXCEPTION
1600: WHEN NO_DATA_FOUND THEN

Line 1690: update msd_dp_scenarios

1686: LOG_MESSAGE('Updating the Old Supply Plan Columns');
1687: -- Populating the Old_Supply_Plan_Name and Old_Supply_Plan_ID
1688: -- to track for the the next run if we need to re-populate the collapsed bom table for
1689: -- this plan or not.
1690: update msd_dp_scenarios
1691: set old_supply_plan_id = supply_plan_id,
1692: old_supply_plan_name = supply_plan_name
1693: where demand_plan_id = p_demand_plan_id
1694: and supply_plan_name is not null;

Line 1708: update msd_dp_scenarios

1704: LOG_MESSAGE('Updating the Old Supply Plan Columns');
1705: -- Populating the Old_Supply_Plan_Name and Old_Supply_Plan_ID
1706: -- to track for the the next run if we need to re-populate the collapsed bom table for
1707: -- this plan or not.
1708: update msd_dp_scenarios
1709: set old_supply_plan_id = supply_plan_id,
1710: old_supply_plan_name = supply_plan_name
1711: where demand_plan_id = p_demand_plan_id
1712: and supply_plan_name is not null;

Line 1738: from msd_dp_scenarios

1734: is
1735:
1736: cursor Supply_Plans is
1737: select distinct supply_plan_id
1738: from msd_dp_scenarios
1739: where demand_plan_id = p_demand_plan_id
1740: and nvl(supply_plan_id,-1) > 0; -- For Legacy Supply Plans the Supply_Plan_Name field will be populated with the Designators.
1741: -- However, UI will populate supply_plan_id as -99.
1742:

Line 1867: msd_dp_scenarios dp_scen

1863: sup_plan_bom.sr_component_pk,
1864: sup_plan_bom.bom_type
1865: from msd_ascp_bom_comp sup_plan_bom,
1866: msc_plans sup_plan,
1867: msd_dp_scenarios dp_scen
1868: where sup_plan_bom.cap_usg_ratio_obj = sup_plan.compile_designator
1869: and sup_plan.plan_id = dp_scen.supply_plan_id
1870: and dp_scen.demand_plan_id = p_demand_plan_id
1871: and dp_scen.supply_plan_id is not null

Line 1876: from msd_dp_scenarios

1872: order by sup_plan_bom.sr_instance_id,sup_plan_bom.sr_assembly_pk,sup_plan_bom.sr_component_pk;
1873:
1874: cursor c_supply_plan_scenarios is
1875: select scenario_name,supply_plan_name,old_supply_plan_name
1876: from msd_dp_scenarios
1877: where demand_plan_id = p_demand_plan_id
1878: and supply_plan_name is not null; -- No need to add condition of supply_plan_id > 0 because we need to
1879: -- consider scenarios with legacy loaded streams attached.
1880:

Line 1883: from msd_dp_scenarios

1879: -- consider scenarios with legacy loaded streams attached.
1880:
1881: cursor c_if_plan_still_attached(p_supply_plan_name varchar2) is
1882: select scenario_name
1883: from msd_dp_scenarios
1884: where demand_plan_id = p_demand_plan_id
1885: and old_supply_plan_name = p_supply_plan_name
1886: AND rownum < 2;
1887:

Line 1890: from msd_dp_scenarios

1886: AND rownum < 2;
1887:
1888: cursor c_if_plan_removed_currently(p_supply_plan_name varchar2) is
1889: select scenario_name
1890: from msd_dp_scenarios
1891: where demand_plan_id = p_demand_plan_id
1892: and supply_plan_name = p_supply_plan_name
1893: AND rownum < 2;
1894:

Line 1915: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;

1911:
1912: lv_new_plan_attached BOOLEAN :=FALSE;
1913: lv_removed_plan BOOLEAN :=FALSE;
1914:
1915: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1916: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1917: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1918:
1919: l_scen_name msd_dp_scenarios.scenario_name%TYPE;

Line 1916: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;

1912: lv_new_plan_attached BOOLEAN :=FALSE;
1913: lv_removed_plan BOOLEAN :=FALSE;
1914:
1915: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1916: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1917: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1918:
1919: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1920:

Line 1917: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;

1913: lv_removed_plan BOOLEAN :=FALSE;
1914:
1915: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1916: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1917: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1918:
1919: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1920:
1921: begin

Line 1919: l_scen_name msd_dp_scenarios.scenario_name%TYPE;

1915: l_scenario_name msd_dp_scenarios.scenario_name%TYPE;
1916: l_supply_plan_name msd_dp_scenarios.supply_plan_name%TYPE;
1917: l_old_supply_plan_name msd_dp_scenarios.old_supply_plan_name%TYPE;
1918:
1919: l_scen_name msd_dp_scenarios.scenario_name%TYPE;
1920:
1921: begin
1922:
1923: LOG_MESSAGE('***********************************************************************');

Line 2315: update msd_dp_scenarios

2311: LOG_MESSAGE('Updating the Old Supply Plan Columns');
2312: -- Populating the Old_Supply_Plan_Name and Old_Supply_Plan_ID
2313: -- to track for the the next run if we need to re-populate the collapsed bom table for
2314: -- this plan or not.
2315: update msd_dp_scenarios
2316: set old_supply_plan_id = supply_plan_id,
2317: old_supply_plan_name = supply_plan_name
2318: where demand_plan_id = p_demand_plan_id
2319: and supply_plan_name is not null;