View: AMS_P_CAMPAIGN_OFFERS_V

Product:	AMS - Marketing
Description:	This public view returns the promotional offers associated with campaigns.
Implementation/DBA Data:	APPS.AMS_P_CAMPAIGN_OFFERS_V

View Text

SELECT OFR.ACTIVITY_OFFER_ID
, CAM.CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.ACTUAL_EXEC_START_DATE
, CAM.ACTUAL_EXEC_END_DATE
, CAM.SOURCE_CODE
, CAM.STATUS_CODE
, QPL.NAME
, OFFER.OFFER_CODE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_OFFER_TYPE'
, OFFER.OFFER_TYPE)
, QPL.CURRENCY_CODE
, QPL.START_DATE_ACTIVE
, QPL.END_DATE_ACTIVE
, QPL.AUTOMATIC_FLAG
, OFR.PRIMARY_OFFER_FLAG
, OFR.QP_LIST_HEADER_ID
, QPL.START_DATE_ACTIVE_FIRST
, QPL.END_DATE_ACTIVE_FIRST
, QPL.START_DATE_ACTIVE_SECOND
, QPL.END_DATE_ACTIVE_SECOND
, OFFER.PERF_DATE_FROM
, OFFER.PERF_DATE_TO
, OFR.STATUS_CODE
, OFFER.STATUS_DATE
, OFFER.OFFER_AMOUNT
, OFFER.LUMPSUM_PAYMENT_TYPE
, OFFER.REUSABLE
, OFFER.LUMPSUM_AMOUNT
FROM AMS_ACT_OFFERS OFR
, AMS_OFFERS OFFER
, QP_LIST_HEADERS_VL QPL
, AMS_CAMPAIGNS_VL CAM
WHERE OFR.ARC_ACT_OFFER_USED_BY = 'CAMP'
AND OFR.ACT_OFFER_USED_BY_ID = CAM.CAMPAIGN_ID
AND CAM.ACTIVE_FLAG = 'Y'
AND CAM.STATUS_CODE = 'ACTIVE'
AND OFR.QP_LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND OFR.QP_LIST_HEADER_ID = OFFER.QP_LIST_HEADER_ID
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'

Columns