APPS.AHL_ENIGMA_UTIL_PKG dependencies on AHL_WORKORDERS

Line 70: FROM ahl_workorders wo,ahl_routes_b rt

66: FROM dual;
67:
68: CURSOR get_doc_id (c_workorder_id NUMBER)IS
69: SELECT enigma_doc_id
70: FROM ahl_workorders wo,ahl_routes_b rt
71: WHERE wo.workorder_id = c_workorder_id
72: AND wo.route_id = rt.route_id;
73:
74: CURSOR get_wo_model_tail_csr (c_workorder NUMBER)

Line 77: FROM ahl_workorders AWO,

73:
74: CURSOR get_wo_model_tail_csr (c_workorder NUMBER)
75: IS
76: SELECT model_code, UCH.name, NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
77: FROM ahl_workorders AWO,
78: ahl_visits_b VST,
79: ahl_visit_tasks_b TSK,
80: ahl_unit_config_headers UCH,
81: ahl_mc_headers_b MCH

Line 290: FROM ahl_routes_b RT,ahl_workorders WO

286: l_doc_id := NULL;
287: BEGIN
288: SELECT enigma_doc_id
289: INTO l_doc_id
290: FROM ahl_routes_b RT,ahl_workorders WO
291: WHERE WO.workorder_id = p_workorder_id
292: AND WO.route_id = RT.route_id;
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN