OTA Views (102)

OTA - Learning Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`OTA_ACTIVITY_DEFINITIONS_V`	View to list all information about an Activity.
`OTA_ACTIVITY_DEFINITIONS_VL`	View to list all information about an Activity. It is scheduled for a future release.
`OTA_ACTIVITY_VERSIONS_V`	View to list all information about an Activity Version.
`OTA_ACTIVITY_VERSIONS_VL`	View to list all information about an Activity Version. It is scheduled for a future release.
`OTA_ACT_CAT_INCLUSIONS_V`	View to list Categories for particular Activity Version.
`OTA_ANNOUNCEMENTS_VL`
`OTA_BKNG_JUSTIFICATIONS_VL`
`OTA_BOOKING_DEALS_V`	View to list all information about an Enrollment Agreement.
`OTA_BOOKING_STATUS_HISTORIES_V`	View to list all information about a Students Booking Status History.
`OTA_BOOKING_STATUS_TYPES_VL`	View to list all information about a Booking Status Type. It is scheduled for a future release.
`OTA_CATEGORY_USAGES_V`	View to list all the uses of a Category
`OTA_CATEGORY_USAGES_V1`	List all the uses of a Category
`OTA_CATEGORY_USAGES_VL`
`OTA_CERTIFICATIONS_VL`
`OTA_CHATS_VL`
`OTA_COMPETENCE_LANGUAGES_V`
`OTA_CONFERENCE_SERVERS_VL`
`OTA_CROSS_CHARGES_V`
`OTA_CTRNG_HISTORIES_V`	This view is used as the data source for the combined training history displayed in the training histories form. (OTA_DELEGATE_BOOKINGS - "H
`OTA_CUSTOMER_ADDRESSES_V`	View to list all Addresses for a Customer.
`OTA_CUSTOMER_CONTACTS_V`	View to list all Contacts for a Customer.
`OTA_DELEGATE_BOOKINGS_V`	View to list all Student and Customer Enrollment.
`OTA_DISCOUNT_DEALS_V`	View to list all Discount Enrollment Agreements.
`OTA_EVENTS_V`	View to list all Events.
`OTA_EVENTS_VL`	View to list all Events. It is scheduled for a future release.
`OTA_EVENT_ASSOCIATIONS_V`	View to list External Asociations for an Event.
`OTA_EVENT_ASSOCIATIONS_V2`	View to list Internal Asociations for an Event.
`OTA_EVENT_ASSOCIAT_BILLING_V`	View to show the Finance information related to an Event Association
`OTA_EVENT_SEARCH_V`	View to list all Events. Used in Event Search Folder Form.
`OTA_EVENT_SEARCH_V2`	View to list all Events. Used in Event Search Folder Form.
`OTA_FINANCE_HEADERS_V`	View to list all information for Finance Headers
`OTA_FINANCE_LINES_V`	View to list all information for Finance Lines.
`OTA_FORUMS_VL`
`OTA_LEARNING_PATHS_VL`
`OTA_LETTER_REQUEST_LINES_V`	View to list all the letter request lines generated for Student Enrollments
`OTA_LP_SECTIONS_VL`
`OTA_NOTRNG_HISTORIES_V`	View for Student Non OTA Histories
`OTA_OFFERINGS_VL`
`OTA_PRE_PURCHASE_DEALS_V`	View to list all Pre-Purchase Enrollment Agreements.
`OTA_PRICE_LISTS_V`	View to list all information for Price list.
`OTA_PRICE_LIST_ENTRIES_V`	View to list all enteries in a Price List.
`OTA_PROGRAM_MEMBERSHIPS_V`	View to list all Program Members.
`OTA_RESOURCE_BOOKINGS_V`	View to list all resource bookings.
`OTA_RESOURCE_USAGES_V`	View to list all resource usages.
`OTA_SKILLS_V`	View to list all types of Skills.
`OTA_SKILL_PROVISIONS_V`	View to list all skills which are provided by an activity.
`OTA_STUDENTS_V`	View to list all Internal Persons.
`OTA_STUDENT_TITLES_V`	View to list all Titles.
`OTA_SUPPLIABLE_RESOURCES_V`	View to list information about Suppliable Resources.
`OTA_SUPPLIABLE_RESOURCES_VL`	View to list information about Suppliable Resources. It is scheduled for a future release.
`OTA_TEST_SECTIONS_V`
`OTA_TP_MEASUREMENT_TYPES_V`
`OTA_TRAINING_COST_LEVELS_V`
`OTA_TRAINING_PLANS_V`
`OTA_TRAINING_PLAN_BUDGETS_V`
`OTA_TRAINING_PLAN_COSTS_V`
`OTA_TRAINING_PLAN_MEMBERS_V`
`OTA_UTEST_QUESTIONS_V`
`OTA_VENDORS_V`	View to list all Suppliers.
`OTA_VENDOR_ADDRESSES_V`	View to list all Addresses for a Supplier.
`OTA_VENDOR_CONTACTS_V`	View to list all Contacts for a Supplier.
`OTFV_ACTIVITY_CATEGORIES`	Business view template from which the flexfield view is generated.
`OTFV_COMBINED_TRAINING_HISTORY`	Business view template from which the flexfield view is generated.
`OTFV_COST_TRANSFER`	Business view template from which the flexfield view is generated.
`OTFV_CUST_RESTRICTED_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_DELIVERED_COMPETENCES`	Business view template from which the flexfield view is generated.
`OTFV_ENROLLED_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_ENROLLMENT_AGREEMENTS`	Business view template from which the flexfield view is generated.
`OTFV_ENROLLMENT_STATUSES`	Business view template from which the flexfield view is generated.
`OTFV_ENROLLMENT_STATUS_HISTORY`	Business view template from which the flexfield view is generated.
`OTFV_EVENTS_WITHOUT_TRAINER`	Business view template from which the flexfield view is generated.
`OTFV_EVENTS_WITHOUT_VENUE`	Business view template from which the flexfield view is generated.
`OTFV_EVENTS_WITH_TRAINER`	Business view template from which the flexfield view is generated.
`OTFV_EVENTS_WITH_VENUE`	Business view template from which the flexfield view is generated.
`OTFV_EVENT_COMPETENCES`	Business view template from which the flexfield view is generated.
`OTFV_EXT_TRAINING_EVENT_ENROLS`	Business view template from which the flexfield view is generated.
`OTFV_FINANCE_HEADERS`	Business view template from which the flexfield view is generated.
`OTFV_FINANCE_LINES`	Business view template from which the flexfield view is generated.
`OTFV_HR_RESTRICTED_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_INT_TRAINING_EVENT_ENROLS`	Business view template from which the flexfield view is generated.
`OTFV_MISSING_REQ_RESOURCES`	Business view template from which the flexfield view is generated.
`OTFV_ONE_TIME_TRAINING_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_OVERBOOKED_RESOURCES`	Business view template from which the flexfield view is generated.
`OTFV_PRICE_LISTS`	Business view template from which the flexfield view is generated.
`OTFV_PRICE_LIST_ENTRIES`	Business view template from which the flexfield view is generated.
`OTFV_RESOURCES`	Business view template from which the flexfield view is generated.
`OTFV_RESOURCES_BOOKED`	Business view template from which the flexfield view is generated.
`OTFV_RESOURCE_CHECKLIST`	Business view template from which the flexfield view is generated.
`OTFV_SCHEDULED_TRAINING_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_SKILL_PROVISIONS`	Business view template from which the flexfield view is generated.
`OTFV_TOTAL_ENROLLMENTS`	Business view template from which the flexfield view is generated.
`OTFV_TRAINING_ACTIVITIES`	Business view template from which the flexfield view is generated.
`OTFV_TRAINING_AMOUNT`	Business view template from which the flexfield view is generated.
`OTFV_TRAINING_EVENTS`	Business view template from which the flexfield view is generated.
`OTFV_TRAINING_EVENT_CATEGORIES`	Business view template from which the flexfield view is generated.
`OTFV_TRAINING_EVENT_SESSIONS`	Business view template from which the flexfield view is generated.
`OTV_ACTIVITIES`	View to list all information about an Activity and Activity Version.
`OTV_EVENT_ASSOCIATIONS`
`OTV_ONE_TIME_EVENTS`
`OTV_SCHEDULED_EVENTS`	View to list Scehduled Event.
`OTV_SESSIONS`	View to list Session event.
`OTV_TRAINING_COMPETENCE`	View to list student's competence for an Activity version.