View: BIM_DIMV_OFFERS

Product:	BIM - Marketing Intelligence
Description:	Shows all marketing offers
Implementation/DBA Data:	APPS.BIM_DIMV_OFFERS

View Text

SELECT TO_CHAR(AAO.ACTIVITY_OFFER_ID)
, SUBSTR(QLH.NAME
, 1
, 80)
, AAO.ACTIVITY_OFFER_ID OFFER_ID
, AAO.OFFER_TYPE OFFER_TYPE
, AAO.OFFER_CODE OFFER_CODE
, AAO.PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG
, QLH.LIST_HEADER_ID LIST_HEADER_ID
, QLH.NAME OFFER_NAME
, QLH.DESCRIPTION DESCRIPTION
FROM AMS_ACT_OFFERS AAO
, QP_LIST_HEADERS_VL QLH
WHERE AAO.QP_LIST_HEADER_ID = QLH.LIST_HEADER_ID UNION ALL SELECT '-999'
, MEANING
, -999
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns