[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_DELEGATE_BOOKINGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OTA.OTA_DELEGATE_BOOKINGS_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
| BOOKING_ID | NUMBER | (9) | Yes | |
| BOOKING_STATUS_TYPE_ID | NUMBER | (9) | Yes | |
| BOOKING_STATUS_MEANING | VARCHAR2 | (80) | Yes | |
| BOOKING_TYPE | VARCHAR2 | (1) | ||
| CUSTOMER_ID | NUMBER | (15) | ||
| CUSTOMER_NAME | VARCHAR2 | (50) | ||
| ORGANIZATION_ID | NUMBER | (9) | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| DISPLAYED_NAME | VARCHAR2 | (2) | ||
| DELEGATE_PERSON_ID | NUMBER | (10) | ||
| DELEGATE_ASSIGNMENT_ID | NUMBER | (10) | ||
| DELEGATE_CONTACT_ID | NUMBER | (15) | ||
| DELEGATE_LAST_NAME | VARCHAR2 | (150) | ||
| DELEGATE_APPLICANT_NUMBER | VARCHAR2 | (30) | ||
| DELEGATE_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| DELEGATE_FIRST_NAME | VARCHAR2 | (150) | ||
| DELEGATE_FULL_NAME | VARCHAR2 | (4000) | ||
| DELEGATE_TITLE | VARCHAR2 | (30) | ||
| DELEGATE_TITLE_MEANING | VARCHAR2 | (4000) | ||
| DELEGATE_ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| DELEGATE_ASSIGNMENT_ORG | VARCHAR2 | (240) | ||
| SPONSOR_PERSON_ID | NUMBER | (10) | ||
| SPONSOR_ASSIGNMENT_ID | NUMBER | (10) | ||
| SPONSOR_CONTACT_ID | NUMBER | (15) | ||
| SPONSOR_LAST_NAME | VARCHAR2 | (150) | ||
| SPONSOR_APPLICANT_NUMBER | VARCHAR2 | (30) | ||
| SPONSOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| SPONSOR_FIRST_NAME | VARCHAR2 | (150) | ||
| SPONSOR_FULL_NAME | VARCHAR2 | (4000) | ||
| SPONSOR_TITLE | VARCHAR2 | (30) | ||
| SPONSOR_TITLE_MEANING | VARCHAR2 | (4000) | ||
| SPONSOR_ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| SPONSOR_ASSIGNMENT_ORG | VARCHAR2 | (240) | ||
| CONTACT_ADDRESS_ID | NUMBER | (15) | ||
| PERSON_ADDRESS_ID | NUMBER | (15) | ||
| CORRESPONDENT | VARCHAR2 | (30) | ||
| CORRESPONDENT_MEANING | VARCHAR2 | (4000) | ||
| CORRESPONDENT_ADDRESS_TYPE | VARCHAR2 | (30) | ||
| CORRESPONDENT_FULL_ADDRESS | VARCHAR2 | (4000) | ||
| CORRESPONDENT_PHONE | VARCHAR2 | (60) | ||
| CORRESPONDENT_EMAIL | VARCHAR2 | (240) | ||
| CORRESPONDENT_FAX | VARCHAR2 | (60) | ||
| THIRD_PARTY_CUSTOMER_ID | NUMBER | (15) | ||
| THIRD_PARTY_CUSTOMER_NAME | VARCHAR2 | (50) | ||
| THIRD_PARTY_CONTACT_ID | NUMBER | (15) | ||
| THIRD_PARTY_CONTACT_LAST_NAME | VARCHAR2 | (50) | ||
| THIRD_PARTY_CONTACT_FIRST_NAME | VARCHAR2 | (40) | ||
| THIRD_PARTY_CONTACT_TITLE | VARCHAR2 | (30) | ||
| THIRD_PARTY_TITLE_MEANING | VARCHAR2 | (4000) | ||
| THIRD_PARTY_CONTACT_FULL_NAME | VARCHAR2 | (4000) | ||
| THIRD_PARTY_FULL_ADDRESS | VARCHAR2 | (1338) | ||
| THIRD_PARTY_ADDRESS_ID | NUMBER | (15) | ||
| THIRD_PARTY_CONTACT_PHONE | VARCHAR2 | (30) | ||
| THIRD_PARTY_CONTACT_FAX | VARCHAR2 | (30) | ||
| THIRD_PARTY_EMAIL | VARCHAR2 | (240) | ||
| EVENT_ID | NUMBER | (9) | Yes | |
| EVENT_TITLE | VARCHAR2 | (80) | Yes | |
| EVENT_CENTRE | VARCHAR2 | (30) | ||
| EVENT_CENTRE_MEANING | VARCHAR2 | (4000) | ||
| COURSE_END_DATE | DATE | |||
| COURSE_START_DATE | DATE | |||
| ENROLMENT_END_DATE | DATE | |||
| ENROLMENT_START_DATE | DATE | |||
| EVENT_TYPE | VARCHAR2 | (30) | Yes | |
| EVENT_STATUS | VARCHAR2 | (4000) | ||
| EVENT_STANDARD_PRICE | NUMBER | |||
| EVENT_CURRENCY_CODE | VARCHAR2 | (30) | ||
| EVENT_ACTIVITY_VERSION_NAME | VARCHAR2 | (80) | ||
| ACTIVITY_VERSION_ID | NUMBER | (9) | ||
| EVENT_PRICE_BASIS | VARCHAR2 | (30) | ||
| PUBLIC_EVENT_FLAG | VARCHAR2 | (30) | ||
| SECURE_EVENT_FLAG | VARCHAR2 | (30) | ||
| DATE_BOOKING_PLACED | DATE | Yes | ||
| INTERNAL_BOOKING_FLAG | VARCHAR2 | (30) | Yes | |
| INTERNAL_BOOKING_FLAG_MEANING | VARCHAR2 | (4000) | ||
| NUMBER_OF_PLACES | NUMBER | (9) | Yes | |
| ADMINISTRATOR | NUMBER | (9) | ||
| AUTHORIZER_PERSON_ID | NUMBER | (10) | ||
| AUTHORIZER_FULL_NAME | VARCHAR2 | (100) | ||
| BOOKING_PRIORITY | VARCHAR2 | (30) | ||
| BOOKING_PRIORITY_MEANING | VARCHAR2 | (4000) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| DATE_STATUS_CHANGED | DATE | |||
| LANGUAGE_ID | NUMBER | (9) | ||
| LANGUAGE_DESCRIPTION | VARCHAR2 | (4000) | ||
| SOURCE_OF_BOOKING | VARCHAR2 | (30) | ||
| SOURCE_OF_BOOKING_MEANING | VARCHAR2 | (4000) | ||
| FAILURE_REASON | VARCHAR2 | (30) | ||
| FAILURE_REASON_MEANING | VARCHAR2 | (4000) | ||
| ATTENDANCE_RESULT | VARCHAR2 | (256) | ||
| SPECIAL_BOOKING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
| SUCCESSFUL_ATTENDANCE_FLAG | VARCHAR2 | (30) | ||
| SUCCESSFUL_ATTENDANCE_MEANING | VARCHAR2 | (4000) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| TDB_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| TDB_INFORMATION1 | VARCHAR2 | (150) | ||
| TDB_INFORMATION2 | VARCHAR2 | (150) | ||
| TDB_INFORMATION3 | VARCHAR2 | (150) | ||
| TDB_INFORMATION4 | VARCHAR2 | (150) | ||
| TDB_INFORMATION5 | VARCHAR2 | (150) | ||
| TDB_INFORMATION6 | VARCHAR2 | (150) | ||
| TDB_INFORMATION7 | VARCHAR2 | (150) | ||
| TDB_INFORMATION8 | VARCHAR2 | (150) | ||
| TDB_INFORMATION9 | VARCHAR2 | (150) | ||
| TDB_INFORMATION10 | VARCHAR2 | (150) | ||
| TDB_INFORMATION11 | VARCHAR2 | (150) | ||
| TDB_INFORMATION12 | VARCHAR2 | (150) | ||
| TDB_INFORMATION13 | VARCHAR2 | (150) | ||
| TDB_INFORMATION14 | VARCHAR2 | (150) | ||
| TDB_INFORMATION15 | VARCHAR2 | (150) | ||
| TDB_INFORMATION16 | VARCHAR2 | (150) | ||
| TDB_INFORMATION17 | VARCHAR2 | (150) | ||
| TDB_INFORMATION18 | VARCHAR2 | (150) | ||
| TDB_INFORMATION19 | VARCHAR2 | (150) | ||
| TDB_INFORMATION20 | VARCHAR2 | (150) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | |
| FINANCE_HEADER_ID | NUMBER | (9) | ||
| FINANCE_LINE_ID | NUMBER | (9) | ||
| INVOICE_CUSTOMER_ID | NUMBER | (15) | ||
| INVOICE_CUSTOMER_NAME | VARCHAR2 | (50) | ||
| INVOICE_CONTACT | VARCHAR2 | (4000) | ||
| INVOICE_ADDRESS | VARCHAR2 | (2000) | ||
| LINE_TRANSFER_STATUS | VARCHAR2 | (30) | ||
| LINE_TRANSFER_MEANING | VARCHAR2 | (4000) | ||
| BOOKING_DEAL_ID | NUMBER | (9) | ||
| BOOKING_DEAL_TYPE | VARCHAR2 | (30) | ||
| BOOKING_DEAL_TYPE_MEANING | VARCHAR2 | (4000) | ||
| DISCOUNT_DEAL_NAME | VARCHAR2 | (80) | ||
| PRE_PURCHASE_DEAL_NAME | VARCHAR2 | (80) | ||
| CURRENCY_CODE | VARCHAR2 | (30) | ||
| STANDARD_AMOUNT | NUMBER | |||
| UNITARY_AMOUNT | NUMBER | (9) | ||
| MONEY_AMOUNT | NUMBER | |||
| TFL_OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
| DELEGATE_LAST_NAME_ALT | VARCHAR2 | (150) | ||
| DELEGATE_FIRST_NAME_ALT | VARCHAR2 | (150) | ||
| SPONSOR_LAST_NAME_ALT | VARCHAR2 | (150) | ||
| SPONSOR_FIRST_NAME_ALT | VARCHAR2 | (150) | ||
| LINE_ID | NUMBER | (15) | ||
| ORG_ID | NUMBER | (15) | ||
| DAEMON_FLAG | VARCHAR2 | (1) | ||
| DAEMON_TYPE | VARCHAR2 | (1) | ||
| OLD_EVENT_ID | NUMBER | (9) | ||
| QUOTE_LINE_ID | NUMBER | |||
| INTERFACE_SOURCE | VARCHAR2 | (30) | ||
| TOTAL_TRAINING_TIME | VARCHAR2 | (10) | ||
| CONTENT_PLAYER_STATUS | VARCHAR2 | (30) | ||
| SCORE | NUMBER | |||
| COMPLETED_CONTENT | NUMBER | |||
| TOTAL_CONTENT | NUMBER | |||
| PARENT_OFFERING_ID | NUMBER | (9) | ||
| EVENT_STATUS_CODE | VARCHAR2 | (30) | ||
| BOOKING_JUSTIFICATION_ID | NUMBER | (15) | ||
| IS_HISTORY_FLAG | VARCHAR2 | (1) |
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;
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
|
|
|
|