[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_MEDIA |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_MEDIA |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_DIMV_MEDIA is a view showing all marketing media.
.
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 |
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;
APPS.BIM_DIMV_MEDIA is not referenced by any database object
|
|
|