[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;
|
|
|