eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMS_ASO_CAMPAIGN_OFFERS_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_ASO_CAMPAIGN_OFFERS_V

View Text

SELECT OFR.ACTIVITY_OFFER_ID
, OFR.ACT_OFFER_USED_BY_ID
, QPL.DESCRIPTION
, OFR.OFFER_CODE
, QPL.CURRENCY_CODE
, QPL.START_DATE_ACTIVE
, QPL.END_DATE_ACTIVE
, QPL.AUTOMATIC_FLAG
, OFR.PRIMARY_OFFER_FLAG
, OFR.QP_LIST_HEADER_ID
, OFR.ORDER_DATE_FROM
, OFR.ORDER_DATE_TO
, OFR.SHIP_DATE_FROM
, OFR.SHIP_DATE_TO
, OFR.PERF_DATE_FROM
, OFR.PERF_DATE_TO
, OFR.STATUS_CODE
, OFR.STATUS_DATE
, OFR.OFFER_AMOUNT
, OFR.LUMPSUM_PAYMENT_TYPE
FROM AMS_ACT_OFFERS OFR
, QP_LIST_HEADERS_VL QPL
WHERE OFR.ARC_ACT_OFFER_USED_BY = 'CAMP'
AND OFR.QP_LIST_HEADER_ID = QPL.LIST_HEADER_ID

Columns

Name
ACTIVITY_OFFER_ID
CAMPAIGN_ID
OFFER_NAME
OFFER_CODE
OFFER_CURRENCY_CODE
START_DATE_EFFECTIVE
END_DATE_EFFECTIVE
AUTOMATIC_FLAG
PRIMARY_OFFER_FLAG
QP_LIST_HEADER_ID
ORDER_DATE_FROM
ORDER_DATE_TO
SHIP_DATE_FROM
SHIP_DATE_TO
PERF_DATE_FROM
PERF_DATE_TO
STATUS_CODE
STATUS_DATE
OFFER_AMOUNT
LUMPSUM_PAYMENT_TYPE