[Home] [Help] [Dependency Information]
Object Name: | OTA_DELEGATE_BOOKINGS# |
---|---|
Object Type: | VIEW |
Owner: | OTA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOKING_ID | NUMBER | (9) | Yes | |
BOOKING_STATUS_TYPE_ID | NUMBER | (9) | Yes | |
DELEGATE_PERSON_ID | NUMBER | (10) | ||
CONTACT_ID | NUMBER | (15) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
EVENT_ID | NUMBER | (9) | Yes | |
PERSON_ADDRESS_ID | NUMBER | (15) | ||
DELEGATE_CONTACT_ID | NUMBER | (15) | ||
DELEGATE_CONTACT_EMAIL | VARCHAR2 | (240) | ||
THIRD_PARTY_EMAIL | VARCHAR2 | (240) | ||
PERSON_ADDRESS_TYPE | VARCHAR2 | (30) | ||
DELEGATE_ASSIGNMENT_ID | NUMBER | (10) | ||
ORGANIZATION_ID | NUMBER | (9) | ||
SPONSOR_PERSON_ID | NUMBER | (10) | ||
SPONSOR_ASSIGNMENT_ID | NUMBER | (10) | ||
CUSTOMER_ID | NUMBER | (15) | ||
AUTHORIZER_PERSON_ID | NUMBER | (10) | ||
DATE_BOOKING_PLACED | DATE | Yes | ||
INTERNAL_BOOKING_FLAG | VARCHAR2 | (30) | Yes | |
NUMBER_OF_PLACES | NUMBER | (9) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | |
ADMINISTRATOR | NUMBER | (9) | ||
ATTENDANCE_RESULT | VARCHAR2 | (256) | ||
BOOKING_PRIORITY | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (2000) | ||
CONTACT_ADDRESS_ID | NUMBER | (15) | ||
CORESPONDENT | VARCHAR2 | (30) | ||
DATE_STATUS_CHANGED | DATE | |||
DELEGATE_CONTACT_FAX | VARCHAR2 | (60) | ||
DELEGATE_CONTACT_PHONE | VARCHAR2 | (60) | ||
FAILURE_REASON | VARCHAR2 | (30) | ||
LANGUAGE_ID | NUMBER | (9) | ||
SOURCE_OF_BOOKING | VARCHAR2 | (30) | ||
SPECIAL_BOOKING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
SUCCESSFUL_ATTENDANCE_FLAG | VARCHAR2 | (30) | ||
THIRD_PARTY_ADDRESS_ID | NUMBER | (15) | ||
THIRD_PARTY_CONTACT_FAX | VARCHAR2 | (30) | ||
THIRD_PARTY_CONTACT_ID | NUMBER | (15) | ||
THIRD_PARTY_CONTACT_PHONE | VARCHAR2 | (30) | ||
THIRD_PARTY_CUSTOMER_ID | NUMBER | (15) | ||
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) | ||
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 | |||
BOOKING_JUSTIFICATION_ID | NUMBER | (15) | ||
IS_HISTORY_FLAG | VARCHAR2 | (1) | ||
IS_MANDATORY_ENROLLMENT | VARCHAR2 | (1) | ||
SIGN_EVAL_STATUS | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT BOOKING_ID
, BOOKING_STATUS_TYPE_ID
, DELEGATE_PERSON_ID
, CONTACT_ID
, BUSINESS_GROUP_ID
, EVENT_ID
, PERSON_ADDRESS_ID
, DELEGATE_CONTACT_ID
, DELEGATE_CONTACT_EMAIL
, THIRD_PARTY_EMAIL
, PERSON_ADDRESS_TYPE
, DELEGATE_ASSIGNMENT_ID
, ORGANIZATION_ID
, SPONSOR_PERSON_ID
, SPONSOR_ASSIGNMENT_ID
, CUSTOMER_ID
, AUTHORIZER_PERSON_ID
, DATE_BOOKING_PLACED
, INTERNAL_BOOKING_FLAG
, NUMBER_OF_PLACES
, OBJECT_VERSION_NUMBER
, ADMINISTRATOR
, ATTENDANCE_RESULT
, BOOKING_PRIORITY
, COMMENTS
, CONTACT_ADDRESS_ID
, CORESPONDENT
, DATE_STATUS_CHANGED
, DELEGATE_CONTACT_FAX
, DELEGATE_CONTACT_PHONE
, FAILURE_REASON
, LANGUAGE_ID
, SOURCE_OF_BOOKING
, SPECIAL_BOOKING_INSTRUCTIONS
, SUCCESSFUL_ATTENDANCE_FLAG
, THIRD_PARTY_ADDRESS_ID
, THIRD_PARTY_CONTACT_FAX
, THIRD_PARTY_CONTACT_ID
, THIRD_PARTY_CONTACT_PHONE
, THIRD_PARTY_CUSTOMER_ID
, 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
, 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
, BOOKING_JUSTIFICATION_ID
, IS_HISTORY_FLAG
, IS_MANDATORY_ENROLLMENT
, SIGN_EVAL_STATUS
FROM OTA.OTA_DELEGATE_BOOKINGS#;
|
|
|