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_CERTIFICATIONS_TL

Line 160: ,ota_certifications_tl ctl

156: cpe.expiration_date,
157: crt.start_date_active,
158: crt.end_date_active
159: FROM ota_certifications_b crt
160: ,ota_certifications_tl ctl
161: ,ota_cert_enrollments cre
162: ,ota_cert_prd_enrollments cpe
163: ,hr_lookups cpe_lkp
164: WHERE cre.person_id BETWEEN nvl(p_start_person_id, cre.person_id)

Line 244: ,ota_certifications_tl ctl

240: cpe.expiration_date,
241: crt.start_date_active,
242: crt.end_date_active
243: FROM ota_certifications_b crt
244: ,ota_certifications_tl ctl
245: ,ota_cert_enrollments cre
246: ,ota_cert_prd_enrollments cpe
247: ,hr_lookups cpe_lkp
248: WHERE

Line 343: ,ota_certifications_tl ctl

339: cpe.expiration_date,
340: crt.start_date_active,
341: crt.end_date_active
342: FROM ota_certifications_b crt
343: ,ota_certifications_tl ctl
344: ,ota_cert_enrollments cre
345: ,ota_cert_prd_enrollments cpe
346: ,hr_lookups cpe_lkp
347: WHERE ((p_person_id IS NULL) OR (p_person_id IS NOT NULL AND cre.person_id = p_person_id))

Line 428: ota_certifications_tl tl

424: , tl.keywords Keywords
425: , INITIAL_PERIOD_COMMENTS
426: , tl.RENEWAL_PERIOD_COMMENTS
427: from ota_certifications_b b,
428: ota_certifications_tl tl
429: where
430: b.certification_id = tl.certification_id
431: --and b.business_group_id = ota_general.get_business_group_id
432: and tl.language = USERENV ('LANG')