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.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 127: AND simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl

123: ahl_visits_b b
124: WHERE a.visit_id = c_visit_id
125: AND a.visit_id = b.visit_id
126: AND a.space_id = c_space_id
127: AND simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl
128: WHERE primary_plan_flag = 'Y')
129: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
130: WHERE simulation_plan_id = c_plan_id )
131: AND trunc(c_start_period) between trunc(b.start_date_time) and trunc(c_visit_end_date);

Line 252: AND simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl

248: IS
249: SELECT count(*)
250: FROM ahl_visits_b
251: WHERE visit_id = c_visit_id
252: AND simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl
253: WHERE primary_plan_flag = 'Y')
254: AND visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
255: WHERE simulation_plan_id = c_plan_id )
256: AND trunc(c_start_period) between trunc(start_date_time) and trunc(c_visit_end_date);

Line 388: AND simulation_plan_id in (select simulation_plan_id from ahl_simulation_plans_vl where primary_plan_flag = 'Y')

384: IS
385: SELECT COUNT(*)
386: FROM ahl_visits_b
387: WHERE visit_id = c_visit_id
388: AND simulation_plan_id in (select simulation_plan_id from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
389: AND visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b WHERE simulation_plan_id = c_plan_id )
390: AND ( ( (TRUNC(start_date_time) BETWEEN trunc(c_start_date) AND trunc(c_end_date))
391: OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))
392: OR ((c_start_date between trunc(start_date_time) and trunc(c_visit_end_date) )

Line 528: from ahl_simulation_plans_vl where primary_plan_flag = 'Y')

524: FROM ahl_space_assignments a,ahl_visits_b b
525: WHERE a.visit_id = c_visit_id
526: AND a.visit_id = b.visit_id
527: AND b.simulation_plan_id in (select simulation_plan_id
528: from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
529: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
530: WHERE simulation_plan_id = c_plan_id )
531: AND a.space_id = c_space_id
532: AND (((TRUNC(start_date_time) BETWEEN trunc(c_start_date) AND trunc(c_end_date))

Line 4019: FROM ahl_simulation_plans_vl

4015: CURSOR get_plan_id_cur (c_plan_id IN NUMBER)
4016: IS
4017: SELECT simulation_plan_id,
4018: primary_plan_flag
4019: FROM ahl_simulation_plans_vl
4020: WHERE simulation_plan_id = c_plan_id;
4021: -- New changes
4022: CURSOR l_org_id_cur (c_org_id IN NUMBER,
4023: c_name IN VARCHAR2)

Line 5376: from ahl_simulation_plans_vl where primary_plan_flag = 'Y')

5372: FROM ahl_visit_details_v a ,
5373: ahl_visits_vl b
5374: WHERE a.visit_id = b.visit_id
5375: AND a.simulation_plan_id in (select simulation_plan_id
5376: from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
5377: AND a.visit_id = c_visit_id
5378: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
5379: WHERE simulation_plan_id = c_plan_id )
5380: AND (((trunc(b.start_date_time) between trunc(c_start_period) and trunc(c_end_period))

Line 5397: FROM ahl_simulation_plans_vl

5393: CURSOR get_plan_id_cur (c_plan_id IN NUMBER)
5394: IS
5395: SELECT simulation_plan_id,
5396: primary_plan_flag
5397: FROM ahl_simulation_plans_vl
5398: WHERE simulation_plan_id = c_plan_id;
5399: -- New changes
5400: CURSOR l_org_id_cur (c_org_id IN NUMBER,
5401: c_name IN VARCHAR2)

Line 5771: FROM ahl_simulation_plans_vl

5767: select count(*) into l_count from ahl_space_assignments
5768: where visit_id = l_visit_wd_detail_rec.visit_id;
5769: --Get plan flag
5770: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
5771: FROM ahl_simulation_plans_vl
5772: WHERE simulation_plan_id = l_visit_wd_detail_rec.simulation_plan_id;
5773: --
5774: x_visit_details_tbl(i).visit_number := l_visit_wd_detail_rec.visit_number;
5775: x_visit_details_tbl(i).visit_type := l_visit_wd_detail_rec.visit_type_mean;

Line 5832: FROM ahl_simulation_plans_vl

5828: select count(*) into l_count from ahl_space_assignments
5829: where visit_id = l_visit_wd1_detail_rec.visit_id;
5830: --Get plan flag
5831: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
5832: FROM ahl_simulation_plans_vl
5833: WHERE simulation_plan_id = l_visit_wd1_detail_rec.simulation_plan_id;
5834: --
5835: x_visit_details_tbl(i).visit_number := l_visit_wd1_detail_rec.visit_number;
5836: x_visit_details_tbl(i).visit_type := l_visit_wd1_detail_rec.visit_type_mean;

Line 5867: FROM ahl_simulation_plans_vl

5863: select count(*) into l_count from ahl_space_assignments
5864: where visit_id = l_visit_wd_detail_rec.visit_id;
5865: --Get plan flag
5866: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
5867: FROM ahl_simulation_plans_vl
5868: WHERE simulation_plan_id = l_visit_wd_detail_rec.simulation_plan_id;
5869: --
5870: x_visit_details_tbl(i).visit_number := l_visit_wd_detail_rec.visit_number;
5871: x_visit_details_tbl(i).visit_type := l_visit_wd_detail_rec.visit_type_mean;

Line 5943: FROM ahl_simulation_plans_vl

5939: --
5940: IF visit_wd_detail_cur%FOUND THEN
5941: --Get plan flag
5942: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
5943: FROM ahl_simulation_plans_vl
5944: WHERE simulation_plan_id = l_visit_wd_detail_rec.simulation_plan_id;
5945: --
5946: x_visit_details_tbl(i).visit_number := l_visit_wd_detail_rec.visit_number;
5947: x_visit_details_tbl(i).visit_type := l_visit_wd_detail_rec.visit_type_mean;

Line 5998: FROM ahl_simulation_plans_vl

5994: FETCH visit_wd1_detail_cur INTO l_visit_wd1_detail_rec;
5995: IF visit_wd1_detail_cur%FOUND THEN
5996: --Get plan flag
5997: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
5998: FROM ahl_simulation_plans_vl
5999: WHERE simulation_plan_id = l_visit_wd1_detail_rec.simulation_plan_id;
6000: --
6001: x_visit_details_tbl(i).visit_number := l_visit_wd1_detail_rec.visit_number;
6002: x_visit_details_tbl(i).visit_type := l_visit_wd1_detail_rec.visit_type_mean;

Line 6024: FROM ahl_simulation_plans_vl

6020: --
6021: IF visit_wd_detail_cur%FOUND THEN
6022: --Get plan flag
6023: SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
6024: FROM ahl_simulation_plans_vl
6025: WHERE simulation_plan_id = l_visit_wd_detail_rec.simulation_plan_id;
6026: --
6027: x_visit_details_tbl(i).visit_number := l_visit_wd_detail_rec.visit_number;
6028: x_visit_details_tbl(i).visit_type := l_visit_wd_detail_rec.visit_type_mean;