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