[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 |