OTA OLM Learning Path

Description
Categories: BI Publisher
Columns: Learning Path Id, Learning Path Name, Lp Start Date, Lp End Date, Lp Enrollment Id, Path Status Code, Learning Path Status, Lp Completion Date, Completion Target Date, Business Group Id ...
Application: Learning Management
Source: OLM Learning Path Report
Short Name: OTALP
DB package: OTA_LP_XMLP_PKG
 SELECT lp.learning_path_id,
       lp.name learning_path_name,
       lp.start_date_active lp_start_date,
       lp.end_date_active lp_end_date,
       lpe.lp_enrollment_id,
       lpe.path_status_code,
       ota_lrng_path_util.get_lp_current_status(lpe.lp_enrollment_id) learning_path_status,
       lpe.completion_date lp_completion_date,
       lpe.completion_target_date,
       lpe.business_group_id,
       oav.activity_version_id,
       oav.version_name course_name,
       oev.event_id,
       oev.title class_name,
       oev.course_start_date,
       oev.course_start_time,
       oev.course_end_date,
       oev.course_end_time,
       odb.booking_id,
       odb.booking_status_type_id,
       obst.type booking_status_type,
       obst.name class_enrollment_status
FROM ota_learning_paths_vl lp,
     ota_lp_enrollments lpe,
     ota_learning_path_members lpm,
     ota_lp_member_enrollments lpme,
     ota_activity_versions_vl oav,
     ota_events_vl oev,
     ota_delegate_bookings odb,
     ota_booking_status_types obst
WHERE lpe.learning_path_id = lp.learning_path_id AND
      lpe.lp_enrollment_id = lpme.lp_enrollment_id AND
      lpme.learning_path_member_id = lpm.learning_path_member_id AND
      lpm.activity_version_id = oav.activity_version_id AND
      oav.activity_version_id = oev.activity_version_id AND
      oev.event_id = odb.event_id AND
      lpe.person_id = odb.delegate_person_id AND
      odb.booking_status_type_id = obst.booking_status_type_id AND
      lpe.path_status_code <> 'CANCELLED' AND
      -- obst.type <> 'C' AND
      lpe.person_id = :P_LEARNER_ID AND
      decode(:P_LP_STATUS_CODE, null, 'N' , ota_lrng_path_util.get_lp_current_status(lpe.lp_enrollment_id)) = nvl(ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', :P_LP_STATUS_CODE, 810), 'N')
      and ota_admin_access_util.admin_can_access_object('CLP',lp.learning_path_id)='Y'
order by learning_path_name, learning_path_status, class_name
Parameter Name SQL text Validation
Learning Path Name
 
LOV Oracle
Learner Name
 
LOV Oracle
Learning Path Status
 
LOV Oracle