[Home] [Help]
View: OTA_DISCOUNT_DEALS_V
Product: | OTA - Learning Management |
Description: | View to list all Discount Enrollment Agreements. |
Implementation/DBA Data: |
APPS.OTA_DISCOUNT_DEALS_V
|
View Text
SELECT DBD.ROWID
, DBD.NAME
, DBD.BOOKING_DEAL_ID
, DBD.DESCRIPTION
, TO_CHAR(DBD.DISCOUNT_PERCENTAGE) DISCOUNT_PERCENTAGE
, DBD.START_DATE
, DBD.END_DATE
, DBD.CUSTOMER_ID
, DBD.BUSINESS_GROUP_ID
, DBD.EVENT_ID
, DBD.ACTIVITY_VERSION_ID
, DBD.CATEGORY
, DBD.PRICE_LIST_ID
, DBD.TYPE
, DBD.APPROVED_BY_PERSON_ID
FROM OTA_BOOKING_DEALS DBD
WHERE DBD.TYPE = 'D'
Columns
Name |
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 |