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

VIEW: APPS.OTA_DISCOUNT_DEALS_V

Object Details
Object Name: OTA_DISCOUNT_DEALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOTA.OTA_DISCOUNT_DEALS_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 Comments
ROW_ID ROWID (10)
NAME VARCHAR2 (80) Yes
BOOKING_DEAL_ID NUMBER (9) Yes
DESCRIPTION VARCHAR2 (240)

DISCOUNT_PERCENTAGE VARCHAR2 (40)

START_DATE DATE
Yes
END_DATE DATE


CUSTOMER_ID NUMBER (15)

BUSINESS_GROUP_ID NUMBER (9) Yes
EVENT_ID NUMBER (9)

ACTIVITY_VERSION_ID NUMBER (9)

CATEGORY VARCHAR2 (30)

PRICE_LIST_ID NUMBER (9)

TYPE VARCHAR2 (30)

APPROVED_BY_PERSON_ID NUMBER (10)

Query Text

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


SELECT ROW_ID
,      NAME
,      BOOKING_DEAL_ID
,      DESCRIPTION
,      DISCOUNT_PERCENTAGE
,      START_DATE
,      END_DATE
,      CUSTOMER_ID
,      BUSINESS_GROUP_ID
,      EVENT_ID
,      ACTIVITY_VERSION_ID
,      CATEGORY
,      PRICE_LIST_ID
,      TYPE
,      APPROVED_BY_PERSON_ID
FROM APPS.OTA_DISCOUNT_DEALS_V;

Dependencies

[top of page]

APPS.OTA_DISCOUNT_DEALS_V references the following:

SchemaAPPS
SynonymOTA_BOOKING_DEALS

APPS.OTA_DISCOUNT_DEALS_V is not referenced by any database object