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: EDW_BIM_OFFR_OFFERS_LCV

Product:	BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AAO.ACTIVITY_OFFER_ID || '-' || INST.INSTANCE_CODE OFFER_PK
, 'ALL' ALL_FK
, SUBSTR(QLH.NAME
, 1
, 80) OFFER_DP
, QLH.NAME NAME
, AAO.ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID
, AAO.OFFER_CODE OFFER_CODE
, AAO.OFFER_TYPE OFFER_TYPE
, AAO.PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG
, QLH.LIST_HEADER_ID LIST_HEADER_ID
, QLH.NAME OFFER_NAME
, QLH.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AAO.CREATION_DATE CREATION_DATE
, GREATEST(AAO.LAST_UPDATE_DATE
, QLH.LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM AMS_ACT_OFFERS AAO
, QP_LIST_HEADERS_VL QLH
, EDW_LOCAL_INSTANCE INST
WHERE AAO.QP_LIST_HEADER_ID = QLH.LIST_HEADER_ID
AND ((AAO.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD')) OR (QLH.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD'))) WITH READ ONLY

Columns

Name
OFFER_PK
ALL_FK
OFFER_DP
NAME
ACTIVITY_OFFER_ID
OFFER_CODE
OFFER_TYPE
PRIMARY_OFFER_FLAG
LIST_HEADER_ID
OFFER_NAME
DESCRIPTION
INSTANCE
CREATION_DATE
LAST_UPDATE_DATE