[Home] [Help]
View: EDW_BIM_IHMD_IH_MEDIA_LCV
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT LKP.LOOKUP_CODE || DECODE( JMI.DIRECTION
, ''
, ''
, '-' ) || JMI.DIRECTION || '-' || INST.INSTANCE_CODE INTRCTN_MEDIA_PK
, 'ALL' ALL_FK
, LKP.MEANING || DECODE( JMI.DIRECTION
, ''
, ''
, '-' ) || JMI.DIRECTION INTRCTN_MEDIA_DP
, LKP.MEANING || DECODE( JMI.DIRECTION
, ''
, ''
, '-' ) || JMI.DIRECTION NAME
, LKP.LOOKUP_CODE INTRCTN_MEDIA_CODE
, JMI.DIRECTION MEDIA_DIRECTION
, LKP.MEANING INTRCTN_MEDIA_NAME
, LKP.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, LKP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LKP.CREATION_DATE CREATION_DATE
FROM JTF_IH_MEDIA_ITEMS JMI
, FND_LOOKUP_VALUES_VL LKP
, EDW_LOCAL_INSTANCE INST
WHERE JMI.MEDIA_ITEM_TYPE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'JTF_MEDIA_TYPE'
AND LKP.VIEW_APPLICATION_ID = 0
AND LKP.SECURITY_GROUP_ID =FND_GLOBAL.LOOKUP_SECURITY_GROUP( LKP.LOOKUP_TYPE
, LKP.VIEW_APPLICATION_ID ) WITH READ ONLY
Columns
| Name |
| INTRCTN_MEDIA_PK |
| ALL_FK |
| INTRCTN_MEDIA_DP |
| NAME |
| INTRCTN_MEDIA_CODE |
| MEDIA_DIRECTION |
| INTRCTN_MEDIA_NAME |
| DESCRIPTION |
| INSTANCE |
| LAST_UPDATE_DATE |
| CREATION_DATE |