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 491: msd_dem_query_utilities.get_query3 (

487:
488: x_key_values := x_key_values || 'C_SIM_SET_ID#' || nvl(fnd_profile.value('MSD_DEM_SIMULATION_SET_NAME'), -1) || '$' ;
489:
490: /* Get the query */
491: msd_dem_query_utilities.get_query3 (
492: x_retcode,
493: x_large_sql,
494: x_identifier,
495: null,

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

1273:
1274:
1275: if l_plan_name is not null then
1276:
1277: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1278:
1279: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1280:
1281: execute immediate l_stmt;

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

1279: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1280:
1281: execute immediate l_stmt;
1282:
1283: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1284:
1285: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans_pop');
1286:
1287: execute immediate l_stmt;

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

1309: EXECUTE IMMEDIATE l_stmt INTO l_start_date;
1310:
1311: if l_plan_type <> 6 then
1312:
1313: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1314:
1315: if l_stmt is null then
1316: return;
1317: end if;

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

1330: --syenamar
1331:
1332: if p_populate = 1 then
1333:
1334: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS', l_instance_id);
1335:
1336: if l_stmt is null then
1337: return;
1338: end if;

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

1348:
1349: /* Get the end date for the SNO plan */
1350: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1351:
1352: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1353:
1354: if l_stmt is null then
1355: return;
1356: end if;

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

1360: 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);
1361:
1362: if p_populate = 1 then
1363:
1364: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS_POP_SNO', l_instance_id);
1365:
1366: if l_stmt is null then
1367: return;
1368: end if;

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

1416:
1417:
1418: if l_plan_type <> 6 then
1419:
1420: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_EBS', l_instance_id);
1421:
1422: if l_stmt is null then
1423: return;
1424: end if;

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

1428: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1429:
1430: execute immediate l_stmt;
1431:
1432: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_EBS', l_instance_id);
1433:
1434: if l_stmt is null then
1435: return;
1436: end if;

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

1441: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1442:
1443: execute immediate l_stmt;
1444:
1445: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_EBS', l_instance_id);
1446:
1447: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1448: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1449: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');

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

1458:
1459: /* Get the end date for the SNO plan */
1460: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1461:
1462: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_SNO', l_instance_id);
1463:
1464: if l_stmt is null then
1465: return;
1466: end if;

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

1470: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1471:
1472: execute immediate l_stmt;
1473:
1474: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_SNO', l_instance_id);
1475:
1476: if l_stmt is null then
1477: return;
1478: end if;

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

1482: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1483:
1484: execute immediate l_stmt;
1485:
1486: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_SNO', l_instance_id);
1487:
1488: if l_stmt is null then
1489: return;
1490: end if;

Line 1998: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);

1994: || ' WHERE sp.plan_id = ' || p_plan_id
1995: || ' AND spd.supply_plan_id = sp.supply_plan_id ';
1996: EXECUTE IMMEDIATE l_stmt INTO l_start_date;
1997:
1998: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1999: if l_stmt is null then
2000: retcode := -1;
2001: errbuf := 'Unable to get query for entity MSD_DEM_PLANS';
2002: log_message('Error(4): msd_dem_sop.load_plan_data_wo - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || ' - ' || errbuf);

Line 2253: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS', l_instance_id);

2249: END IF;
2250:
2251: -- get population based on BIIO_OTHER_PLAN_DATA
2252: log_debug('Info: msd_dem_sop.load_plan_data_wo - get population based on BIIO_OTHER_PLAN_DATA - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2253: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS', l_instance_id);
2254:
2255: if l_stmt is null then
2256: retcode := -1;
2257: errbuf := 'Unable to get query for entity MSD_DEM_PLANS_POP_EBS';

Line 2267: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS_WO', l_instance_id);

2263: execute immediate l_stmt using l_plan_name, l_start_date, l_end_date, p_plan_id, p_plan_id, p_plan_id, p_plan_id, p_plan_id, p_plan_id;
2264:
2265: -- get population based on BIIO_SUPPLY_PLAN_DATA_WO
2266: log_debug('Info: msd_dem_sop.load_plan_data_wo - get population based on MSD_DEM_PLANS_POP_EBS_WO - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2267: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PLANS_POP_EBS_WO', l_instance_id);
2268:
2269: if l_stmt is null then
2270: retcode := -1;
2271: errbuf := 'Unable to get query for entity MSD_DEM_PLANS_POP_EBS_WO';

Line 2282: msd_dem_query_utilities.get_query(retcode, l_stmt, 'EQ_SOP_WO_ITEM_TMPL', l_instance_id);

2278:
2279:
2280: -- load item staging table
2281: log_debug('Info: msd_dem_sop.load_plan_data_wo - load item staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2282: msd_dem_query_utilities.get_query(retcode, l_stmt, 'EQ_SOP_WO_ITEM_TMPL', l_instance_id);
2283:
2284: if l_stmt is null then
2285: retcode := -1;
2286: errbuf := 'Unable to get query for entity EQ_SOP_WO_ITEM_TMPL';