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 HR_ALL_ORGANIZATION_UNITS

Line 221: hr_all_organization_units hrou,

217: UNION ALL
218: select vst1.* from
219: ahl_visits_b vst1
220: where simulation_plan_id IS NULL)vst,
221: hr_all_organization_units hrou,
222: bom_departments bdpt
223: WHERE vst.visit_id = tsk.visit_id
224: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
225: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 1572: l_unit_related_ii_sql := l_unit_related_ii_sql || ' AND AUS.ARRIVAL_ORG_ID IN (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU

1568: l_unit_related_ii_sql := ' Select DISTINCT ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu,ahl_unit_schedules aus
1569: where AUS.UNIT_CONFIG_HEADER_ID = AHLU.UNIT_CONFIG_HEADER_ID and UPPER(ahlu.name) like (:UNIT_NAME) ';
1570: L_BINDVAR_TBL(L_BIND_INDEX) := UPPER(P_SEARCH_UMP_REC.UNIT_NAME);
1571: L_BIND_INDEX := L_BIND_INDEX + 1;
1572: l_unit_related_ii_sql := l_unit_related_ii_sql || ' AND AUS.ARRIVAL_ORG_ID IN (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU
1573: WHERE HROU.NAME LIKE :ORG_NAME) ';
1574: L_BINDVAR_TBL(L_BIND_INDEX) := P_SEARCH_UMP_REC.ARRIVAL_ORG;
1575: L_BIND_INDEX := L_BIND_INDEX + 1;
1576: IF(L_DUE_FROM IS NOT NULL)THEN

Line 1663: l_unit_related_ii_sql := l_unit_related_ii_sql || ' AND AUS.ARRIVAL_ORG_ID IN (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU

1659: l_bindvar_tbl(l_bind_index) := UPPER(p_search_ump_rec.unit_name);
1660: END IF;
1661: L_BIND_INDEX := L_BIND_INDEX + 1;
1662: IF (P_SEARCH_UMP_REC.ARRIVAL_ORG IS NOT NULL) THEN
1663: l_unit_related_ii_sql := l_unit_related_ii_sql || ' AND AUS.ARRIVAL_ORG_ID IN (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU
1664: WHERE HROU.NAME LIKE :ORG_NAME) ';
1665: L_BINDVAR_TBL(L_BIND_INDEX) := P_SEARCH_UMP_REC.ARRIVAL_ORG;
1666: L_BIND_INDEX := L_BIND_INDEX + 1;
1667: IF(L_DUE_FROM IS NOT NULL)THEN

Line 1683: (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU WHERE HROU.NAME LIKE :ORG_NAME) ';

1679: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || 'and exists (select ''x'' from ahl_unit_config_headers uc where uc.CSI_ITEM_INSTANCE_ID = csii.instance_id ) ';
1680: IF (P_SEARCH_UMP_REC.ARRIVAL_ORG IS NOT NULL) THEN
1681: l_unit_related_ii_sql := l_unit_related_ii_sql || ' and csii.instance_id IN (select uc.CSI_ITEM_INSTANCE_ID from ahl_unit_schedules aus,
1682: ahl_unit_config_headers uc where AUS.UNIT_CONFIG_HEADER_ID = UC.UNIT_CONFIG_HEADER_ID AND AUS.ARRIVAL_ORG_ID IN
1683: (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HROU WHERE HROU.NAME LIKE :ORG_NAME) ';
1684: L_BINDVAR_TBL(L_BIND_INDEX) := P_SEARCH_UMP_REC.ARRIVAL_ORG;
1685: L_BIND_INDEX := L_BIND_INDEX + 1;
1686: IF(L_DUE_FROM IS NOT NULL)THEN
1687: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || 'AND AUS.EST_ARRIVAL_TIME >= NVL(:FROM_DATE , AUS.EST_ARRIVAL_TIME) ';

Line 1920: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_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
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,

Line 1933: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou

1929: mrb.down_time mrduration , mrb.uom_code MrDurationUOM , to_char(null) primaryvisittype ,
1930: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id
1931: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED'' and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE''
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

Line 2048: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou

2044: L_BIND_INDEX := L_BIND_INDEX+1;
2045: END IF;
2046: IF(P_SEARCH_UMP_REC.VISIT_ORG_NAME IS NOT NULL) THEN
2047: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_ORG_NAME;
2048: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou
2049: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and
2050: vst.organization_id = hrou.organization_id
2051: and hrou.name like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2052: L_BIND_INDEX := L_BIND_INDEX+1;

Line 2190: l_mr_search_query := l_mr_search_query || ' and EXISTS (select ''x'' FROM AHL_FLEET_HEADERS_B FLT, HR_ALL_ORGANIZATION_UNITS HROU where

2186: END IF;
2187: -- operating org
2188: if(p_search_ump_rec.OPERATING_ORG is not null) then
2189: x_ump_bind_params(l_bind_index).bind_param := p_search_ump_rec.operating_org;
2190: l_mr_search_query := l_mr_search_query || ' and EXISTS (select ''x'' FROM AHL_FLEET_HEADERS_B FLT, HR_ALL_ORGANIZATION_UNITS HROU where
2191: FLT.OPERATING_ORG_ID = HROU.ORGANIZATION_ID and flt.fleet_header_id = b.fleet_header_id and HROU.NAME like (:' || l_bind_index || '))';
2192: l_bind_index := l_bind_index+1;
2193: end if;
2194: -- engineering org

Line 2228: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_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
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,

Line 2239: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou

2235: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt
2236: where vst.visit_id = task.visit_id and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''
2237: and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE'' and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'')
2238: and rownum < 2) scheduledvisittype ,
2239: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou
2240: where vst.visit_id = task.visit_id and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''
2241: and vst.organization_id = hrou.organization_id and rownum < 2) scheduledVisitOrg
2242: FROM AHL_UNIT_EFFECTIVITIES_B B,
2243: CS_INCIDENT_TYPES_B CITB,

Line 2321: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou

2317: L_BIND_INDEX := L_BIND_INDEX+1;
2318: END IF;
2319: IF(P_SEARCH_UMP_REC.VISIT_ORG_NAME IS NOT NULL) THEN
2320: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_ORG_NAME;
2321: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou
2322: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and vst.organization_id = hrou.organization_id
2323: and hrou.name like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2324: L_BIND_INDEX := L_BIND_INDEX+1;
2325: END IF;

Line 2422: l_nr_search_query := l_nr_search_query || ' and EXISTS (select ''x'' FROM AHL_FLEET_HEADERS_B FLT, HR_ALL_ORGANIZATION_UNITS HROU where FLT.OPERATING_ORG_ID = HROU.ORGANIZATION_ID

2418: END IF;
2419: -- operating org
2420: if(p_search_ump_rec.OPERATING_ORG is not null) then
2421: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.OPERATING_ORG;
2422: l_nr_search_query := l_nr_search_query || ' and EXISTS (select ''x'' FROM AHL_FLEET_HEADERS_B FLT, HR_ALL_ORGANIZATION_UNITS HROU where FLT.OPERATING_ORG_ID = HROU.ORGANIZATION_ID
2423: and flt.fleet_header_id = b.fleet_header_id and HROU.NAME like (:' || l_bind_index || '))';
2424: l_bind_index := l_bind_index+1;
2425: end if;
2426: IF(NVL(P_SEARCH_UMP_REC.SHOW_VISIT_DATE_VIOLATIONS,'N') = 'Y') THEN