APPS.AHL_OSP_UTIL_PKG dependencies on AHL_VISITS_VL

Line 868: FROM AHL_WORKORDERS WO, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS, CSI_ITEM_INSTANCES CSI

864: p_serial_number IN VARCHAR2,
865: p_lot_number IN VARCHAR2) RETURN VARCHAR2 IS
866: CURSOR get_wo_instance_csr IS
867: SELECT csi.instance_number
868: FROM AHL_WORKORDERS WO, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS, CSI_ITEM_INSTANCES CSI
869: WHERE WO.WORKORDER_ID = p_workorder_id AND
870: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
871: VST.VISIT_ID = VTS.VISIT_ID AND
872: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID) = CSI.INSTANCE_ID;