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_STRIPE_DEMAND_PLAN dependencies on MSD_LEVEL_VALUES

Line 637: delete from msd_level_values_ds

633: -- If LOB is not specified and Stream is not specified, but existing partition exists.
634: --
635: elsif ((l_dp_rec.build_stripe_level_pk is not null) or (l_dp_rec.build_stripe_stream_name is not null)) then
636:
637: delete from msd_level_values_ds
638: where demand_plan_id = p_demand_plan_id;
639:
640: delete from msd_cs_Data_ds
641: where demand_plan_id = p_demand_plan_id;

Line 723: insert into msd_level_values_ds_temp

719: end if;
720:
721: close c1;
722:
723: insert into msd_level_values_ds_temp
724: (
725: DEMAND_PLAN_ID,
726: INSTANCE,
727: LEVEL_ID,

Line 751: from msd_level_values mlv,

747: fnd_global.user_id,
748: mlv.system_attribute1,
749: mlv.system_attribute2,
750: mlv.dp_enabled_flag
751: from msd_level_values mlv,
752: msd_level_values_ds_temp mld,
753: msd_level_associations mla
754: where mla.level_id = x_child_level
755: and mla.parent_level_id = x_current_parent_level_id

Line 752: msd_level_values_ds_temp mld,

748: mlv.system_attribute1,
749: mlv.system_attribute2,
750: mlv.dp_enabled_flag
751: from msd_level_values mlv,
752: msd_level_values_ds_temp mld,
753: msd_level_associations mla
754: where mla.level_id = x_child_level
755: and mla.parent_level_id = x_current_parent_level_id
756: and mla.parent_level_id = mld.level_id

Line 776: from msd_level_values_ds_temp

772: fnd_global.user_id,
773: system_attribute1,
774: system_attribute2,
775: dp_enabled_flag
776: from msd_level_values_ds_temp
777: where demand_plan_id = p_demand_plan_id;
778:
779:
780: x_current_parent_level_id := x_child_level;

Line 843: insert into msd_level_values_ds_temp

839: end if;
840:
841: close c1;
842:
843: insert into msd_level_values_ds_temp
844: (
845: DEMAND_PLAN_ID,
846: INSTANCE,
847: LEVEL_ID,

Line 871: from msd_level_values mlv,

867: fnd_global.user_id,
868: mlv.system_attribute1,
869: mlv.system_attribute2,
870: mlv.dp_enabled_flag
871: from msd_level_values mlv,
872: msd_level_values_ds_temp mld,
873: msd_level_associations mla
874: where mla.parent_level_id = x_parent_level
875: and mla.level_id = x_current_child_level_id

Line 872: msd_level_values_ds_temp mld,

868: mlv.system_attribute1,
869: mlv.system_attribute2,
870: mlv.dp_enabled_flag
871: from msd_level_values mlv,
872: msd_level_values_ds_temp mld,
873: msd_level_associations mla
874: where mla.parent_level_id = x_parent_level
875: and mla.level_id = x_current_child_level_id
876: and mla.level_id = mld.level_id

Line 896: from msd_level_values_ds_temp

892: fnd_global.user_id,
893: system_attribute1,
894: system_attribute2,
895: dp_enabled_flag
896: from msd_level_values_ds_temp
897: where demand_plan_id = p_demand_plan_id;
898:
899: x_current_child_level_id := x_parent_level;
900:

Line 922: insert into msd_level_values_ds_temp

918: debug_out( 'Entering insert_related_orgs ' || to_char(sysdate, 'hh24:mi:ss'));
919: end if;
920:
921:
922: insert into msd_level_values_ds_temp
923: (
924: DEMAND_PLAN_ID,
925: INSTANCE,
926: LEVEL_ID,

Line 950: msd_level_values mlv,

946: mlv.system_attribute1,
947: mlv.system_attribute2,
948: mlv.dp_enabled_flag
949: from msd_level_org_asscns mlo,
950: msd_level_values mlv,
951: msd_level_values_ds_temp mld
952: where mld.demand_plan_id = p_demand_plan_id
953: and mlo.instance = mld.instance
954: and mlo.org_level_id = p_level_id

Line 951: msd_level_values_ds_temp mld

947: mlv.system_attribute2,
948: mlv.dp_enabled_flag
949: from msd_level_org_asscns mlo,
950: msd_level_values mlv,
951: msd_level_values_ds_temp mld
952: where mld.demand_plan_id = p_demand_plan_id
953: and mlo.instance = mld.instance
954: and mlo.org_level_id = p_level_id
955: and mlo.org_sr_level_pk = mlv.sr_level_pk

Line 973: from msd_level_values_ds_temp

969: fnd_global.user_id,
970: system_attribute1,
971: system_attribute2,
972: dp_enabled_flag
973: from msd_level_values_ds_temp
974: where demand_plan_id = p_demand_plan_id;
975:
976: chk_insert_org_no_associations (errbuf,
977: retcode,

Line 1041: insert into msd_level_values_ds_temp

1037: end if;
1038:
1039: if (v_is_dp_dim = C_TRUE) then
1040:
1041: insert into msd_level_values_ds_temp
1042: (
1043: DEMAND_PLAN_ID,
1044: INSTANCE,
1045: LEVEL_ID,

Line 1069: msd_level_values mlv,

1065: mlv.system_attribute1,
1066: mlv.system_attribute2,
1067: mlv.dp_enabled_flag
1068: from msd_level_org_asscns mlo,
1069: msd_level_values mlv,
1070: msd_level_values_ds_temp mld
1071: where mld.demand_plan_id = p_demand_plan_id
1072: and mlo.instance = mld.instance
1073: -- and mlo.org_level_id = mld.level_id Bug# 4929528

Line 1070: msd_level_values_ds_temp mld

1066: mlv.system_attribute2,
1067: mlv.dp_enabled_flag
1068: from msd_level_org_asscns mlo,
1069: msd_level_values mlv,
1070: msd_level_values_ds_temp mld
1071: where mld.demand_plan_id = p_demand_plan_id
1072: and mlo.instance = mld.instance
1073: -- and mlo.org_level_id = mld.level_id Bug# 4929528
1074: and mlo.org_level_id = decode(p_level_id,C_ITEM_LEVEL_ID, 7, 8) -- Bug# 4929528

Line 1095: from msd_level_values_ds_temp

1091: fnd_global.user_id,
1092: system_attribute1,
1093: system_attribute2,
1094: dp_enabled_flag
1095: from msd_level_values_ds_temp
1096: where demand_plan_id = p_demand_plan_id;
1097:
1098: /* ISO Code Change - Only for GEO dimension - Insert the internal sites for the
1099: * ISO orgs attached to the plan

Line 1103: INSERT INTO msd_level_values_ds_temp

1099: * ISO orgs attached to the plan
1100: */
1101: IF (p_level_id in (C_SHIP_LEVEL_ID)) THEN
1102:
1103: INSERT INTO msd_level_values_ds_temp
1104: ( DEMAND_PLAN_ID,
1105: INSTANCE,
1106: LEVEL_ID,
1107: SR_LEVEL_PK,

Line 1130: msd_level_values mlv

1126: mlv.system_attribute2,
1127: mlv.dp_enabled_flag
1128: FROM msd_dp_iso_organizations mdio,
1129: msd_level_org_asscns mloa,
1130: msd_level_values mlv
1131: WHERE
1132: mdio.demand_plan_id = p_demand_plan_id
1133: AND mloa.instance = mdio.sr_instance_id
1134: AND mloa.level_id = 11

Line 1154: FROM msd_level_values_ds_temp

1150: fnd_global.user_id,
1151: system_attribute1,
1152: system_attribute2,
1153: dp_enabled_flag
1154: FROM msd_level_values_ds_temp
1155: WHERE demand_plan_id = p_demand_plan_id;
1156:
1157: END IF;
1158: end if;

Line 1182: insert into msd_level_values_ds_temp

1178: end if;
1179:
1180: if ((p_insert_rep is null) and (p_insert_geo is null)) then
1181:
1182: insert into msd_level_values_ds_temp
1183: (
1184: DEMAND_PLAN_ID,
1185: INSTANCE,
1186: LEVEL_ID,

Line 1209: from msd_level_values mlv,

1205: fnd_global.user_id,
1206: mlv.system_attribute1,
1207: mlv.system_attribute2,
1208: mlv.dp_enabled_flag
1209: from msd_level_values mlv,
1210: msd_levels ml
1211: where ml.level_id = mlv.level_id
1212: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_REP_DIM_CODE,C_GEO_DIM_CODE)
1213: minus

Line 1226: from msd_level_values_ds_temp

1222: fnd_global.user_id,
1223: system_attribute1,
1224: system_attribute2,
1225: dp_enabled_flag
1226: from msd_level_values_ds_temp
1227: where demand_plan_id = p_demand_plan_id;
1228:
1229: elsif ((p_insert_rep is not null) and (p_insert_geo is null)) then
1230:

Line 1231: insert into msd_level_values_ds_temp

1227: where demand_plan_id = p_demand_plan_id;
1228:
1229: elsif ((p_insert_rep is not null) and (p_insert_geo is null)) then
1230:
1231: insert into msd_level_values_ds_temp
1232: (
1233: DEMAND_PLAN_ID,
1234: INSTANCE,
1235: LEVEL_ID,

Line 1258: from msd_level_values mlv,

1254: fnd_global.user_id,
1255: mlv.system_attribute1,
1256: mlv.system_attribute2,
1257: mlv.dp_enabled_flag
1258: from msd_level_values mlv,
1259: msd_levels ml
1260: where ml.level_id = mlv.level_id
1261: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_GEO_DIM_CODE)
1262: minus

Line 1275: from msd_level_values_ds_temp

1271: fnd_global.user_id,
1272: system_attribute1,
1273: system_attribute2,
1274: dp_enabled_flag
1275: from msd_level_values_ds_temp
1276: where demand_plan_id = p_demand_plan_id;
1277:
1278: elsif ((p_insert_rep is null) and (p_insert_geo is not null)) then
1279:

Line 1280: insert into msd_level_values_ds_temp

1276: where demand_plan_id = p_demand_plan_id;
1277:
1278: elsif ((p_insert_rep is null) and (p_insert_geo is not null)) then
1279:
1280: insert into msd_level_values_ds_temp
1281: (
1282: DEMAND_PLAN_ID,
1283: INSTANCE,
1284: LEVEL_ID,

Line 1307: from msd_level_values mlv,

1303: fnd_global.user_id,
1304: mlv.system_attribute1,
1305: mlv.system_attribute2,
1306: mlv.dp_enabled_flag
1307: from msd_level_values mlv,
1308: msd_levels ml
1309: where ml.level_id = mlv.level_id
1310: and ml.dimension_code not in (C_PRD_DIM_CODE,C_GEO_DIM_CODE,C_REP_DIM_CODE)
1311: minus

Line 1324: from msd_level_values_ds_temp

1320: fnd_global.user_id,
1321: system_attribute1,
1322: system_attribute2,
1323: dp_enabled_flag
1324: from msd_level_values_ds_temp
1325: where demand_plan_id = p_demand_plan_id;
1326:
1327: elsif ((p_insert_rep is not null) and (p_insert_geo is not null)) then
1328:

Line 1329: insert into msd_level_values_ds_temp

1325: where demand_plan_id = p_demand_plan_id;
1326:
1327: elsif ((p_insert_rep is not null) and (p_insert_geo is not null)) then
1328:
1329: insert into msd_level_values_ds_temp
1330: (
1331: DEMAND_PLAN_ID,
1332: INSTANCE,
1333: LEVEL_ID,

Line 1356: from msd_level_values mlv,

1352: fnd_global.user_id,
1353: mlv.system_attribute1,
1354: mlv.system_attribute2,
1355: mlv.dp_enabled_flag
1356: from msd_level_values mlv,
1357: msd_levels ml
1358: where ml.level_id = mlv.level_id
1359: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE)
1360: minus

Line 1373: from msd_level_values_ds_temp

1369: fnd_global.user_id,
1370: system_attribute1,
1371: system_attribute2,
1372: dp_enabled_flag
1373: from msd_level_values_ds_temp
1374: where demand_plan_id = p_demand_plan_id;
1375: end if;
1376:
1377: -- Bug 3239820. Cannot Download Input Scenario if LOB used

Line 1484: -- msd_level_values_ds mld

1480: -- sysdate,
1481: -- fnd_global.user_id
1482: -- from (select demand_plan_id from msd_dp_session) mds,
1483: -- msd_cs_data_v1 csd,
1484: -- msd_level_values_ds mld
1485: -- where csd.cs_definition_id = 21
1486: -- and mld.level_pk = csd.product_lvl_pk
1487:
1488: procedure insert_fact_data (errbuf out nocopy varchar2,

Line 1619: v_sql_stmt := v_sql_stmt || ' , ' || ' msd_level_values_ds mld' || i ;

1615:
1616: for c2_rec in c2(c1_rec.cs_definition_id) loop
1617:
1618: i := i + 1;
1619: v_sql_stmt := v_sql_stmt || ' , ' || ' msd_level_values_ds mld' || i ;
1620:
1621: v_sql_where_stmt := v_sql_where_stmt || ' and mld' || i || '.level_pk = cdv.' || c2_rec.dimension_code || '_LEVEL_VALUE_PK ';
1622: v_sql_where_stmt := v_sql_where_stmt || ' and mld' || i || '.demand_plan_id = mds.demand_plan_id ';
1623: end loop;

Line 1701: from msd_level_values

1697: cursor c1(p_instance in varchar2,
1698: p_level_id in number,
1699: p_sr_level_pk in varchar2) is
1700: select level_pk, level_value, system_attribute1, system_attribute2, dp_enabled_flag
1701: from msd_level_values
1702: where instance = p_instance
1703: and level_id = p_level_id
1704: and sr_level_pk = p_sr_level_pk;
1705:

Line 1715: delete from msd_level_values_ds_temp

1711: debug_out( 'Entering create_level_val_stripe ' || to_char(sysdate, 'hh24:mi:ss'));
1712: end if;
1713:
1714:
1715: delete from msd_level_values_ds_temp
1716: where demand_plan_id = p_demand_plan_id;
1717:
1718:
1719: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);

Line 1723: insert into msd_level_values_ds_temp

1719: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
1720: fetch c1 into l_c1_rec;
1721: close c1;
1722:
1723: insert into msd_level_values_ds_temp
1724: (
1725: DEMAND_PLAN_ID,
1726: INSTANCE,
1727: LEVEL_ID,

Line 1801: from msd_level_values_ds

1797: retcode out nocopy varchar2,
1798: p_demand_plan_id in number) return varchar2 is
1799: cursor c1 is
1800: select demand_plan_id, instance, level_id, sr_level_pk
1801: from msd_level_values_ds
1802: where demand_plan_id = p_demand_plan_id
1803: minus
1804: select demand_plan_id, instance, level_id, sr_level_pk
1805: from msd_level_values_ds_temp

Line 1805: from msd_level_values_ds_temp

1801: from msd_level_values_ds
1802: where demand_plan_id = p_demand_plan_id
1803: minus
1804: select demand_plan_id, instance, level_id, sr_level_pk
1805: from msd_level_values_ds_temp
1806: where demand_plan_id = p_demand_plan_id;
1807:
1808: cursor c2 is
1809: select demand_plan_id, instance, level_id, sr_level_pk

Line 1810: from msd_level_values_ds_temp

1806: where demand_plan_id = p_demand_plan_id;
1807:
1808: cursor c2 is
1809: select demand_plan_id, instance, level_id, sr_level_pk
1810: from msd_level_values_ds_temp
1811: where demand_plan_id = p_demand_plan_id
1812: minus
1813: select demand_plan_id, instance, level_id, sr_level_pk
1814: from msd_level_values_ds

Line 1814: from msd_level_values_ds

1810: from msd_level_values_ds_temp
1811: where demand_plan_id = p_demand_plan_id
1812: minus
1813: select demand_plan_id, instance, level_id, sr_level_pk
1814: from msd_level_values_ds
1815: where demand_plan_id = p_demand_plan_id;
1816:
1817: l_rec_1 c1%rowtype;
1818: l_rec_2 c2%rowtype;

Line 1848: delete from msd_level_values_ds

1844: debug_out( 'Entering copy_level_val_stripe ' || to_char(sysdate, 'hh24:mi:ss'));
1845: end if;
1846:
1847:
1848: delete from msd_level_values_ds
1849: where demand_plan_id = p_demand_plan_id;
1850:
1851: insert into msd_level_values_ds
1852: (

Line 1851: insert into msd_level_values_ds

1847:
1848: delete from msd_level_values_ds
1849: where demand_plan_id = p_demand_plan_id;
1850:
1851: insert into msd_level_values_ds
1852: (
1853: DEMAND_PLAN_ID,
1854: INSTANCE,
1855: LEVEL_ID,

Line 1878: from msd_level_values_ds_temp

1874: CREATED_BY,
1875: SYSTEM_ATTRIBUTE1,
1876: SYSTEM_ATTRIBUTE2,
1877: DP_ENABLED_FLAG
1878: from msd_level_values_ds_temp
1879: where demand_plan_id = p_demand_plan_id;
1880:
1881: delete from msd_level_values_ds_temp
1882: where demand_plan_id = p_demand_plan_id;

Line 1881: delete from msd_level_values_ds_temp

1877: DP_ENABLED_FLAG
1878: from msd_level_values_ds_temp
1879: where demand_plan_id = p_demand_plan_id;
1880:
1881: delete from msd_level_values_ds_temp
1882: where demand_plan_id = p_demand_plan_id;
1883:
1884: /* Bug# 5078878
1885: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics

Line 1885: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics

1881: delete from msd_level_values_ds_temp
1882: where demand_plan_id = p_demand_plan_id;
1883:
1884: /* Bug# 5078878
1885: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics
1886: are upto date when insert into msd_cs_data_ds is done.
1887: */
1888: commit;
1889: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);

Line 1889: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);

1885: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics
1886: are upto date when insert into msd_cs_data_ds is done.
1887: */
1888: commit;
1889: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);
1890:
1891: if l_debug = C_YES_FLAG then
1892: debug_out( 'Exiting copy_level_val_stripe ' || to_char(sysdate, 'hh24:mi:ss'));
1893: end if;

Line 2011: msd_level_values_ds mlvd,

2007: from msd_events me,
2008: msd_dp_events mde,
2009: msd_event_products mep,
2010: msd_evt_prod_relationships mepr,
2011: msd_level_values_ds mlvd,
2012: msd_level_values mlv
2013: where mepr.instance = mlvd.instance
2014: and mepr.product_lvl_id = mlvd.level_id
2015: and mlvd.level_id = 1

Line 2012: msd_level_values mlv

2008: msd_dp_events mde,
2009: msd_event_products mep,
2010: msd_evt_prod_relationships mepr,
2011: msd_level_values_ds mlvd,
2012: msd_level_values mlv
2013: where mepr.instance = mlvd.instance
2014: and mepr.product_lvl_id = mlvd.level_id
2015: and mlvd.level_id = 1
2016: and mepr.sr_product_lvl_pk = mlvd.sr_level_pk

Line 2032: from msd_level_values_ds

2028: minus
2029: select instance,
2030: level_id,
2031: sr_level_pk
2032: from msd_level_values_ds
2033: where demand_plan_id = p_demand_plan_id;
2034:
2035: begin
2036:

Line 2070: from msd_level_values

2066: cursor c1(p_instance in varchar2,
2067: p_level_id in number,
2068: p_sr_level_pk in varchar2) is
2069: select level_pk, level_value
2070: from msd_level_values
2071: where instance = p_instance
2072: and level_id = p_level_id
2073: and sr_level_pk = p_sr_level_pk;
2074:

Line 2382: from msd_level_values_ds_temp

2378: p_level_id in number) return varchar2 IS
2379:
2380: cursor chk_row_count is
2381: select 1
2382: from msd_level_values_ds_temp
2383: where demand_plan_id = p_demand_plan_id
2384: and level_id = p_level_id
2385: and rownum = 1;
2386:

Line 2428: delete from msd_level_values_ds_temp

2424: if l_debug = C_YES_FLAG then
2425: debug_out( 'Entering create_level_val_stripe_stream ' || to_char(sysdate, 'hh24:mi:ss'));
2426: end if;
2427:
2428: delete from msd_level_values_ds_temp
2429: where demand_plan_id = p_demand_plan_id;
2430:
2431: insert_stream_items(errbuf,
2432: retcode,

Line 2491: from msd_level_values

2487: cursor c1(p_instance in varchar2,
2488: p_level_id in number,
2489: p_sr_level_pk in varchar2) is
2490: select level_pk, level_value, system_attribute1, system_attribute2, dp_enabled_flag
2491: from msd_level_values
2492: where instance = p_instance
2493: and level_id = p_level_id
2494: and sr_level_pk = p_sr_level_pk;
2495:

Line 2501: delete from msd_level_values_ds_temp

2497: x_refresh_num number;
2498:
2499: BEGIN
2500:
2501: delete from msd_level_values_ds_temp
2502: where demand_plan_id = p_demand_plan_id;
2503:
2504: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
2505: fetch c1 into l_c1_rec;

Line 2508: insert into msd_level_values_ds_temp

2504: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
2505: fetch c1 into l_c1_rec;
2506: close c1;
2507:
2508: insert into msd_level_values_ds_temp
2509: (
2510: DEMAND_PLAN_ID,
2511: INSTANCE,
2512: LEVEL_ID,

Line 2720: l_sql_stmt := ' insert into msd_level_values_ds_temp ' ||

2716: close get_dim_col_id;
2717:
2718: x_desig_clmn_name := get_desig_clmn_name (x_cs_definition_id);
2719:
2720: l_sql_stmt := ' insert into msd_level_values_ds_temp ' ||
2721: ' ( ' ||
2722: ' DEMAND_PLAN_ID, ' ||
2723: ' INSTANCE, ' ||
2724: ' LEVEL_ID, ' ||

Line 2747: ' from msd_level_values mlv, ' ||

2743: ' fnd_global.user_id, ' ||
2744: ' mlv.system_attribute1, ' ||
2745: ' mlv.system_attribute2, ' ||
2746: ' mlv.dp_enabled_flag ' ||
2747: ' from msd_level_values mlv, ' ||
2748: x_planning_server_view_name || ' fact ' ||
2749: ' where mlv.level_pk = fact.' || p_dim_code || '_LEVEL_VALUE_PK ' ||
2750: ' and mlv.level_id = fact.' || x_dim_lvl_clmn_name ||
2751: ' and fact.action_code = ''I''';

Line 2842: from msd_level_values

2838: cursor c1(p_instance in varchar2,
2839: p_level_id in number,
2840: p_sr_level_pk in varchar2) is
2841: select level_pk, level_value
2842: from msd_level_values
2843: where instance = p_instance
2844: and level_id = p_level_id
2845: and sr_level_pk = p_sr_level_pk;
2846:

Line 2941: l_sql_stmt := ' delete from msd_level_values_ds_temp ' ||

2937: close get_dim_col_id;
2938:
2939: x_desig_clmn_name := get_desig_clmn_name(x_cs_definition_id);
2940:
2941: l_sql_stmt := ' delete from msd_level_values_ds_temp ' ||
2942: ' where level_id = ' || C_ITEM_LEVEL_ID ||
2943: ' and demand_plan_id = ' || p_demand_plan_id ||
2944: ' and level_pk in ( ' ||
2945: ' select to_char(level_pk) from msd_level_values_ds_temp ' ||

Line 2945: ' select to_char(level_pk) from msd_level_values_ds_temp ' ||

2941: l_sql_stmt := ' delete from msd_level_values_ds_temp ' ||
2942: ' where level_id = ' || C_ITEM_LEVEL_ID ||
2943: ' and demand_plan_id = ' || p_demand_plan_id ||
2944: ' and level_pk in ( ' ||
2945: ' select to_char(level_pk) from msd_level_values_ds_temp ' ||
2946: ' where demand_plan_id = ' || p_demand_plan_id ||
2947: ' minus select to_char(' ||
2948: ' fact.' || p_dim_code || '_LEVEL_VALUE_PK) ' ||
2949: ' from ' || x_planning_server_view_name || ' fact ' ||

Line 2981: insert into msd_level_values_ds_temp

2977: if l_debug = C_YES_FLAG then
2978: debug_out( 'Entering insert_supercession_items ' || to_char(sysdate, 'hh24:mi:ss'));
2979: end if;
2980:
2981: insert into msd_level_values_ds_temp
2982: (
2983: DEMAND_PLAN_ID,
2984: INSTANCE,
2985: LEVEL_ID,

Line 3012: msd_level_values_ds_temp mlvd,

3008: from msd_dp_events mde,
3009: msd_events me,
3010: msd_event_products mep,
3011: msd_evt_prod_relationships mepr,
3012: msd_level_values_ds_temp mlvd,
3013: msd_level_values mlv
3014: where mepr.instance = mlvd.instance
3015: and mepr.product_lvl_id = mlvd.level_id
3016: and mlvd.level_id = 1

Line 3013: msd_level_values mlv

3009: msd_events me,
3010: msd_event_products mep,
3011: msd_evt_prod_relationships mepr,
3012: msd_level_values_ds_temp mlvd,
3013: msd_level_values mlv
3014: where mepr.instance = mlvd.instance
3015: and mepr.product_lvl_id = mlvd.level_id
3016: and mlvd.level_id = 1
3017: and mepr.sr_product_lvl_pk = mlvd.sr_level_pk

Line 3042: from msd_level_values_ds_temp

3038: fnd_global.user_id,
3039: system_attribute1,
3040: system_attribute2,
3041: dp_enabled_flag
3042: from msd_level_values_ds_temp
3043: where demand_plan_id = p_demand_plan_id;
3044:
3045: if l_debug = C_YES_FLAG then
3046: debug_out( 'Exiting insert_supercession_items ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3112: from msd_level_values_ds_temp

3108: p_demand_plan_id in number) is
3109:
3110: cursor chk_pseudo is
3111: select 1
3112: from msd_level_values_ds_temp
3113: where demand_plan_id = p_demand_plan_id
3114: and level_pk = C_PSEUDO_PK;
3115:
3116: x_cnt number;

Line 3128: insert into msd_level_values_ds_temp

3124: open chk_pseudo;
3125: fetch chk_pseudo into x_cnt;
3126: if (chk_pseudo%NOTFOUND) then
3127:
3128: insert into msd_level_values_ds_temp
3129: (
3130: DEMAND_PLAN_ID,
3131: INSTANCE,
3132: LEVEL_ID,

Line 3184: insert into msd_level_values_ds_temp

3180: if l_debug = C_YES_FLAG then
3181: debug_out( 'Entering ins_other_level_val ' || to_char(sysdate, 'hh24:mi:ss'));
3182: end if;
3183:
3184: insert into msd_level_values_ds_temp
3185: (
3186: DEMAND_PLAN_ID,
3187: INSTANCE,
3188: LEVEL_ID,

Line 3211: from msd_level_values mlv

3207: fnd_global.user_id,
3208: mlv.system_attribute1,
3209: mlv.system_attribute2,
3210: mlv.dp_enabled_flag
3211: from msd_level_values mlv
3212: where mlv.sr_level_pk = x_other_sr_level_pk
3213: minus
3214: select p_demand_plan_id,
3215: instance,

Line 3226: from msd_level_values_ds_temp

3222: fnd_global.user_id,
3223: system_attribute1,
3224: system_attribute2,
3225: dp_enabled_flag
3226: from msd_level_values_ds_temp
3227: where demand_plan_id = p_demand_plan_id;
3228:
3229: if l_debug = C_YES_FLAG then
3230: debug_out( 'Exiting ins_other_level_val ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3246: insert into msd_level_values_ds_temp

3242: if l_debug = C_YES_FLAG then
3243: debug_out( 'Entering ins_all_level_val ' || to_char(sysdate, 'hh24:mi:ss'));
3244: end if;
3245:
3246: insert into msd_level_values_ds_temp
3247: (
3248: DEMAND_PLAN_ID,
3249: INSTANCE,
3250: LEVEL_ID,

Line 3273: from msd_level_values mlv

3269: fnd_global.user_id,
3270: mlv.system_attribute1,
3271: mlv.system_attribute2,
3272: mlv.dp_enabled_flag
3273: from msd_level_values mlv
3274: where (mlv.level_id, mlv.sr_level_pk) IN (select level_id, sr_level_pk from msd_level_values where level_id in
3275: (select level_id from msd_levels where level_type_code = 1))
3276: minus
3277: select p_demand_plan_id,

Line 3274: where (mlv.level_id, mlv.sr_level_pk) IN (select level_id, sr_level_pk from msd_level_values where level_id in

3270: mlv.system_attribute1,
3271: mlv.system_attribute2,
3272: mlv.dp_enabled_flag
3273: from msd_level_values mlv
3274: where (mlv.level_id, mlv.sr_level_pk) IN (select level_id, sr_level_pk from msd_level_values where level_id in
3275: (select level_id from msd_levels where level_type_code = 1))
3276: minus
3277: select p_demand_plan_id,
3278: instance,

Line 3289: from msd_level_values_ds_temp

3285: fnd_global.user_id,
3286: system_attribute1,
3287: system_attribute2,
3288: dp_enabled_flag
3289: from msd_level_values_ds_temp
3290: where demand_plan_id = p_demand_plan_id;
3291:
3292: if l_debug = C_YES_FLAG then
3293: debug_out( 'Exiting ins_all_level_val ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3326: from msd_level_values_ds_temp

3322: p_level_id in number) IS
3323:
3324: cursor chk_row_count is
3325: select 1
3326: from msd_level_values_ds_temp
3327: where demand_plan_id = p_demand_plan_id
3328: and level_id = p_level_id
3329: and rownum = 1;
3330:

Line 3339: insert into msd_level_values_ds_temp

3335: open chk_row_count;
3336: fetch chk_row_count into x_cnt;
3337:
3338: if (chk_row_count%NOTFOUND) then
3339: insert into msd_level_values_ds_temp
3340: (
3341: DEMAND_PLAN_ID,
3342: INSTANCE,
3343: LEVEL_ID,

Line 3366: from msd_level_values mlv

3362: fnd_global.user_id,
3363: mlv.system_attribute1,
3364: mlv.system_attribute2,
3365: mlv.dp_enabled_flag
3366: from msd_level_values mlv
3367: where mlv.level_id = p_level_id
3368: minus
3369: select p_demand_plan_id,
3370: instance,

Line 3381: from msd_level_values_ds_temp

3377: fnd_global.user_id,
3378: system_attribute1,
3379: system_attribute2,
3380: dp_enabled_flag
3381: from msd_level_values_ds_temp
3382: where demand_plan_id = p_demand_plan_id;
3383: end if;
3384: close chk_row_count;
3385: end chk_insert_org_no_associations;

Line 3417: FROM msd_level_values_ds

3413: AND mloa.org_level_id = 7
3414: AND mloa.org_sr_level_pk = mdio.sr_organization_id
3415: MINUS
3416: SELECT sr_level_pk
3417: FROM msd_level_values_ds
3418: WHERE
3419: demand_plan_id = p_demand_plan_id
3420: AND level_id = 11);
3421:

Line 3430: FROM msd_level_values_ds

3426: IS
3427: SELECT 1
3428: FROM dual
3429: WHERE EXISTS (SELECT sr_level_pk
3430: FROM msd_level_values_ds
3431: WHERE
3432: demand_plan_id = p_demand_plan_id
3433: AND level_id = 11
3434: MINUS