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_VISITS_B

Line 104: ahl_visits_b b

100: c_visit_end_date IN DATE)
101: IS
102: SELECT count(*)
103: FROM ahl_space_assignments a,
104: ahl_visits_b b
105: WHERE a.visit_id = c_visit_id
106: AND a.visit_id = b.visit_id
107: AND b.simulation_plan_id = c_plan_id
108: AND a.space_id = c_space_id

Line 123: ahl_visits_b b

119: c_visit_end_date IN DATE)
120: IS
121: SELECT count(*)
122: FROM ahl_space_assignments a,
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

Line 129: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b

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);
132:
133: --

Line 139: ahl_visits_b B

135: IS
136: SELECT A.visit_id,start_date_time,
137: trunc(b.close_date_time) close_date_time
138: FROM ahl_space_assignments a,
139: ahl_visits_b B
140: WHERE a.visit_id = B.visit_id
141: AND a.space_id = c_space_id
142: -- anraj:Do not consider visits which are deleted or cancelled
143: AND status_code NOT IN('DELETED','CANCELLED');

Line 231: FROM ahl_visits_b

227: c_visit_end_date IN DATE,
228: c_dept_id IN NUMBER)
229: IS
230: SELECT count(*)
231: FROM ahl_visits_b
232: WHERE visit_id = c_visit_id
233: AND simulation_plan_id = c_plan_id
234: AND department_id = c_dept_id
235: AND trunc(c_start_period) between trunc(start_date_time) and trunc(c_visit_end_date)

Line 250: FROM ahl_visits_b

246: c_start_period IN DATE,
247: c_visit_end_date IN DATE)
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

Line 254: AND visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b

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);
257:
258: --Get all the visits assigned to department (with or without space assignment)

Line 358: FROM ahl_visits_b

354: c_visit_end_date IN DATE,
355: c_plan_id IN NUMBER)
356: IS
357: SELECT COUNT(*)
358: FROM ahl_visits_b
359: WHERE visit_id = c_visit_id
360: AND simulation_plan_id = c_plan_id
361: AND ( ( (TRUNC(start_date_time) BETWEEN trunc(c_start_date) AND trunc(c_end_date))
362: OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))

Line 386: FROM ahl_visits_b

382: c_visit_end_date IN DATE,
383: c_plan_id IN NUMBER)
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))

Line 389: AND visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b WHERE simulation_plan_id = c_plan_id )

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) )
393: OR trunc(c_end_date) between trunc(start_date_time) and trunc(c_visit_end_date)));

Line 490: FROM ahl_space_assignments a,ahl_visits_b b

486: c_visit_end_date IN DATE,
487: c_plan_id IN NUMBER)
488: IS
489: SELECT COUNT(*)
490: FROM ahl_space_assignments a,ahl_visits_b b
491: WHERE a.visit_id = c_visit_id
492: AND a.visit_id = b.visit_id
493: AND b.simulation_plan_id = c_plan_id
494: AND a.space_id = c_space_id

Line 508: ahl_visits_b B

504: SELECT A.visit_id,
505: start_date_time,
506: trunc(b.close_date_time) close_date_time
507: FROM ahl_space_assignments a,
508: ahl_visits_b B
509: WHERE a.visit_id = B.visit_id
510: AND a.space_id = c_space_id
511: --anraj:Do not consider visits which are deleted or cancelled
512: AND status_code NOT IN('DELETED','CANCELLED');

Line 524: FROM ahl_space_assignments a,ahl_visits_b b

520: c_visit_end_date IN DATE,
521: c_plan_id IN NUMBER)
522: IS
523: SELECT COUNT(*)
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')

Line 529: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_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))
533: OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))

Line 820: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

816: l_bind_idx := l_bind_idx + 1;
817: END IF;
818:
819: l_sql_string := l_sql_string || ' AND b.department_id NOT IN' ;
820: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;
821: IF p_org_id IS NOT NULL THEN
822: l_sql_string := l_sql_string || ' WHERE organization_id = :ORG_ID';
823: l_tempbind_tbl(l_bind_idx) := p_org_id;
824: l_bind_idx := l_bind_idx + 1;

Line 1874: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

1870: END IF;
1871:
1872:
1873: l_sql_string := l_sql_string || ' AND b.department_id NOT IN' ;
1874: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;
1875: IF p_org_id IS NOT NULL THEN
1876: l_sql_string := l_sql_string || ' WHERE organization_id = :ORG_ID';
1877: l_tempbind_tbl(l_bind_idx) := p_org_id;
1878: l_bind_idx := l_bind_idx + 1;

Line 3008: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

3004: END IF;
3005:
3006:
3007: l_sql_string := l_sql_string || ' AND b.department_id NOT IN' ;
3008: l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;
3009: IF p_org_id IS NOT NULL THEN
3010: l_sql_string := l_sql_string || ' WHERE organization_id = :ORG_ID';
3011: l_tempbind_tbl(l_bind_idx) := p_org_id;
3012: l_bind_idx := l_bind_idx + 1;

Line 4597: FROM AHL_VISITS_B

4593: --
4594: CURSOR get_visit_cur (c_visit_id IN NUMBER)
4595: IS
4596: SELECT start_date_time
4597: FROM AHL_VISITS_B
4598: WHERE visit_id = c_visit_id;
4599:
4600: /* Modified by mpothuku on 01/25/05 to include the status_code clause */
4601: CURSOR get_task_end_cur (c_visit_id IN NUMBER)

Line 4778: FROM AHL_VISITS_B

4774: --
4775: CURSOR get_visit_cur (c_visit_id IN NUMBER)
4776: IS
4777: SELECT start_date_time
4778: FROM AHL_VISITS_B
4779: WHERE visit_id = c_visit_id;
4780:
4781: CURSOR get_task_end_cur (c_visit_id IN NUMBER)
4782: IS

Line 5378: AND b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_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))
5381: OR
5382: (trunc(c_visit_end_date) between trunc(c_start_period) and trunc(c_end_period) ))

Line 6138: FROM AHL_VISITS_B

6134:
6135: CURSOR get_visit_cur (c_visit_id IN NUMBER)
6136: IS
6137: SELECT start_date_time
6138: FROM AHL_VISITS_B
6139: WHERE visit_id = c_visit_id;
6140:
6141: CURSOR get_task_end_cur (c_visit_id IN NUMBER)
6142: IS