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: ViewBIM.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 Mandatory 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:

SchemaAPPS
ViewAMS_CAMPAIGNS_VL
ViewAMS_SOURCE_CODES_DETAILS_V
SynonymBIM_I_SOURCE_CODES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIM_DIMV_CAMPAIGNS is not referenced by any database object