APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_WORKORDERS_V

Line 174: FROM ahl_workorders_v

170: scheduled_start_date,
171: job_status_code,
172: job_number,
173: organization_id
174: FROM ahl_workorders_v
175: WHERE workorder_id = p_workorder_id;
176: */
177: -- Modified by SURRKUMA for Service Bulletin on 17-Jun-11
178: -- AnRaj: Changed query, Perf Bug#4908609,Issue#1

Line 2638: FROM ahl_workorders_v

2634: --sareepar Added for Bug #13372980 on 25/04/2012
2635: -- Cursor to get originating workorder details
2636: CURSOR get_orig_workorder_det_csr(p_workorder_id NUMBER) IS
2637: SELECT scheduled_start_date
2638: FROM ahl_workorders_v
2639: WHERE workorder_id = p_workorder_id;
2640:
2641:
2642: l_rel_nm_wo_id NUMBER;