DBA Data[Home] [Help]

APPS.OTA_FR_PLAN_DFORM dependencies on OTA_ACTIVITY_VERSIONS

Line 56: from ota_activity_versions course,

52: select course_tl.version_name member_name
53: ,course.activity_version_id member_id
54: ,course_tl.description member_description
55: ,'ACTIVITY_VERSION' member_level
56: from ota_activity_versions course,
57: ota_activity_versions_tl course_tl
58: where course.activity_version_id = course_tl.activity_version_id(+)
59: and course_tl.language(+) = userenv('LANG')
60: and exists

Line 57: ota_activity_versions_tl course_tl

53: ,course.activity_version_id member_id
54: ,course_tl.description member_description
55: ,'ACTIVITY_VERSION' member_level
56: from ota_activity_versions course,
57: ota_activity_versions_tl course_tl
58: where course.activity_version_id = course_tl.activity_version_id(+)
59: and course_tl.language(+) = userenv('LANG')
60: and exists
61: (select null

Line 124: ota_activity_versions course

120: ,fnd_date.date_to_canonical(class.course_start_date) class_from
121: ,fnd_date.date_to_canonical(class.course_end_date) class_to
122: from ota_events class,
123: ota_events_tl class_tl,
124: ota_activity_versions course
125: where class.event_id is not null
126: and class_tl.event_id = class.event_id
127: and class_tl.language(+) = userenv('LANG')
128: and class.activity_version_id = course.activity_version_id