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 FND_LOOKUP_VALUES_VL

Line 678: FROM FND_LOOKUP_VALUES_VL

674: BEGIN
675: IF (p_lookup_code IS NOT NULL) THEN
676: IF (p_check_id_flag = 'Y') THEN
677: SELECT lookup_code INTO x_lookup_code
678: FROM FND_LOOKUP_VALUES_VL
679: WHERE lookup_type = p_lookup_type
680: AND lookup_code = p_lookup_code
681: AND SYSDATE BETWEEN start_date_active
682: AND NVL(end_date_active,SYSDATE);

Line 688: FROM FND_LOOKUP_VALUES_VL

684: x_lookup_code := p_lookup_code;
685: END IF;
686: ELSE
687: SELECT lookup_code INTO x_lookup_code
688: FROM FND_LOOKUP_VALUES_VL
689: WHERE lookup_type = p_lookup_type
690: AND meaning = p_meaning
691: AND SYSDATE BETWEEN start_date_active
692: AND NVL(end_date_active,SYSDATE);

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 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 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 5276: FND_LOOKUP_VALUES_VL FLVT,

5272: ) due_by
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(+)

Line 5313: FND_LOOKUP_VALUES_VL FLVT

5309: ) due_by
5310: FROM AHL_VISITS_VL VST,
5311: CSI_ITEM_INSTANCES CSI ,
5312: MTL_SYSTEM_ITEMS_B_KFV mtl,
5313: FND_LOOKUP_VALUES_VL FLVT
5314: where VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
5315: and VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)
5316: AND VST.ITEM_ORGANIZATION_ID = mtl.ORGANIZATION_ID(+)
5317: AND FLVT.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'