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_UMP_SMRINSTANCE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_V

Line 144: FROM ahl_unit_effectivities_v UMP

140: UMP.MANUALLY_PLANNED_DESC,
141: UMP.cs_incident_id, UMP.cs_incident_number,
142: -- added for bug# 6530920.
143: UMP.orig_ue_instance_id
144: FROM ahl_unit_effectivities_v UMP
145: WHERE UMP.unit_effectivity_id = p_unit_effectivity_id;
146:
147: -- Added to fix bug# 2780716.
148: l_counter_id NUMBER;

Line 465: --l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';

461: END IF;
462:
463: --start fix for bug#7327283
464: --SELECT Clause
465: --l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';
466:
467: --fix for bug# 7562008. Added hint /*+ dynamic_sampling(AAI1 4) */ to queries based on AHL_APPLICABLE_INSTANCES table
468: --as per feedback from Application Performance team.
469: IF (l_is_pm_installed = 'Y') THEN

Line 470: l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';

466:
467: --fix for bug# 7562008. Added hint /*+ dynamic_sampling(AAI1 4) */ to queries based on AHL_APPLICABLE_INSTANCES table
468: --as per feedback from Application Performance team.
469: IF (l_is_pm_installed = 'Y') THEN
470: l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';
471: ELSE
472: IF (p_search_mr_instance_rec.unit_name is NOT NULL OR nvl(p_search_mr_instance_rec.part_number,'%')
473: <> '%' OR p_search_mr_instance_rec.serial_number IS NOT NULL) THEN
474: --l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP WHERE UMP.application_usg_code= ''AHL'' ';