VIEW: APPS.AMS_ASO_CAMPAIGN_OFFERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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