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_CONFIG_HEADERS

Line 1404: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu

1400: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type) IS
1401:
1402:
1403: CURSOR only_units_csr(p_unit_name in VARCHAR2) IS
1404: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu
1405: where UPPER(ahlu.name) like upper(p_unit_name);
1406:
1407:
1408: l_unit_related_ii_sql VARCHAR2(4000);

Line 1438: l_unit_related_ii_sql := l_unit_related_ii_sql || ', ahl_unit_config_headers uc ';

1434: l_unit_related_ii_sql := l_unit_related_ii_sql || ', mtl_system_items_kfv mtl ';
1435: END IF;
1436:
1437: IF p_search_mr_instance_rec.unit_name is NOT NULL THEN
1438: l_unit_related_ii_sql := l_unit_related_ii_sql || ', ahl_unit_config_headers uc ';
1439: END IF;
1440:
1441: l_unit_related_ii_sql := l_unit_related_ii_sql || 'where 0=0 ';
1442:

Line 1524: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu

1520: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type) IS
1521:
1522:
1523: CURSOR only_units_csr(p_unit_name in VARCHAR2) IS
1524: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu
1525: where UPPER(ahlu.name) like upper(p_unit_name);
1526:
1527: l_unit_related_ii_sql VARCHAR2(4000);
1528:

Line 1568: l_unit_related_ii_sql := ' Select DISTINCT ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu,ahl_unit_schedules aus

1564: INSERT INTO AHL_APPLICABLE_INSTANCES (CSI_ITEM_INSTANCE_ID, POSITION_ID) VALUES (ONLY_UNITS_REC.CSI_ITEM_INSTANCE_ID,0);
1565: END LOOP;
1566: ELSE
1567: L_BIND_INDEX := 1;
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

Line 1615: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || ', ahl_unit_config_headers uc ';

1611: l_unit_related_ii_sql := l_unit_related_ii_sql || ', mtl_system_items_kfv mtl ';
1612: END IF;
1613:
1614: IF p_search_ump_rec.unit_name is NOT NULL THEN
1615: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || ', ahl_unit_config_headers uc ';
1616: IF (P_SEARCH_UMP_REC.ARRIVAL_ORG IS NOT NULL) THEN
1617: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || ', ahl_unit_schedules aus ';
1618: END IF;
1619: END IF;

Line 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 ) ';

1675: L_BIND_INDEX := L_BIND_INDEX + 1;
1676: END IF;
1677: END IF;
1678: ELSE
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) ';

Line 1682: ahl_unit_config_headers uc where AUS.UNIT_CONFIG_HEADER_ID = UC.UNIT_CONFIG_HEADER_ID AND AUS.ARRIVAL_ORG_ID IN

1678: ELSE
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

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 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