View: OTA_PRE_PURCHASE_DEALS_V

Product:	OTA - Learning Management
Description:	View to list all Pre-Purchase Enrollment Agreements.
Implementation/DBA Data:	APPS.OTA_PRE_PURCHASE_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 = 'P'

Columns