eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BIM_DIMV_SOURCE_CODES_V

Object Details

Object Name:	BIM_DIMV_SOURCE_CODES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIM.BIM_DIMV_SOURCE_CODES_V
Subobject Name:
Status:	VALID

View Type

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

BIM_DIMV_SOURCE_CODES_V is a view showing details for all marketing source codes.
.

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE_CODE_ID	NUMBER		source code id
SOURCE_CODE	VARCHAR2	(30)	source code
CAMPAIGN_SCHEDULE_ID	NUMBER		campaign schedule id
CAMPAIGN_ID	NUMBER		campaign id
MEDIA_ID	NUMBER		media id
CHANNEL_ID	VARCHAR2	(70)	channel id
OFFER_ID	NUMBER		offer id
EVENT_ID	VARCHAR2	(44)	event id
EVENT_OFFER_ID	VARCHAR2	(44)	event offer id
CREATION_DATE	DATE		creation date

Query Text

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


SELECT SOURCE_CODE_ID
,      SOURCE_CODE
,      CAMPAIGN_SCHEDULE_ID
,      CAMPAIGN_ID
,      MEDIA_ID
,      CHANNEL_ID
,      OFFER_ID
,      EVENT_ID
,      EVENT_OFFER_ID
,      CREATION_DATE
FROM APPS.BIM_DIMV_SOURCE_CODES_V;

Dependencies

[top of page]

APPS.BIM_DIMV_SOURCE_CODES_V references the following:

APPS: AMS_ACT_OFFERS; AMS_CAMPAIGNS_ALL_B; AMS_CAMPAIGN_SCHEDULES; AMS_EVENT_OFFERS_ALL_B; AMS_SOURCE_CODES

APPS.BIM_DIMV_SOURCE_CODES_V is not referenced by any database object