DBA Data[Home] [Help]

APPS.OTA_TRAINING_RECORD dependencies on OTA_CERTIFICATION_MEMBERS

Line 590: ota_certification_members cmb,

586: DECODE(cre.person_id, NULL, 'C', 'E'), cme.cert_mbr_enrollment_id))AS CLASSROOM_ID
587: from ota_cert_enrollments cre,
588: ota_cert_prd_enrollments cpe,
589: ota_cert_mbr_enrollments cme,
590: ota_certification_members cmb,
591: ota_activity_versions_vl tav,
592: hr_lookups lkp
593: where tav.activity_version_id = cmb.object_id
594: and cmb.object_type = 'H'

Line 778: ota_certification_members cmb,

774: ota_booking_status_types_VL s,
775: ota_cert_enrollments cre,
776: ota_cert_prd_enrollments cpe,
777: ota_cert_mbr_enrollments cme,
778: ota_certification_members cmb,
779: ota_offerings ofr,
780: ota_category_usages c
781: WHERE e.event_id = b.event_id
782: AND cre.cert_enrollment_id = cpe.cert_enrollment_id