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_UMP_UTIL_PKG

Line 1081: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details

1077: l_service_req_id := NULL;
1078: l_service_req_num := NULL;
1079: l_service_req_date := NULL;
1080:
1081: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details
1082: (
1083: l_unit_effectivity_id,
1084: l_service_req_id,
1085: l_service_req_num,

Line 1905: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' ''N'' select_flag, ''Show'' details,ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) unit_name,

1901: L_MR_SEARCH_QUERY := 'select /*+ dynamic_sampling(AAI1 4) */ ';
1902: ELSE
1903: L_MR_SEARCH_QUERY := 'select ';
1904: END IF;
1905: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' ''N'' select_flag, ''Show'' details,ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) unit_name,
1906: (select meaning from fnd_lookup_values where lookup_code = mrb.PROGRAM_TYPE_CODE and lookup_type = ''AHL_FMP_MR_PROGRAM_TYPE'' and language = userenv(''LANG'')) prog_type ,
1907: B.MR_HEADER_ID,MRB.TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,csib.serial_number,
1908: (select c.name from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id and i.counter_id = c.counter_id) name ,
1909: (select c.uom_code from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id AND I.COUNTER_ID = C.COUNTER_ID) uom_code,

Line 1916: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,

1912: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id
1914: and task.status_code <> ''DELETED'' and rownum < 2) visit_name,
1915: null sr_incident_id,null sr_number,b.unit_effectivity_id,
1916: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
1917: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
1918: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
1919: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
1920: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id

Line 1922: (select master_config_name from ahl_unit_header_details_v ucd where ucd.name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) mc,

1918: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
1919: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
1920: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id
1921: and flt.fleet_header_id = b.fleet_header_id and rownum < 2) operatingorg ,
1922: (select master_config_name from ahl_unit_header_details_v ucd where ucd.name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) mc,
1923: (Select position_ref_meaning from ahl_unit_details_v ucd where ucd.csi_item_instance_id = b.csi_item_instance_id and rownum< 2) ucposition,
1924: MAINTTORG.MR_MAINTENANCE_ORG_NAME eng_org,
1925: (select meaning from fnd_lookup_values where lookup_code = MRB.IMPLEMENT_STATUS_CODE and lookup_type = ''AHL_FMP_MR_IMPLEMENT_STATUS'' and language = userenv(''LANG'')) implementstatus ,
1926: (select meaning from fnd_lookup_values where lookup_code = mrb.PROGRAM_SUBTYPE_CODE and lookup_type = ''AHL_FMP_MR_PROGRAM_SUBTYPE'' and language = userenv(''LANG'')) progsubtype ,

Line 1970: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' AND ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) IS NOT NULL ';

1966: IF (P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL OR NVL(P_SEARCH_UMP_REC.ITEM,'%')
1967: <> '%' OR P_SEARCH_UMP_REC.ITEM_SERIAL_NUMBER IS NOT NULL OR P_SEARCH_UMP_REC.ARRIVAL_ORG IS NOT NULL) THEN
1968: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' AND B.CSI_ITEM_INSTANCE_ID = AAI1.CSI_ITEM_INSTANCE_ID ';
1969: ELSE
1970: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' AND ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) IS NOT NULL ';
1971: END IF;
1972:
1973: /*IF(P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL) THEN
1974: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.UNIT_NAME;

Line 1975: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) like (:' ||L_BIND_INDEX ||')';

1971: END IF;
1972:
1973: /*IF(P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL) THEN
1974: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.UNIT_NAME;
1975: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) like (:' ||L_BIND_INDEX ||')';
1976: L_BIND_INDEX := L_BIND_INDEX+1;
1977: END IF;*/
1978: IF(P_SEARCH_UMP_REC.MR_TITLE IS NOT NULL) THEN
1979: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.MR_TITLE;

Line 2213: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' ''N'' select_flag, ''Show'' details,ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) unit_name,

2209: L_NR_SEARCH_QUERY := 'select /*+ dynamic_sampling(AAI1 4) */ ';
2210: ELSE
2211: L_NR_SEARCH_QUERY := 'select ';
2212: END IF;
2213: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' ''N'' select_flag, ''Show'' details,ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) unit_name,
2214: (select meaning from fnd_lookup_values where lookup_type = ''AHL_FMP_MR_PROGRAM_TYPE'' and lookup_code = ''NON-ROUTINE''
2215: AND LANGUAGE = USERENV(''LANG'')) prog_type,
2216: null mr_header_id,(CITT.NAME || ''-'' || CSB.INCIDENT_NUMBER) TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,
2217: csib.serial_number,null name ,null uom_code,AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) due_counter_value,''View all UOMs'' view_all_uoms,

Line 2224: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,

2220: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2222: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_name,
2223: B.CS_INCIDENT_ID sr_incident_id,CSB.INCIDENT_NUMBER sr_number,b.unit_effectivity_id,
2224: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
2225: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2226: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
2227: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
2228: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id

Line 2230: (select master_config_name from ahl_unit_header_details_v ucd where ucd.name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) mc,

2226: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
2227: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
2228: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id
2229: and flt.fleet_header_id = b.fleet_header_id and rownum < 2) operatingorg,
2230: (select master_config_name from ahl_unit_header_details_v ucd where ucd.name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) mc,
2231: (Select position_ref_meaning from ahl_unit_details_v ucd where ucd.csi_item_instance_id = b.csi_item_instance_id and rownum < 2) ucposition,
2232: null eng_org,
2233: null implementstatus ,null progsubtype , null servicecat, null mrServiceType, null mrduration,
2234: null MrDurationUOM , to_char(null) primaryvisittype ,

Line 2269: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' AND ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) IS NOT NULL ';

2265: IF (P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL OR NVL(P_SEARCH_UMP_REC.ITEM,'%')
2266: <> '%' OR P_SEARCH_UMP_REC.ITEM_SERIAL_NUMBER IS NOT NULL OR P_SEARCH_UMP_REC.ARRIVAL_ORG IS NOT NULL) THEN
2267: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' AND B.CSI_ITEM_INSTANCE_ID = AAI1.CSI_ITEM_INSTANCE_ID ';
2268: ELSE
2269: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' AND ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) IS NOT NULL ';
2270: END IF;
2271: /*IF(P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL) THEN
2272: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.UNIT_NAME;
2273: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) like (:' ||L_BIND_INDEX ||')';

Line 2273: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) like (:' ||L_BIND_INDEX ||')';

2269: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' AND ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) IS NOT NULL ';
2270: END IF;
2271: /*IF(P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL) THEN
2272: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.UNIT_NAME;
2273: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) like (:' ||L_BIND_INDEX ||')';
2274: L_BIND_INDEX := L_BIND_INDEX+1;
2275: END IF;*/
2276: IF(P_SEARCH_UMP_REC.MR_TITLE IS NOT NULL) THEN
2277: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.MR_TITLE;