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 149: FROM ahl_unit_effectivities_v UMP

145: UMP.MANUALLY_PLANNED_DESC,
146: UMP.cs_incident_id, UMP.cs_incident_number,
147: -- added for bug# 6530920.
148: UMP.orig_ue_instance_id
149: FROM ahl_unit_effectivities_v UMP
150: WHERE UMP.unit_effectivity_id = p_unit_effectivity_id;
151:
152: --Changes for SBE - Dependent MR Details Begins
153: l_prec_ue_id NUMBER;

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

527: END IF;
528:
529: --start fix for bug#7327283
530: --SELECT Clause
531: --l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';
532:
533: --fix for bug# 7562008. Added hint /*+ dynamic_sampling(AAI1 4) */ to queries based on AHL_APPLICABLE_INSTANCES table
534: --as per feedback from Application Performance team.
535: IF (l_is_pm_installed = 'Y') THEN

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

532:
533: --fix for bug# 7562008. Added hint /*+ dynamic_sampling(AAI1 4) */ to queries based on AHL_APPLICABLE_INSTANCES table
534: --as per feedback from Application Performance team.
535: IF (l_is_pm_installed = 'Y') THEN
536: l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_V UMP WHERE 0=0 ';
537: ELSE
538: IF (p_search_mr_instance_rec.unit_name is NOT NULL OR nvl(p_search_mr_instance_rec.part_number,'%')
539: <> '%' OR p_search_mr_instance_rec.serial_number IS NOT NULL) THEN
540: --l_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP WHERE UMP.application_usg_code= ''AHL'' ';

Line 2540: FROM AHL_UNIT_EFFECTIVITIES_V UMP

2536: UMP.counter_name,
2537: UMP.status_code, UMP.originator_title, UMP.csi_item_instance_id,
2538: UMP.COUNTER_ID,
2539: UMP.orig_ue_instance_id
2540: FROM AHL_UNIT_EFFECTIVITIES_V UMP
2541: WHERE UMP.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID;
2542: l_net_reading NUMBER;
2543: l_uom_remain NUMBER;
2544: BEGIN