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