[Home] [Help]
View: EDW_BIM_IHRN_IH_REASON_LCV
Product: | BIM - Marketing Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RSN.REASON_ID || '-' || INST.INSTANCE_CODE INTRCTN_REASON_PK
, 'ALL' ALL_FK
, RSN.SHORT_DESCRIPTION REASON_DP
, RSN.SHORT_DESCRIPTION NAME
, RSN.REASON_CODE REASON_CODE
, RSN.SHORT_DESCRIPTION SHORT_DESCRIPTION
, RSN.LONG_DESCRIPTION LONG_DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, RSN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RSN.CREATION_DATE CREATION_DATE
FROM JTF_IH_REASONS_VL RSN
, EDW_LOCAL_INSTANCE INST WITH READ ONLY
Columns
Name |
INTRCTN_REASON_PK |
ALL_FK |
REASON_DP |
NAME |
REASON_CODE |
SHORT_DESCRIPTION |
LONG_DESCRIPTION |
INSTANCE |
LAST_UPDATE_DATE |
CREATION_DATE |