[Home] [Help] [Dependency Information]

VIEW: APPS.OTA_DELEGATE_BOOKINGS_V

Object Details

Object Name:	OTA_DELEGATE_BOOKINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_DELEGATE_BOOKINGS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      BUSINESS_GROUP_ID
,      BOOKING_ID
,      BOOKING_STATUS_TYPE_ID
,      BOOKING_STATUS_MEANING
,      BOOKING_TYPE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DISPLAYED_NAME
,      DELEGATE_PERSON_ID
,      DELEGATE_ASSIGNMENT_ID
,      DELEGATE_CONTACT_ID
,      DELEGATE_LAST_NAME
,      DELEGATE_APPLICANT_NUMBER
,      DELEGATE_EMPLOYEE_NUMBER
,      DELEGATE_FIRST_NAME
,      DELEGATE_FULL_NAME
,      DELEGATE_TITLE
,      DELEGATE_TITLE_MEANING
,      DELEGATE_ASSIGNMENT_NUMBER
,      DELEGATE_ASSIGNMENT_ORG
,      SPONSOR_PERSON_ID
,      SPONSOR_ASSIGNMENT_ID
,      SPONSOR_CONTACT_ID
,      SPONSOR_LAST_NAME
,      SPONSOR_APPLICANT_NUMBER
,      SPONSOR_EMPLOYEE_NUMBER
,      SPONSOR_FIRST_NAME
,      SPONSOR_FULL_NAME
,      SPONSOR_TITLE
,      SPONSOR_TITLE_MEANING
,      SPONSOR_ASSIGNMENT_NUMBER
,      SPONSOR_ASSIGNMENT_ORG
,      CONTACT_ADDRESS_ID
,      PERSON_ADDRESS_ID
,      CORRESPONDENT
,      CORRESPONDENT_MEANING
,      CORRESPONDENT_ADDRESS_TYPE
,      CORRESPONDENT_FULL_ADDRESS
,      CORRESPONDENT_PHONE
,      CORRESPONDENT_EMAIL
,      CORRESPONDENT_FAX
,      THIRD_PARTY_CUSTOMER_ID
,      THIRD_PARTY_CUSTOMER_NAME
,      THIRD_PARTY_CONTACT_ID
,      THIRD_PARTY_CONTACT_LAST_NAME
,      THIRD_PARTY_CONTACT_FIRST_NAME
,      THIRD_PARTY_CONTACT_TITLE
,      THIRD_PARTY_TITLE_MEANING
,      THIRD_PARTY_CONTACT_FULL_NAME
,      THIRD_PARTY_FULL_ADDRESS
,      THIRD_PARTY_ADDRESS_ID
,      THIRD_PARTY_CONTACT_PHONE
,      THIRD_PARTY_CONTACT_FAX
,      THIRD_PARTY_EMAIL
,      EVENT_ID
,      EVENT_TITLE
,      EVENT_CENTRE
,      EVENT_CENTRE_MEANING
,      COURSE_END_DATE
,      COURSE_START_DATE
,      ENROLMENT_END_DATE
,      ENROLMENT_START_DATE
,      EVENT_TYPE
,      EVENT_STATUS
,      EVENT_STANDARD_PRICE
,      EVENT_CURRENCY_CODE
,      EVENT_ACTIVITY_VERSION_NAME
,      ACTIVITY_VERSION_ID
,      EVENT_PRICE_BASIS
,      PUBLIC_EVENT_FLAG
,      SECURE_EVENT_FLAG
,      DATE_BOOKING_PLACED
,      INTERNAL_BOOKING_FLAG
,      INTERNAL_BOOKING_FLAG_MEANING
,      NUMBER_OF_PLACES
,      ADMINISTRATOR
,      AUTHORIZER_PERSON_ID
,      AUTHORIZER_FULL_NAME
,      BOOKING_PRIORITY
,      BOOKING_PRIORITY_MEANING
,      COMMENTS
,      DATE_STATUS_CHANGED
,      LANGUAGE_ID
,      LANGUAGE_DESCRIPTION
,      SOURCE_OF_BOOKING
,      SOURCE_OF_BOOKING_MEANING
,      FAILURE_REASON
,      FAILURE_REASON_MEANING
,      ATTENDANCE_RESULT
,      SPECIAL_BOOKING_INSTRUCTIONS
,      SUCCESSFUL_ATTENDANCE_FLAG
,      SUCCESSFUL_ATTENDANCE_MEANING
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TDB_INFORMATION_CATEGORY
,      TDB_INFORMATION1
,      TDB_INFORMATION2
,      TDB_INFORMATION3
,      TDB_INFORMATION4
,      TDB_INFORMATION5
,      TDB_INFORMATION6
,      TDB_INFORMATION7
,      TDB_INFORMATION8
,      TDB_INFORMATION9
,      TDB_INFORMATION10
,      TDB_INFORMATION11
,      TDB_INFORMATION12
,      TDB_INFORMATION13
,      TDB_INFORMATION14
,      TDB_INFORMATION15
,      TDB_INFORMATION16
,      TDB_INFORMATION17
,      TDB_INFORMATION18
,      TDB_INFORMATION19
,      TDB_INFORMATION20
,      OBJECT_VERSION_NUMBER
,      FINANCE_HEADER_ID
,      FINANCE_LINE_ID
,      INVOICE_CUSTOMER_ID
,      INVOICE_CUSTOMER_NAME
,      INVOICE_CONTACT
,      INVOICE_ADDRESS
,      LINE_TRANSFER_STATUS
,      LINE_TRANSFER_MEANING
,      BOOKING_DEAL_ID
,      BOOKING_DEAL_TYPE
,      BOOKING_DEAL_TYPE_MEANING
,      DISCOUNT_DEAL_NAME
,      PRE_PURCHASE_DEAL_NAME
,      CURRENCY_CODE
,      STANDARD_AMOUNT
,      UNITARY_AMOUNT
,      MONEY_AMOUNT
,      TFL_OBJECT_VERSION_NUMBER
,      DELEGATE_LAST_NAME_ALT
,      DELEGATE_FIRST_NAME_ALT
,      SPONSOR_LAST_NAME_ALT
,      SPONSOR_FIRST_NAME_ALT
,      LINE_ID
,      ORG_ID
,      DAEMON_FLAG
,      DAEMON_TYPE
,      OLD_EVENT_ID
,      QUOTE_LINE_ID
,      INTERFACE_SOURCE
,      TOTAL_TRAINING_TIME
,      CONTENT_PLAYER_STATUS
,      SCORE
,      COMPLETED_CONTENT
,      TOTAL_CONTENT
,      PARENT_OFFERING_ID
,      EVENT_STATUS_CODE
,      BOOKING_JUSTIFICATION_ID
,      IS_HISTORY_FLAG
FROM APPS.OTA_DELEGATE_BOOKINGS_V;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

FND_USER

HR_ALL_ORGANIZATION_UNITS_TL

HR_GENERAL - show dependent code

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_LOCATIONS

HZ_ORG_CONTACTS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

OTA_ACTIVITY_VERSIONS_TL

OTA_BOOKING_DEALS

OTA_BOOKING_STATUS_TYPES_TL

OTA_DELEGATE_BOOKINGS

OTA_EVENTS

OTA_EVENTS_TL

OTA_FINANCE_HEADERS

OTA_FINANCE_LINES

OTA_GENERAL - show dependent code

OTA_TDB_BUS - show dependent code

PER_ADDRESSES

PER_ALL_ASSIGNMENTS_F

PER_ALL_PEOPLE_F

PER_BUSINESS_GROUPS

APPS

PQP_RIW_ENROLL_WRAPPER - show dependent code