[Home] [Help]
View: BIM_DIMV_MEDIA
Product: | BIM - Marketing Intelligence(Obsolete) |
Description: | Shows all marketing media. |
Implementation/DBA Data: |
APPS.BIM_DIMV_MEDIA
|
View Text
SELECT TO_CHAR(AME.MEDIA_ID)
, SUBSTR(AME.MEDIA_NAME
, 1
, 80)
, AME.MEDIA_ID MEDIA_ID
, AME.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, AME.MEDIA_NAME MEDIA_NAME
, AME.DESCRIPTION MEDIA_DESCRIPTION
, AME.INBOUND_FLAG INBOUND_FLAG
, AME.ENABLED_FLAG ENABLED_FLAG
, AML.MEANING MEDIA_TYPE_NAME
, AML.DESCRIPTION MEDIA_TYPE_DESCRIPTION
FROM AMS_MEDIA_VL AME
, AMS_LOOKUPS AML
WHERE AML.LOOKUP_CODE = AME.MEDIA_TYPE_CODE
AND AML.LOOKUP_TYPE = 'AMS_MEDIA_TYPE' UNION ALL SELECT '-999'
, MEANING
, -999
, '-999'
, MEANING
, NULL
, NULL
, NULL
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY
Columns
Name |
ID |
VALUE |
MEDIA_ID |
MEDIA_TYPE_CODE |
MEDIA_NAME |
MEDIA_DESCRIPTION |
INBOUND_FLAG |
ENABLED_FLAG |
MEDIA_TYPE_NAME |
MEDIA_TYPE_DESCRIPTION |