Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OTA Tables and Views

TABLE - OTA.OTA_ACTIVITY_DEFINITIONS
TABLE - OTA.OTA_ACTIVITY_DEFINITIONS_TL
TABLE - OTA.OTA_ACTIVITY_VERSIONS
TABLE - OTA.OTA_ACTIVITY_VERSIONS_TL
TABLE - OTA.OTA_ACT_CAT_INCLUSIONS
TABLE - OTA.OTA_ANNOUNCEMENTS
TABLE - OTA.OTA_ANNOUNCEMENTS_TL
TABLE - OTA.OTA_ATTEMPTS
TABLE - OTA.OTA_BKNG_JUSTIFICATIONS_B
TABLE - OTA.OTA_BKNG_JUSTIFICATIONS_TL
TABLE - OTA.OTA_BOOKING_DEALS
TABLE - OTA.OTA_BOOKING_STATUS_EXCL
TABLE - OTA.OTA_BOOKING_STATUS_HISTORIES
TABLE - OTA.OTA_BOOKING_STATUS_TYPES
TABLE - OTA.OTA_BOOKING_STATUS_TYPES_TL
TABLE - OTA.OTA_BULK_ENR_REQUESTS
TABLE - OTA.OTA_BULK_ENR_REQ_MEMBERS
TABLE - OTA.OTA_CATEGORY_USAGES
TABLE - OTA.OTA_CATEGORY_USAGES_TL
TABLE - OTA.OTA_CERTIFICATIONS_B
TABLE - OTA.OTA_CERTIFICATIONS_TL
TABLE - OTA.OTA_CERTIFICATION_MEMBERS
TABLE - OTA.OTA_CERT_CAT_INCLUSIONS
TABLE - OTA.OTA_CERT_ENROLLMENTS
TABLE - OTA.OTA_CERT_MBR_ENROLLMENTS
TABLE - OTA.OTA_CERT_PRD_ENROLLMENTS
TABLE - OTA.OTA_CHATS_B
TABLE - OTA.OTA_CHATS_TL
TABLE - OTA.OTA_CHAT_MESSAGES
TABLE - OTA.OTA_CHAT_OBJ_INCLUSIONS
TABLE - OTA.OTA_CHAT_USERS
TABLE - OTA.OTA_CMI_ADAPTERS
TABLE - OTA.OTA_COMPETENCE_LANGUAGES
TABLE - OTA.OTA_CONFERENCES
TABLE - OTA.OTA_CONFERENCE_SERVERS_B
TABLE - OTA.OTA_CONFERENCE_SERVERS_TL
TABLE - OTA.OTA_CONTENT_SERVERS
TABLE - OTA.OTA_COURSE_PREREQUISITES
TABLE - OTA.OTA_CROSS_CHARGES
TABLE - OTA.OTA_DELEGATE_BOOKINGS
TABLE - OTA.OTA_EVALUATIONS
TABLE - OTA.OTA_EVENTS
TABLE - OTA.OTA_EVENTS_TL
TABLE - OTA.OTA_EVENT_ASSOCIATIONS
TABLE - OTA.OTA_FINANCE_HEADERS
TABLE - OTA.OTA_FINANCE_LINES
TABLE - OTA.OTA_FORUMS_B
TABLE - OTA.OTA_FORUMS_TL
TABLE - OTA.OTA_FORUM_MESSAGES
TABLE - OTA.OTA_FORUM_THREADS
TABLE - OTA.OTA_FRM_NOTIF_SUBSCRIBERS
TABLE - OTA.OTA_FRM_OBJ_INCLUSIONS
TABLE - OTA.OTA_HR_GL_FLEX_MAPS
TABLE - OTA.OTA_ILN_XML_PROCESSES
TABLE - OTA.OTA_IMPORT_HISTORIES
TABLE - OTA.OTA_LEARNING_OBJECTS
TABLE - OTA.OTA_LEARNING_PATHS
TABLE - OTA.OTA_LEARNING_PATHS_TL
TABLE - OTA.OTA_LEARNING_PATH_MEMBERS
TABLE - OTA.OTA_LO_FOLDERS
TABLE - OTA.OTA_LO_SCORM_OBJECTIVES
TABLE - OTA.OTA_LP_CAT_INCLUSIONS
TABLE - OTA.OTA_LP_ENROLLMENTS
TABLE - OTA.OTA_LP_MEMBER_ENROLLMENTS
TABLE - OTA.OTA_LP_SECTIONS
TABLE - OTA.OTA_LP_SECTIONS_TL
TABLE - OTA.OTA_MANDATORY_ENR_REQUESTS
TABLE - OTA.OTA_MANDATORY_ENR_REQ_MEMBERS
TABLE - OTA.OTA_NOTRNG_HISTORIES
TABLE - OTA.OTA_OFFERINGS
TABLE - OTA.OTA_OFFERINGS_TL
TABLE - OTA.OTA_OPEN_FC_ENROLLMENTS
TABLE - OTA.OTA_PERFORMANCES
TABLE - OTA.OTA_PREREQUISITES
TABLE - OTA.OTA_PRICE_LISTS
TABLE - OTA.OTA_PRICE_LIST_ENTRIES
TABLE - OTA.OTA_PROGRAM_MEMBERSHIPS
TABLE - OTA.OTA_PVT_FRM_THREAD_USERS
TABLE - OTA.OTA_QBANK_QUESTIONS
TABLE - OTA.OTA_QUESTIONS
TABLE - OTA.OTA_QUESTION_BANKS
TABLE - OTA.OTA_RESOURCE_ALLOCATIONS
TABLE - OTA.OTA_RESOURCE_BOOKINGS
TABLE - OTA.OTA_RESOURCE_DEFINITIONS
TABLE - OTA.OTA_RESOURCE_USAGES
TABLE - OTA.OTA_RESPONSE_TYPES
TABLE - OTA.OTA_RESPONSE_VALUES
TABLE - OTA.OTA_SCORM_OBJECTIVES
TABLE - OTA.OTA_SCORM_OBJ_ATTEMPTS
TABLE - OTA.OTA_SCORM_OBJ_PERFS
TABLE - OTA.OTA_SECTION_RULES
TABLE - OTA.OTA_SKILL_PROVISIONS
TABLE - OTA.OTA_SUPPLIABLE_RESOURCES
TABLE - OTA.OTA_SUPPLIABLE_RESOURCES_TL
TABLE - OTA.OTA_TESTS
TABLE - OTA.OTA_TEST_QUESTIONS
TABLE - OTA.OTA_TEST_SECTIONS
TABLE - OTA.OTA_TITLE_CONVERSIONS
TABLE - OTA.OTA_TP_MEASUREMENT_TYPES
TABLE - OTA.OTA_TRAINING_PLANS
TABLE - OTA.OTA_TRAINING_PLAN_COSTS
TABLE - OTA.OTA_TRAINING_PLAN_MEMBERS
TABLE - OTA.OTA_UPGRADE_LOG
TABLE - OTA.OTA_USER_GROUPS_B
TABLE - OTA.OTA_USER_GROUPS_TL
TABLE - OTA.OTA_USER_GROUP_ELEMENTS
TABLE - OTA.OTA_UTEST_QUESTIONS
TABLE - OTA.OTA_UTEST_RESPONSES
TABLE - OTA.OTA_VENDOR_SUPPLIES
VIEW - APPS.OTA_ACTIVITY_DEFINITIONS_V
VIEW - APPS.OTA_ACTIVITY_DEFINITIONS_VL
VIEW - APPS.OTA_ACTIVITY_VERSIONS_V
VIEW - APPS.OTA_ACTIVITY_VERSIONS_VL
VIEW - APPS.OTA_ACT_CAT_INCLUSIONS_V
VIEW - APPS.OTA_ANNOUNCEMENTS_VL
VIEW - APPS.OTA_BKNG_JUSTIFICATIONS_VL
VIEW - APPS.OTA_BOOKING_DEALS_V
VIEW - APPS.OTA_BOOKING_STATUS_HISTORIES_V
VIEW - APPS.OTA_BOOKING_STATUS_TYPES_VL
VIEW - APPS.OTA_CATEGORY_USAGES_V
VIEW - APPS.OTA_CATEGORY_USAGES_V1
VIEW - APPS.OTA_CATEGORY_USAGES_VL
VIEW - APPS.OTA_CERTIFICATIONS_VL
VIEW - APPS.OTA_CHATS_VL
VIEW - APPS.OTA_COMPETENCE_LANGUAGES_V
VIEW - APPS.OTA_CONFERENCE_SERVERS_VL
VIEW - APPS.OTA_CROSS_CHARGES_V
VIEW - APPS.OTA_CTRNG_HISTORIES_V
VIEW - APPS.OTA_CUSTOMER_ADDRESSES_V
VIEW - APPS.OTA_CUSTOMER_CONTACTS_V
VIEW - APPS.OTA_DELEGATE_BOOKINGS_V
VIEW - APPS.OTA_DISCOUNT_DEALS_V
VIEW - APPS.OTA_EVENTS_V
VIEW - APPS.OTA_EVENTS_VL
VIEW - APPS.OTA_EVENT_ASSOCIATIONS_V
VIEW - APPS.OTA_EVENT_ASSOCIATIONS_V2
VIEW - APPS.OTA_EVENT_ASSOCIAT_BILLING_V
VIEW - APPS.OTA_EVENT_SEARCH_V
VIEW - APPS.OTA_EVENT_SEARCH_V2
VIEW - APPS.OTA_FINANCE_HEADERS_V
VIEW - APPS.OTA_FINANCE_LINES_V
VIEW - APPS.OTA_FORUMS_VL
VIEW - APPS.OTA_LEARNING_PATHS_VL
VIEW - APPS.OTA_LETTER_REQUEST_LINES_V
VIEW - APPS.OTA_LP_SECTIONS_VL
VIEW - APPS.OTA_NOTRNG_HISTORIES_V
VIEW - APPS.OTA_OFFERINGS_VL
VIEW - APPS.OTA_PRE_PURCHASE_DEALS_V
VIEW - APPS.OTA_PRICE_LISTS_V
VIEW - APPS.OTA_PRICE_LIST_ENTRIES_V
VIEW - APPS.OTA_PROGRAM_MEMBERSHIPS_V
VIEW - APPS.OTA_RESOURCE_BOOKINGS_V
VIEW - APPS.OTA_RESOURCE_USAGES_V
VIEW - APPS.OTA_SKILLS_V
VIEW - APPS.OTA_SKILL_PROVISIONS_V
VIEW - APPS.OTA_STUDENTS_V
VIEW - APPS.OTA_STUDENT_TITLES_V
VIEW - APPS.OTA_SUPPLIABLE_RESOURCES_V
VIEW - APPS.OTA_SUPPLIABLE_RESOURCES_VL
VIEW - APPS.OTA_TEST_SECTIONS_V
VIEW - APPS.OTA_TP_MEASUREMENT_TYPES_V
VIEW - APPS.OTA_TRAINING_COST_LEVELS_V
VIEW - APPS.OTA_TRAINING_PLANS_V
VIEW - APPS.OTA_TRAINING_PLAN_BUDGETS_V
VIEW - APPS.OTA_TRAINING_PLAN_COSTS_V
VIEW - APPS.OTA_TRAINING_PLAN_MEMBERS_V
VIEW - APPS.OTA_UTEST_QUESTIONS_V
VIEW - APPS.OTA_VENDORS_V
VIEW - APPS.OTA_VENDOR_ADDRESSES_V
VIEW - APPS.OTA_VENDOR_CONTACTS_V
VIEW - APPS.OTFV_ACTIVITY_CATEGORIES
VIEW - APPS.OTFV_COMBINED_TRAINING_HISTORY
VIEW - APPS.OTFV_COST_TRANSFER
VIEW - APPS.OTFV_CUST_RESTRICTED_EVENTS
VIEW - APPS.OTFV_DELIVERED_COMPETENCES
VIEW - APPS.OTFV_ENROLLED_EVENTS
VIEW - APPS.OTFV_ENROLLMENT_AGREEMENTS
VIEW - APPS.OTFV_ENROLLMENT_STATUSES
VIEW - APPS.OTFV_ENROLLMENT_STATUS_HISTORY
VIEW - APPS.OTFV_EVENTS_WITHOUT_TRAINER
VIEW - APPS.OTFV_EVENTS_WITHOUT_VENUE
VIEW - APPS.OTFV_EVENTS_WITH_TRAINER
VIEW - APPS.OTFV_EVENTS_WITH_VENUE
VIEW - APPS.OTFV_EVENT_COMPETENCES
VIEW - APPS.OTFV_EXT_TRAINING_EVENT_ENROLS
VIEW - APPS.OTFV_FINANCE_HEADERS
VIEW - APPS.OTFV_FINANCE_LINES
VIEW - APPS.OTFV_HR_RESTRICTED_EVENTS
VIEW - APPS.OTFV_INT_TRAINING_EVENT_ENROLS
VIEW - APPS.OTFV_MISSING_REQ_RESOURCES
VIEW - APPS.OTFV_ONE_TIME_TRAINING_EVENTS
VIEW - APPS.OTFV_OVERBOOKED_RESOURCES
VIEW - APPS.OTFV_PRICE_LISTS
VIEW - APPS.OTFV_PRICE_LIST_ENTRIES
VIEW - APPS.OTFV_RESOURCES
VIEW - APPS.OTFV_RESOURCES_BOOKED
VIEW - APPS.OTFV_RESOURCE_CHECKLIST
VIEW - APPS.OTFV_SCHEDULED_TRAINING_EVENTS
VIEW - APPS.OTFV_SKILL_PROVISIONS
VIEW - APPS.OTFV_TOTAL_ENROLLMENTS
VIEW - APPS.OTFV_TRAINING_ACTIVITIES
VIEW - APPS.OTFV_TRAINING_AMOUNT
VIEW - APPS.OTFV_TRAINING_EVENTS
VIEW - APPS.OTFV_TRAINING_EVENT_CATEGORIES
VIEW - APPS.OTFV_TRAINING_EVENT_SESSIONS
VIEW - APPS.OTV_ACTIVITIES
VIEW - APPS.OTV_EVENT_ASSOCIATIONS
VIEW - APPS.OTV_ONE_TIME_EVENTS
VIEW - APPS.OTV_SCHEDULED_EVENTS
VIEW - APPS.OTV_SESSIONS
VIEW - APPS.OTV_TRAINING_COMPETENCE

Table: OTA_ACTIVITY_DEFINITIONS

Description: An activity is any educational offering designed to improve a students qualifications, competencies or experience.
Primary Key: OTA_ACTIVITY_DEFINITIONS_PK
  1. ACTIVITY_ID
Primary Key: OTA_ACTIVITY_DEFINITIONS_UK2
  1. NAME
  2. BUSINESS_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_ACTIVITY_VERSIONS.ACTIVITY_ID OTA_ACTIVITY_DEFINITIONS
OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID OTA_ACTIVITY_DEFINITIONS

[top of page]

OTA.OTA_ACTIVITY_DEFINITIONS does not reference any database object

OTA.OTA_ACTIVITY_DEFINITIONS is referenced by following:

APPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
TRIGGER - OTA_ACTIVITY_DEFINITIONS_WHO

[top of page]

Table: OTA_ACTIVITY_DEFINITIONS_TL

Description: This table is used for Activity language translations.
Primary Key: OTA_ACTIVITY_DEFINITIONS_TL_PK
  1. ACTIVITY_ID
  2. LANGUAGE

[top of page]

OTA.OTA_ACTIVITY_DEFINITIONS_TL does not reference any database object

OTA.OTA_ACTIVITY_DEFINITIONS_TL is referenced by following:

APPS
TRIGGER - OTA_ACTIVITY_DEFINIT041313_WHO
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL

[top of page]

Table: OTA_ACTIVITY_VERSIONS

Description: A course is the highest level of learning that can be prescribed to a learner.It also contains the objectives and competencies a learner will achieve by completing any class that belongs underneath. It is an object in the catalog, and resid
Primary Key: OTA_ACTIVITY_VERSIONS_PK
  1. ACTIVITY_VERSION_ID
Primary Key: OTA_ACTIVITY_VERSIONS_UK2
  1. ACTIVITY_ID
  2. VERSION_NAME
Primary Key: OTA_ACTIVITY_VERSIONS_UK5
  1. RCO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_ACTIVITY_VERSIONS.ACTIVITY_ID OTA_ACTIVITY_DEFINITIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_BOOKING_DEALS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_COURSE_PREREQUISITES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_COURSE_PREREQUISITES.PREREQUISITE_COURSE_ID OTA_ACTIVITY_VERSIONS
OTA_EVENTS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_NOTRNG_HISTORIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_OFFERINGS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_PRICE_LIST_ENTRIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_RESOURCE_USAGES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_SKILL_PROVISIONS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_VENDOR_SUPPLIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_ACTIVITY_VERSIONS does not reference any database object

OTA.OTA_ACTIVITY_VERSIONS is referenced by following:

APPS
SYNONYM - OTA_ACTIVITY_VERSIONS
TRIGGER - OTA_ACTIVITY_VERSIONS_WHO

[top of page]

Table: OTA_ACTIVITY_VERSIONS_TL

Description: This table is used for Activity Version language translations.
Primary Key: OTA_ACTIVITY_VERSIONS_TL_PK
  1. ACTIVITY_VERSION_ID
  2. LANGUAGE

[top of page]

OTA.OTA_ACTIVITY_VERSIONS_TL does not reference any database object

OTA.OTA_ACTIVITY_VERSIONS_TL is referenced by following:

APPS
TRIGGER - OTA_ACTIVITY_VERSION041318_WHO
SYNONYM - OTA_ACTIVITY_VERSIONS_TL

[top of page]

Table: OTA_ACT_CAT_INCLUSIONS

Description: A course category inclusion specifies that a course is within a particular type of category.
Primary Key: OTA_ACT_CAT_INCLUSIONS_UK2
  1. ACTIVITY_VERSION_ID
  2. EVENT_ID
  3. ACTIVITY_CATEGORY
Primary Key: OTA_ACT_CAT_INCLUSIONS_UK3
  1. ACTIVITY_VERSION_ID
  2. EVENT_ID
  3. CATEGORY_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_ACT_CAT_INCLUSIONS.EVENT_ID OTA_EVENTS

[top of page]

OTA.OTA_ACT_CAT_INCLUSIONS does not reference any database object

OTA.OTA_ACT_CAT_INCLUSIONS is referenced by following:

APPS
SYNONYM - OTA_ACT_CAT_INCLUSIONS
TRIGGER - OTA_ACT_CAT_INCLUSIONS_WHO

[top of page]

Table: OTA_ANNOUNCEMENTS

Description: Defined by administrators to communicate news or timely information to learners.
Primary Key: OTA_ANNOUNCEMENTS_PK
  1. ANNOUNCEMENT_ID

[top of page]

OTA.OTA_ANNOUNCEMENTS does not reference any database object

OTA.OTA_ANNOUNCEMENTS is referenced by following:

APPS
SYNONYM - OTA_ANNOUNCEMENTS
TRIGGER - OTA_ANNOUNCEMENTS_WHO

[top of page]

Table: OTA_ANNOUNCEMENTS_TL

Description: This table is used for Announcement translations.

[top of page]

OTA.OTA_ANNOUNCEMENTS_TL does not reference any database object

OTA.OTA_ANNOUNCEMENTS_TL is referenced by following:

APPS
SYNONYM - OTA_ANNOUNCEMENTS_TL
TRIGGER - OTA_ANNOUNCEMENTS_TL041320_WHO

[top of page]

Table: OTA_ATTEMPTS

Description: Every time a learner plays online learning, a row in this table is created for a specific leaner against a learning object.
Primary Key: OTA_ATTEMPTS_PK
  1. ATTEMPT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_ATTEMPTS.EVENT_ID OTA_EVENTS
OTA_ATTEMPTS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_SCORM_OBJ_ATTEMPTS.ATTEMPT_ID OTA_ATTEMPTS
OTA_UTEST_QUESTIONS.ATTEMPT_ID OTA_ATTEMPTS

[top of page]

OTA.OTA_ATTEMPTS does not reference any database object

OTA.OTA_ATTEMPTS is referenced by following:

APPS
SYNONYM - OTA_ATTEMPTS
TRIGGER - OTA_ATTEMPTS_WHO

[top of page]

Table: OTA_BKNG_JUSTIFICATIONS_B

Description: This is used by watilist optimization feature to default an enrollment priority level. Admin can define their own justification name with enrollment priority level attached to it. Learners can select a value when enrolling into class.
Primary Key: OTA_BKNG_JUSTIFICATIONS_B_PK
  1. BOOKING_JUSTIFICATION_ID

[top of page]

OTA.OTA_BKNG_JUSTIFICATIONS_B does not reference any database object

OTA.OTA_BKNG_JUSTIFICATIONS_B is referenced by following:

APPS
SYNONYM - OTA_BKNG_JUSTIFICATIONS_B
TRIGGER - OTA_BKNG_JUSTIFICATIONS_B_WHO

[top of page]

Table: OTA_BKNG_JUSTIFICATIONS_TL

Description: This table is used for storing the translation definition of enrollment justification.
Primary Key: OTA_BKNG_JUSTIFICATIONS_TL_PK
  1. BOOKING_JUSTIFICATION_ID
  2. LANGUAGE

[top of page]

OTA.OTA_BKNG_JUSTIFICATIONS_TL does not reference any database object

OTA.OTA_BKNG_JUSTIFICATIONS_TL is referenced by following:

APPS
TRIGGER - OTA_BKNG_JUSTIFICATI041310_WHO
SYNONYM - OTA_BKNG_JUSTIFICATIONS_TL

[top of page]

Table: OTA_BOOKING_DEALS

Description: An enrollment agreement (booking deal) is an arrangement about the price or method of paying for an event(s).
Primary Key: OTA_BOOKING_DEALS_PK
  1. BOOKING_DEAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_BOOKING_DEALS.PRICE_LIST_ID OTA_PRICE_LISTS
OTA_BOOKING_DEALS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_BOOKING_DEALS.EVENT_ID OTA_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FINANCE_LINES.BOOKING_DEAL_ID OTA_BOOKING_DEALS

[top of page]

OTA.OTA_BOOKING_DEALS does not reference any database object

OTA.OTA_BOOKING_DEALS is referenced by following:

APPS
SYNONYM - OTA_BOOKING_DEALS
TRIGGER - OTA_BOOKING_DEALS_WHO

[top of page]

Table: OTA_BOOKING_STATUS_EXCL

Description: Booking status exclusions prevent users with specific responsibilities from handling enrollments of certain statuses.
Primary Key: OTA_BOOKING_STATUS_EXCL_PK
  1. APPLICATION_ID
  2. RESPONSIBILITY_ID
  3. BOOKING_STATUS_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_BOOKING_STATUS_EXCL.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES

[top of page]

OTA.OTA_BOOKING_STATUS_EXCL does not reference any database object

OTA.OTA_BOOKING_STATUS_EXCL is referenced by following:

APPS
SYNONYM - OTA_BOOKING_STATUS_EXCL

[top of page]

Table: OTA_BOOKING_STATUS_HISTORIES

Description: A booking status history records status of changes to a student enrollment.
Primary Key: OTA_BOOKING_STATUS_HISTORY_PK
  1. BOOKING_ID
  2. BOOKING_STATUS_TYPE_ID
  3. START_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_BOOKING_STATUS_HISTORIES.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_BOOKING_STATUS_HISTORIES.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES

[top of page]

OTA.OTA_BOOKING_STATUS_HISTORIES does not reference any database object

OTA.OTA_BOOKING_STATUS_HISTORIES is referenced by following:

APPS
SYNONYM - OTA_BOOKING_STATUS_HISTORIES
TRIGGER - OTA_BOOKING_STATUS_HISTORI_WHO

[top of page]

Table: OTA_BOOKING_STATUS_TYPES

Description: Booking status types contain a list of user-defined enrollment statuses, along with their corresponding system statuses.
Primary Key: OTA_BOOKING_STATUS_TYPES_PK
  1. BOOKING_STATUS_TYPE_ID
Primary Key: OTA_BOOKING_STATUS_TYPES_UK2
  1. NAME
  2. BUSINESS_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_BOOKING_STATUS_EXCL.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES
OTA_BOOKING_STATUS_HISTORIES.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES
OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES is referenced by following:

APPS
SYNONYM - OTA_BOOKING_STATUS_TYPES
TRIGGER - OTA_BOOKING_STATUS_TYPES_WHO

[top of page]

Table: OTA_BOOKING_STATUS_TYPES_TL

Description: This table is used for Booking Status language translations.
Primary Key: OTA_BOOKING_STATUS_TYPES_TL
  1. BOOKING_STATUS_TYPE_ID
  2. LANGUAGE

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES_TL does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES_TL is referenced by following:

APPS
TRIGGER - OTA_BOOKING_STATUS_T041317_WHO
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL

[top of page]

Table: OTA_BULK_ENR_REQUESTS

Description: Bulk Enrollment request consist of any request which is made from the bulk enrollment functionality.
Primary Key: OTA_BULK_ENR_REQUESTS_PK
  1. BULK_ENR_REQUEST_ID

[top of page]

OTA.OTA_BULK_ENR_REQUESTS does not reference any database object

OTA.OTA_BULK_ENR_REQUESTS is referenced by following:

APPS
SYNONYM - OTA_BULK_ENR_REQUESTS
TRIGGER - OTA_BULK_ENR_REQUESTS_WHO

[top of page]

Table: OTA_BULK_ENR_REQ_MEMBERS

Description: Bulk Enrollment request member hold the data of the leaner whom is requested to be enrolled into Class, Learning Path or Learning Certification via Bulk Enrollment.
Primary Key: OTA_BULK_ENR_REQ_MEMBERS_UK
  1. BULK_ENR_REQUEST_ID
  2. PERSON_ID

[top of page]

OTA.OTA_BULK_ENR_REQ_MEMBERS does not reference any database object

OTA.OTA_BULK_ENR_REQ_MEMBERS is referenced by following:

APPS
SYNONYM - OTA_BULK_ENR_REQ_MEMBERS
TRIGGER - OTA_BULK_ENR_REQ_MEMBERS_WHO

[top of page]

Table: OTA_CATEGORY_USAGES

Description: Category usages indicate the role in which an activity category is used.
Primary Key: OTA_CATEGORY_USAGES_PK
  1. CATEGORY_USAGE_ID
Primary Key: OTA_CATEGORY_USAGES_UK2
  1. TYPE
  2. CATEGORY
  3. BUSINESS_GROUP_ID

[top of page]

OTA.OTA_CATEGORY_USAGES does not reference any database object

OTA.OTA_CATEGORY_USAGES is referenced by following:

APPS
SYNONYM - OTA_CATEGORY_USAGES
TRIGGER - OTA_CATEGORY_USAGES_WHO

[top of page]

Table: OTA_CATEGORY_USAGES_TL

Description: This table is used for Category translations.
Primary Key: OTA_CATEGORY_USAGES_TL_PK
  1. CATEGORY_USAGE_ID
  2. LANGUAGE

[top of page]

OTA.OTA_CATEGORY_USAGES_TL does not reference any database object

OTA.OTA_CATEGORY_USAGES_TL is referenced by following:

APPS
TRIGGER - OTA_CATEGORY_USAGES_041312_WHO
SYNONYM - OTA_CATEGORY_USAGES_TL

[top of page]

Table: OTA_CERTIFICATIONS_B

Description: Certification is an object that belong to a category. Certification can consist of one or more courses. Certification can be categorized as one time or renewable. Certifications usually need to be completed by learner in a specific time per
Primary Key: OTA_CERTIFICATIONS_B_PK
  1. CERTIFICATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CERTIFICATIONS_TL.CERTIFICATION_ID OTA_CERTIFICATIONS_B
OTA_CERTIFICATION_MEMBERS.CERTIFICATION_ID OTA_CERTIFICATIONS_B
OTA_CERT_ENROLLMENTS.CERTIFICATION_ID OTA_CERTIFICATIONS_B

[top of page]

OTA.OTA_CERTIFICATIONS_B does not reference any database object

OTA.OTA_CERTIFICATIONS_B is referenced by following:

APPS
SYNONYM - OTA_CERTIFICATIONS_B
TRIGGER - OTA_CERTIFICATIONS_B_WHO

[top of page]

Table: OTA_CERTIFICATIONS_TL

Description: This table is used for storing the translation definition of certification
Primary Key: OTA_CERTIFICATIONS_TL_PK
  1. CERTIFICATION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CERTIFICATIONS_TL.CERTIFICATION_ID OTA_CERTIFICATIONS_B

[top of page]

OTA.OTA_CERTIFICATIONS_TL does not reference any database object

OTA.OTA_CERTIFICATIONS_TL is referenced by following:

APPS
TRIGGER - OTA_CERTIFICATIONS_T041252_WHO
SYNONYM - OTA_CERTIFICATIONS_TL

[top of page]

Table: OTA_CERTIFICATION_MEMBERS

Description: Certification member is child of certification. It consist of objects that need to be completed by a learner in order for a certification to be completed. The only object currently supported is course.
Primary Key: OTA_CERTIFICATION_MEMBERS_PK
  1. CERTIFICATION_MEMBER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CERTIFICATION_MEMBERS.CERTIFICATION_ID OTA_CERTIFICATIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CERT_MBR_ENROLLMENTS.CERT_MEMBER_ID OTA_CERTIFICATION_MEMBERS

[top of page]

OTA.OTA_CERTIFICATION_MEMBERS does not reference any database object

OTA.OTA_CERTIFICATION_MEMBERS is referenced by following:

APPS
SYNONYM - OTA_CERTIFICATION_MEMBERS
TRIGGER - OTA_CERTIFICATION_MEMBERS_WHO

[top of page]

Table: OTA_CERT_CAT_INCLUSIONS

Description: A certication category inclusion specifies that a certification is within a particular type of category .
Primary Key: OTA_CERT_CAT_INCLUSIONS_UK1
  1. CERTIFICATION_ID
  2. CATEGORY_USAGE_ID

[top of page]

OTA.OTA_CERT_CAT_INCLUSIONS does not reference any database object

OTA.OTA_CERT_CAT_INCLUSIONS is referenced by following:

APPS
SYNONYM - OTA_CERT_CAT_INCLUSIONS
TRIGGER - OTA_CERT_CAT_INCLUSIONS_WHO

[top of page]

Table: OTA_CERT_ENROLLMENTS

Description: This record all learner subscriptions into a certification. There is one row for each learner who subcribe to a certification.
Primary Key: OTA_CERT_ENROLLMENTS_PK
  1. CERT_ENROLLMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CERT_ENROLLMENTS.CERTIFICATION_ID OTA_CERTIFICATIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CERT_PRD_ENROLLMENTS.CERT_ENROLLMENT_ID OTA_CERT_ENROLLMENTS

[top of page]

OTA.OTA_CERT_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_CERT_ENROLLMENTS
TRIGGER - OTA_CERT_ENROLLMENTS_WHO

[top of page]

Table: OTA_CERT_MBR_ENROLLMENTS

Description: This is a child of certification enrollment and certification period enrollment. When a learner enroll into a certification, there will be a row created for each member that belongs to the certifications. The purpose is to keep track of the
Primary Key: OTA_CERT_MBR_ENROLLMENTS_PK
  1. CERT_MBR_ENROLLMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CERT_MBR_ENROLLMENTS.CERT_PRD_ENROLLMENT_ID OTA_CERT_PRD_ENROLLMENTS
OTA_CERT_MBR_ENROLLMENTS.CERT_MEMBER_ID OTA_CERTIFICATION_MEMBERS

[top of page]

OTA.OTA_CERT_MBR_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_MBR_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_CERT_MBR_ENROLLMENTS
TRIGGER - OTA_CERT_MBR_ENROLLMENTS_WHO

[top of page]

Table: OTA_CERT_PRD_ENROLLMENTS

Description: This is a child of certification enrollment. When a learner enroll into certification for for the first time, one row is created that defines the first period. Each time the learner renew to the certification, another record will be created
Primary Key: OTA_CERT_PRD_ENROLLMENTS_PK
  1. CERT_PRD_ENROLLMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CERT_PRD_ENROLLMENTS.CERT_ENROLLMENT_ID OTA_CERT_ENROLLMENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CERT_MBR_ENROLLMENTS.CERT_PRD_ENROLLMENT_ID OTA_CERT_PRD_ENROLLMENTS

[top of page]

OTA.OTA_CERT_PRD_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_PRD_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_CERT_PRD_ENROLLMENTS
TRIGGER - OTA_CERT_PRD_ENROLLMENTS_WHO

[top of page]

Table: OTA_CHATS_B

Description: Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and real time.
Primary Key: OTA_CHATS_B_PK
  1. CHAT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CHATS_TL.CHAT_ID OTA_CHATS_B
OTA_CHAT_MESSAGES.CHAT_ID OTA_CHATS_B
OTA_OPEN_FC_ENROLLMENTS.CHAT_ID OTA_CHATS_B

[top of page]

OTA.OTA_CHATS_B does not reference any database object

OTA.OTA_CHATS_B is referenced by following:

APPS
SYNONYM - OTA_CHATS_B
TRIGGER - OTA_CHATS_B_WHO

[top of page]

Table: OTA_CHATS_TL

Description: This table is used for storing the translation definition of chat.
Primary Key: OTA_CHATS_TL_PK
  1. CHAT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CHATS_TL.CHAT_ID OTA_CHATS_B

[top of page]

OTA.OTA_CHATS_TL does not reference any database object

OTA.OTA_CHATS_TL is referenced by following:

APPS
SYNONYM - OTA_CHATS_TL
TRIGGER - OTA_CHATS_TL041305_WHO

[top of page]

Table: OTA_CHAT_MESSAGES

Description: This hold the messages which have been posted to the chat by external or internal learner.
Primary Key: OTA_CHAT_MESSAGES_PK
  1. CHAT_MESSAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CHAT_MESSAGES.CHAT_ID OTA_CHATS_B

[top of page]

OTA.OTA_CHAT_MESSAGES does not reference any database object

OTA.OTA_CHAT_MESSAGES is referenced by following:

APPS
SYNONYM - OTA_CHAT_MESSAGES
TRIGGER - OTA_CHAT_MESSAGES_WHO

[top of page]

Table: OTA_CHAT_OBJ_INCLUSIONS

Description: This specifies that a chat belongs to a category or class. Chat can belong to multiple categories, or can only belong to one class. Once the chat belongs to a class, it cannot be defined under a category and vice versa.
Primary Key: OTA_CHAT_OBJ_INCLUSIONS_UK1
  1. CHAT_ID
  2. OBJECT_TYPE
  3. OBJECT_ID

[top of page]

OTA.OTA_CHAT_OBJ_INCLUSIONS does not reference any database object

OTA.OTA_CHAT_OBJ_INCLUSIONS is referenced by following:

APPS
SYNONYM - OTA_CHAT_OBJ_INCLUSIONS
TRIGGER - OTA_CHAT_OBJ_INCLUSIONS_WHO

[top of page]

Table: OTA_CHAT_USERS

Description: This hold the information of who has joined to the chat
Primary Key: OTA_CHAT_USERS_UK1
  1. CHAT_ID
  2. PERSON_ID
  3. CONTACT_ID

[top of page]

OTA.OTA_CHAT_USERS does not reference any database object

OTA.OTA_CHAT_USERS is referenced by following:

APPS
SYNONYM - OTA_CHAT_USERS
TRIGGER - OTA_CHAT_USERS_WHO

[top of page]

Table: OTA_CMI_ADAPTERS

Description: A CMI adapter is only required for content that uses CMI communication with Oracle iLearning.

[top of page]

OTA.OTA_CMI_ADAPTERS does not reference any database object

OTA.OTA_CMI_ADAPTERS is referenced by following:

APPS
SYNONYM - OTA_CMI_ADAPTERS
TRIGGER - OTA_CMI_ADAPTERS_WHO

[top of page]

Table: OTA_COMPETENCE_LANGUAGES

Description: Mapping between Language and Competence
Primary Key: OTA_COMPETENCE_LANGUAGES_PK
  1. COMPETENCE_LANGUAGE_ID
Primary Key: OTA_COMPETENCE_LANGUAGES_UK
  1. BUSINESS_GROUP_ID
  2. COMPETENCE_ID
  3. LANGUAGE_ID

[top of page]

OTA.OTA_COMPETENCE_LANGUAGES does not reference any database object

OTA.OTA_COMPETENCE_LANGUAGES is referenced by following:

APPS
SYNONYM - OTA_COMPETENCE_LANGUAGES
TRIGGER - OTA_COMPETENCE_LANGUAGES_WHO

[top of page]

Table: OTA_CONFERENCES

Description: A web conference belong to only one class. A class can only have one web conference. this is only used for integration with Oracle Collaboration Suite.
Primary Key: OTA_CONFERENCES_PK
  1. CONFERENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CONFERENCES.EVENT_ID OTA_EVENTS
OTA_CONFERENCES.CONFERENCE_SERVER_ID OTA_CONFERENCE_SERVERS_B

[top of page]

OTA.OTA_CONFERENCES does not reference any database object

OTA.OTA_CONFERENCES is referenced by following:

APPS
SYNONYM - OTA_CONFERENCES
TRIGGER - OTA_CONFERENCES_WHO

[top of page]

Table: OTA_CONFERENCE_SERVERS_B

Description: This table hold the definition of each conference server. Currently this table will be only used for integration with Oracle Collaboration Suite.
Primary Key: OTA_CONFERENCE_SERVERS_B_PK
  1. CONFERENCE_SERVER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_CONFERENCES.CONFERENCE_SERVER_ID OTA_CONFERENCE_SERVERS_B
OTA_CONFERENCE_SERVERS_TL.CONFERENCE_SERVER_ID OTA_CONFERENCE_SERVERS_B

[top of page]

OTA.OTA_CONFERENCE_SERVERS_B does not reference any database object

OTA.OTA_CONFERENCE_SERVERS_B is referenced by following:

APPS
SYNONYM - OTA_CONFERENCE_SERVERS_B
TRIGGER - OTA_CONFERENCE_SERVERS_B_WHO

[top of page]

Table: OTA_CONFERENCE_SERVERS_TL

Description: This table is used for Conference server language translation
Primary Key: OTA_CONFERENCE_SERVERS_TL_PK
  1. LANGUAGE
  2. CONFERENCE_SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_CONFERENCE_SERVERS_TL.CONFERENCE_SERVER_ID OTA_CONFERENCE_SERVERS_B

[top of page]

OTA.OTA_CONFERENCE_SERVERS_TL does not reference any database object

OTA.OTA_CONFERENCE_SERVERS_TL is referenced by following:

APPS
TRIGGER - OTA_CONFERENCE_SERVE041251_WHO
SYNONYM - OTA_CONFERENCE_SERVERS_TL

[top of page]

Table: OTA_CONTENT_SERVERS

Description: Content servers define web server machines that contain physical content files, that should be accessible from within Oracle iLearning. Administrators can upload content to these servers.
Primary Key: OTA_CONTENT_SERVERS_PK
  1. CONTENT_SERVER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_LEARNING_OBJECTS.CONTENT_SERVER_ID OTA_CONTENT_SERVERS

[top of page]

OTA.OTA_CONTENT_SERVERS does not reference any database object

OTA.OTA_CONTENT_SERVERS is referenced by following:

APPS
SYNONYM - OTA_CONTENT_SERVERS
TRIGGER - OTA_CONTENT_SERVERS_WHO

[top of page]

Table: OTA_COURSE_PREREQUISITES

Description: This hold the information of which courses need to be completed before learners can enroll into a specific course. A course can have one or more courses as prerequisite. The prerequisite can be mandadory or advisory.
Primary Key: OTA_COURSE_PREREQUISITES_PK
  1. ACTIVITY_VERSION_ID
  2. PREREQUISITE_COURSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_COURSE_PREREQUISITES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_COURSE_PREREQUISITES.PREREQUISITE_COURSE_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_COURSE_PREREQUISITES does not reference any database object

OTA.OTA_COURSE_PREREQUISITES is referenced by following:

APPS
SYNONYM - OTA_COURSE_PREREQUISITES
TRIGGER - OTA_COURSE_PREREQUISITES_WHO

[top of page]

Table: OTA_CROSS_CHARGES

Description: Details to enable internal Cross Charging by mapping Chart of Account details from Oracle General Ledger to Oracle Human Resources.
Primary Key: OTA_CROSS_CHARGES_PK
  1. CROSS_CHARGE_ID
Primary Key: OTA_CROSS_CHARGES_UK
  1. BUSINESS_GROUP_ID
  2. TYPE
  3. FROM_TO
  4. START_DATE_ACTIVE
  5. END_DATE_ACTIVE
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_HR_GL_FLEX_MAPS.CROSS_CHARGE_ID OTA_CROSS_CHARGES

[top of page]

OTA.OTA_CROSS_CHARGES does not reference any database object

OTA.OTA_CROSS_CHARGES is referenced by following:

APPS
SYNONYM - OTA_CROSS_CHARGES
TRIGGER - OTA_CROSS_CHARGES_WHO

[top of page]

Table: OTA_DELEGATE_BOOKINGS

Description: An student booking (delegate booking) records an enrollment onto a scheduled, program or one time event.
Primary Key: OTA_DELEGATE_BOOKINGS_PK
  1. BOOKING_ID
Primary Key: OTA_DELEGATE_BOOKINGS_UK1
  1. LINE_ID
Primary Key: OTA_DELEGATE_BOOKINGS_UK2
  1. QUOTE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID OTA_BOOKING_STATUS_TYPES
OTA_DELEGATE_BOOKINGS.EVENT_ID OTA_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_BOOKING_STATUS_HISTORIES.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_FINANCE_LINES.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_RESOURCE_ALLOCATIONS.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_TRAINING_PLAN_COSTS.BOOKING_ID OTA_DELEGATE_BOOKINGS

[top of page]

OTA.OTA_DELEGATE_BOOKINGS does not reference any database object

OTA.OTA_DELEGATE_BOOKINGS is referenced by following:

APPS
SYNONYM - OTA_DELEGATE_BOOKINGS
TRIGGER - OTA_DELEGATE_BOOKINGS_WHO

[top of page]

Table: OTA_EVALUATIONS

Description:
Primary Key: OTA_EVALUATIONS_UK1
  1. OBJECT_TYPE
  2. OBJECT_ID

[top of page]

OTA.OTA_EVALUATIONS does not reference any database object

OTA.OTA_EVALUATIONS is referenced by following:

APPS
SYNONYM - OTA_EVALUATIONS
TRIGGER - OTA_EVALUATIONS_WHO

[top of page]

Table: OTA_EVENTS

Description: An event can be scheduled, one time, developmental, program or session.
Primary Key: OTA_EVENTS_PK
  1. EVENT_ID
Primary Key: OTA_EVENTS_UK2
  1. TITLE
  2. BUSINESS_GROUP_ID
  3. PARENT_EVENT_ID
Primary Key: OTA_EVENTS_UK3
  1. LINE_ID
Primary Key: OTA_EVENTS_UK4
  1. OFFERING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_EVENTS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_EVENTS.PARENT_EVENT_ID OTA_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_ACT_CAT_INCLUSIONS.EVENT_ID OTA_EVENTS
OTA_ATTEMPTS.EVENT_ID OTA_EVENTS
OTA_BOOKING_DEALS.EVENT_ID OTA_EVENTS
OTA_CONFERENCES.EVENT_ID OTA_EVENTS
OTA_DELEGATE_BOOKINGS.EVENT_ID OTA_EVENTS
OTA_EVENTS.PARENT_EVENT_ID OTA_EVENTS
OTA_EVENT_ASSOCIATIONS.EVENT_ID OTA_EVENTS
OTA_PROGRAM_MEMBERSHIPS.EVENT_ID OTA_EVENTS
OTA_PROGRAM_MEMBERSHIPS.PROGRAM_EVENT_ID OTA_EVENTS
OTA_RESOURCE_BOOKINGS.EVENT_ID OTA_EVENTS
OTA_TRAINING_PLAN_COSTS.EVENT_ID OTA_EVENTS

[top of page]

OTA.OTA_EVENTS does not reference any database object

OTA.OTA_EVENTS is referenced by following:

APPS
SYNONYM - OTA_EVENTS
TRIGGER - OTA_EVENTS_WHO

[top of page]

Table: OTA_EVENTS_TL

Description: This table is used for Event language translations.
Primary Key: OTA_EVENTS_TL_PK
  1. EVENT_ID
  2. LANGUAGE

[top of page]

OTA.OTA_EVENTS_TL does not reference any database object

OTA.OTA_EVENTS_TL is referenced by following:

APPS
SYNONYM - OTA_EVENTS_TL
TRIGGER - OTA_EVENTS_TL041240_WHO

[top of page]

Table: OTA_EVENT_ASSOCIATIONS

Description: You use event associations to restrict the list of customers and students who can enroll onto an event.
Primary Key: OTA_EVENT_ASSOCIATIONS_PK
  1. EVENT_ASSOCIATION_ID
Primary Key: OTA_EVENT_ASSOCIATIONS_UK2
  1. EVENT_ID
  2. CUSTOMER_ID
  3. ORGANIZATION_ID
  4. JOB_ID
  5. POSITION_ID
  6. LEARNING_PATH_ID
  7. CATEGORY_USAGE_ID
  8. ACTIVITY_VERSION_ID
  9. OFFERING_ID
  10. PERSON_ID
  11. PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_EVENT_ASSOCIATIONS.EVENT_ID OTA_EVENTS

[top of page]

OTA.OTA_EVENT_ASSOCIATIONS does not reference any database object

OTA.OTA_EVENT_ASSOCIATIONS is referenced by following:

APPS
SYNONYM - OTA_EVENT_ASSOCIATIONS
TRIGGER - OTA_EVENT_ASSOCIATIONS_WHO

[top of page]

Table: OTA_FINANCE_HEADERS

Description: A finance header holds generic financial information about dealings you have with particular customers or suppliers.
Primary Key: OTA_FINANCE_HEADERS_PK
  1. FINANCE_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FINANCE_HEADERS.SUPERCEDING_HEADER_ID OTA_FINANCE_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FINANCE_HEADERS.SUPERCEDING_HEADER_ID OTA_FINANCE_HEADERS
OTA_FINANCE_LINES.FINANCE_HEADER_ID OTA_FINANCE_HEADERS

[top of page]

OTA.OTA_FINANCE_HEADERS does not reference any database object

OTA.OTA_FINANCE_HEADERS is referenced by following:

APPS
SYNONYM - OTA_FINANCE_HEADERS
TRIGGER - OTA_FINANCE_HEADERS_WHO

[top of page]

Table: OTA_FINANCE_LINES

Description: A finance line records each financial transaction with a customer or supplier.
Primary Key: OTA_FINANCE_LINES_PK
  1. FINANCE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FINANCE_LINES.FINANCE_HEADER_ID OTA_FINANCE_HEADERS
OTA_FINANCE_LINES.BOOKING_DEAL_ID OTA_BOOKING_DEALS
OTA_FINANCE_LINES.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_FINANCE_LINES.RESOURCE_ALLOCATION_ID OTA_RESOURCE_ALLOCATIONS
OTA_FINANCE_LINES.RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS

[top of page]

OTA.OTA_FINANCE_LINES does not reference any database object

OTA.OTA_FINANCE_LINES is referenced by following:

APPS
SYNONYM - OTA_FINANCE_LINES
TRIGGER - OTA_FINANCE_LINES_WHO

[top of page]

Table: OTA_FORUMS_B

Description: Forum can belongs to a category or class. Forum can be used to communicate between one or more user online.
Primary Key: OTA_FORUMS_B_PK
  1. FORUM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FORUMS_TL.FORUM_ID OTA_FORUMS_B
OTA_FORUM_MESSAGES.FORUM_ID OTA_FORUMS_B
OTA_FORUM_THREADS.FORUM_ID OTA_FORUMS_B
OTA_FRM_NOTIF_SUBSCRIBERS.FORUM_ID OTA_FORUMS_B
OTA_FRM_OBJ_INCLUSIONS.FORUM_ID OTA_FORUMS_B
OTA_OPEN_FC_ENROLLMENTS.FORUM_ID OTA_FORUMS_B
OTA_PVT_FRM_THREAD_USERS.FORUM_ID OTA_FORUMS_B

[top of page]

OTA.OTA_FORUMS_B does not reference any database object

OTA.OTA_FORUMS_B is referenced by following:

APPS
SYNONYM - OTA_FORUMS_B
TRIGGER - OTA_FORUMS_B_WHO

[top of page]

Table: OTA_FORUMS_TL

Description: This table is used for Forum language translation
Primary Key: OTA_FORUMS_TL_PK
  1. FORUM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FORUMS_TL.FORUM_ID OTA_FORUMS_B

[top of page]

OTA.OTA_FORUMS_TL does not reference any database object

OTA.OTA_FORUMS_TL is referenced by following:

APPS
SYNONYM - OTA_FORUMS_TL
TRIGGER - OTA_FORUMS_TL041238_WHO

[top of page]

Table: OTA_FORUM_MESSAGES

Description: This a child of forum thread. This hold the messages which have been posted to the forum thread by external or internal learner.
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FORUM_MESSAGES.FORUM_ID OTA_FORUMS_B
OTA_FORUM_MESSAGES.FORUM_THREAD_ID OTA_FORUM_THREADS

[top of page]

OTA.OTA_FORUM_MESSAGES does not reference any database object

OTA.OTA_FORUM_MESSAGES is referenced by following:

APPS
SYNONYM - OTA_FORUM_MESSAGES
TRIGGER - OTA_FORUM_MESSAGES_WHO

[top of page]

Table: OTA_FORUM_THREADS

Description: This a child of forum. This hold the topic that make up the forum.
Primary Key: OTA_FORUM_THREADS_PK
  1. FORUM_THREAD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FORUM_THREADS.FORUM_ID OTA_FORUMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FORUM_MESSAGES.FORUM_THREAD_ID OTA_FORUM_THREADS
OTA_PVT_FRM_THREAD_USERS.FORUM_THREAD_ID OTA_FORUM_THREADS

[top of page]

OTA.OTA_FORUM_THREADS does not reference any database object

OTA.OTA_FORUM_THREADS is referenced by following:

APPS
SYNONYM - OTA_FORUM_THREADS
TRIGGER - OTA_FORUM_THREADS_WHO

[top of page]

Table: OTA_FRM_NOTIF_SUBSCRIBERS

Description: This stores the information of the learner who chose to recieve a notification when someone post a message or reply to a specific forum.
Primary Key: OTA_FRM_NOTIF_SUBSCRIBERS_UK1
  1. FORUM_ID
  2. PERSON_ID
  3. CONTACT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FRM_NOTIF_SUBSCRIBERS.FORUM_ID OTA_FORUMS_B

[top of page]

OTA.OTA_FRM_NOTIF_SUBSCRIBERS does not reference any database object

OTA.OTA_FRM_NOTIF_SUBSCRIBERS is referenced by following:

APPS
SYNONYM - OTA_FRM_NOTIF_SUBSCRIBERS
TRIGGER - OTA_FRM_NOTIF_SUBSCRIBERS_WHO

[top of page]

Table: OTA_FRM_OBJ_INCLUSIONS

Description: This specifies that a forum belongs to a category or class. Forum can belong to multiple categories, or can only belong to one class. Once the forum belongs to a class, it cannot be defined under a category and vice versa.
Primary Key: OTA_FRM_OBJ_INCLUSIONS_UK1
  1. FORUM_ID
  2. OBJECT_ID
  3. OBJECT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_FRM_OBJ_INCLUSIONS.FORUM_ID OTA_FORUMS_B

[top of page]

OTA.OTA_FRM_OBJ_INCLUSIONS does not reference any database object

OTA.OTA_FRM_OBJ_INCLUSIONS is referenced by following:

APPS
SYNONYM - OTA_FRM_OBJ_INCLUSIONS
TRIGGER - OTA_FRM_OBJ_INCLUSIONS_WHO

[top of page]

Table: OTA_HR_GL_FLEX_MAPS

Description: Details to enable internal Cross Charging by mapping Chart of Account details from Oracle General Ledger to Oracle Human Resources.
Primary Key: OTA_HR_GL_FLEX_MAPS_PK
  1. GL_DEFAULT_SEGMENT_ID
Primary Key: OTA_HR_GL_FLEX_MAPS_UK1
  1. CROSS_CHARGE_ID
  2. SEGMENT
  3. SEGMENT_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_HR_GL_FLEX_MAPS.CROSS_CHARGE_ID OTA_CROSS_CHARGES

[top of page]

OTA.OTA_HR_GL_FLEX_MAPS does not reference any database object

OTA.OTA_HR_GL_FLEX_MAPS is referenced by following:

APPS
SYNONYM - OTA_HR_GL_FLEX_MAPS
TRIGGER - OTA_HR_GL_FLEX_MAPS_WHO

[top of page]

Table: OTA_ILN_XML_PROCESSES

Description: iLearning integration data exchange process
Primary Key: OTA_ILN_XML_PROCESSES_UK1
  1. EXECUTABLE_NAME
  2. BUSINESS_GROUP_ID

[top of page]

OTA.OTA_ILN_XML_PROCESSES does not reference any database object

OTA.OTA_ILN_XML_PROCESSES is referenced by following:

APPS
SYNONYM - OTA_ILN_XML_PROCESSES
TRIGGER - OTA_ILN_XML_PROCESSES_WHO

[top of page]

Table: OTA_IMPORT_HISTORIES

Description: Logs of import and export tasks
Primary Key: OTA_IMPORT_HISTORIES_PK
  1. IMPORT_HISTORY_ID

[top of page]

OTA.OTA_IMPORT_HISTORIES does not reference any database object

OTA.OTA_IMPORT_HISTORIES is referenced by following:

APPS
SYNONYM - OTA_IMPORT_HISTORIES
TRIGGER - OTA_IMPORT_HISTORIES_WHO

[top of page]

Table: OTA_LEARNING_OBJECTS

Description: A learning object holds metadata relating to a piece of online content or test, and are created in the Content tree by administrators.
Primary Key: OTA_LEARNING_OBJECTS_PK
  1. LEARNING_OBJECT_ID
Primary Key: OTA_LEARNING_OBJECTS_UK1
  1. IDENTIFIER
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_LEARNING_OBJECTS.FOLDER_ID OTA_LO_FOLDERS
OTA_LEARNING_OBJECTS.PARENT_LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_LEARNING_OBJECTS.CONTENT_SERVER_ID OTA_CONTENT_SERVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_ATTEMPTS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_LEARNING_OBJECTS.PARENT_LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_LO_SCORM_OBJECTIVES.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_OFFERINGS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_TEST_SECTIONS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS

[top of page]

OTA.OTA_LEARNING_OBJECTS does not reference any database object

OTA.OTA_LEARNING_OBJECTS is referenced by following:

APPS
SYNONYM - OTA_LEARNING_OBJECTS
TRIGGER - OTA_LEARNING_OBJECTS_WHO

[top of page]

Table: OTA_LEARNING_PATHS

Description: A learning path defines a sequence of courses that should be completed in order to obtain specific knowledge.
Primary Key: OTA_LEARNING_PATHS_PK
  1. LEARNING_PATH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID OTA_LEARNING_PATHS

[top of page]

OTA.OTA_LEARNING_PATHS does not reference any database object

OTA.OTA_LEARNING_PATHS is referenced by following:

APPS
SYNONYM - OTA_LEARNING_PATHS
TRIGGER - OTA_LEARNING_PATHS_WHO

[top of page]

Table: OTA_LEARNING_PATHS_TL

Description: This table is used for Learning Path language translations.
Primary Key: OTA_LEARNING_PATHS_TL_PK
  1. LEARNING_PATH_ID
  2. LANGUAGE

[top of page]

OTA.OTA_LEARNING_PATHS_TL does not reference any database object

OTA.OTA_LEARNING_PATHS_TL is referenced by following:

APPS
TRIGGER - OTA_LEARNING_PATHS_T041258_WHO
SYNONYM - OTA_LEARNING_PATHS_TL

[top of page]

Table: OTA_LEARNING_PATH_MEMBERS

Description: Describe each course that belongs to a learning path
Primary Key: OTA_LEARNING_PATH_MEMBERS_PK
  1. LEARNING_PATH_MEMBER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID OTA_LEARNING_PATHS
OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_LEARNING_PATH_MEMBERS does not reference any database object

OTA.OTA_LEARNING_PATH_MEMBERS is referenced by following:

APPS
SYNONYM - OTA_LEARNING_PATH_MEMBERS
TRIGGER - OTA_LEARNING_PATH_MEMBERS_WHO

[top of page]

Table: OTA_LO_FOLDERS

Description: A folder contains learning objects and other folders, and are created in the Content tree by administrators.
Primary Key: OTA_LO_FOLDERS_PK
  1. FOLDER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_LO_FOLDERS.PARENT_FOLDER_ID OTA_LO_FOLDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_LEARNING_OBJECTS.FOLDER_ID OTA_LO_FOLDERS
OTA_LO_FOLDERS.PARENT_FOLDER_ID OTA_LO_FOLDERS
OTA_QUESTION_BANKS.FOLDER_ID OTA_LO_FOLDERS
OTA_SCORM_OBJECTIVES.FOLDER_ID OTA_LO_FOLDERS

[top of page]

OTA.OTA_LO_FOLDERS does not reference any database object

OTA.OTA_LO_FOLDERS is referenced by following:

APPS
SYNONYM - OTA_LO_FOLDERS
TRIGGER - OTA_LO_FOLDERS_WHO

[top of page]

Table: OTA_LO_SCORM_OBJECTIVES

Description: This table is an intersection table which hold relationship between OTA_SCORM_OBJECTIVES and OTA_LEARNING_OBJECTS.
Primary Key: OTA_LO_SCORM_OBJECTIVES_PK
  1. LEARNING_OBJECT_ID
  2. OBJECTIVE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_LO_SCORM_OBJECTIVES.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_LO_SCORM_OBJECTIVES.OBJECTIVE_ID OTA_SCORM_OBJECTIVES

[top of page]

OTA.OTA_LO_SCORM_OBJECTIVES does not reference any database object

OTA.OTA_LO_SCORM_OBJECTIVES is referenced by following:

APPS
SYNONYM - OTA_LO_SCORM_OBJECTIVES
TRIGGER - OTA_LO_SCORM_OBJECTIVES_WHO

[top of page]

Table: OTA_LP_CAT_INCLUSIONS

Description: A Learning Path category inclusion specifies that a learning path is within a particular type of category.
Primary Key: OTA_LP_CAT_INCLUSIONS_UK1
  1. LEARNING_PATH_ID
  2. CATEGORY_USAGE_ID

[top of page]

OTA.OTA_LP_CAT_INCLUSIONS does not reference any database object

OTA.OTA_LP_CAT_INCLUSIONS is referenced by following:

APPS
SYNONYM - OTA_LP_CAT_INCLUSIONS
TRIGGER - OTA_LP_CAT_INCLUSIONS_WHO

[top of page]

Table: OTA_LP_ENROLLMENTS

Description:
Primary Key: OTA_LP_ENROLLMENTS_PK
  1. LP_ENROLLMENT_ID

[top of page]

OTA.OTA_LP_ENROLLMENTS does not reference any database object

OTA.OTA_LP_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_LP_ENROLLMENTS
TRIGGER - OTA_LP_ENROLLMENTS_WHO

[top of page]

Table: OTA_LP_MEMBER_ENROLLMENTS

Description:
Primary Key: OTA_LP_MEMBER_ENROLLMENTS_PK
  1. LP_MEMBER_ENROLLMENT_ID

[top of page]

OTA.OTA_LP_MEMBER_ENROLLMENTS does not reference any database object

OTA.OTA_LP_MEMBER_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_LP_MEMBER_ENROLLMENTS
TRIGGER - OTA_LP_MEMBER_ENROLLMENTS_WHO

[top of page]

Table: OTA_LP_SECTIONS

Description: This table hold the info about the section of a Learning path. The section can be all mandatory, some mandatory or all optional.
Primary Key: OTA_LP_SECTIONS_PK
  1. LEARNING_PATH_SECTION_ID

[top of page]

OTA.OTA_LP_SECTIONS does not reference any database object

OTA.OTA_LP_SECTIONS is referenced by following:

APPS
SYNONYM - OTA_LP_SECTIONS
TRIGGER - OTA_LP_SECTIONS_WHO

[top of page]

Table: OTA_LP_SECTIONS_TL

Description: This table is used for Learning Path Section language translations.
Primary Key: OTA_LP_SECTIONS_TL_PK
  1. LEARNING_PATH_SECTION_ID
  2. LANGUAGE

[top of page]

OTA.OTA_LP_SECTIONS_TL does not reference any database object

OTA.OTA_LP_SECTIONS_TL is referenced by following:

APPS
SYNONYM - OTA_LP_SECTIONS_TL
TRIGGER - OTA_LP_SECTIONS_TL041257_WHO

[top of page]

Table: OTA_MANDATORY_ENR_REQUESTS

Description:

[top of page]

OTA.OTA_MANDATORY_ENR_REQUESTS does not reference any database object

OTA.OTA_MANDATORY_ENR_REQUESTS is referenced by following:

APPS
SYNONYM - OTA_MANDATORY_ENR_REQUESTS

[top of page]

Table: OTA_MANDATORY_ENR_REQ_MEMBERS

Description:

[top of page]

OTA.OTA_MANDATORY_ENR_REQ_MEMBERS does not reference any database object

OTA.OTA_MANDATORY_ENR_REQ_MEMBERS is referenced by following:

APPS
SYNONYM - OTA_MANDATORY_ENR_REQ_MEMBERS

[top of page]

Table: OTA_NOTRNG_HISTORIES

Description: Records attendance data for external training events initiated outside of OTA.
Primary Key: OTA_NOTRNG_HISTORIES_PK
  1. NOTA_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_NOTRNG_HISTORIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_NOTRNG_HISTORIES does not reference any database object

OTA.OTA_NOTRNG_HISTORIES is referenced by following:

APPS
SYNONYM - OTA_NOTRNG_HISTORIES
TRIGGER - OTA_NOTRNG_HISTORIES_WHO

[top of page]

Table: OTA_OFFERINGS

Description: An offering is a child of a course.
Primary Key: OTA_OFFERINGS_PK
  1. OFFERING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_OFFERINGS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_OFFERINGS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_OFFERINGS does not reference any database object

OTA.OTA_OFFERINGS is referenced by following:

APPS
SYNONYM - OTA_OFFERINGS
TRIGGER - OTA_OFFERINGS_WHO

[top of page]

Table: OTA_OFFERINGS_TL

Description: This table is used for Offering language translations.
Primary Key: OTA_OFFERINGS_TL_PK
  1. OFFERING_ID
  2. LANGUAGE

[top of page]

OTA.OTA_OFFERINGS_TL does not reference any database object

OTA.OTA_OFFERINGS_TL is referenced by following:

APPS
SYNONYM - OTA_OFFERINGS_TL
TRIGGER - OTA_OFFERINGS_TL041308_WHO

[top of page]

Table: OTA_OPEN_FC_ENROLLMENTS

Description: This stores the enrollment for all category based chat and forum.
Primary Key: OTA_OPEN_FC_ENROLLMENTS_PK
  1. ENROLLMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_OPEN_FC_ENROLLMENTS.FORUM_ID OTA_FORUMS_B
OTA_OPEN_FC_ENROLLMENTS.CHAT_ID OTA_CHATS_B

[top of page]

OTA.OTA_OPEN_FC_ENROLLMENTS does not reference any database object

OTA.OTA_OPEN_FC_ENROLLMENTS is referenced by following:

APPS
SYNONYM - OTA_OPEN_FC_ENROLLMENTS
TRIGGER - OTA_OPEN_FC_ENROLLMENTS_WHO

[top of page]

Table: OTA_PERFORMANCES

Description: This tables stores the latest status information for a learner against a learning object.There is only ever one row for a learner and learning object.
Primary Key: OTA_PERFORMANCES_PK
  1. PERFORMANCE_ID

[top of page]

OTA.OTA_PERFORMANCES does not reference any database object

OTA.OTA_PERFORMANCES is referenced by following:

APPS
SYNONYM - OTA_PERFORMANCES
TRIGGER - OTA_PERFORMANCES_WHO

[top of page]

Table: OTA_PREREQUISITES

Description: Prerequisites are only available for learning objects (online learning). They define in which sequence learning objects must be completed.
Primary Key: OTA_PREREQUISITES_UK1
  1. OBJECT_ID
  2. PARENT_OBJECT_ID
  3. PARENT_TYPE

[top of page]

OTA.OTA_PREREQUISITES does not reference any database object

OTA.OTA_PREREQUISITES is referenced by following:

APPS
SYNONYM - OTA_PREREQUISITES
TRIGGER - OTA_PREREQUISITES_WHO

[top of page]

Table: OTA_PRICE_LISTS

Description: A price list contains entries that identify pricing information for activities.
Primary Key: OTA_PRICE_LISTS_PK
  1. PRICE_LIST_ID
Primary Key: OTA_PRICE_LISTS_UK2
  1. NAME
  2. BUSINESS_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_BOOKING_DEALS.PRICE_LIST_ID OTA_PRICE_LISTS
OTA_PRICE_LIST_ENTRIES.PRICE_LIST_ID OTA_PRICE_LISTS

[top of page]

OTA.OTA_PRICE_LISTS does not reference any database object

OTA.OTA_PRICE_LISTS is referenced by following:

APPS
SYNONYM - OTA_PRICE_LISTS
TRIGGER - OTA_PRICE_LISTS_WHO

[top of page]

Table: OTA_PRICE_LIST_ENTRIES

Description: A price list entry records the price of an activity between two dates.
Primary Key: OTA_PRICE_LIST_ENTRIES_PK
  1. PRICE_LIST_ENTRY_ID
Primary Key: OTA_PRICE_LIST_ENTRIES_UK2
  1. ACTIVITY_VERSION_ID
  2. START_DATE
  3. PRICE_LIST_ID
  4. VENDOR_SUPPLY_ID
  5. PRICE_BASIS
  6. MINIMUM_ATTENDEES
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_PRICE_LIST_ENTRIES.VENDOR_SUPPLY_ID OTA_VENDOR_SUPPLIES
OTA_PRICE_LIST_ENTRIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
OTA_PRICE_LIST_ENTRIES.PRICE_LIST_ID OTA_PRICE_LISTS

[top of page]

OTA.OTA_PRICE_LIST_ENTRIES does not reference any database object

OTA.OTA_PRICE_LIST_ENTRIES is referenced by following:

APPS
SYNONYM - OTA_PRICE_LIST_ENTRIES
TRIGGER - OTA_PRICE_LIST_ENTRIES_WHO

[top of page]

Table: OTA_PROGRAM_MEMBERSHIPS

Description: Program membership holds a record of which scheduled events are within a program.
Primary Key: OTA_PROGRAM_MEMBERSHIPS_PK
  1. PROGRAM_MEMBERSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_PROGRAM_MEMBERSHIPS.EVENT_ID OTA_EVENTS
OTA_PROGRAM_MEMBERSHIPS.PROGRAM_EVENT_ID OTA_EVENTS

[top of page]

OTA.OTA_PROGRAM_MEMBERSHIPS does not reference any database object

OTA.OTA_PROGRAM_MEMBERSHIPS is referenced by following:

APPS
SYNONYM - OTA_PROGRAM_MEMBERSHIPS
TRIGGER - OTA_PROGRAM_MEMBERSHIPS_WHO

[top of page]

Table: OTA_PVT_FRM_THREAD_USERS

Description: This stores information of a private message which is posted by a person to another person
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_PVT_FRM_THREAD_USERS.FORUM_ID OTA_FORUMS_B
OTA_PVT_FRM_THREAD_USERS.FORUM_THREAD_ID OTA_FORUM_THREADS

[top of page]

OTA.OTA_PVT_FRM_THREAD_USERS does not reference any database object

OTA.OTA_PVT_FRM_THREAD_USERS is referenced by following:

APPS
SYNONYM - OTA_PVT_FRM_THREAD_USERS
TRIGGER - OTA_PVT_FRM_THREAD_USERS_WHO

[top of page]

Table: OTA_QBANK_QUESTIONS

Description: This table acts as a bridge table between OTA_QUESTION_BANKS and OTA_QUESTIONS because of the N:N relation that could be specified between the two entities.
Primary Key: OTA_QBANK_QUESTIONS_PK
  1. QUESTION_BANK_ID
  2. QUESTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_QBANK_QUESTIONS.QUESTION_ID OTA_QUESTIONS
OTA_QBANK_QUESTIONS.QUESTION_BANK_ID OTA_QUESTION_BANKS

[top of page]

OTA.OTA_QBANK_QUESTIONS does not reference any database object

OTA.OTA_QBANK_QUESTIONS is referenced by following:

APPS
SYNONYM - OTA_QBANK_QUESTIONS
TRIGGER - OTA_QBANK_QUESTIONS_WHO

[top of page]

Table: OTA_QUESTIONS

Description: This table contains the question definitions. Questions can be reused in different tests. At present there is support for Five Types of Questions. The data model is designed to support hybrid questions e.g Support Multiple Choice Single Cor
Primary Key: OTA_QUESTIONS_PK
  1. QUESTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_QBANK_QUESTIONS.QUESTION_ID OTA_QUESTIONS
OTA_RESPONSE_TYPES.QUESTION_ID OTA_QUESTIONS
OTA_TEST_QUESTIONS.QUESTION_ID OTA_QUESTIONS
OTA_UTEST_RESPONSES.QUESTION_ID OTA_QUESTIONS

[top of page]

OTA.OTA_QUESTIONS does not reference any database object

OTA.OTA_QUESTIONS is referenced by following:

APPS
SYNONYM - OTA_QUESTIONS
TRIGGER - OTA_QUESTIONS_WHO

[top of page]

Table: OTA_QUESTION_BANKS

Description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in
Primary Key: OTA_QUESTIONS_BANKS_UK1
  1. FOLDER_ID
  2. NAME
Primary Key: OTA_QUESTION_BANKS_PK
  1. QUESTION_BANK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_QUESTION_BANKS.FOLDER_ID OTA_LO_FOLDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_QBANK_QUESTIONS.QUESTION_BANK_ID OTA_QUESTION_BANKS
OTA_SECTION_RULES.QUESTION_BANK_ID OTA_QUESTION_BANKS
OTA_TEST_QUESTIONS.QUESTION_BANK_ID OTA_QUESTION_BANKS

[top of page]

OTA.OTA_QUESTION_BANKS does not reference any database object

OTA.OTA_QUESTION_BANKS is referenced by following:

APPS
SYNONYM - OTA_QUESTION_BANKS
TRIGGER - OTA_QUESTION_BANKS_WHO

[top of page]

Table: OTA_RESOURCE_ALLOCATIONS

Description: A resource allocation records a supplied resource to a student on an event.
Primary Key: OTA_RESOURCE_ALLOCATIONS_PK
  1. RESOURCE_ALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_RESOURCE_ALLOCATIONS.TRAINER_RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS
OTA_RESOURCE_ALLOCATIONS.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_RESOURCE_ALLOCATIONS.EQUIPMENT_RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FINANCE_LINES.RESOURCE_ALLOCATION_ID OTA_RESOURCE_ALLOCATIONS

[top of page]

OTA.OTA_RESOURCE_ALLOCATIONS does not reference any database object

OTA.OTA_RESOURCE_ALLOCATIONS is referenced by following:

APPS
SYNONYM - OTA_RESOURCE_ALLOCATIONS
TRIGGER - OTA_RESOURCE_ALLOCATIONS_WHO

[top of page]

Table: OTA_RESOURCE_BOOKINGS

Description: You book a resource (people, equipment or facilities) for a scheduled or development event, or for a session.
Primary Key: OTA_RESOURCE_BOOKINGS_PK
  1. RESOURCE_BOOKING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_RESOURCE_BOOKINGS.SUPPLIED_RESOURCE_ID OTA_SUPPLIABLE_RESOURCES
OTA_RESOURCE_BOOKINGS.EVENT_ID OTA_EVENTS
OTA_RESOURCE_BOOKINGS.FORUM_ID %
OTA_RESOURCE_BOOKINGS.CHAT_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_FINANCE_LINES.RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS
OTA_RESOURCE_ALLOCATIONS.TRAINER_RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS
OTA_RESOURCE_ALLOCATIONS.EQUIPMENT_RESOURCE_BOOKING_ID OTA_RESOURCE_BOOKINGS

[top of page]

OTA.OTA_RESOURCE_BOOKINGS does not reference any database object

OTA.OTA_RESOURCE_BOOKINGS is referenced by following:

APPS
SYNONYM - OTA_RESOURCE_BOOKINGS
TRIGGER - OTA_RESOURCE_BOOKINGS_WHO

[top of page]

Table: OTA_RESOURCE_DEFINITIONS

Description: Resource definitions hold the unique key flexfield combinations for supplied resources.
Primary Key: OTA_RESOURCE_DEFINITIONS_PK
  1. RESOURCE_DEFINITION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_SUPPLIABLE_RESOURCES.RESOURCE_DEFINITION_ID OTA_RESOURCE_DEFINITIONS

[top of page]

OTA.OTA_RESOURCE_DEFINITIONS does not reference any database object

OTA.OTA_RESOURCE_DEFINITIONS is referenced by following:

APPS
SYNONYM - OTA_RESOURCE_DEFINITIONS
TRIGGER - OTA_RESOURCE_DEFINITIONS_WHO

[top of page]

Table: OTA_RESOURCE_USAGES

Description: A resource usage holds holds the requirement of an activity version for a specific resource, or for a resource type.
Primary Key: OTA_RESOURCE_USAGES_PK
  1. RESOURCE_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_RESOURCE_USAGES.SUPPLIED_RESOURCE_ID OTA_SUPPLIABLE_RESOURCES
OTA_RESOURCE_USAGES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_RESOURCE_USAGES does not reference any database object

OTA.OTA_RESOURCE_USAGES is referenced by following:

APPS
SYNONYM - OTA_RESOURCE_USAGES
TRIGGER - OTA_RESOURCE_USAGES_WHO

[top of page]

Table: OTA_RESPONSE_TYPES

Description: This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TYPES. The data model however is designed so that we can support hybrid question types. That functiona
Primary Key: OTA_RESPONSE_TYPES_PK
  1. RESPONSE_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_RESPONSE_TYPES.QUESTION_ID OTA_QUESTIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_RESPONSE_VALUES.RESPONSE_TYPE_ID OTA_RESPONSE_TYPES
OTA_UTEST_RESPONSES.RESPONSE_TYPE_ID OTA_RESPONSE_TYPES

[top of page]

OTA.OTA_RESPONSE_TYPES does not reference any database object

OTA.OTA_RESPONSE_TYPES is referenced by following:

APPS
SYNONYM - OTA_RESPONSE_TYPES
TRIGGER - OTA_RESPONSE_TYPES_WHO

[top of page]

Table: OTA_RESPONSE_VALUES

Description: This stores the response values for a question. There is a 1:N relation between OTA_RESPONSE_TYPES and OTA_RESPONSE_VALUES.
Primary Key: OTA_RESPONSE_VALUES_PK
  1. RESPONSE_VALUE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_RESPONSE_VALUES.RESPONSE_TYPE_ID OTA_RESPONSE_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_UTEST_RESPONSES.RESPONSE_VALUE_ID OTA_RESPONSE_VALUES

[top of page]

OTA.OTA_RESPONSE_VALUES does not reference any database object

OTA.OTA_RESPONSE_VALUES is referenced by following:

APPS
SYNONYM - OTA_RESPONSE_VALUES
TRIGGER - OTA_RESPONSE_VALUES_WHO

[top of page]

Table: OTA_SCORM_OBJECTIVES

Description: Holds one record for each objective. Objectives are used in both AICCand SCORM.
Primary Key: OTA_SCORM_OBJECTIVES_PK
  1. OBJECTIVE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SCORM_OBJECTIVES.FOLDER_ID OTA_LO_FOLDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_LO_SCORM_OBJECTIVES.OBJECTIVE_ID OTA_SCORM_OBJECTIVES
OTA_SCORM_OBJ_ATTEMPTS.OBJECTIVE_ID OTA_SCORM_OBJECTIVES
OTA_SCORM_OBJ_PERFS.OBJECTIVE_ID OTA_SCORM_OBJECTIVES

[top of page]

OTA.OTA_SCORM_OBJECTIVES does not reference any database object

OTA.OTA_SCORM_OBJECTIVES is referenced by following:

APPS
SYNONYM - OTA_SCORM_OBJECTIVES
TRIGGER - OTA_SCORM_OBJECTIVES_WHO

[top of page]

Table: OTA_SCORM_OBJ_ATTEMPTS

Description: Holds the raw lesson status, score, and identifier changes (SCORM only) set by the content during a particular attempt. When the attempt is finished, this data is used to update the learner's overall performance on the objective, which is
Primary Key: OTA_SCORM_OBJ_ATTEMPTS_PK
  1. OBJECTIVE_ATTEMPT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SCORM_OBJ_ATTEMPTS.ATTEMPT_ID OTA_ATTEMPTS
OTA_SCORM_OBJ_ATTEMPTS.OBJECTIVE_ID OTA_SCORM_OBJECTIVES

[top of page]

OTA.OTA_SCORM_OBJ_ATTEMPTS does not reference any database object

OTA.OTA_SCORM_OBJ_ATTEMPTS is referenced by following:

APPS
SYNONYM - OTA_SCORM_OBJ_ATTEMPTS
TRIGGER - OTA_SCORM_OBJ_ATTEMPTS_WHO

[top of page]

Table: OTA_SCORM_OBJ_PERFS

Description: Stores a learner's current lesson status and score for a particular objective.
Primary Key: OTA_SCORM_OBJ_PERFS_PK
  1. OBJECTIVE_PERFORMANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SCORM_OBJ_PERFS.OBJECTIVE_ID OTA_SCORM_OBJECTIVES

[top of page]

OTA.OTA_SCORM_OBJ_PERFS does not reference any database object

OTA.OTA_SCORM_OBJ_PERFS is referenced by following:

APPS
SYNONYM - OTA_SCORM_OBJ_PERFS
TRIGGER - OTA_SCORM_OBJ_PERFS_WHO

[top of page]

Table: OTA_SECTION_RULES

Description: This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic)
Primary Key: OTA_SECTION_RULES_PK
  1. SECTION_RULE_ID
Primary Key: OTA_SECTION_RULES_UK1
  1. SECTION_ID
  2. QUESTION_BANK_ID
Primary Key: OTA_SECTION_RULES_UK2
  1. TEST_ID
  2. QUESTION_BANK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SECTION_RULES.QUESTION_BANK_ID OTA_QUESTION_BANKS
OTA_SECTION_RULES.SECTION_ID OTA_TEST_SECTIONS
OTA_SECTION_RULES.TEST_ID OTA_TESTS

[top of page]

OTA.OTA_SECTION_RULES does not reference any database object

OTA.OTA_SECTION_RULES is referenced by following:

APPS
SYNONYM - OTA_SECTION_RULES
TRIGGER - OTA_SECTION_RULES_WHO

[top of page]

Table: OTA_SKILL_PROVISIONS

Description: This table holds any data you specify as other information for an activity version.
Primary Key: OTA_SKILL_PROVISIONS_PK
  1. SKILL_PROVISION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SKILL_PROVISIONS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_SKILL_PROVISIONS does not reference any database object

OTA.OTA_SKILL_PROVISIONS is referenced by following:

APPS
SYNONYM - OTA_SKILL_PROVISIONS
TRIGGER - OTA_SKILL_PROVISIONS_WHO

[top of page]

Table: OTA_SUPPLIABLE_RESOURCES

Description: A resource is any facility, person or equipment that you need to book to run an event.
Primary Key: OTA_SUPPLIABLE_RESOURCES_PK
  1. SUPPLIED_RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_SUPPLIABLE_RESOURCES.RESOURCE_DEFINITION_ID OTA_RESOURCE_DEFINITIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_RESOURCE_BOOKINGS.SUPPLIED_RESOURCE_ID OTA_SUPPLIABLE_RESOURCES
OTA_RESOURCE_USAGES.SUPPLIED_RESOURCE_ID OTA_SUPPLIABLE_RESOURCES

[top of page]

OTA.OTA_SUPPLIABLE_RESOURCES does not reference any database object

OTA.OTA_SUPPLIABLE_RESOURCES is referenced by following:

APPS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
TRIGGER - OTA_SUPPLIABLE_RESOURCES_WHO

[top of page]

Table: OTA_SUPPLIABLE_RESOURCES_TL

Description: This table is used for Resource language translations.
Primary Key: OTA_SUPPLIABLE_RESOURCES_TL_PK
  1. SUPPLIED_RESOURCE_ID
  2. LANGUAGE

[top of page]

OTA.OTA_SUPPLIABLE_RESOURCES_TL does not reference any database object

OTA.OTA_SUPPLIABLE_RESOURCES_TL is referenced by following:

APPS
TRIGGER - OTA_SUPPLIABLE_RESOU041307_WHO
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL

[top of page]

Table: OTA_TESTS

Description: This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this table. There exists a 1:1 relation between the OTA_TESTS and OTA_LEARNING_OBJECTS table.
Primary Key: OTA_TESTS_PK
  1. TEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_SECTION_RULES.TEST_ID OTA_TESTS
OTA_TEST_QUESTIONS.TEST_ID OTA_TESTS
OTA_TEST_SECTIONS.TEST_ID OTA_TESTS

[top of page]

OTA.OTA_TESTS does not reference any database object

OTA.OTA_TESTS is referenced by following:

APPS
SYNONYM - OTA_TESTS
TRIGGER - OTA_TESTS_WHO

[top of page]

Table: OTA_TEST_QUESTIONS

Description: This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections.
Primary Key: OTA_TEST_QUESTIONS_PK
  1. TEST_QUESTION_ID
Primary Key: OTA_TEST_QUESTIONS_UK1
  1. TEST_ID
  2. QUESTION_BANK_ID
  3. QUESTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_TEST_QUESTIONS.QUESTION_ID OTA_QUESTIONS
OTA_TEST_QUESTIONS.QUESTION_BANK_ID OTA_QUESTION_BANKS
OTA_TEST_QUESTIONS.SECTION_ID OTA_TEST_SECTIONS
OTA_TEST_QUESTIONS.TEST_ID OTA_TESTS

[top of page]

OTA.OTA_TEST_QUESTIONS does not reference any database object

OTA.OTA_TEST_QUESTIONS is referenced by following:

APPS
SYNONYM - OTA_TEST_QUESTIONS
TRIGGER - OTA_TEST_QUESTIONS_WHO

[top of page]

Table: OTA_TEST_SECTIONS

Description: A test can have one or more test sections. For a test to be offered it must have atleast one test section associated with it which contains atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS
Primary Key: OTA_TEST_SECTIONS_PK
  1. TEST_SECTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_TEST_SECTIONS.LEARNING_OBJECT_ID OTA_LEARNING_OBJECTS
OTA_TEST_SECTIONS.TEST_ID OTA_TESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_SECTION_RULES.SECTION_ID OTA_TEST_SECTIONS
OTA_TEST_QUESTIONS.SECTION_ID OTA_TEST_SECTIONS

[top of page]

OTA.OTA_TEST_SECTIONS does not reference any database object

OTA.OTA_TEST_SECTIONS is referenced by following:

APPS
SYNONYM - OTA_TEST_SECTIONS
TRIGGER - OTA_TEST_SECTIONS_WHO

[top of page]

Table: OTA_TITLE_CONVERSIONS

Description: Currenty not used.
Primary Key: OTA_TITLE_CONVERSIONS_PK
  1. AR_TITLE
  2. HR_TITLE

[top of page]

OTA.OTA_TITLE_CONVERSIONS does not reference any database object

OTA.OTA_TITLE_CONVERSIONS is referenced by following:

APPS
SYNONYM - OTA_TITLE_CONVERSIONS

[top of page]

Table: OTA_TP_MEASUREMENT_TYPES

Description: A measurement type is a statistic type used to record information about a training plan.
Primary Key: OTA_TP_MEASUREMENT_TYPES_PK
  1. TP_MEASUREMENT_TYPE_ID
Primary Key: OTA_TP_MEASUREMENT_TYPES_UK2
  1. BUSINESS_GROUP_ID
  2. TP_MEASUREMENT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_TRAINING_PLAN_COSTS.TP_MEASUREMENT_TYPE_ID OTA_TP_MEASUREMENT_TYPES

[top of page]

OTA.OTA_TP_MEASUREMENT_TYPES does not reference any database object

OTA.OTA_TP_MEASUREMENT_TYPES is referenced by following:

APPS
SYNONYM - OTA_TP_MEASUREMENT_TYPES
TRIGGER - OTA_TP_MEASUREMENT_TYPES_WHO

[top of page]

Table: OTA_TRAINING_PLANS

Description: A Training Plan is a collection of Activities and Activity Definintions for a person or organization.
Primary Key: OTA_TRAINING_PLANS_PK
  1. TRAINING_PLAN_ID
Primary Key: OTA_TRAINING_PLANS_UK3
  1. ORGANIZATION_ID
  2. TIME_PERIOD_ID
  3. PERSON_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_TRAINING_PLANS.LEARNING_PATH_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_TRAINING_PLAN_COSTS.TRAINING_PLAN_ID OTA_TRAINING_PLANS
OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID OTA_TRAINING_PLANS

[top of page]

OTA.OTA_TRAINING_PLANS does not reference any database object

OTA.OTA_TRAINING_PLANS is referenced by following:

APPS
SYNONYM - OTA_TRAINING_PLANS
TRIGGER - OTA_TRAINING_PLANS_WHO

[top of page]

Table: OTA_TRAINING_PLAN_COSTS

Description: A plan cost is a recorded measure against the training plan.
Primary Key: OTA_TRAINING_PLAN_COSTS_PK
  1. TRAINING_PLAN_COST_ID
Primary Key: OTA_TRAINING_PLAN_COSTS_UK2
  1. BOOKING_ID
  2. TRAINING_PLAN_ID
  3. TP_MEASUREMENT_TYPE_ID
  4. EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_TRAINING_PLAN_COSTS.TP_MEASUREMENT_TYPE_ID OTA_TP_MEASUREMENT_TYPES
OTA_TRAINING_PLAN_COSTS.TRAINING_PLAN_ID OTA_TRAINING_PLANS
OTA_TRAINING_PLAN_COSTS.BOOKING_ID OTA_DELEGATE_BOOKINGS
OTA_TRAINING_PLAN_COSTS.EVENT_ID OTA_EVENTS

[top of page]

OTA.OTA_TRAINING_PLAN_COSTS does not reference any database object

OTA.OTA_TRAINING_PLAN_COSTS is referenced by following:

APPS
SYNONYM - OTA_TRAINING_PLAN_COSTS
TRIGGER - OTA_TRAINING_PLAN_COSTS_WHO

[top of page]

Table: OTA_TRAINING_PLAN_MEMBERS

Description: A Training Plan member is an Activity or Activity version.
Primary Key: OTA_TRAINING_PLAN_MEMBERS_PK
  1. TRAINING_PLAN_MEMBER_ID
Primary Key: OTA_TRAINING_PLAN_MEMBERS_UK2
  1. TRAINING_PLAN_ID
  2. ACTIVITY_VERSION_ID
  3. ACTIVITY_DEFINITION_ID
  4. TARGET_COMPLETION_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID OTA_TRAINING_PLANS
OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID OTA_ACTIVITY_DEFINITIONS
OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS

[top of page]

OTA.OTA_TRAINING_PLAN_MEMBERS does not reference any database object

OTA.OTA_TRAINING_PLAN_MEMBERS is referenced by following:

APPS
SYNONYM - OTA_TRAINING_PLAN_MEMBERS
TRIGGER - OTA_TRAINING_PLAN_MEMBERS_WHO

[top of page]

Table: OTA_UPGRADE_LOG

Description: This table hold the information about data which is failed during upgrade.

[top of page]

OTA.OTA_UPGRADE_LOG does not reference any database object

OTA.OTA_UPGRADE_LOG is referenced by following:

APPS
SYNONYM - OTA_UPGRADE_LOG
TRIGGER - OTA_UPGRADE_LOG_WHO

[top of page]

Table: OTA_USER_GROUPS_B

Description:
Primary Key: OTA_USER_GROUPS_B_UK1
  1. USER_GROUP_ID

[top of page]

OTA.OTA_USER_GROUPS_B does not reference any database object

OTA.OTA_USER_GROUPS_B is referenced by following:

APPS
SYNONYM - OTA_USER_GROUPS_B
TRIGGER - OTA_USER_GROUPS_B_WHO

[top of page]

Table: OTA_USER_GROUPS_TL

Description:
Primary Key: OTA_USER_GROUPS_TL_UK1
  1. LANGUAGE
  2. USER_GROUP_ID

[top of page]

OTA.OTA_USER_GROUPS_TL does not reference any database object

OTA.OTA_USER_GROUPS_TL is referenced by following:

APPS
SYNONYM - OTA_USER_GROUPS_TL
TRIGGER - OTA_USER_GROUPS_TL041254_WHO

[top of page]

Table: OTA_USER_GROUP_ELEMENTS

Description:
Primary Key: OTA_USER_GROUP_ELEMENTS_N1
  1. USER_GROUP_ID
Primary Key: OTA_USER_GROUP_ELEMENTS_N2
  1. PERSON_ID
  2. ORGANIZATION_ID
  3. JOB_ID
  4. POSITION_ID
  5. ORG_STRUCTURE_VERSION_ID
  6. CHILD_USER_GROUP_ID
Primary Key: OTA_USER_GROUP_ELEMENTS_UK1
  1. USER_GROUP_ELEMENT_ID

[top of page]

OTA.OTA_USER_GROUP_ELEMENTS does not reference any database object

OTA.OTA_USER_GROUP_ELEMENTS is referenced by following:

APPS
SYNONYM - OTA_USER_GROUP_ELEMENTS
TRIGGER - OTA_USER_GROUP_ELEMENTS_WHO

[top of page]

Table: OTA_UTEST_QUESTIONS

Description: Whenever a user takes a test a new test instance is generated for the user. The test definition (test questions that make up the test) are stored in this table. If the test is resumable and the user has resumed an old test, the attempt_id f
Primary Key: OTA_UTEST_QUESTIONS_PK
  1. USER_TEST_QUESTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_UTEST_QUESTIONS.ATTEMPT_ID OTA_ATTEMPTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_UTEST_RESPONSES.USER_TEST_QUESTION_ID OTA_UTEST_QUESTIONS

[top of page]

OTA.OTA_UTEST_QUESTIONS does not reference any database object

OTA.OTA_UTEST_QUESTIONS is referenced by following:

APPS
SYNONYM - OTA_UTEST_QUESTIONS
TRIGGER - OTA_UTEST_QUESTIONS_WHO

[top of page]

Table: OTA_UTEST_RESPONSES

Description: When the test is assembled for the user, each response to all questions are created in this table. The table is updated as per the response by the user.
Primary Key: OTA_UTEST_RESPONSES_PK
  1. USER_TEST_RESPONSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_UTEST_RESPONSES.QUESTION_ID OTA_QUESTIONS
OTA_UTEST_RESPONSES.RESPONSE_VALUE_ID OTA_RESPONSE_VALUES
OTA_UTEST_RESPONSES.RESPONSE_TYPE_ID OTA_RESPONSE_TYPES
OTA_UTEST_RESPONSES.USER_TEST_QUESTION_ID OTA_UTEST_QUESTIONS

[top of page]

OTA.OTA_UTEST_RESPONSES does not reference any database object

OTA.OTA_UTEST_RESPONSES is referenced by following:

APPS
SYNONYM - OTA_UTEST_RESPONSES
TRIGGER - OTA_UTEST_RESPONSES_WHO

[top of page]

Table: OTA_VENDOR_SUPPLIES

Description: Currently not used
Primary Key: OTA_VENDOR_SUPPLIES_PK
  1. VENDOR_SUPPLY_ID
Primary Key: OTA_VENDOR_SUPPLIES_UK2
  1. ACTIVITY_VERSION_ID
  2. VENDOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OTA_VENDOR_SUPPLIES.ACTIVITY_VERSION_ID OTA_ACTIVITY_VERSIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OTA_PRICE_LIST_ENTRIES.VENDOR_SUPPLY_ID OTA_VENDOR_SUPPLIES

[top of page]

OTA.OTA_VENDOR_SUPPLIES does not reference any database object

OTA.OTA_VENDOR_SUPPLIES is referenced by following:

APPS
SYNONYM - OTA_VENDOR_SUPPLIES
TRIGGER - OTA_VENDOR_SUPPLIES_WHO

[top of page]

View: OTA_ACTIVITY_DEFINITIONS_V

[top of page]

APPS.OTA_ACTIVITY_DEFINITIONS_V references the following:

APPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
APPS.OTA_ACTIVITY_DEFINITIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_ACTIVITY_DEFINITIONS_V

[top of page]

View: OTA_ACTIVITY_DEFINITIONS_VL

[top of page]

APPS.OTA_ACTIVITY_DEFINITIONS_VL references the following:

APPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
APPS.OTA_ACTIVITY_DEFINITIONS_VL is referenced by following:

APPS
PACKAGE BODY - OTA_CTU_BUS
PACKAGE BODY - OTA_TAD_API
PUBLIC
SYNONYM - OTA_ACTIVITY_DEFINITIONS_VL

[top of page]

View: OTA_ACTIVITY_VERSIONS_V

[top of page]

APPS.OTA_ACTIVITY_VERSIONS_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
PACKAGE - OTA_GENERAL
PACKAGE - OTA_TAV_BUS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTA_ACTIVITY_VERSIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_ACTIVITY_VERSIONS_V

[top of page]

View: OTA_ACTIVITY_VERSIONS_VL

[top of page]

APPS.OTA_ACTIVITY_VERSIONS_VL references the following:

APPS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
APPS.OTA_ACTIVITY_VERSIONS_VL is referenced by following:

APPS
PACKAGE BODY - OTA_CLASSIC_UPGRADE
PACKAGE BODY - OTA_CPE_UTIL
PACKAGE BODY - OTA_ILEARNING
PACKAGE BODY - OTA_LEARNER_ACCESS_UTIL
PACKAGE BODY - OTA_TAV_API_BUSINESS_RULES
PACKAGE - OTA_TRAINING_RECORD
PACKAGE BODY - OTA_TRAINING_RECORD
PUBLIC
SYNONYM - OTA_ACTIVITY_VERSIONS_VL

[top of page]

View: OTA_ACT_CAT_INCLUSIONS_V

[top of page]

APPS.OTA_ACT_CAT_INCLUSIONS_V references the following:

APPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_ACT_CAT_INCLUSIONS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
APPS.OTA_ACT_CAT_INCLUSIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_ACT_CAT_INCLUSIONS_V

[top of page]

View: OTA_ANNOUNCEMENTS_VL

[top of page]

APPS.OTA_ANNOUNCEMENTS_VL references the following:

APPS
SYNONYM - OTA_ANNOUNCEMENTS
SYNONYM - OTA_ANNOUNCEMENTS_TL
APPS.OTA_ANNOUNCEMENTS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_ANNOUNCEMENTS_VL

[top of page]

View: OTA_BKNG_JUSTIFICATIONS_VL

[top of page]

APPS.OTA_BKNG_JUSTIFICATIONS_VL references the following:

APPS
SYNONYM - OTA_BKNG_JUSTIFICATIONS_B
SYNONYM - OTA_BKNG_JUSTIFICATIONS_TL
APPS.OTA_BKNG_JUSTIFICATIONS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_BKNG_JUSTIFICATIONS_VL

[top of page]

View: OTA_BOOKING_DEALS_V

[top of page]

APPS.OTA_BOOKING_DEALS_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_PRICE_LISTS
PACKAGE - OTA_TBD_API
APPS.OTA_BOOKING_DEALS_V is referenced by following:

APPS
VIEW - OTA_FINANCE_LINES_V
VIEW - OTFV_FINANCE_LINES
PUBLIC
SYNONYM - OTA_BOOKING_DEALS_V

[top of page]

View: OTA_BOOKING_STATUS_HISTORIES_V

[top of page]

APPS.OTA_BOOKING_STATUS_HISTORIES_V references the following:

APPS
SYNONYM - OTA_BOOKING_STATUS_HISTORIES
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
APPS.OTA_BOOKING_STATUS_HISTORIES_V is referenced by following:

PUBLIC
SYNONYM - OTA_BOOKING_STATUS_HISTORIES_V

[top of page]

View: OTA_BOOKING_STATUS_TYPES_VL

[top of page]

APPS.OTA_BOOKING_STATUS_TYPES_VL references the following:

APPS
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
APPS.OTA_BOOKING_STATUS_TYPES_VL is referenced by following:

APPS
PACKAGE BODY - OTA_BST_API
PACKAGE BODY - OTA_CME_UTIL
PACKAGE BODY - OTA_LO_UTILITY
PACKAGE BODY - OTA_LRNG_PATH_MEMBER_UTIL
PACKAGE BODY - OTA_TRAINING_RECORD
PACKAGE BODY - OTA_UTILITY
PUBLIC
SYNONYM - OTA_BOOKING_STATUS_TYPES_VL

[top of page]

View: OTA_CATEGORY_USAGES_V

[top of page]

APPS.OTA_CATEGORY_USAGES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - OTA_CATEGORY_USAGES
APPS.OTA_CATEGORY_USAGES_V is referenced by following:

PUBLIC
SYNONYM - OTA_CATEGORY_USAGES_V

[top of page]

View: OTA_CATEGORY_USAGES_V1

[top of page]

APPS.OTA_CATEGORY_USAGES_V1 references the following:

APPS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
APPS.OTA_CATEGORY_USAGES_V1 is referenced by following:

PUBLIC
SYNONYM - OTA_CATEGORY_USAGES_V1

[top of page]

View: OTA_CATEGORY_USAGES_VL

[top of page]

APPS.OTA_CATEGORY_USAGES_VL references the following:

APPS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
APPS.OTA_CATEGORY_USAGES_VL is referenced by following:

APPS
PACKAGE BODY - OTA_AME_ATTRIBUTES
PACKAGE BODY - OTA_CLASSIC_UPGRADE
PACKAGE BODY - OTA_CTU_BUS
PUBLIC
SYNONYM - OTA_CATEGORY_USAGES_VL

[top of page]

View: OTA_CERTIFICATIONS_VL

[top of page]

APPS.OTA_CERTIFICATIONS_VL references the following:

APPS
SYNONYM - OTA_CERTIFICATIONS_B
SYNONYM - OTA_CERTIFICATIONS_TL
APPS.OTA_CERTIFICATIONS_VL is referenced by following:

APPS
PACKAGE BODY - OTA_CERTIFICATION_SWI
PACKAGE BODY - OTA_CERT_APPROVAL_SS
PACKAGE BODY - OTA_CPE_UTIL
PUBLIC
SYNONYM - OTA_CERTIFICATIONS_VL

[top of page]

View: OTA_CHATS_VL

[top of page]

APPS.OTA_CHATS_VL references the following:

APPS
SYNONYM - OTA_CHATS_B
SYNONYM - OTA_CHATS_TL
APPS.OTA_CHATS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_CHATS_VL

[top of page]

View: OTA_COMPETENCE_LANGUAGES_V

[top of page]

APPS.OTA_COMPETENCE_LANGUAGES_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - OTA_COMPETENCE_LANGUAGES
PACKAGE - OTA_UTILITY
SYNONYM - PER_COMPETENCES
SYNONYM - PER_RATING_LEVELS
APPS.OTA_COMPETENCE_LANGUAGES_V is referenced by following:

PUBLIC
SYNONYM - OTA_COMPETENCE_LANGUAGES_V

[top of page]

View: OTA_CONFERENCE_SERVERS_VL

[top of page]

APPS.OTA_CONFERENCE_SERVERS_VL references the following:

APPS
SYNONYM - OTA_CONFERENCE_SERVERS_B
SYNONYM - OTA_CONFERENCE_SERVERS_TL
APPS.OTA_CONFERENCE_SERVERS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_CONFERENCE_SERVERS_VL

[top of page]

View: OTA_CROSS_CHARGES_V

[top of page]

APPS.OTA_CROSS_CHARGES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - OTA_CROSS_CHARGES
VIEW - PER_BUSINESS_GROUPS
APPS.OTA_CROSS_CHARGES_V is referenced by following:

PUBLIC
SYNONYM - OTA_CROSS_CHARGES_V

[top of page]

View: OTA_CTRNG_HISTORIES_V

[top of page]

APPS.OTA_CTRNG_HISTORIES_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
VIEW - OTA_NOTRNG_HISTORIES_V
VIEW - PO_VENDORS
APPS.OTA_CTRNG_HISTORIES_V is referenced by following:

PUBLIC
SYNONYM - OTA_CTRNG_HISTORIES_V

[top of page]

View: OTA_CUSTOMER_ADDRESSES_V

[top of page]

APPS.OTA_CUSTOMER_ADDRESSES_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
APPS.OTA_CUSTOMER_ADDRESSES_V is referenced by following:

APPS
PACKAGE BODY - OTA_TFH_API_BUSINESS_RULES
PUBLIC
SYNONYM - OTA_CUSTOMER_ADDRESSES_V

[top of page]

View: OTA_CUSTOMER_CONTACTS_V

[top of page]

APPS.OTA_CUSTOMER_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_PROFILE
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - HZ_ROLE_RESPONSIBILITY
PACKAGE - OTA_TDB_BUS
APPS.OTA_CUSTOMER_CONTACTS_V is referenced by following:

APPS
PACKAGE BODY - OTA_OM_UPD_API
PACKAGE BODY - OTA_TFH_API_BUSINESS_RULES
PACKAGE BODY - OTA_UTILITY
PUBLIC
SYNONYM - OTA_CUSTOMER_CONTACTS_V

[top of page]

View: OTA_DELEGATE_BOOKINGS_V

[top of page]

APPS.OTA_DELEGATE_BOOKINGS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - FND_USER
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_HEADERS
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
PACKAGE - OTA_TDB_BUS
SYNONYM - PER_ADDRESSES
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PER_BUSINESS_GROUPS
APPS.OTA_DELEGATE_BOOKINGS_V is referenced by following:

PUBLIC
SYNONYM - OTA_DELEGATE_BOOKINGS_V

[top of page]

View: OTA_DISCOUNT_DEALS_V

[top of page]

APPS.OTA_DISCOUNT_DEALS_V references the following:

APPS
SYNONYM - OTA_BOOKING_DEALS
APPS.OTA_DISCOUNT_DEALS_V is referenced by following:

PUBLIC
SYNONYM - OTA_DISCOUNT_DEALS_V

[top of page]

View: OTA_EVENTS_V

[top of page]

APPS.OTA_EVENTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_EVT_SHD
PACKAGE - OTA_GENERAL
VIEW - OTA_OFFERINGS_VL
PACKAGE - OTA_UTILITY
SYNONYM - PA_PROJECTS_ALL
VIEW - PO_VENDORS
APPS.OTA_EVENTS_V is referenced by following:

APPS
PACKAGE BODY - OTA_TRAINING_RECORD
PACKAGE - OTA_TRAINING_RECORD
PUBLIC
SYNONYM - OTA_EVENTS_V

[top of page]

View: OTA_EVENTS_VL

[top of page]

APPS.OTA_EVENTS_VL references the following:

APPS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
APPS.OTA_EVENTS_VL is referenced by following:

APPS
PACKAGE BODY - OTA_BULK_ENROLL_UTIL
PACKAGE BODY - OTA_CANCEL_API
PACKAGE BODY - OTA_CANCEL_TRAINING_SS
PACKAGE BODY - OTA_COMPETENCE_SS
PACKAGE BODY - OTA_DELEGATE_BOOKING_API
PACKAGE BODY - OTA_ENROLL_IN_TRAINING_SS
PACKAGE BODY - OTA_ENROLL_REVIEW_SS
PACKAGE BODY - OTA_EVT_BUS
PACKAGE BODY - OTA_EVT_SHD
PACKAGE BODY - OTA_GENERAL
PACKAGE BODY - OTA_ILEARNING
PACKAGE BODY - OTA_INITIALIZATION_WF
PACKAGE BODY - OTA_LEARNER_ACCESS_UTIL
PACKAGE BODY - OTA_LEARNER_ENROLL_REVIEW_SS
PACKAGE BODY - OTA_LEARNER_ENROLL_SS
PACKAGE BODY - OTA_OM_UTIL
PACKAGE BODY - OTA_OTARPBUD_XMLP_PKG
PACKAGE BODY - OTA_TRAINING_SS
PACKAGE BODY - OTA_TRB_API_PROCEDURES
PACKAGE BODY - OTA_TRNG_ENROLL_SS
PACKAGE BODY - OTA_UTILITY
PUBLIC
SYNONYM - OTA_EVENTS_VL

[top of page]

View: OTA_EVENT_ASSOCIATIONS_V

[top of page]

APPS.OTA_EVENT_ASSOCIATIONS_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_EVENT_ASSOCIATIONS
SYNONYM - OTA_FINANCE_HEADERS
SYNONYM - OTA_FINANCE_LINES
SYNONYM - OTA_PRICE_LISTS
PACKAGE - OTA_TDB_BUS
PACKAGE - OTA_TEA_BUS
APPS.OTA_EVENT_ASSOCIATIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_EVENT_ASSOCIATIONS_V

[top of page]

View: OTA_EVENT_ASSOCIATIONS_V2

[top of page]

APPS.OTA_EVENT_ASSOCIATIONS_V2 references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENT_ASSOCIATIONS
SYNONYM - PER_ALL_POSITIONS
SYNONYM - PER_JOBS
APPS.OTA_EVENT_ASSOCIATIONS_V2 is referenced by following:

PUBLIC
SYNONYM - OTA_EVENT_ASSOCIATIONS_V2

[top of page]

View: OTA_EVENT_ASSOCIAT_BILLING_V

[top of page]

APPS.OTA_EVENT_ASSOCIAT_BILLING_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_BOOKING_DEALS
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENT_ASSOCIATIONS
SYNONYM - OTA_FINANCE_HEADERS
SYNONYM - OTA_FINANCE_LINES
SYNONYM - OTA_PRICE_LISTS
APPS.OTA_EVENT_ASSOCIAT_BILLING_V is referenced by following:

PUBLIC
SYNONYM - OTA_EVENT_ASSOCIAT_BILLING_V

[top of page]

View: OTA_EVENT_SEARCH_V

[top of page]

APPS.OTA_EVENT_SEARCH_V references the following:

APPS
VIEW - FND_CURRENCIES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_EVT_SHD
VIEW - OTA_OFFERINGS_VL
SYNONYM - OTA_PROGRAM_MEMBERSHIPS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
PACKAGE - OTA_UTILITY
VIEW - PO_VENDORS
APPS.OTA_EVENT_SEARCH_V is referenced by following:

PUBLIC
SYNONYM - OTA_EVENT_SEARCH_V

[top of page]

View: OTA_EVENT_SEARCH_V2

[top of page]

APPS.OTA_EVENT_SEARCH_V2 references the following:

APPS
VIEW - FND_CURRENCIES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_EVT_SHD
VIEW - OTA_OFFERINGS_VL
SYNONYM - OTA_PROGRAM_MEMBERSHIPS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
PACKAGE - OTA_UTILITY
VIEW - PO_VENDORS
APPS.OTA_EVENT_SEARCH_V2 is referenced by following:

PUBLIC
SYNONYM - OTA_EVENT_SEARCH_V2

[top of page]

View: OTA_FINANCE_HEADERS_V

[top of page]

APPS.OTA_FINANCE_HEADERS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OTA_FINANCE_HEADERS
PACKAGE - OTA_TFH_API_BUSINESS_RULES2
VIEW - PO_VENDORS
APPS.OTA_FINANCE_HEADERS_V is referenced by following:

PUBLIC
SYNONYM - OTA_FINANCE_HEADERS_V

[top of page]

View: OTA_FINANCE_LINES_V

[top of page]

APPS.OTA_FINANCE_LINES_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
VIEW - OTA_BOOKING_DEALS_V
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PRICE_LISTS
SYNONYM - OTA_RESOURCE_BOOKINGS
VIEW - OTA_SUPPLIABLE_RESOURCES_V
PACKAGE - OTA_TBD_API
PACKAGE - OTA_TDB_BUS
SYNONYM - PER_ALL_PEOPLE_F
APPS.OTA_FINANCE_LINES_V is referenced by following:

PUBLIC
SYNONYM - OTA_FINANCE_LINES_V

[top of page]

View: OTA_FORUMS_VL

[top of page]

APPS.OTA_FORUMS_VL references the following:

APPS
SYNONYM - OTA_FORUMS_B
SYNONYM - OTA_FORUMS_TL
APPS.OTA_FORUMS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_FORUMS_VL

[top of page]

View: OTA_LEARNING_PATHS_VL

[top of page]

APPS.OTA_LEARNING_PATHS_VL references the following:

APPS
SYNONYM - OTA_LEARNING_PATHS
SYNONYM - OTA_LEARNING_PATHS_TL
APPS.OTA_LEARNING_PATHS_VL is referenced by following:

APPS
PACKAGE BODY - OTA_LEARNING_PATH_SWI
PACKAGE BODY - OTA_TAV_API_BUSINESS_RULES
PUBLIC
SYNONYM - OTA_LEARNING_PATHS_VL

[top of page]

View: OTA_LETTER_REQUEST_LINES_V

[top of page]

APPS.OTA_LETTER_REQUEST_LINES_V references the following:

APPS
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_LETTER_REQUEST_LINES
APPS.OTA_LETTER_REQUEST_LINES_V is referenced by following:

PUBLIC
SYNONYM - OTA_LETTER_REQUEST_LINES_V

[top of page]

View: OTA_LP_SECTIONS_VL

[top of page]

APPS.OTA_LP_SECTIONS_VL references the following:

APPS
SYNONYM - OTA_LP_SECTIONS
SYNONYM - OTA_LP_SECTIONS_TL
APPS.OTA_LP_SECTIONS_VL is referenced by following:

PUBLIC
SYNONYM - OTA_LP_SECTIONS_VL

[top of page]

View: OTA_NOTRNG_HISTORIES_V

[top of page]

APPS.OTA_NOTRNG_HISTORIES_V references the following:

APPS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_NOTRNG_HISTORIES
APPS.OTA_NOTRNG_HISTORIES_V is referenced by following:

APPS
VIEW - OTA_CTRNG_HISTORIES_V
PUBLIC
SYNONYM - OTA_NOTRNG_HISTORIES_V

[top of page]

View: OTA_OFFERINGS_VL

[top of page]

APPS.OTA_OFFERINGS_VL references the following:

APPS
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_OFFERINGS_TL
APPS.OTA_OFFERINGS_VL is referenced by following:

APPS
VIEW - OTA_EVENTS_V
VIEW - OTA_EVENT_SEARCH_V
VIEW - OTA_EVENT_SEARCH_V2
PACKAGE BODY - OTA_LEARNER_ACCESS_UTIL
PACKAGE BODY - OTA_OFF_BUS
PACKAGE BODY - OTA_TRB_API_PROCEDURES
VIEW - OTFV_HR_RESTRICTED_EVENTS
VIEW - OTV_SCHEDULED_EVENTS
PUBLIC
SYNONYM - OTA_OFFERINGS_VL

[top of page]

View: OTA_PRE_PURCHASE_DEALS_V

[top of page]

APPS.OTA_PRE_PURCHASE_DEALS_V references the following:

APPS
SYNONYM - OTA_BOOKING_DEALS
APPS.OTA_PRE_PURCHASE_DEALS_V is referenced by following:

PUBLIC
SYNONYM - OTA_PRE_PURCHASE_DEALS_V

[top of page]

View: OTA_PRICE_LISTS_V

[top of page]

APPS.OTA_PRICE_LISTS_V references the following:

APPS
VIEW - FND_CURRENCIES_VL
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - OTA_PRICE_LISTS
APPS.OTA_PRICE_LISTS_V is referenced by following:

APPS
PACKAGE BODY - OTA_TEA_BUS
PUBLIC
SYNONYM - OTA_PRICE_LISTS_V

[top of page]

View: OTA_PRICE_LIST_ENTRIES_V

[top of page]

APPS.OTA_PRICE_LIST_ENTRIES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_PRICE_LISTS
SYNONYM - OTA_PRICE_LIST_ENTRIES
VIEW - PO_VENDORS
APPS.OTA_PRICE_LIST_ENTRIES_V is referenced by following:

PUBLIC
SYNONYM - OTA_PRICE_LIST_ENTRIES_V

[top of page]

View: OTA_PROGRAM_MEMBERSHIPS_V

[top of page]

APPS.OTA_PROGRAM_MEMBERSHIPS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_PROGRAM_MEMBERSHIPS
APPS.OTA_PROGRAM_MEMBERSHIPS_V is referenced by following:

PUBLIC
SYNONYM - OTA_PROGRAM_MEMBERSHIPS_V

[top of page]

View: OTA_RESOURCE_BOOKINGS_V

[top of page]

APPS.OTA_RESOURCE_BOOKINGS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_USER
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_LINES
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
VIEW - PO_VENDORS
APPS.OTA_RESOURCE_BOOKINGS_V is referenced by following:

PUBLIC
SYNONYM - OTA_RESOURCE_BOOKINGS_V

[top of page]

View: OTA_RESOURCE_USAGES_V

[top of page]

APPS.OTA_RESOURCE_USAGES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_RESOURCE_USAGES
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTA_RESOURCE_USAGES_V is referenced by following:

PUBLIC
SYNONYM - OTA_RESOURCE_USAGES_V

[top of page]

View: OTA_SKILLS_V

[top of page]

APPS.OTA_SKILLS_V references the following:

APPS
VIEW - FND_ID_FLEX_STRUCTURES_VL
SYNONYM - PER_SPECIAL_INFO_TYPES
SYNONYM - PER_SPECIAL_INFO_TYPE_USAGES
APPS.OTA_SKILLS_V is referenced by following:

PUBLIC
SYNONYM - OTA_SKILLS_V

[top of page]

View: OTA_SKILL_PROVISIONS_V

[top of page]

APPS.OTA_SKILL_PROVISIONS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_ID_FLEX_STRUCTURES_VL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_SKILL_PROVISIONS
SYNONYM - PER_ANALYSIS_CRITERIA
SYNONYM - PER_SPECIAL_INFO_TYPES
APPS.OTA_SKILL_PROVISIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_SKILL_PROVISIONS_V

[top of page]

View: OTA_STUDENTS_V

[top of page]

APPS.OTA_STUDENTS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PER_BUSINESS_GROUPS
APPS.OTA_STUDENTS_V is referenced by following:

PUBLIC
SYNONYM - OTA_STUDENTS_V

[top of page]

View: OTA_STUDENT_TITLES_V

[top of page]

APPS.OTA_STUDENT_TITLES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
APPS.OTA_STUDENT_TITLES_V is referenced by following:

PUBLIC
SYNONYM - OTA_STUDENT_TITLES_V

[top of page]

View: OTA_SUPPLIABLE_RESOURCES_V

[top of page]

APPS.OTA_SUPPLIABLE_RESOURCES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_DEFINITIONS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
VIEW - PO_VENDORS
APPS.OTA_SUPPLIABLE_RESOURCES_V is referenced by following:

APPS
VIEW - OTA_FINANCE_LINES_V
PUBLIC
SYNONYM - OTA_SUPPLIABLE_RESOURCES_V

[top of page]

View: OTA_SUPPLIABLE_RESOURCES_VL

[top of page]

APPS.OTA_SUPPLIABLE_RESOURCES_VL references the following:

APPS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTA_SUPPLIABLE_RESOURCES_VL is referenced by following:

APPS
PACKAGE BODY - OTA_TSR_BUS
PUBLIC
SYNONYM - OTA_SUPPLIABLE_RESOURCES_VL

[top of page]

View: OTA_TEST_SECTIONS_V

[top of page]

APPS.OTA_TEST_SECTIONS_V references the following:

APPS
SYNONYM - OTA_TESTS
SYNONYM - OTA_TEST_SECTIONS
SYNONYM - OTA_UTEST_QUESTIONS
APPS.OTA_TEST_SECTIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_TEST_SECTIONS_V

[top of page]

View: OTA_TP_MEASUREMENT_TYPES_V

[top of page]

APPS.OTA_TP_MEASUREMENT_TYPES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
VIEW - HR_SUMMARY_ITEM_TYPE
VIEW - HR_SUMMARY_ITEM_TYPE_USAGE
VIEW - HR_SUMMARY_TEMPLATE
SYNONYM - OTA_TP_MEASUREMENT_TYPES
APPS.OTA_TP_MEASUREMENT_TYPES_V is referenced by following:

PUBLIC
SYNONYM - OTA_TP_MEASUREMENT_TYPES_V

[top of page]

View: OTA_TRAINING_COST_LEVELS_V

[top of page]

APPS.OTA_TRAINING_COST_LEVELS_V references the following:

APPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_TP_MEASUREMENT_TYPES
VIEW - OTA_TRAINING_PLANS_V
SYNONYM - OTA_TRAINING_PLAN_COSTS
APPS.OTA_TRAINING_COST_LEVELS_V is referenced by following:

PUBLIC
SYNONYM - OTA_TRAINING_COST_LEVELS_V

[top of page]

View: OTA_TRAINING_PLANS_V

[top of page]

APPS.OTA_TRAINING_PLANS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - OTA_TRAINING_PLANS
SYNONYM - PAY_CALENDARS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_TIME_PERIODS
APPS.OTA_TRAINING_PLANS_V is referenced by following:

APPS
VIEW - OTA_TRAINING_COST_LEVELS_V
PUBLIC
SYNONYM - OTA_TRAINING_PLANS_V

[top of page]

View: OTA_TRAINING_PLAN_BUDGETS_V

[top of page]

APPS.OTA_TRAINING_PLAN_BUDGETS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_TP_MEASUREMENT_TYPES
SYNONYM - OTA_TRAINING_PLAN_MEMBERS
SYNONYM - PER_BUDGETS
SYNONYM - PER_BUDGET_ELEMENTS
SYNONYM - PER_BUDGET_VALUES
SYNONYM - PER_BUDGET_VERSIONS
APPS.OTA_TRAINING_PLAN_BUDGETS_V is referenced by following:

PUBLIC
SYNONYM - OTA_TRAINING_PLAN_BUDGETS_V

[top of page]

View: OTA_TRAINING_PLAN_COSTS_V

[top of page]

APPS.OTA_TRAINING_PLAN_COSTS_V references the following:

APPS
VIEW - FND_COMMON_LOOKUPS
PACKAGE - FND_GLOBAL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_TP_MEASUREMENT_TYPES
SYNONYM - OTA_TRAINING_PLAN_COSTS
SYNONYM - PER_ALL_PEOPLE_F
APPS.OTA_TRAINING_PLAN_COSTS_V is referenced by following:

PUBLIC
SYNONYM - OTA_TRAINING_PLAN_COSTS_V

[top of page]

View: OTA_TRAINING_PLAN_MEMBERS_V

[top of page]

APPS.OTA_TRAINING_PLAN_MEMBERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_TRAINING_PLAN_MEMBERS
APPS.OTA_TRAINING_PLAN_MEMBERS_V is referenced by following:

PUBLIC
SYNONYM - OTA_TRAINING_PLAN_MEMBERS_V

[top of page]

View: OTA_UTEST_QUESTIONS_V

[top of page]

APPS.OTA_UTEST_QUESTIONS_V references the following:

APPS
SYNONYM - OTA_QUESTIONS
SYNONYM - OTA_RESPONSE_TYPES
SYNONYM - OTA_RESPONSE_VALUES
SYNONYM - OTA_TESTS
SYNONYM - OTA_TEST_SECTIONS
SYNONYM - OTA_UTEST_QUESTIONS
SYNONYM - OTA_UTEST_RESPONSES
APPS.OTA_UTEST_QUESTIONS_V is referenced by following:

PUBLIC
SYNONYM - OTA_UTEST_QUESTIONS_V

[top of page]

View: OTA_VENDORS_V

[top of page]

APPS.OTA_VENDORS_V references the following:

APPS
VIEW - PO_VENDORS
APPS.OTA_VENDORS_V is referenced by following:

PUBLIC
SYNONYM - OTA_VENDORS_V

[top of page]

View: OTA_VENDOR_ADDRESSES_V

[top of page]

APPS.OTA_VENDOR_ADDRESSES_V references the following:

APPS
VIEW - PO_VENDOR_SITES_ALL
APPS.OTA_VENDOR_ADDRESSES_V is referenced by following:

APPS
PACKAGE BODY - OTA_TFH_API_BUSINESS_RULES
PUBLIC
SYNONYM - OTA_VENDOR_ADDRESSES_V

[top of page]

View: OTA_VENDOR_CONTACTS_V

[top of page]

APPS.OTA_VENDOR_CONTACTS_V references the following:

APPS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL
APPS.OTA_VENDOR_CONTACTS_V is referenced by following:

PUBLIC
SYNONYM - OTA_VENDOR_CONTACTS_V

[top of page]

View: OTFV_ACTIVITY_CATEGORIES

[top of page]

APPS.OTFV_ACTIVITY_CATEGORIES references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_ACT_CAT_INCLUSIONS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_OFFERINGS
APPS.OTFV_ACTIVITY_CATEGORIES is referenced by following:

PUBLIC
SYNONYM - OTFV_ACTIVITY_CATEGORIES

[top of page]

View: OTFV_COMBINED_TRAINING_HISTORY

[top of page]

APPS.OTFV_COMBINED_TRAINING_HISTORY references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_LEARNING_OBJECTS
SYNONYM - OTA_NOTRNG_HISTORIES
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PERFORMANCES
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_COMBINED_TRAINING_HISTORY is referenced by following:

PUBLIC
SYNONYM - OTFV_COMBINED_TRAINING_HISTORY

[top of page]

View: OTFV_COST_TRANSFER

[top of page]

APPS.OTFV_COST_TRANSFER references the following:

APPS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_HEADERS
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - PER_ALL_PEOPLE_F
APPS.OTFV_COST_TRANSFER is referenced by following:

PUBLIC
SYNONYM - OTFV_COST_TRANSFER

[top of page]

View: OTFV_CUST_RESTRICTED_EVENTS

[top of page]

APPS.OTFV_CUST_RESTRICTED_EVENTS references the following:

APPS
VIEW - FND_CURRENCIES_VL
PACKAGE - HRI_BPL_OE_ORDER
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_EVENT_ASSOCIATIONS
PACKAGE - OTA_EVT_SHD
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
PACKAGE - OTA_UTILITY
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_CUST_RESTRICTED_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_CUST_RESTRICTED_EVENTS

[top of page]

View: OTFV_DELIVERED_COMPETENCES

[top of page]

APPS.OTFV_DELIVERED_COMPETENCES references the following:

APPS
VIEW - FND_LANGUAGES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
PACKAGE - OTA_GENERAL
SYNONYM - PER_COMPETENCES
SYNONYM - PER_COMPETENCE_ELEMENTS
SYNONYM - PER_RATING_LEVELS
VIEW - PO_VENDORS
APPS.OTFV_DELIVERED_COMPETENCES is referenced by following:

PUBLIC
SYNONYM - OTFV_DELIVERED_COMPETENCES

[top of page]

View: OTFV_ENROLLED_EVENTS

[top of page]

APPS.OTFV_ENROLLED_EVENTS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_LEARNING_OBJECTS
PACKAGE - OTA_LO_UTILITY
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PERFORMANCES
PACKAGE - OTA_TDB_BUS
PACKAGE - OTA_UTILITY
SYNONYM - PER_ADDRESSES
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_JOBS
SYNONYM - PER_JOB_EXTRA_INFO
APPS.OTFV_ENROLLED_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_ENROLLED_EVENTS

[top of page]

View: OTFV_ENROLLMENT_AGREEMENTS

[top of page]

APPS.OTFV_ENROLLMENT_AGREEMENTS references the following:

APPS
SYNONYM - FND_USER
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_PRICE_LISTS
PACKAGE - OTA_TBD_API
APPS.OTFV_ENROLLMENT_AGREEMENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_ENROLLMENT_AGREEMENTS

[top of page]

View: OTFV_ENROLLMENT_STATUSES

[top of page]

APPS.OTFV_ENROLLMENT_STATUSES references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
PACKAGE - OTA_GENERAL
APPS.OTFV_ENROLLMENT_STATUSES is referenced by following:

PUBLIC
SYNONYM - OTFV_ENROLLMENT_STATUSES

[top of page]

View: OTFV_ENROLLMENT_STATUS_HISTORY

[top of page]

APPS.OTFV_ENROLLMENT_STATUS_HISTORY references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_HISTORIES
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_LEARNING_OBJECTS
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PERFORMANCES
SYNONYM - PER_ALL_PEOPLE_F
APPS.OTFV_ENROLLMENT_STATUS_HISTORY is referenced by following:

PUBLIC
SYNONYM - OTFV_ENROLLMENT_STATUS_HISTORY

[top of page]

View: OTFV_EVENTS_WITHOUT_TRAINER

[top of page]

APPS.OTFV_EVENTS_WITHOUT_TRAINER references the following:

APPS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
APPS.OTFV_EVENTS_WITHOUT_TRAINER is referenced by following:

PUBLIC
SYNONYM - OTFV_EVENTS_WITHOUT_TRAINER

[top of page]

View: OTFV_EVENTS_WITHOUT_VENUE

[top of page]

APPS.OTFV_EVENTS_WITHOUT_VENUE references the following:

APPS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
APPS.OTFV_EVENTS_WITHOUT_VENUE is referenced by following:

PUBLIC
SYNONYM - OTFV_EVENTS_WITHOUT_VENUE

[top of page]

View: OTFV_EVENTS_WITH_TRAINER

[top of page]

APPS.OTFV_EVENTS_WITH_TRAINER references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTFV_EVENTS_WITH_TRAINER is referenced by following:

PUBLIC
SYNONYM - OTFV_EVENTS_WITH_TRAINER

[top of page]

View: OTFV_EVENTS_WITH_VENUE

[top of page]

APPS.OTFV_EVENTS_WITH_VENUE references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTFV_EVENTS_WITH_VENUE is referenced by following:

PUBLIC
SYNONYM - OTFV_EVENTS_WITH_VENUE

[top of page]

View: OTFV_EVENT_COMPETENCES

[top of page]

APPS.OTFV_EVENT_COMPETENCES references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - PER_COMPETENCES
SYNONYM - PER_COMPETENCE_ELEMENTS
SYNONYM - PER_RATING_LEVELS
APPS.OTFV_EVENT_COMPETENCES is referenced by following:

PUBLIC
SYNONYM - OTFV_EVENT_COMPETENCES

[top of page]

View: OTFV_EXT_TRAINING_EVENT_ENROLS

[top of page]

APPS.OTFV_EXT_TRAINING_EVENT_ENROLS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_LEARNING_OBJECTS
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PERFORMANCES
APPS.OTFV_EXT_TRAINING_EVENT_ENROLS is referenced by following:

PUBLIC
SYNONYM - OTFV_EXT_TRAINING_EVENT_ENROLS

[top of page]

View: OTFV_FINANCE_HEADERS

[top of page]

APPS.OTFV_FINANCE_HEADERS references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GL_CODE_COMBINATIONS
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_FINANCE_HEADERS
PACKAGE - OTA_GENERAL
PACKAGE - OTA_TFH_API_BUSINESS_RULES2
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
APPS.OTFV_FINANCE_HEADERS is referenced by following:

PUBLIC
SYNONYM - OTFV_FINANCE_HEADERS

[top of page]

View: OTFV_FINANCE_LINES

[top of page]

APPS.OTFV_FINANCE_LINES references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_DEALS
VIEW - OTA_BOOKING_DEALS_V
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_HEADERS
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PRICE_LISTS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
PACKAGE - OTA_TBD_API
PACKAGE - OTA_TDB_BUS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_FINANCE_LINES is referenced by following:

PUBLIC
SYNONYM - OTFV_FINANCE_LINES

[top of page]

View: OTFV_HR_RESTRICTED_EVENTS

[top of page]

APPS.OTFV_HR_RESTRICTED_EVENTS references the following:

APPS
VIEW - FND_CURRENCIES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_EVENT_ASSOCIATIONS
PACKAGE - OTA_EVT_SHD
PACKAGE - OTA_GENERAL
VIEW - OTA_OFFERINGS_VL
PACKAGE - OTA_UTILITY
SYNONYM - PER_ALL_POSITIONS
SYNONYM - PER_JOBS
VIEW - PO_VENDORS
APPS.OTFV_HR_RESTRICTED_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_HR_RESTRICTED_EVENTS

[top of page]

View: OTFV_INT_TRAINING_EVENT_ENROLS

[top of page]

APPS.OTFV_INT_TRAINING_EVENT_ENROLS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_BOOKING_STATUS_TYPES_TL
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_LEARNING_OBJECTS
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_PERFORMANCES
PACKAGE - OTA_TDB_BUS
PACKAGE - OTA_UTILITY
SYNONYM - PER_ADDRESSES
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_JOBS
SYNONYM - PER_JOB_EXTRA_INFO
APPS.OTFV_INT_TRAINING_EVENT_ENROLS is referenced by following:

PUBLIC
SYNONYM - OTFV_INT_TRAINING_EVENT_ENROLS

[top of page]

View: OTFV_MISSING_REQ_RESOURCES

[top of page]

APPS.OTFV_MISSING_REQ_RESOURCES references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_RESOURCE_USAGES
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTFV_MISSING_REQ_RESOURCES is referenced by following:

PUBLIC
SYNONYM - OTFV_MISSING_REQ_RESOURCES

[top of page]

View: OTFV_ONE_TIME_TRAINING_EVENTS

[top of page]

APPS.OTFV_ONE_TIME_TRAINING_EVENTS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
VIEW - PO_VENDORS
APPS.OTFV_ONE_TIME_TRAINING_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_ONE_TIME_TRAINING_EVENTS

[top of page]

View: OTFV_OVERBOOKED_RESOURCES

[top of page]

APPS.OTFV_OVERBOOKED_RESOURCES references the following:

APPS
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTFV_OVERBOOKED_RESOURCES is referenced by following:

PUBLIC
SYNONYM - OTFV_OVERBOOKED_RESOURCES

[top of page]

View: OTFV_PRICE_LISTS

[top of page]

APPS.OTFV_PRICE_LISTS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - OTA_GENERAL
SYNONYM - OTA_PRICE_LISTS
APPS.OTFV_PRICE_LISTS is referenced by following:

PUBLIC
SYNONYM - OTFV_PRICE_LISTS

[top of page]

View: OTFV_PRICE_LIST_ENTRIES

[top of page]

APPS.OTFV_PRICE_LIST_ENTRIES references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_PRICE_LISTS
SYNONYM - OTA_PRICE_LIST_ENTRIES
APPS.OTFV_PRICE_LIST_ENTRIES is referenced by following:

PUBLIC
SYNONYM - OTFV_PRICE_LIST_ENTRIES

[top of page]

View: OTFV_RESOURCES

[top of page]

APPS.OTFV_RESOURCES references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - OTA_GENERAL
SYNONYM - OTA_RESOURCE_DEFINITIONS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
VIEW - PO_VENDORS
APPS.OTFV_RESOURCES is referenced by following:

PUBLIC
SYNONYM - OTFV_RESOURCES

[top of page]

View: OTFV_RESOURCES_BOOKED

[top of page]

APPS.OTFV_RESOURCES_BOOKED references the following:

APPS
SYNONYM - FND_USER
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_RESOURCE_BOOKINGS
SYNONYM - OTA_RESOURCE_DEFINITIONS
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
VIEW - PO_VENDORS
APPS.OTFV_RESOURCES_BOOKED is referenced by following:

PUBLIC
SYNONYM - OTFV_RESOURCES_BOOKED

[top of page]

View: OTFV_RESOURCE_CHECKLIST

[top of page]

APPS.OTFV_RESOURCE_CHECKLIST references the following:

APPS
SYNONYM - FND_LANGUAGES
SYNONYM - FND_LANGUAGES_TL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS_B
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_ACT_CAT_INCLUSIONS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
SYNONYM - OTA_RESOURCE_USAGES
SYNONYM - OTA_SUPPLIABLE_RESOURCES
SYNONYM - OTA_SUPPLIABLE_RESOURCES_TL
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_RESOURCE_CHECKLIST is referenced by following:

PUBLIC
SYNONYM - OTFV_RESOURCE_CHECKLIST

[top of page]

View: OTFV_SCHEDULED_TRAINING_EVENTS

[top of page]

APPS.OTFV_SCHEDULED_TRAINING_EVENTS references the following:

APPS
VIEW - FND_CURRENCIES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
PACKAGE - OTA_UTILITY
PACKAGE - OTA_VIEWS_PKG
VIEW - PO_VENDORS
APPS.OTFV_SCHEDULED_TRAINING_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_SCHEDULED_TRAINING_EVENTS

[top of page]

View: OTFV_SKILL_PROVISIONS

[top of page]

APPS.OTFV_SKILL_PROVISIONS references the following:

APPS
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_SKILL_PROVISIONS
SYNONYM - PER_ANALYSIS_CRITERIA
APPS.OTFV_SKILL_PROVISIONS is referenced by following:

PUBLIC
SYNONYM - OTFV_SKILL_PROVISIONS

[top of page]

View: OTFV_TOTAL_ENROLLMENTS

[top of page]

APPS.OTFV_TOTAL_ENROLLMENTS references the following:

APPS
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
APPS.OTFV_TOTAL_ENROLLMENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_TOTAL_ENROLLMENTS

[top of page]

View: OTFV_TRAINING_ACTIVITIES

[top of page]

APPS.OTFV_TRAINING_ACTIVITIES references the following:

APPS
VIEW - FND_LANGUAGES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
PACKAGE - OTA_GENERAL
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_TRAINING_ACTIVITIES is referenced by following:

PUBLIC
SYNONYM - OTFV_TRAINING_ACTIVITIES

[top of page]

View: OTFV_TRAINING_AMOUNT

[top of page]

APPS.OTFV_TRAINING_AMOUNT references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_BOOKING_STATUS_TYPES
SYNONYM - OTA_DELEGATE_BOOKINGS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
SYNONYM - OTA_FINANCE_LINES
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
APPS.OTFV_TRAINING_AMOUNT is referenced by following:

PUBLIC
SYNONYM - OTFV_TRAINING_AMOUNT

[top of page]

View: OTFV_TRAINING_EVENTS

[top of page]

APPS.OTFV_TRAINING_EVENTS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_EVT_SHD
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
PACKAGE - OTA_UTILITY
SYNONYM - PA_PROJECTS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTFV_TRAINING_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTFV_TRAINING_EVENTS

[top of page]

View: OTFV_TRAINING_EVENT_CATEGORIES

[top of page]

APPS.OTFV_TRAINING_EVENT_CATEGORIES references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_BIS
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_ACT_CAT_INCLUSIONS
SYNONYM - OTA_CATEGORY_USAGES
SYNONYM - OTA_CATEGORY_USAGES_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
APPS.OTFV_TRAINING_EVENT_CATEGORIES is referenced by following:

PUBLIC
SYNONYM - OTFV_TRAINING_EVENT_CATEGORIES

[top of page]

View: OTFV_TRAINING_EVENT_SESSIONS

[top of page]

APPS.OTFV_TRAINING_EVENT_SESSIONS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_ACTIVITY_VERSIONS_TL
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENTS_TL
PACKAGE - OTA_GENERAL
SYNONYM - OTA_OFFERINGS
APPS.OTFV_TRAINING_EVENT_SESSIONS is referenced by following:

PUBLIC
SYNONYM - OTFV_TRAINING_EVENT_SESSIONS

[top of page]

View: OTV_ACTIVITIES

[top of page]

APPS.OTV_ACTIVITIES references the following:

APPS
VIEW - FND_LANGUAGES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - OTA_ACTIVITY_DEFINITIONS
SYNONYM - OTA_ACTIVITY_VERSIONS
PACKAGE - OTA_GENERAL
PACKAGE - OTA_UTILITY
PACKAGE - OTA_VIEWS_PKG
VIEW - OTV_SCHEDULED_EVENTS
VIEW - PER_PEOPLE_F
VIEW - PO_VENDORS
APPS.OTV_ACTIVITIES is referenced by following:

PUBLIC
SYNONYM - OTV_ACTIVITIES

[top of page]

View: OTV_EVENT_ASSOCIATIONS

[top of page]

APPS.OTV_EVENT_ASSOCIATIONS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_EVENTS
SYNONYM - OTA_EVENT_ASSOCIATIONS
PACKAGE - OTA_GENERAL
SYNONYM - PER_JOBS
VIEW - PER_POSITIONS
APPS.OTV_EVENT_ASSOCIATIONS is referenced by following:

PUBLIC
SYNONYM - OTV_EVENT_ASSOCIATIONS

[top of page]

View: OTV_ONE_TIME_EVENTS

[top of page]

APPS.OTV_ONE_TIME_EVENTS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - OTA_EVENTS
VIEW - PO_VENDORS
APPS.OTV_ONE_TIME_EVENTS is referenced by following:

PUBLIC
SYNONYM - OTV_ONE_TIME_EVENTS

[top of page]

View: OTV_SCHEDULED_EVENTS

[top of page]

APPS.OTV_SCHEDULED_EVENTS references the following:

APPS
VIEW - FND_CURRENCIES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - OTA_ACTIVITY_VERSIONS
SYNONYM - OTA_EVENTS
PACKAGE - OTA_GENERAL
VIEW - OTA_OFFERINGS_VL
PACKAGE - OTA_UTILITY
PACKAGE - OTA_VIEWS_PKG
VIEW - PO_VENDORS
APPS.OTV_SCHEDULED_EVENTS is referenced by following:

APPS
PACKAGE BODY - OTA_EL_ENROLL_SS
PACKAGE BODY - OTA_ENROLL_IN_TRAINING_SS
PACKAGE - OTA_LEARNER_ACCESS_UTIL
PACKAGE BODY - OTA_LEARNER_ACCESS_UTIL
PACKAGE BODY - OTA_LEARNER_ENROLL_SS
PACKAGE BODY - OTA_TRNG_ENROLL_SS
VIEW - OTV_ACTIVITIES
PUBLIC
SYNONYM - OTV_SCHEDULED_EVENTS

[top of page]

View: OTV_SESSIONS

[top of page]

APPS.OTV_SESSIONS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - OTA_EVENTS
PACKAGE - OTA_GENERAL
APPS.OTV_SESSIONS is referenced by following:

PUBLIC
SYNONYM - OTV_SESSIONS

[top of page]

View: OTV_TRAINING_COMPETENCE

[top of page]

APPS.OTV_TRAINING_COMPETENCE references the following:

APPS
VIEW - FND_LANGUAGES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - OTA_ACTIVITY_VERSIONS
PACKAGE - OTA_GENERAL
SYNONYM - PER_COMPETENCES
SYNONYM - PER_COMPETENCE_ELEMENTS
VIEW - PER_PEOPLE_F
SYNONYM - PER_RATING_LEVELS
VIEW - PO_VENDORS
APPS.OTV_TRAINING_COMPETENCE is referenced by following:

PUBLIC
SYNONYM - OTV_TRAINING_COMPETENCE

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract