[Home] [Help]
View: EDW_BIM_MDCH_MDTYPES_LCV
Product: | BIM - Marketing Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FND.LOOKUP_CODE || '-' || INST.INSTANCE_CODE MEDIA_TYPE_PK
, 'ALL' ALL_FK
, FND.MEANING MEDIA_TYPE_DP
, FND.MEANING NAME
, FND.LOOKUP_CODE MEDIA_TYPE_CODE
, FND.ENABLED_FLAG ENABLED_FLAG
, FND.START_DATE_ACTIVE START_DATE_ACTIVE
, FND.END_DATE_ACTIVE END_DATE_ACTIVE
, FND.MEANING MEDIA_TYPE_NAME
, FND.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, FND.CREATION_DATE CREATION_DATE
, FND.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM FND_LOOKUP_VALUES FND
, EDW_LOCAL_INSTANCE INST
WHERE FND.LOOKUP_TYPE = 'AMS_MEDIA_TYPE'
AND FND.LANGUAGE = USERENV('LANG')
AND FND.VIEW_APPLICATION_ID = 530
AND FND.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FND.LOOKUP_TYPE
, FND.VIEW_APPLICATION_ID)
Columns
Name |
MEDIA_TYPE_PK |
ALL_FK |
MEDIA_TYPE_DP |
NAME |
MEDIA_TYPE_CODE |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
MEDIA_TYPE_NAME |
DESCRIPTION |
INSTANCE |
CREATION_DATE |
LAST_UPDATE_DATE |