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 HR_ALL_ORGANIZATION_UNITS

Line 767: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';

763: --
764: --SELECT Clause
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';

Line 800: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;

796: --anraj: for getting departments which do not have visits assigned to it
797: -- this is needs to be done only if the user has not specified a category code
798: IF p_space_category IS NULL THEN
799: l_sql_string := l_sql_string || ' UNION select b.department_id, b.description, b.department_code, c.name ' ;
800: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;
801: l_sql_string := l_sql_string || ' WHERE b.organization_id = c.organization_id ';
802: l_sql_string := l_sql_string || ' AND m.organization_id = c.organization_id ';
803: l_sql_string := l_sql_string || ' AND b.description is not null ';
804: l_sql_string := l_sql_string || ' AND m.eam_enabled_flag = ''Y'' ';

Line 844: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';

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';
848: l_sql_string1 := l_sql_string1 || ' and a.bom_department_id = d.department_id';

Line 1820: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';

1816:
1817: --SELECT Clause
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';

Line 1853: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;

1849: --anraj: for getting departments which do not have visits assigned to it
1850: -- Needs to be done only if the user has not specified a category code in the search
1851: IF p_space_category IS NULL THEN
1852: l_sql_string := l_sql_string || ' UNION select b.department_id, b.description, b.department_code, c.name ' ;
1853: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;
1854: l_sql_string := l_sql_string || ' WHERE b.organization_id = c.organization_id ';
1855: l_sql_string := l_sql_string || ' AND m.organization_id = c.organization_id ';
1856: l_sql_string := l_sql_string || ' AND b.description is not null ';
1857: l_sql_string := l_sql_string || ' AND m.eam_enabled_flag = ''Y'' ';

Line 1898: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';

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';
1902: l_sql_string1 := l_sql_string1 || ' and a.bom_department_id = d.department_id';

Line 2887: l_sql_string := l_sql_string || ' from ahl_visits_vl a , bom_departments b, hr_all_organization_units c';

2883:
2884: --SELECT Clause
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';

Line 2944: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';

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';
2948: l_sql_string1 := l_sql_string1 || ' and a.bom_department_id = d.department_id';

Line 2988: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;

2984: --anraj: for getting departments which do not have visits assigned to it
2985: --done only if the user has not specified category code in the search
2986: IF p_space_category IS NULL THEN
2987: l_sql_string := l_sql_string || ' UNION select b.department_id, b.description, b.department_code, c.name ' ;
2988: l_sql_string := l_sql_string || ' FROM bom_departments b, hr_all_organization_units c, mtl_parameters m ' ;
2989: l_sql_string := l_sql_string || ' WHERE b.organization_id = c.organization_id ';
2990: l_sql_string := l_sql_string || ' AND m.organization_id = c.organization_id ';
2991: l_sql_string := l_sql_string || ' AND b.description is not null ';
2992: l_sql_string := l_sql_string || ' AND m.eam_enabled_flag = ''Y'' ';

Line 4026: FROM hr_all_organization_units

4022: CURSOR l_org_id_cur (c_org_id IN NUMBER,
4023: c_name IN VARCHAR2)
4024: IS
4025: SELECT organization_id,name
4026: FROM hr_all_organization_units
4027: WHERE (organization_id = c_org_id
4028: OR name = c_name);
4029: --Get Item id or Desc
4030:

Line 5404: FROM hr_all_organization_units

5400: CURSOR l_org_id_cur (c_org_id IN NUMBER,
5401: c_name IN VARCHAR2)
5402: IS
5403: SELECT organization_id,name
5404: FROM hr_all_organization_units
5405: WHERE (organization_id = c_org_id
5406: OR name = c_name);
5407: -- Get dept info
5408: CURSOR l_dept_id_cur (c_org_id IN NUMBER,