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

TABLE: BIM.EDW_BIM_CMPGNS_M

Object Details
Object Name: EDW_BIM_CMPGNS_M
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_CMPGNS_M
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_BIM_CMPGNS_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL10_CAMPAIGN_SCHEDULE_PK
ColumnL10_CAMPAIGN_SCHEDULE_PK_KEY
EDW_BIM_CMPGNS_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL10_CAMPAIGN_SCHEDULE_PK_KEY
Columns
Name Datatype Length Mandatory Comments
L10_CAMPAIGN_SCHEDULE_PK_KEY NUMBER
Yes System Generated Unique Identifier for Campaign Schedule .
L9_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level .
L8_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 8.
L7_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 7.
L6_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 6.
L5_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 5.
L4_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 4.
L3_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 3.
L2_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 2.
L1_CAMPAIGN_PK_KEY NUMBER

System Generated Unique Identifier for Campaign level 1.
L0_ALL_PK_KEY NUMBER

System Generated Unique Identifier for All Level .
L0_ALL_PK VARCHAR2 (40)
Unique identifier for All level .
L0_NAME VARCHAR2 (80)
Reserved for future use in Express .
L1_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L1_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L1_NAME VARCHAR2 (240)
Reserved for future use in Express .
L1_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L1_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L1_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L1_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L1_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L1_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L1_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L1_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L1_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L1_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L1_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L1_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L1_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L1_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L1_INSTANCE VARCHAR2 (40)
Instance identifier .
L1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L2_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L2_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L2_NAME VARCHAR2 (240)
Reserved for future use in Express .
L2_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L2_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L2_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L2_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L2_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L2_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L2_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L2_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L2_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L2_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L2_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L2_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L2_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L2_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L2_INSTANCE VARCHAR2 (40)
Instance identifier .
L2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L3_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L3_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L3_NAME VARCHAR2 (240)
Reserved for future use in Express .
L3_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L3_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L3_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L3_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L3_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L3_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L3_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L3_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L3_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L3_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L3_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L3_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L3_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L3_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L3_INSTANCE VARCHAR2 (40)
Instance identifier .
L3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L4_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L4_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L4_NAME VARCHAR2 (240)
Reserved for future use in Express .
L4_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L4_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L4_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L4_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L4_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L4_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L4_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L4_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L4_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L4_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L4_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L4_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L4_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L4_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L4_INSTANCE VARCHAR2 (40)
Instance identifier .
L4_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L5_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L5_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L5_NAME VARCHAR2 (240)
Reserved for future use in Express .
L5_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L5_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L5_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L5_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L5_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L5_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L5_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L5_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L5_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L5_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L5_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L5_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L5_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L5_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L5_INSTANCE VARCHAR2 (40)
Instance identifier .
L5_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L6_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L6_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L6_NAME VARCHAR2 (240)
Reserved for future use in Express .
L6_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L6_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L6_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L6_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L6_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L6_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L6_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L6_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L6_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L6_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L6_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L6_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L6_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L6_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L6_INSTANCE VARCHAR2 (40)
Instance identifier .
L6_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L7_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L7_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L7_NAME VARCHAR2 (240)
Reserved for future use in Express .
L7_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L7_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L7_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L7_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L7_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L7_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L7_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L7_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L7_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L7_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L7_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L7_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L7_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L7_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L7_INSTANCE VARCHAR2 (40)
Instance identifier .
L7_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L8_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L8_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L8_NAME VARCHAR2 (240)
Reserved for future use in Express .
L8_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L8_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L8_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L8_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L8_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L8_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L8_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L8_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L8_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L8_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L8_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L8_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L8_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L8_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L8_INSTANCE VARCHAR2 (40)
Instance identifier .
L8_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L8_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L8_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L8_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L8_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L9_CAMPAIGN_PK VARCHAR2 (320)
Unique identifier for campaign .
L9_CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L9_NAME VARCHAR2 (240)
Reserved for future use in Express .
L9_CAMPAIGN_ID NUMBER

OLTP unique identifier for campaign .
L9_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign .
L9_ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup) .
L9_CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign .
L9_FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date .
L9_FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date .
L9_FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date .
L9_FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date .
L9_ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date .
L9_ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date .
L9_ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date .
L9_ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date .
L9_CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign .
L9_DESCRIPTION VARCHAR2 (4000)
Long description of the campaign .
L9_INSTANCE VARCHAR2 (40)
Instance identifier .
L9_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L10_CAMPAIGN_SCHEDULE_PK VARCHAR2 (320)
Unique identiifier for campaign schedule .
L10_CAMPAIGN_SCHEDULE_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L10_NAME VARCHAR2 (240)
Reserved for future use in Express .
L10_LEVEL_NAME VARCHAR2 (80)
Indicates whether the record is campaign or campaign schedule .
L10_CAMPAIGN_SCHEDULE_ID NUMBER

OLTP unique identifier for campaign schedule .
L10_SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign Schedule .
L10_FREQUENCY NUMBER

Frequency of the Campaign Schedule .
L10_FREQUENCY_UOM_CODE VARCHAR2 (40)
Unit of Frequency .
L10_DELIVERABLE_ID NUMBER

OLTP Unique Identifier of Deliverable associated with Campaign Schedule .
L10_ACTIVITY_OFFER_ID NUMBER

OLTP Unique Identifier of Activity Offer associated with the Campaign Schedule .
L10_FORECASTED_START_DATE_TIME DATE

Forecasted Start Date Time .
L10_FORECASTED_END_DATE_TIME DATE

Forecasted End Date Time .
L10_ACTUAL_START_DATE_TIME DATE

Actual Start Date Time .
L10_ACTUAL_END_DATE_TIME DATE

Actual End Date Time .
L10_INSTANCE VARCHAR2 (40)
Instance identifier .
L10_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L10_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L10_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L10_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L10_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L10_LAST_UPDATE_DATE DATE

Standard Who Column .
L10_CREATION_DATE DATE

Standard Who Column .
SECURITY_GROUP_ID NUMBER

Standard Who Column .
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
Query Text

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


SELECT L10_CAMPAIGN_SCHEDULE_PK_KEY
,      L9_CAMPAIGN_PK_KEY
,      L8_CAMPAIGN_PK_KEY
,      L7_CAMPAIGN_PK_KEY
,      L6_CAMPAIGN_PK_KEY
,      L5_CAMPAIGN_PK_KEY
,      L4_CAMPAIGN_PK_KEY
,      L3_CAMPAIGN_PK_KEY
,      L2_CAMPAIGN_PK_KEY
,      L1_CAMPAIGN_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_CAMPAIGN_PK
,      L1_CAMPAIGN_DP
,      L1_NAME
,      L1_CAMPAIGN_ID
,      L1_SOURCE_CODE
,      L1_ROLLUP_TYPE
,      L1_CAMPAIGN_TYPE
,      L1_FORECASTED_PLAN_START_DATE
,      L1_FORECASTED_PLAN_END_DATE
,      L1_FORECASTED_EXEC_START_DATE
,      L1_FORECASTED_EXEC_END_DATE
,      L1_ACTUAL_PLAN_START_DATE
,      L1_ACTUAL_PLAN_END_DATE
,      L1_ACTUAL_EXEC_START_DATE
,      L1_ACTUAL_EXEC_END_DATE
,      L1_CAMPAIGN_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_CAMPAIGN_PK
,      L2_CAMPAIGN_DP
,      L2_NAME
,      L2_CAMPAIGN_ID
,      L2_SOURCE_CODE
,      L2_ROLLUP_TYPE
,      L2_CAMPAIGN_TYPE
,      L2_FORECASTED_PLAN_START_DATE
,      L2_FORECASTED_PLAN_END_DATE
,      L2_FORECASTED_EXEC_START_DATE
,      L2_FORECASTED_EXEC_END_DATE
,      L2_ACTUAL_PLAN_START_DATE
,      L2_ACTUAL_PLAN_END_DATE
,      L2_ACTUAL_EXEC_START_DATE
,      L2_ACTUAL_EXEC_END_DATE
,      L2_CAMPAIGN_NAME
,      L2_DESCRIPTION
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L3_CAMPAIGN_PK
,      L3_CAMPAIGN_DP
,      L3_NAME
,      L3_CAMPAIGN_ID
,      L3_SOURCE_CODE
,      L3_ROLLUP_TYPE
,      L3_CAMPAIGN_TYPE
,      L3_FORECASTED_PLAN_START_DATE
,      L3_FORECASTED_PLAN_END_DATE
,      L3_FORECASTED_EXEC_START_DATE
,      L3_FORECASTED_EXEC_END_DATE
,      L3_ACTUAL_PLAN_START_DATE
,      L3_ACTUAL_PLAN_END_DATE
,      L3_ACTUAL_EXEC_START_DATE
,      L3_ACTUAL_EXEC_END_DATE
,      L3_CAMPAIGN_NAME
,      L3_DESCRIPTION
,      L3_INSTANCE
,      L3_USER_ATTRIBUTE1
,      L3_USER_ATTRIBUTE2
,      L3_USER_ATTRIBUTE3
,      L3_USER_ATTRIBUTE4
,      L3_USER_ATTRIBUTE5
,      L4_CAMPAIGN_PK
,      L4_CAMPAIGN_DP
,      L4_NAME
,      L4_CAMPAIGN_ID
,      L4_SOURCE_CODE
,      L4_ROLLUP_TYPE
,      L4_CAMPAIGN_TYPE
,      L4_FORECASTED_PLAN_START_DATE
,      L4_FORECASTED_PLAN_END_DATE
,      L4_FORECASTED_EXEC_START_DATE
,      L4_FORECASTED_EXEC_END_DATE
,      L4_ACTUAL_PLAN_START_DATE
,      L4_ACTUAL_PLAN_END_DATE
,      L4_ACTUAL_EXEC_START_DATE
,      L4_ACTUAL_EXEC_END_DATE
,      L4_CAMPAIGN_NAME
,      L4_DESCRIPTION
,      L4_INSTANCE
,      L4_USER_ATTRIBUTE1
,      L4_USER_ATTRIBUTE2
,      L4_USER_ATTRIBUTE3
,      L4_USER_ATTRIBUTE4
,      L4_USER_ATTRIBUTE5
,      L5_CAMPAIGN_PK
,      L5_CAMPAIGN_DP
,      L5_NAME
,      L5_CAMPAIGN_ID
,      L5_SOURCE_CODE
,      L5_ROLLUP_TYPE
,      L5_CAMPAIGN_TYPE
,      L5_FORECASTED_PLAN_START_DATE
,      L5_FORECASTED_PLAN_END_DATE
,      L5_FORECASTED_EXEC_START_DATE
,      L5_FORECASTED_EXEC_END_DATE
,      L5_ACTUAL_PLAN_START_DATE
,      L5_ACTUAL_PLAN_END_DATE
,      L5_ACTUAL_EXEC_START_DATE
,      L5_ACTUAL_EXEC_END_DATE
,      L5_CAMPAIGN_NAME
,      L5_DESCRIPTION
,      L5_INSTANCE
,      L5_USER_ATTRIBUTE1
,      L5_USER_ATTRIBUTE2
,      L5_USER_ATTRIBUTE3
,      L5_USER_ATTRIBUTE4
,      L5_USER_ATTRIBUTE5
,      L6_CAMPAIGN_PK
,      L6_CAMPAIGN_DP
,      L6_NAME
,      L6_CAMPAIGN_ID
,      L6_SOURCE_CODE
,      L6_ROLLUP_TYPE
,      L6_CAMPAIGN_TYPE
,      L6_FORECASTED_PLAN_START_DATE
,      L6_FORECASTED_PLAN_END_DATE
,      L6_FORECASTED_EXEC_START_DATE
,      L6_FORECASTED_EXEC_END_DATE
,      L6_ACTUAL_PLAN_START_DATE
,      L6_ACTUAL_PLAN_END_DATE
,      L6_ACTUAL_EXEC_START_DATE
,      L6_ACTUAL_EXEC_END_DATE
,      L6_CAMPAIGN_NAME
,      L6_DESCRIPTION
,      L6_INSTANCE
,      L6_USER_ATTRIBUTE1
,      L6_USER_ATTRIBUTE2
,      L6_USER_ATTRIBUTE3
,      L6_USER_ATTRIBUTE4
,      L6_USER_ATTRIBUTE5
,      L7_CAMPAIGN_PK
,      L7_CAMPAIGN_DP
,      L7_NAME
,      L7_CAMPAIGN_ID
,      L7_SOURCE_CODE
,      L7_ROLLUP_TYPE
,      L7_CAMPAIGN_TYPE
,      L7_FORECASTED_PLAN_START_DATE
,      L7_FORECASTED_PLAN_END_DATE
,      L7_FORECASTED_EXEC_START_DATE
,      L7_FORECASTED_EXEC_END_DATE
,      L7_ACTUAL_PLAN_START_DATE
,      L7_ACTUAL_PLAN_END_DATE
,      L7_ACTUAL_EXEC_START_DATE
,      L7_ACTUAL_EXEC_END_DATE
,      L7_CAMPAIGN_NAME
,      L7_DESCRIPTION
,      L7_INSTANCE
,      L7_USER_ATTRIBUTE1
,      L7_USER_ATTRIBUTE2
,      L7_USER_ATTRIBUTE3
,      L7_USER_ATTRIBUTE4
,      L7_USER_ATTRIBUTE5
,      L8_CAMPAIGN_PK
,      L8_CAMPAIGN_DP
,      L8_NAME
,      L8_CAMPAIGN_ID
,      L8_SOURCE_CODE
,      L8_ROLLUP_TYPE
,      L8_CAMPAIGN_TYPE
,      L8_FORECASTED_PLAN_START_DATE
,      L8_FORECASTED_PLAN_END_DATE
,      L8_FORECASTED_EXEC_START_DATE
,      L8_FORECASTED_EXEC_END_DATE
,      L8_ACTUAL_PLAN_START_DATE
,      L8_ACTUAL_PLAN_END_DATE
,      L8_ACTUAL_EXEC_START_DATE
,      L8_ACTUAL_EXEC_END_DATE
,      L8_CAMPAIGN_NAME
,      L8_DESCRIPTION
,      L8_INSTANCE
,      L8_USER_ATTRIBUTE1
,      L8_USER_ATTRIBUTE2
,      L8_USER_ATTRIBUTE3
,      L8_USER_ATTRIBUTE4
,      L8_USER_ATTRIBUTE5
,      L9_CAMPAIGN_PK
,      L9_CAMPAIGN_DP
,      L9_NAME
,      L9_CAMPAIGN_ID
,      L9_SOURCE_CODE
,      L9_ROLLUP_TYPE
,      L9_CAMPAIGN_TYPE
,      L9_FORECASTED_PLAN_START_DATE
,      L9_FORECASTED_PLAN_END_DATE
,      L9_FORECASTED_EXEC_START_DATE
,      L9_FORECASTED_EXEC_END_DATE
,      L9_ACTUAL_PLAN_START_DATE
,      L9_ACTUAL_PLAN_END_DATE
,      L9_ACTUAL_EXEC_START_DATE
,      L9_ACTUAL_EXEC_END_DATE
,      L9_CAMPAIGN_NAME
,      L9_DESCRIPTION
,      L9_INSTANCE
,      L9_USER_ATTRIBUTE1
,      L9_USER_ATTRIBUTE2
,      L9_USER_ATTRIBUTE3
,      L9_USER_ATTRIBUTE4
,      L9_USER_ATTRIBUTE5
,      L10_CAMPAIGN_SCHEDULE_PK
,      L10_CAMPAIGN_SCHEDULE_DP
,      L10_NAME
,      L10_LEVEL_NAME
,      L10_CAMPAIGN_SCHEDULE_ID
,      L10_SOURCE_CODE
,      L10_FREQUENCY
,      L10_FREQUENCY_UOM_CODE
,      L10_DELIVERABLE_ID
,      L10_ACTIVITY_OFFER_ID
,      L10_FORECASTED_START_DATE_TIME
,      L10_FORECASTED_END_DATE_TIME
,      L10_ACTUAL_START_DATE_TIME
,      L10_ACTUAL_END_DATE_TIME
,      L10_INSTANCE
,      L10_USER_ATTRIBUTE1
,      L10_USER_ATTRIBUTE2
,      L10_USER_ATTRIBUTE3
,      L10_USER_ATTRIBUTE4
,      L10_USER_ATTRIBUTE5
,      L10_LAST_UPDATE_DATE
,      L10_CREATION_DATE
,      SECURITY_GROUP_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM BIM.EDW_BIM_CMPGNS_M;

Dependencies

[top of page]

BIM.EDW_BIM_CMPGNS_M does not reference any database object

BIM.EDW_BIM_CMPGNS_M is referenced by following:

SchemaAPPS
SynonymEDW_BIM_CMPGNS_M