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_CAMPAIGNS

Object Details

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

View Type

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

BIM_DIMV_CAMPAIGNS is a view showing all campaigns.
.

[View Source]

Columns

Name	Datatype	Length	Comments
ID	VARCHAR2	(40)	ID
VALUE	VARCHAR2	(80)	VALUE
CAMPAIGN_ID	NUMBER		campaign id
USER_STATUS_ID	NUMBER		standard who column
STATUS_CODE	VARCHAR2	(0)	status code for campaign
STATUS_DATE	DATE		status date for campaign
ROLLUP_TYPE	VARCHAR2	(0)	campaign rollup type
SOURCE_CODE	VARCHAR2	(0)	campaign source code
CAMPAIGN_TYPE	VARCHAR2	(4)	campaign type
CAMPAIGN_TYPE_NAME	VARCHAR2	(0)	campaign type name
PARENT_CAMPAIGN_ID	NUMBER		parent campaign id
FORECASTED_EXEC_START_DATE	DATE		forecasted execution start date
FORECASTED_EXEC_END_DATE	DATE		forecasted executed end date
ACTUAL_EXEC_START_DATE	DATE		actural execute start date
ACTUAL_EXEC_END_DATE	DATE		actual execute end date
CAMPAIGN_NAME	VARCHAR2	(240)	campaign name
CAMPAIGN_DESCRIPTION	VARCHAR2	(0)	campaign description
STATUS_NAME	VARCHAR2	(0)	name of the status
STATUS_DESCRIPTION	VARCHAR2	(0)	description of the status

Query Text

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


SELECT ID
,      VALUE
,      CAMPAIGN_ID
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      ROLLUP_TYPE
,      SOURCE_CODE
,      CAMPAIGN_TYPE
,      CAMPAIGN_TYPE_NAME
,      PARENT_CAMPAIGN_ID
,      FORECASTED_EXEC_START_DATE
,      FORECASTED_EXEC_END_DATE
,      ACTUAL_EXEC_START_DATE
,      ACTUAL_EXEC_END_DATE
,      CAMPAIGN_NAME
,      CAMPAIGN_DESCRIPTION
,      STATUS_NAME
,      STATUS_DESCRIPTION
FROM APPS.BIM_DIMV_CAMPAIGNS;

Dependencies

[top of page]

APPS.BIM_DIMV_CAMPAIGNS references the following:

APPS: AMS_CAMPAIGNS_VL; AMS_SOURCE_CODES_DETAILS_V; BIM_I_SOURCE_CODES; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.BIM_DIMV_CAMPAIGNS is not referenced by any database object