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_LTP_RESRC_LEVL_PVT dependencies on BOM_RESOURCE_SHIFTS

Line 2583: FROM bom_resource_shifts

2579: CURSOR l_get_shift_dtls_csr(p_bom_resource_id IN NUMBER,
2580: p_bom_department_id IN NUMBER) IS
2581: SELECT SHIFT_NUM,
2582: CAPACITY_UNITS SHIFT_CAPACITY
2583: FROM bom_resource_shifts
2584: WHERE resource_id = p_bom_resource_id
2585: AND department_id = p_bom_department_id;
2586:
2587: --

Line 4350: FROM bom_shift_times st, bom_resource_shifts rs

4346: IS
4347:
4348: CURSOR l_shift_details_csr(p_resource_id NUMBER) IS
4349: SELECT from_time, to_time
4350: FROM bom_shift_times st, bom_resource_shifts rs
4351: WHERE st.shift_num = rs.shift_num AND
4352: rs.resource_id = p_resource_id;
4353:
4354: l_shift_start NUMBER := 0;

Line 4673: FROM bom_resource_shifts

4669: -- Gets shift capacity
4670: CURSOR l_get_shift_dtls_csr(p_bom_resource_id IN NUMBER,
4671: p_bom_department_id IN NUMBER) IS
4672: SELECT CAPACITY_UNITS SHIFT_CAPACITY
4673: FROM bom_resource_shifts
4674: WHERE resource_id = p_bom_resource_id
4675: AND department_id = p_bom_department_id
4676: AND SHIFT_NUM = ( select shift_num
4677: FROM AHL_DEPARTMENT_SHIFTS