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_CPE_UTIL dependencies on OTA_CERTIFICATIONS_VL

Line 1882: From ota_certifications_vl ceb

1878: ,prd.cert_prd_enrollment_id
1879: ,prd.period_status_code
1880: ,prd.cert_period_end_date
1881: ,prd.object_version_number
1882: From ota_certifications_vl ceb
1883: ,ota_cert_enrollments enr
1884: ,ota_cert_prd_enrollments prd
1885: Where
1886: ceb.certification_id = enr.certification_id

Line 1905: From ota_certifications_vl ceb

1901: ,prd.period_status_code
1902: ,prd.cert_period_end_date
1903: ,ceb.initial_completion_date
1904: ,enr.object_version_number
1905: From ota_certifications_vl ceb
1906: ,ota_cert_enrollments enr
1907: ,ota_cert_prd_enrollments prd
1908: Where
1909: ceb.certification_id = enr.certification_id

Line 2340: FROM ota_certifications_vl ocb, ota_cert_enrollments oce, ota_cert_prd_enrollments ocpe

2336: ocpe.cert_prd_enrollment_id,
2337: ocpe.cert_period_start_date,
2338: ocpe.cert_period_end_date,
2339: ocpe.expiration_date
2340: FROM ota_certifications_vl ocb, ota_cert_enrollments oce, ota_cert_prd_enrollments ocpe
2341: WHERE ocb.certification_id = oce.certification_id
2342: AND oce.cert_enrollment_id = ocpe.cert_enrollment_id
2343: AND trunc(SYSDATE) BETWEEN trunc(ocb.start_date_active) AND trunc(nvl(ocb.end_date_active, SYSDATE))
2344: AND ocb.renewable_flag = 'Y'