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 BOM_DEPARTMENTS

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 5413: FROM bom_departments

5409: c_dept_id IN NUMBER,
5410: c_dept_name IN VARCHAR2)
5411: IS
5412: SELECT department_id,department_code,description
5413: FROM bom_departments
5414: WHERE organization_id = c_org_id
5415: AND (department_id = c_dept_id
5416: OR description = c_dept_name);
5417: -- Get space info