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.OTA_TRAINING_RECORD dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,

53: );
54:
55: TYPE cert_component_rectype IS RECORD
56: (
57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,
58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,

Line 59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,

55: TYPE cert_component_rectype IS RECORD
56: (
57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,
58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),

Line 61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,

57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,
58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,

Line 72: cert_prd_enrollment_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%TYPE,

68: certification_member_id ota_certification_members.certification_member_id%TYPE,
69: member_sequence ota_certification_members.member_sequence%TYPE,
70: event_id ota_events.event_id%TYPE,
71: perf_status ota_booking_status_types_tl.name%TYPE,
72: cert_prd_enrollment_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%TYPE,
73: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
74: certification_id ota_cert_enrollments.certification_id%TYPE,
75: site_address varchar2(255),
76: site_short_name varchar2(255),