eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OTA_EVENT_ASSOCIAT_BILLING_V

Object Details

Object Name:	OTA_EVENT_ASSOCIAT_BILLING_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_EVENT_ASSOCIAT_BILLING_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

Name	Datatype	Length	Mandatory
EVENT_ASSOCIATION_ID	NUMBER		Yes
BOOKING_ID	NUMBER	(9)	Yes
BOOKING_OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes
BOOKING_STATUS_TYPE_ID	NUMBER	(9)	Yes
BOOKING_STATUS_MEANING	VARCHAR2	(80)	Yes
INTERNAL_BOOKING_FLAG	VARCHAR2	(30)	Yes
SOURCE_OF_BOOKING_CODE	VARCHAR2	(30)
SOURCE_OF_BOOKING_MEANING	VARCHAR2	(4000)
DELEGATE_CONTACT_ID	NUMBER	(15)
DELEGATE_CONTACT_LAST_NAME	VARCHAR2	(40)
DELEGATE_CONTACT_FIRST_NAME	VARCHAR2	(50)
DELEGATE_CONTACT_TITLE_CODE	VARCHAR2	(30)
DELEGATE_CONTACT_TITLE_MEANING	VARCHAR2	(80)
DELEGATE_CONTACT_FULL_NAME	VARCHAR2	(173)
EVENT_STANDARD_PRICE	NUMBER
EVENT_CURRENCY_CODE	VARCHAR2	(30)
BOOKING_DEAL_ID	NUMBER	(9)
BOOKING_DEAL_NAME	VARCHAR2	(80)
BOOKING_DEAL_TYPE	VARCHAR2	(30)
DISCOUNT_DEAL_NAME	VARCHAR2	(80)
PRE_PURCHASE_DEAL_NAME	VARCHAR2	(80)
TRAINING_UNIT_TYPE	VARCHAR2	(30)
TRAINING_UNIT_MEANING	VARCHAR2	(80)
FINANCE_HEADER_ID	NUMBER	(9)
INVOICE_CUSTOMER_ID	NUMBER	(15)
INVOICE_CUSTOMER_NAME	VARCHAR2	(50)
INVOICE_CONTACT	VARCHAR2	(240)
INVOICE_ADDRESS	VARCHAR2	(2000)
FINANCE_LINE_ID	NUMBER	(9)	Yes
TFL_STANDARD_AMOUNT	NUMBER
MONEY_AMOUNT	NUMBER
UNITARY_AMOUNT	NUMBER	(9)

Query Text

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


SELECT EVENT_ASSOCIATION_ID
,      BOOKING_ID
,      BOOKING_OBJECT_VERSION_NUMBER
,      BOOKING_STATUS_TYPE_ID
,      BOOKING_STATUS_MEANING
,      INTERNAL_BOOKING_FLAG
,      SOURCE_OF_BOOKING_CODE
,      SOURCE_OF_BOOKING_MEANING
,      DELEGATE_CONTACT_ID
,      DELEGATE_CONTACT_LAST_NAME
,      DELEGATE_CONTACT_FIRST_NAME
,      DELEGATE_CONTACT_TITLE_CODE
,      DELEGATE_CONTACT_TITLE_MEANING
,      DELEGATE_CONTACT_FULL_NAME
,      EVENT_STANDARD_PRICE
,      EVENT_CURRENCY_CODE
,      BOOKING_DEAL_ID
,      BOOKING_DEAL_NAME
,      BOOKING_DEAL_TYPE
,      DISCOUNT_DEAL_NAME
,      PRE_PURCHASE_DEAL_NAME
,      TRAINING_UNIT_TYPE
,      TRAINING_UNIT_MEANING
,      FINANCE_HEADER_ID
,      INVOICE_CUSTOMER_ID
,      INVOICE_CUSTOMER_NAME
,      INVOICE_CONTACT
,      INVOICE_ADDRESS
,      FINANCE_LINE_ID
,      TFL_STANDARD_AMOUNT
,      MONEY_AMOUNT
,      UNITARY_AMOUNT
FROM APPS.OTA_EVENT_ASSOCIAT_BILLING_V;

Dependencies

[top of page]

APPS.OTA_EVENT_ASSOCIAT_BILLING_V references the following:

APPS: AR_LOOKUPS; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOOKUPS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS; OTA_BOOKING_DEALS; OTA_BOOKING_STATUS_TYPES_TL; OTA_DELEGATE_BOOKINGS; OTA_EVENTS; OTA_EVENT_ASSOCIATIONS; OTA_FINANCE_HEADERS; OTA_FINANCE_LINES; OTA_PRICE_LISTS

APPS.OTA_EVENT_ASSOCIAT_BILLING_V is not referenced by any database object