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_PROCESSUNIT_PVT dependencies on AHL_UF_DETAILS

Line 1698: CURSOR ahl_uf_details_csr(p_uf_header_id IN NUMBER) IS

1694: SELECT uf_header_id, use_unit_flag
1695: FROM ahl_uf_headers
1696: WHERE unit_config_header_id = p_uc_header_id;
1697:
1698: CURSOR ahl_uf_details_csr(p_uf_header_id IN NUMBER) IS
1699: SELECT uom_code, start_date, end_date, usage_per_day
1700: FROM ahl_uf_details
1701: WHERE uf_header_id = p_uf_header_id
1702: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 1700: FROM ahl_uf_details

1696: WHERE unit_config_header_id = p_uc_header_id;
1697:
1698: CURSOR ahl_uf_details_csr(p_uf_header_id IN NUMBER) IS
1699: SELECT uom_code, start_date, end_date, usage_per_day
1700: FROM ahl_uf_details
1701: WHERE uf_header_id = p_uf_header_id
1702: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)
1703: order by uom_code, start_date;
1704:

Line 1712: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi

1708: WHERE csi_item_instance_id = p_csi_item_instance_id;
1709:
1710: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1711: SELECT uom_code, start_date, end_date, usage_per_day
1712: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi
1713: WHERE uh.uf_header_id = ud.uf_header_id
1714: AND csi.instance_id = p_csi_item_instance_id
1715: AND csi.inventory_item_id = uh.inventory_item_id
1716: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 1756: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP

1752: --dbms_output.put_line('Found uf header and use_unit_flag' || l_uf_header_id);
1753:
1754: -- initialize.
1755: l_index := 1;
1756: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
1757: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
1758: l_forecast_details_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);
1759: l_forecast_details_tbl(l_index).end_date := trunc(l_forecast_detail_rec.end_date);
1760: l_forecast_details_tbl(l_index).usage_per_day := l_forecast_detail_rec.usage_per_day;

Line 1794: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP

1790: -- check if forecast defined.
1791: OPEN ahl_uf_headers_csr (p_uc_header_id);
1792: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
1793: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
1794: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
1795: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
1796: l_forecast_details_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);
1797: l_forecast_details_tbl(l_index).end_date := trunc(l_forecast_detail_rec.end_date);
1798: l_forecast_details_tbl(l_index).usage_per_day := l_forecast_detail_rec.usage_per_day;