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_DEM_SOP dependencies on MSD_DEM_QUERY_UTILITIES

Line 338: msd_dem_query_utilities.get_query3 (

334: || '$C_TIME_CLAUSE#' || ', msd_dem_dates inp WHERE mdbr.sdate BETWEEN inp.start_date AND inp.end_date$';
335: END IF;
336:
337: /* Get the query */
338: msd_dem_query_utilities.get_query3 (
339: x_retcode,
340: x_large_sql,
341: x_identifier,
342: null,

Line 1052: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);

1048:
1049:
1050: if l_plan_name is not null then
1051:
1052: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1053:
1054: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1055:
1056: execute immediate l_stmt;

Line 1058: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);

1054: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1055:
1056: execute immediate l_stmt;
1057:
1058: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1059:
1060: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans_pop');
1061:
1062: execute immediate l_stmt;

Line 1086: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);

1082: EXECUTE IMMEDIATE l_stmt INTO l_start_date;
1083:
1084: if l_plan_type <> 6 then
1085:
1086: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1087:
1088: if l_stmt is null then
1089: return;
1090: end if;

Line 1098: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS', l_instance_id);

1094: execute immediate l_stmt using l_plan_name, l_plan_name, 'ASCP', 2, l_start_date, l_end_date, p_plan_id, substr(x_dem_sched,1,200);
1095:
1096: if p_populate = 1 then
1097:
1098: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS', l_instance_id);
1099:
1100: if l_stmt is null then
1101: return;
1102: end if;

Line 1116: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);

1112:
1113: /* Get the end date for the SNO plan */
1114: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1115:
1116: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1117:
1118: if l_stmt is null then
1119: return;
1120: end if;

Line 1128: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_SNO', l_instance_id);

1124: execute immediate l_stmt using l_plan_name, l_plan_name, 'SNO', 2, l_start_date, l_end_date, p_plan_id, substr(x_dem_sched,1,200);
1125:
1126: if p_populate = 1 then
1127:
1128: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_SNO', l_instance_id);
1129:
1130: if l_stmt is null then
1131: return;
1132: end if;

Line 1184: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_EBS', l_instance_id);

1180:
1181:
1182: if l_plan_type <> 6 then
1183:
1184: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_EBS', l_instance_id);
1185:
1186: if l_stmt is null then
1187: return;
1188: end if;

Line 1196: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_EBS', l_instance_id);

1192: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1193:
1194: execute immediate l_stmt;
1195:
1196: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_EBS', l_instance_id);
1197:
1198: if l_stmt is null then
1199: return;
1200: end if;

Line 1209: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_EBS', l_instance_id);

1205: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1206:
1207: execute immediate l_stmt;
1208:
1209: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_EBS', l_instance_id);
1210:
1211: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1212: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1213: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');

Line 1226: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_SNO', l_instance_id);

1222:
1223: /* Get the end date for the SNO plan */
1224: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1225:
1226: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_SNO', l_instance_id);
1227:
1228: if l_stmt is null then
1229: return;
1230: end if;

Line 1238: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_SNO', l_instance_id);

1234: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1235:
1236: execute immediate l_stmt;
1237:
1238: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_SNO', l_instance_id);
1239:
1240: if l_stmt is null then
1241: return;
1242: end if;

Line 1250: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_SNO', l_instance_id);

1246: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1247:
1248: execute immediate l_stmt;
1249:
1250: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_SNO', l_instance_id);
1251:
1252: if l_stmt is null then
1253: return;
1254: end if;