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 1843: From ota_certifications_vl ceb

1839: ,prd.cert_prd_enrollment_id
1840: ,prd.period_status_code
1841: ,prd.cert_period_end_date
1842: ,prd.object_version_number
1843: From ota_certifications_vl ceb
1844: ,ota_cert_enrollments enr
1845: ,ota_cert_prd_enrollments prd
1846: Where
1847: ceb.certification_id = enr.certification_id

Line 1866: From ota_certifications_vl ceb

1862: ,prd.period_status_code
1863: ,prd.cert_period_end_date
1864: ,ceb.initial_completion_date
1865: ,enr.object_version_number
1866: From ota_certifications_vl ceb
1867: ,ota_cert_enrollments enr
1868: ,ota_cert_prd_enrollments prd
1869: Where
1870: ceb.certification_id = enr.certification_id

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

2297: ocpe.cert_prd_enrollment_id,
2298: ocpe.cert_period_start_date,
2299: ocpe.cert_period_end_date,
2300: ocpe.expiration_date
2301: FROM ota_certifications_vl ocb, ota_cert_enrollments oce, ota_cert_prd_enrollments ocpe
2302: WHERE ocb.certification_id = oce.certification_id
2303: AND oce.cert_enrollment_id = ocpe.cert_enrollment_id
2304: AND trunc(SYSDATE) BETWEEN trunc(ocb.start_date_active) AND trunc(nvl(ocb.end_date_active, SYSDATE))
2305: AND ocb.renewable_flag = 'Y'