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_DS_TEMP

Line 726: insert into msd_level_values_ds_temp

722: end if;
723:
724: close c1;
725:
726: insert into msd_level_values_ds_temp
727: (
728: DEMAND_PLAN_ID,
729: INSTANCE,
730: LEVEL_ID,

Line 755: msd_level_values_ds_temp mld,

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

Line 779: from msd_level_values_ds_temp

775: fnd_global.user_id,
776: system_attribute1,
777: system_attribute2,
778: dp_enabled_flag
779: from msd_level_values_ds_temp
780: where demand_plan_id = p_demand_plan_id;
781:
782:
783: x_current_parent_level_id := x_child_level;

Line 846: insert into msd_level_values_ds_temp

842: end if;
843:
844: close c1;
845:
846: insert into msd_level_values_ds_temp
847: (
848: DEMAND_PLAN_ID,
849: INSTANCE,
850: LEVEL_ID,

Line 875: msd_level_values_ds_temp mld,

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

Line 899: from msd_level_values_ds_temp

895: fnd_global.user_id,
896: system_attribute1,
897: system_attribute2,
898: dp_enabled_flag
899: from msd_level_values_ds_temp
900: where demand_plan_id = p_demand_plan_id;
901:
902: x_current_child_level_id := x_parent_level;
903:

Line 925: insert into msd_level_values_ds_temp

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

Line 954: msd_level_values_ds_temp mld

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

Line 976: from msd_level_values_ds_temp

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

Line 1044: insert into msd_level_values_ds_temp

1040: end if;
1041:
1042: if (v_is_dp_dim = C_TRUE) then
1043:
1044: insert into msd_level_values_ds_temp
1045: (
1046: DEMAND_PLAN_ID,
1047: INSTANCE,
1048: LEVEL_ID,

Line 1073: msd_level_values_ds_temp mld

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

Line 1101: from msd_level_values_ds_temp

1097: fnd_global.user_id,
1098: system_attribute1,
1099: system_attribute2,
1100: dp_enabled_flag
1101: from msd_level_values_ds_temp
1102: where demand_plan_id = p_demand_plan_id;
1103:
1104: /* ISO Code Change - Only for GEO dimension - Insert the internal sites for the
1105: * ISO orgs attached to the plan

Line 1109: INSERT INTO msd_level_values_ds_temp

1105: * ISO orgs attached to the plan
1106: */
1107: IF (p_level_id in (C_SHIP_LEVEL_ID) and (l_iso_check='N')) THEN --Bug#13526284
1108:
1109: INSERT INTO msd_level_values_ds_temp
1110: ( DEMAND_PLAN_ID,
1111: INSTANCE,
1112: LEVEL_ID,
1113: SR_LEVEL_PK,

Line 1160: FROM msd_level_values_ds_temp

1156: fnd_global.user_id,
1157: system_attribute1,
1158: system_attribute2,
1159: dp_enabled_flag
1160: FROM msd_level_values_ds_temp
1161: WHERE demand_plan_id = p_demand_plan_id;
1162:
1163: END IF;
1164: end if;

Line 1188: insert into msd_level_values_ds_temp

1184: end if;
1185:
1186: if ((p_insert_rep is null) and (p_insert_geo is null)) then
1187:
1188: insert into msd_level_values_ds_temp
1189: (
1190: DEMAND_PLAN_ID,
1191: INSTANCE,
1192: LEVEL_ID,

Line 1232: from msd_level_values_ds_temp

1228: fnd_global.user_id,
1229: system_attribute1,
1230: system_attribute2,
1231: dp_enabled_flag
1232: from msd_level_values_ds_temp
1233: where demand_plan_id = p_demand_plan_id;
1234:
1235: elsif ((p_insert_rep is not null) and (p_insert_geo is null)) then
1236:

Line 1237: insert into msd_level_values_ds_temp

1233: where demand_plan_id = p_demand_plan_id;
1234:
1235: elsif ((p_insert_rep is not null) and (p_insert_geo is null)) then
1236:
1237: insert into msd_level_values_ds_temp
1238: (
1239: DEMAND_PLAN_ID,
1240: INSTANCE,
1241: LEVEL_ID,

Line 1281: from msd_level_values_ds_temp

1277: fnd_global.user_id,
1278: system_attribute1,
1279: system_attribute2,
1280: dp_enabled_flag
1281: from msd_level_values_ds_temp
1282: where demand_plan_id = p_demand_plan_id;
1283:
1284: elsif ((p_insert_rep is null) and (p_insert_geo is not null)) then
1285:

Line 1286: insert into msd_level_values_ds_temp

1282: where demand_plan_id = p_demand_plan_id;
1283:
1284: elsif ((p_insert_rep is null) and (p_insert_geo is not null)) then
1285:
1286: insert into msd_level_values_ds_temp
1287: (
1288: DEMAND_PLAN_ID,
1289: INSTANCE,
1290: LEVEL_ID,

Line 1330: from msd_level_values_ds_temp

1326: fnd_global.user_id,
1327: system_attribute1,
1328: system_attribute2,
1329: dp_enabled_flag
1330: from msd_level_values_ds_temp
1331: where demand_plan_id = p_demand_plan_id;
1332:
1333: elsif ((p_insert_rep is not null) and (p_insert_geo is not null)) then
1334:

Line 1335: insert into msd_level_values_ds_temp

1331: where demand_plan_id = p_demand_plan_id;
1332:
1333: elsif ((p_insert_rep is not null) and (p_insert_geo is not null)) then
1334:
1335: insert into msd_level_values_ds_temp
1336: (
1337: DEMAND_PLAN_ID,
1338: INSTANCE,
1339: LEVEL_ID,

Line 1379: from msd_level_values_ds_temp

1375: fnd_global.user_id,
1376: system_attribute1,
1377: system_attribute2,
1378: dp_enabled_flag
1379: from msd_level_values_ds_temp
1380: where demand_plan_id = p_demand_plan_id;
1381: end if;
1382:
1383: -- Bug 3239820. Cannot Download Input Scenario if LOB used

Line 1721: delete from msd_level_values_ds_temp

1717: debug_out( 'Entering create_level_val_stripe ' || to_char(sysdate, 'hh24:mi:ss'));
1718: end if;
1719:
1720:
1721: delete from msd_level_values_ds_temp
1722: where demand_plan_id = p_demand_plan_id;
1723:
1724:
1725: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);

Line 1729: insert into msd_level_values_ds_temp

1725: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
1726: fetch c1 into l_c1_rec;
1727: close c1;
1728:
1729: insert into msd_level_values_ds_temp
1730: (
1731: DEMAND_PLAN_ID,
1732: INSTANCE,
1733: LEVEL_ID,

Line 1811: from msd_level_values_ds_temp

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

Line 1816: from msd_level_values_ds_temp

1812: where demand_plan_id = p_demand_plan_id;
1813:
1814: cursor c2 is
1815: select demand_plan_id, instance, level_id, sr_level_pk
1816: from msd_level_values_ds_temp
1817: where demand_plan_id = p_demand_plan_id
1818: minus
1819: select demand_plan_id, instance, level_id, sr_level_pk
1820: from msd_level_values_ds

Line 1884: from msd_level_values_ds_temp

1880: CREATED_BY,
1881: SYSTEM_ATTRIBUTE1,
1882: SYSTEM_ATTRIBUTE2,
1883: DP_ENABLED_FLAG
1884: from msd_level_values_ds_temp
1885: where demand_plan_id = p_demand_plan_id;
1886:
1887: delete from msd_level_values_ds_temp
1888: where demand_plan_id = p_demand_plan_id;

Line 1887: delete from msd_level_values_ds_temp

1883: DP_ENABLED_FLAG
1884: from msd_level_values_ds_temp
1885: where demand_plan_id = p_demand_plan_id;
1886:
1887: delete from msd_level_values_ds_temp
1888: where demand_plan_id = p_demand_plan_id;
1889:
1890: /* Bug# 5078878
1891: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics

Line 2388: from msd_level_values_ds_temp

2384: p_level_id in number) return varchar2 IS
2385:
2386: cursor chk_row_count is
2387: select 1
2388: from msd_level_values_ds_temp
2389: where demand_plan_id = p_demand_plan_id
2390: and level_id = p_level_id
2391: and rownum = 1;
2392:

Line 2434: delete from msd_level_values_ds_temp

2430: if l_debug = C_YES_FLAG then
2431: debug_out( 'Entering create_level_val_stripe_stream ' || to_char(sysdate, 'hh24:mi:ss'));
2432: end if;
2433:
2434: delete from msd_level_values_ds_temp
2435: where demand_plan_id = p_demand_plan_id;
2436:
2437: insert_stream_items(errbuf,
2438: retcode,

Line 2507: delete from msd_level_values_ds_temp

2503: x_refresh_num number;
2504:
2505: BEGIN
2506:
2507: delete from msd_level_values_ds_temp
2508: where demand_plan_id = p_demand_plan_id;
2509:
2510: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
2511: fetch c1 into l_c1_rec;

Line 2514: insert into msd_level_values_ds_temp

2510: open c1(p_stripe_instance, p_stripe_level_id, p_stripe_sr_level_pk);
2511: fetch c1 into l_c1_rec;
2512: close c1;
2513:
2514: insert into msd_level_values_ds_temp
2515: (
2516: DEMAND_PLAN_ID,
2517: INSTANCE,
2518: LEVEL_ID,

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

2722: close get_dim_col_id;
2723:
2724: x_desig_clmn_name := get_desig_clmn_name (x_cs_definition_id);
2725:
2726: l_sql_stmt := ' insert into msd_level_values_ds_temp ' ||
2727: ' ( ' ||
2728: ' DEMAND_PLAN_ID, ' ||
2729: ' INSTANCE, ' ||
2730: ' LEVEL_ID, ' ||

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

2943: close get_dim_col_id;
2944:
2945: x_desig_clmn_name := get_desig_clmn_name(x_cs_definition_id);
2946:
2947: l_sql_stmt := ' delete from msd_level_values_ds_temp ' ||
2948: ' where level_id = ' || C_ITEM_LEVEL_ID ||
2949: ' and demand_plan_id = ' || p_demand_plan_id ||
2950: ' and level_pk in ( ' ||
2951: ' select to_char(level_pk) from msd_level_values_ds_temp ' ||

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

2947: l_sql_stmt := ' delete from msd_level_values_ds_temp ' ||
2948: ' where level_id = ' || C_ITEM_LEVEL_ID ||
2949: ' and demand_plan_id = ' || p_demand_plan_id ||
2950: ' and level_pk in ( ' ||
2951: ' select to_char(level_pk) from msd_level_values_ds_temp ' ||
2952: ' where demand_plan_id = ' || p_demand_plan_id ||
2953: ' minus select to_char(' ||
2954: ' fact.' || p_dim_code || '_LEVEL_VALUE_PK) ' ||
2955: ' from ' || x_planning_server_view_name || ' fact ' ||

Line 2987: insert into msd_level_values_ds_temp

2983: if l_debug = C_YES_FLAG then
2984: debug_out( 'Entering insert_supercession_items ' || to_char(sysdate, 'hh24:mi:ss'));
2985: end if;
2986:
2987: insert into msd_level_values_ds_temp
2988: (
2989: DEMAND_PLAN_ID,
2990: INSTANCE,
2991: LEVEL_ID,

Line 3018: msd_level_values_ds_temp mlvd,

3014: from msd_dp_events mde,
3015: msd_events me,
3016: msd_event_products mep,
3017: msd_evt_prod_relationships mepr,
3018: msd_level_values_ds_temp mlvd,
3019: msd_level_values mlv
3020: where mepr.instance = mlvd.instance
3021: and mepr.product_lvl_id = mlvd.level_id
3022: and mlvd.level_id = 1

Line 3048: from msd_level_values_ds_temp

3044: fnd_global.user_id,
3045: system_attribute1,
3046: system_attribute2,
3047: dp_enabled_flag
3048: from msd_level_values_ds_temp
3049: where demand_plan_id = p_demand_plan_id;
3050:
3051: if l_debug = C_YES_FLAG then
3052: debug_out( 'Exiting insert_supercession_items ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3118: from msd_level_values_ds_temp

3114: p_demand_plan_id in number) is
3115:
3116: cursor chk_pseudo is
3117: select 1
3118: from msd_level_values_ds_temp
3119: where demand_plan_id = p_demand_plan_id
3120: and level_pk = C_PSEUDO_PK;
3121:
3122: x_cnt number;

Line 3134: insert into msd_level_values_ds_temp

3130: open chk_pseudo;
3131: fetch chk_pseudo into x_cnt;
3132: if (chk_pseudo%NOTFOUND) then
3133:
3134: insert into msd_level_values_ds_temp
3135: (
3136: DEMAND_PLAN_ID,
3137: INSTANCE,
3138: LEVEL_ID,

Line 3190: insert into msd_level_values_ds_temp

3186: if l_debug = C_YES_FLAG then
3187: debug_out( 'Entering ins_other_level_val ' || to_char(sysdate, 'hh24:mi:ss'));
3188: end if;
3189:
3190: insert into msd_level_values_ds_temp
3191: (
3192: DEMAND_PLAN_ID,
3193: INSTANCE,
3194: LEVEL_ID,

Line 3232: from msd_level_values_ds_temp

3228: fnd_global.user_id,
3229: system_attribute1,
3230: system_attribute2,
3231: dp_enabled_flag
3232: from msd_level_values_ds_temp
3233: where demand_plan_id = p_demand_plan_id;
3234:
3235: if l_debug = C_YES_FLAG then
3236: debug_out( 'Exiting ins_other_level_val ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3252: insert into msd_level_values_ds_temp

3248: if l_debug = C_YES_FLAG then
3249: debug_out( 'Entering ins_all_level_val ' || to_char(sysdate, 'hh24:mi:ss'));
3250: end if;
3251:
3252: insert into msd_level_values_ds_temp
3253: (
3254: DEMAND_PLAN_ID,
3255: INSTANCE,
3256: LEVEL_ID,

Line 3295: from msd_level_values_ds_temp

3291: fnd_global.user_id,
3292: system_attribute1,
3293: system_attribute2,
3294: dp_enabled_flag
3295: from msd_level_values_ds_temp
3296: where demand_plan_id = p_demand_plan_id;
3297:
3298: if l_debug = C_YES_FLAG then
3299: debug_out( 'Exiting ins_all_level_val ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3332: from msd_level_values_ds_temp

3328: p_level_id in number) IS
3329:
3330: cursor chk_row_count is
3331: select 1
3332: from msd_level_values_ds_temp
3333: where demand_plan_id = p_demand_plan_id
3334: and level_id = p_level_id
3335: and rownum = 1;
3336:

Line 3345: insert into msd_level_values_ds_temp

3341: open chk_row_count;
3342: fetch chk_row_count into x_cnt;
3343:
3344: if (chk_row_count%NOTFOUND) then
3345: insert into msd_level_values_ds_temp
3346: (
3347: DEMAND_PLAN_ID,
3348: INSTANCE,
3349: LEVEL_ID,

Line 3387: from msd_level_values_ds_temp

3383: fnd_global.user_id,
3384: system_attribute1,
3385: system_attribute2,
3386: dp_enabled_flag
3387: from msd_level_values_ds_temp
3388: where demand_plan_id = p_demand_plan_id;
3389: end if;
3390: close chk_row_count;
3391: end chk_insert_org_no_associations;