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_SPACE_ASSIGNMENTS

Line 103: FROM ahl_space_assignments a,

99: c_start_period IN DATE,
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

Line 122: FROM ahl_space_assignments a,

118: c_start_period IN DATE,
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

Line 138: FROM ahl_space_assignments a,

134: CURSOR get_visit_cur (c_space_id IN NUMBER)
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

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 507: FROM ahl_space_assignments a,

503: IS
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

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 769: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

765: l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';
766: -- From Clause
767: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';
768: -- Where Clause
769: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';
770: l_sql_string := l_sql_string || ' and a.department_id = b.department_id';
771: l_sql_string := l_sql_string || ' and a.organization_id = c.organization_id';
772: l_sql_string := l_sql_string || ' and a.department_id is not null';
773: l_sql_string := l_sql_string || ' and a.start_date_time is not null';

Line 827: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

823: l_tempbind_tbl(l_bind_idx) := p_org_id;
824: l_bind_idx := l_bind_idx + 1;
825: END IF;
826: l_sql_string := l_sql_string || ' AND department_id IS NOT NULL';
827: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';
828: l_sql_string := l_sql_string || ' and exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;
829: END IF;
830:
831:

Line 843: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

839: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
840: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
841: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
842: -- From Clause
843: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
844: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
845: -- Where Clause
846: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
847: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 1822: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

1818: l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';
1819: -- From Clause
1820: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';
1821: -- Where Clause
1822: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';
1823: l_sql_string := l_sql_string || ' and a.department_id = b.department_id';
1824: l_sql_string := l_sql_string || ' and a.organization_id = c.organization_id';
1825: l_sql_string := l_sql_string || ' and a.department_id is not null';
1826: l_sql_string := l_sql_string || ' and a.start_date_time is not null';

Line 1881: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

1877: l_tempbind_tbl(l_bind_idx) := p_org_id;
1878: l_bind_idx := l_bind_idx + 1;
1879: END IF;
1880: l_sql_string := l_sql_string || ' AND department_id IS NOT NULL';
1881: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';
1882: l_sql_string := l_sql_string || ' and exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;
1883: END IF; -- category code null
1884:
1885:

Line 1897: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

1893: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
1894: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
1895: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
1896: -- From Clause
1897: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
1898: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
1899: -- Where Clause
1900: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
1901: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 2889: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

2885: l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';
2886: -- From Clause
2887: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';
2888: -- Where Clause
2889: l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';
2890: l_sql_string := l_sql_string || ' and a.department_id = b.department_id';
2891: l_sql_string := l_sql_string || ' and a.organization_id = c.organization_id';
2892: l_sql_string := l_sql_string || ' and a.department_id is not null';
2893: l_sql_string := l_sql_string || ' and a.start_date_time is not null';

Line 2943: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

2939: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
2940: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
2941: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
2942: -- From Clause
2943: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
2944: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
2945: -- Where Clause
2946: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
2947: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 3015: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

3011: l_tempbind_tbl(l_bind_idx) := p_org_id;
3012: l_bind_idx := l_bind_idx + 1;
3013: END IF;
3014: l_sql_string := l_sql_string || ' AND department_id IS NOT NULL';
3015: l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';
3016: l_sql_string := l_sql_string || ' and exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;
3017: END IF;
3018:
3019:

Line 5277: ahl_space_assignments SPS

5273: FROM AHL_VISITS_VL VST,
5274: CSI_ITEM_INSTANCES CSI ,
5275: MTL_SYSTEM_ITEMS_B_KFV mtl,
5276: FND_LOOKUP_VALUES_VL FLVT,
5277: ahl_space_assignments SPS
5278: where VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
5279: and VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)
5280: AND VST.ITEM_ORGANIZATION_ID = mtl.ORGANIZATION_ID(+)
5281: AND FLVT.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'

Line 5767: select count(*) into l_count from ahl_space_assignments

5763: FETCH visit_wd_detail_cur INTO l_visit_wd_detail_rec;
5764: --
5765: IF visit_wd_detail_cur%FOUND THEN
5766: --Check for visit has been assigned to multiple spaces
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

Line 5828: select count(*) into l_count from ahl_space_assignments

5824: trunc(nvl(l_visit_end_date, l_get_visit_detail_rec.start_date_time)));
5825: FETCH visit_wd1_detail_cur INTO l_visit_wd1_detail_rec;
5826: IF visit_wd1_detail_cur%FOUND THEN
5827: --Check for visit has been assigned to multiple spaces
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

Line 5863: select count(*) into l_count from ahl_space_assignments

5859: FETCH visit_wd_detail_cur INTO l_visit_wd_detail_rec;
5860: --
5861: IF visit_wd_detail_cur%FOUND THEN
5862: --Check for visit has been assigned to multiple spaces
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