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_MR_HEADERS_B

Line 305: select mr_status_code, effective_to, version_number from ahl_mr_headers_b

301:
302: -- Bug 9410754 added for adding version number to results table Start
303:
304: CURSOR ump_version_csr(mr_id IN NUMBER) IS
305: select mr_status_code, effective_to, version_number from ahl_mr_headers_b
306: where mr_header_id = mr_id;
307:
308: l_version_number NUMBER;
309: l_status_code VARCHAR2(40);

Line 543: l_mr_select_sql_string := 'SELECT /+ dynamic_sampling(AAI1 4) / UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_APPLICABLE_INSTANCES AAI1, AHL_MR_HEADERS_B MR';

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'' ';
541: l_select_sql_string := 'SELECT /*+ dynamic_sampling(AAI1 4) */ UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_APPLICABLE_INSTANCES AAI1 ';
542: l_select_sql_string := l_select_sql_string || 'WHERE UMP.application_usg_code= :APPL_USG_CODE AND AAI1.csi_item_instance_id = UMP.csi_item_instance_id ';
543: l_mr_select_sql_string := 'SELECT /*+ dynamic_sampling(AAI1 4) */ UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_APPLICABLE_INSTANCES AAI1, AHL_MR_HEADERS_B MR';
544: l_mr_select_sql_string := l_mr_select_sql_string || ' WHERE UMP.application_usg_code= :APPL_USG_CODE AND AAI1.csi_item_instance_id = UMP.csi_item_instance_id AND UMP.mr_header_id = MR.mr_header_id ';
545:
546: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));
547: l_bind_index := l_bind_index + 1;

Line 584: l_mr_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_MR_HEADERS_B MR WHERE UMP.application_usg_code= :APPL_USG_CODE AND UMP.mr_header_id = MR.mr_header_id ';

580: END IF; -- p_search_mr_instance_rec.INCIDENT_TYPE_ID
581: ELSE -- p_search_mr_instance_rec.unit_name
582: l_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP WHERE UMP.application_usg_code= :APPL_USG_CODE ';
583:
584: l_mr_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_MR_HEADERS_B MR WHERE UMP.application_usg_code= :APPL_USG_CODE AND UMP.mr_header_id = MR.mr_header_id ';
585: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));
586: l_bind_index := l_bind_index + 1;
587: IF p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL THEN
588: IF nvl(p_search_mr_instance_rec.SERVICE_REQ_NUM, '%') <> '%' THEN

Line 656: (select MR.program_type_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id)) like :FMP_PROGRAM_TYPE ';

652: --If the Prgram_type_code is NON_ROUTINE
653: l_sql_string := l_sql_string || ' AND UMP.OBJECT_TYPE IN (''SR'',''MR'') ';
654: -- fix for bug#7327283
655: l_sql_string := l_sql_string || ' AND DECODE(UMP.OBJECT_TYPE,''SR'',''NON-ROUTINE'',
656: (select MR.program_type_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id)) like :FMP_PROGRAM_TYPE ';
657:
658: l_bindvar_tbl(l_bind_index) := p_search_mr_instance_rec.program_type;
659: l_bind_index := l_bind_index + 1;
660:

Line 942: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';

938: l_bind_index := l_bind_index + 1;
939: END IF;
940:
941: IF p_search_mr_instance_rec.on_wing is NOT NULL THEN
942: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';
943: l_sql_string := l_sql_string || ' WHERE UMP.mr_header_id = MRB.mr_header_id AND MRB.service_type_code = :on_wing) ';
944: l_bindvar_tbl(l_bind_index) := p_search_mr_instance_rec.on_wing;
945: l_bind_index := l_bind_index + 1;
946: END IF;

Line 955: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';

951: IF (p_search_mr_instance_rec.IS_VWP_NAVG ='Y') THEN
952:
953: -- MR implement status check
954: IF p_search_mr_instance_rec.MR_IMPLEMENT_STATUS is NOT NULL THEN
955: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';
956: l_sql_string := l_sql_string || ' WHERE UMP.mr_header_id = MRB.mr_header_id AND UPPER(MRB.IMPLEMENT_STATUS_CODE) = :MR_IMPLEMENT_STATUS )';
957:
958: l_bindvar_tbl(l_bind_index) := UPPER(p_search_mr_instance_rec.MR_IMPLEMENT_STATUS);
959: l_bind_index := l_bind_index + 1;

Line 974: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';

970: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;
973: END;
974: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';
975: l_sql_string := l_sql_string || ' WHERE UMP.mr_header_id = MRB.mr_header_id AND MRB.SERVICE_CATEGORY_RANK >= :SERVICE_CATEGORY_RANK )';
976:
977: l_bindvar_tbl(l_bind_index) := TO_NUMBER(p_search_mr_instance_rec.SERVICE_CATEGORY);
978: l_bind_index := l_bind_index + 1;

Line 996: (select MR.program_type_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id))';

992: ELSIF (l_nr_select_sql_string IS NOT NULL) THEN
993: l_sql_string := l_sql_string || ' ORDER BY ''NONROUTINE'' ';
994: ELSE
995: l_sql_string := l_sql_string || ' ORDER BY DECODE(UMP.OBJECT_TYPE,''SR'',''NON-ROUTINE'',
996: (select MR.program_type_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id))';
997: END IF;
998: ELSIF p_search_mr_instance_rec.sort_by = 'AHL_UMP_MR_CATEGORY' THEN
999: IF (l_is_pm_installed = 'Y') THEN
1000: l_sql_string := l_sql_string || ' ORDER BY UMP.CATEGORY_CODE';

Line 1005: (select MR.category_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id))';

1001: ELSIF (l_mr_select_flag = TRUE) THEN
1002: l_sql_string := l_sql_string || ' ORDER BY MR.CATEGORY_CODE';
1003: ELSE
1004: l_sql_string := l_sql_string || ' ORDER BY DECODE(UMP.OBJECT_TYPE,''SR'',NULL,
1005: (select MR.category_code from AHL_MR_HEADERS_B MR where MR.mr_header_id = UMP.mr_header_id))';
1006: END IF;
1007: ELSIF p_search_mr_instance_rec.sort_by = 'AHL_UMP_IMPL_STATUS' THEN
1008: l_sql_string := l_sql_string || ' ORDER BY UMP.STATUS_CODE';
1009: END IF;

Line 1132: (SELECT mr.title FROM ahl_mr_headers_b mr,ahl_unit_effectivities_b dep

1128: IF(l_pick_record_flag) THEN
1129: IF ( row_count >= p_start_row AND row_count < p_start_row + p_rows_per_page) THEN
1130: --Changes for SBE - Dependent MR Details Begins
1131: SELECT preceding_ue_id, terminating_ue_id, accomplish_trigger_type,
1132: (SELECT mr.title FROM ahl_mr_headers_b mr,ahl_unit_effectivities_b dep
1133: WHERE dep.mr_header_id = mr.mr_header_id
1134: AND dep.unit_effectivity_id = eff.terminating_ue_id) termtitle
1135: INTO l_prec_ue_id, l_term_ue_id,l_acc_trig_reln_type,l_term_title
1136: FROM ahl_unit_effectivities_b eff

Line 1936: FROM AHL_UNIT_EFFECTIVITIES_B B, ahl_mr_headers_b mrb, CSI_ITEM_INSTANCES CSIB, mtl_system_items_kfv mtl,

1932: and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'') and rownum < 2) scheduledvisittype ,
1933: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou
1934: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''
1935: and vst.organization_id = hrou.organization_id and rownum < 2) scheduledVisitOrg
1936: FROM AHL_UNIT_EFFECTIVITIES_B B, ahl_mr_headers_b mrb, CSI_ITEM_INSTANCES CSIB, mtl_system_items_kfv mtl,
1937: (SELECT AUE.unit_effectivity_id, ( CASE WHEN AUE.FLEET_HEADER_ID IS NULL AND AMO.OPERATING_ORG_ID IS NOT NULL
1938: THEN NULL
1939: WHEN AUE.FLEET_HEADER_ID IS NOT NULL AND AMO.OPERATING_ORG_ID IS NOT NULL AND AFH.OPERATING_ORG_ID != AMO.OPERATING_ORG_ID
1940: THEN (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID= AFH.OPERATING_ORG_ID)

Line 1943: ELSE (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID= AMO.MAINTENANCE_ORG_ID) END) MR_MAINTENANCE_ORG_NAME FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_MR_HEADERS_B AMH, AHL_MR_ORGANIZATIONS AMO, AHL_FLEET_HEADERS_B AFH

1939: WHEN AUE.FLEET_HEADER_ID IS NOT NULL AND AMO.OPERATING_ORG_ID IS NOT NULL AND AFH.OPERATING_ORG_ID != AMO.OPERATING_ORG_ID
1940: THEN (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID= AFH.OPERATING_ORG_ID)
1941: WHEN AUE.FLEET_HEADER_ID IS NOT NULL AND AMO.MR_TITLE IS NULL
1942: THEN(SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID= AFH.OPERATING_ORG_ID)
1943: ELSE (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID= AMO.MAINTENANCE_ORG_ID) END) MR_MAINTENANCE_ORG_NAME FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_MR_HEADERS_B AMH, AHL_MR_ORGANIZATIONS AMO, AHL_FLEET_HEADERS_B AFH
1944: WHERE AUE.MR_HEADER_ID = AMH.MR_HEADER_ID (+) AND AMH.TITLE = AMO.MR_TITLE (+) AND AUE.FLEET_HEADER_ID = AFH.FLEET_HEADER_ID (+)
1945: AND ( (AUE.FLEET_HEADER_ID IS NULL AND AMO.OPERATING_ORG_ID IS NULL) OR (AFH.OPERATING_ORG_ID IS NULL
1946: AND AMO.OPERATING_ORG_ID IS NOT NULL AND (0 = (SELECT COUNT(MR_ORGANIZATION_ID) FROM AHL_MR_ORGANIZATIONS
1947: WHERE MR_TITLE = AMO.MR_TITLE AND OPERATING_ORG_ID IS NULL ))) OR (AUE.FLEET_HEADER_ID IS NOT NULL