VIEW: APPS.OZF_P_CAMPAIGN_OFFERS_V

Source

View Text - Preformatted

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 OZF_ACT_OFFERS OFR, OZF_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'

View Text - HTML Formatted

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 OZF_ACT_OFFERS OFR
, OZF_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'