DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.BIM_DIMV_MEDIA

Object Details
Object Name: BIM_DIMV_MEDIA
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_DIMV_MEDIA
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIM_DIMV_MEDIA is a view showing all marketing media.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (40)
id
VALUE VARCHAR2 (80)
value
MEDIA_ID NUMBER

media id
MEDIA_TYPE_CODE VARCHAR2 (30)
media type code
MEDIA_NAME VARCHAR2 (120)
media name
MEDIA_DESCRIPTION VARCHAR2 (4000)
media description
INBOUND_FLAG VARCHAR2 (1)
inbound flag
ENABLED_FLAG VARCHAR2 (1)
enabled flag
MEDIA_TYPE_NAME VARCHAR2 (80)
media type name
MEDIA_TYPE_DESCRIPTION VARCHAR2 (240)
media type description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      VALUE
,      MEDIA_ID
,      MEDIA_TYPE_CODE
,      MEDIA_NAME
,      MEDIA_DESCRIPTION
,      INBOUND_FLAG
,      ENABLED_FLAG
,      MEDIA_TYPE_NAME
,      MEDIA_TYPE_DESCRIPTION
FROM APPS.BIM_DIMV_MEDIA;

Dependencies

[top of page]

APPS.BIM_DIMV_MEDIA references the following:

SchemaAPPS
ViewAMS_LOOKUPS
ViewAMS_MEDIA_VL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIM_DIMV_MEDIA is not referenced by any database object