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

TABLE: BIM.EDW_BIM_CMPGNS_M_TEMP

Object Details
Object Name: EDW_BIM_CMPGNS_M_TEMP
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID

Temporary Table Details

BIM.EDW_BIM_CMPGNS_M_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
L10_CAMPAIGN_SCHEDULE_PK_KEY NUMBER

L9_CAMPAIGN_PK_KEY NUMBER

L8_CAMPAIGN_PK_KEY NUMBER

L7_CAMPAIGN_PK_KEY NUMBER

L6_CAMPAIGN_PK_KEY NUMBER

L5_CAMPAIGN_PK_KEY NUMBER

L4_CAMPAIGN_PK_KEY NUMBER

L3_CAMPAIGN_PK_KEY NUMBER

L2_CAMPAIGN_PK_KEY NUMBER

L1_CAMPAIGN_PK_KEY NUMBER

L0_ALL_PK_KEY NUMBER

L0_ALL_PK VARCHAR2 (40)
L0_NAME VARCHAR2 (80)
L1_CAMPAIGN_PK VARCHAR2 (320)
L1_CAMPAIGN_DP VARCHAR2 (240)
L1_NAME VARCHAR2 (240)
L1_CAMPAIGN_ID NUMBER

L1_SOURCE_CODE VARCHAR2 (40)
L1_ROLLUP_TYPE VARCHAR2 (40)
L1_CAMPAIGN_TYPE VARCHAR2 (40)
L1_FORECASTED_PLAN_START_DATE DATE

L1_FORECASTED_PLAN_END_DATE DATE

L1_FORECASTED_EXEC_START_DATE DATE

L1_FORECASTED_EXEC_END_DATE DATE

L1_ACTUAL_PLAN_START_DATE DATE

L1_ACTUAL_PLAN_END_DATE DATE

L1_ACTUAL_EXEC_START_DATE DATE

L1_ACTUAL_EXEC_END_DATE DATE

L1_CAMPAIGN_NAME VARCHAR2 (240)
L1_DESCRIPTION VARCHAR2 (4000)
L1_INSTANCE VARCHAR2 (40)
L1_USER_ATTRIBUTE1 VARCHAR2 (240)
L1_USER_ATTRIBUTE2 VARCHAR2 (240)
L1_USER_ATTRIBUTE3 VARCHAR2 (240)
L1_USER_ATTRIBUTE4 VARCHAR2 (240)
L1_USER_ATTRIBUTE5 VARCHAR2 (240)
L2_CAMPAIGN_PK VARCHAR2 (320)
L2_CAMPAIGN_DP VARCHAR2 (240)
L2_NAME VARCHAR2 (240)
L2_CAMPAIGN_ID NUMBER

L2_SOURCE_CODE VARCHAR2 (40)
L2_ROLLUP_TYPE VARCHAR2 (40)
L2_CAMPAIGN_TYPE VARCHAR2 (40)
L2_FORECASTED_PLAN_START_DATE DATE

L2_FORECASTED_PLAN_END_DATE DATE

L2_FORECASTED_EXEC_START_DATE DATE

L2_FORECASTED_EXEC_END_DATE DATE

L2_ACTUAL_PLAN_START_DATE DATE

L2_ACTUAL_PLAN_END_DATE DATE

L2_ACTUAL_EXEC_START_DATE DATE

L2_ACTUAL_EXEC_END_DATE DATE

L2_CAMPAIGN_NAME VARCHAR2 (240)
L2_DESCRIPTION VARCHAR2 (4000)
L2_INSTANCE VARCHAR2 (40)
L2_USER_ATTRIBUTE1 VARCHAR2 (240)
L2_USER_ATTRIBUTE2 VARCHAR2 (240)
L2_USER_ATTRIBUTE3 VARCHAR2 (240)
L2_USER_ATTRIBUTE4 VARCHAR2 (240)
L2_USER_ATTRIBUTE5 VARCHAR2 (240)
L3_CAMPAIGN_PK VARCHAR2 (320)
L3_CAMPAIGN_DP VARCHAR2 (240)
L3_NAME VARCHAR2 (240)
L3_CAMPAIGN_ID NUMBER

L3_SOURCE_CODE VARCHAR2 (40)
L3_ROLLUP_TYPE VARCHAR2 (40)
L3_CAMPAIGN_TYPE VARCHAR2 (40)
L3_FORECASTED_PLAN_START_DATE DATE

L3_FORECASTED_PLAN_END_DATE DATE

L3_FORECASTED_EXEC_START_DATE DATE

L3_FORECASTED_EXEC_END_DATE DATE

L3_ACTUAL_PLAN_START_DATE DATE

L3_ACTUAL_PLAN_END_DATE DATE

L3_ACTUAL_EXEC_START_DATE DATE

L3_ACTUAL_EXEC_END_DATE DATE

L3_CAMPAIGN_NAME VARCHAR2 (240)
L3_DESCRIPTION VARCHAR2 (4000)
L3_INSTANCE VARCHAR2 (40)
L3_USER_ATTRIBUTE1 VARCHAR2 (240)
L3_USER_ATTRIBUTE2 VARCHAR2 (240)
L3_USER_ATTRIBUTE3 VARCHAR2 (240)
L3_USER_ATTRIBUTE4 VARCHAR2 (240)
L3_USER_ATTRIBUTE5 VARCHAR2 (240)
L4_CAMPAIGN_PK VARCHAR2 (320)
L4_CAMPAIGN_DP VARCHAR2 (240)
L4_NAME VARCHAR2 (240)
L4_CAMPAIGN_ID NUMBER

L4_SOURCE_CODE VARCHAR2 (40)
L4_ROLLUP_TYPE VARCHAR2 (40)
L4_CAMPAIGN_TYPE VARCHAR2 (40)
L4_FORECASTED_PLAN_START_DATE DATE

L4_FORECASTED_PLAN_END_DATE DATE

L4_FORECASTED_EXEC_START_DATE DATE

L4_FORECASTED_EXEC_END_DATE DATE

L4_ACTUAL_PLAN_START_DATE DATE

L4_ACTUAL_PLAN_END_DATE DATE

L4_ACTUAL_EXEC_START_DATE DATE

L4_ACTUAL_EXEC_END_DATE DATE

L4_CAMPAIGN_NAME VARCHAR2 (240)
L4_DESCRIPTION VARCHAR2 (4000)
L4_INSTANCE VARCHAR2 (40)
L4_USER_ATTRIBUTE1 VARCHAR2 (240)
L4_USER_ATTRIBUTE2 VARCHAR2 (240)
L4_USER_ATTRIBUTE3 VARCHAR2 (240)
L4_USER_ATTRIBUTE4 VARCHAR2 (240)
L4_USER_ATTRIBUTE5 VARCHAR2 (240)
L5_CAMPAIGN_PK VARCHAR2 (320)
L5_CAMPAIGN_DP VARCHAR2 (240)
L5_NAME VARCHAR2 (240)
L5_CAMPAIGN_ID NUMBER

L5_SOURCE_CODE VARCHAR2 (40)
L5_ROLLUP_TYPE VARCHAR2 (40)
L5_CAMPAIGN_TYPE VARCHAR2 (40)
L5_FORECASTED_PLAN_START_DATE DATE

L5_FORECASTED_PLAN_END_DATE DATE

L5_FORECASTED_EXEC_START_DATE DATE

L5_FORECASTED_EXEC_END_DATE DATE

L5_ACTUAL_PLAN_START_DATE DATE

L5_ACTUAL_PLAN_END_DATE DATE

L5_ACTUAL_EXEC_START_DATE DATE

L5_ACTUAL_EXEC_END_DATE DATE

L5_CAMPAIGN_NAME VARCHAR2 (240)
L5_DESCRIPTION VARCHAR2 (4000)
L5_INSTANCE VARCHAR2 (40)
L5_USER_ATTRIBUTE1 VARCHAR2 (240)
L5_USER_ATTRIBUTE2 VARCHAR2 (240)
L5_USER_ATTRIBUTE3 VARCHAR2 (240)
L5_USER_ATTRIBUTE4 VARCHAR2 (240)
L5_USER_ATTRIBUTE5 VARCHAR2 (240)
L6_CAMPAIGN_PK VARCHAR2 (320)
L6_CAMPAIGN_DP VARCHAR2 (240)
L6_NAME VARCHAR2 (240)
L6_CAMPAIGN_ID NUMBER

L6_SOURCE_CODE VARCHAR2 (40)
L6_ROLLUP_TYPE VARCHAR2 (40)
L6_CAMPAIGN_TYPE VARCHAR2 (40)
L6_FORECASTED_PLAN_START_DATE DATE

L6_FORECASTED_PLAN_END_DATE DATE

L6_FORECASTED_EXEC_START_DATE DATE

L6_FORECASTED_EXEC_END_DATE DATE

L6_ACTUAL_PLAN_START_DATE DATE

L6_ACTUAL_PLAN_END_DATE DATE

L6_ACTUAL_EXEC_START_DATE DATE

L6_ACTUAL_EXEC_END_DATE DATE

L6_CAMPAIGN_NAME VARCHAR2 (240)
L6_DESCRIPTION VARCHAR2 (4000)
L6_INSTANCE VARCHAR2 (40)
L6_USER_ATTRIBUTE1 VARCHAR2 (240)
L6_USER_ATTRIBUTE2 VARCHAR2 (240)
L6_USER_ATTRIBUTE3 VARCHAR2 (240)
L6_USER_ATTRIBUTE4 VARCHAR2 (240)
L6_USER_ATTRIBUTE5 VARCHAR2 (240)
L7_CAMPAIGN_PK VARCHAR2 (320)
L7_CAMPAIGN_DP VARCHAR2 (240)
L7_NAME VARCHAR2 (240)
L7_CAMPAIGN_ID NUMBER

L7_SOURCE_CODE VARCHAR2 (40)
L7_ROLLUP_TYPE VARCHAR2 (40)
L7_CAMPAIGN_TYPE VARCHAR2 (40)
L7_FORECASTED_PLAN_START_DATE DATE

L7_FORECASTED_PLAN_END_DATE DATE

L7_FORECASTED_EXEC_START_DATE DATE

L7_FORECASTED_EXEC_END_DATE DATE

L7_ACTUAL_PLAN_START_DATE DATE

L7_ACTUAL_PLAN_END_DATE DATE

L7_ACTUAL_EXEC_START_DATE DATE

L7_ACTUAL_EXEC_END_DATE DATE

L7_CAMPAIGN_NAME VARCHAR2 (240)
L7_DESCRIPTION VARCHAR2 (4000)
L7_INSTANCE VARCHAR2 (40)
L7_USER_ATTRIBUTE1 VARCHAR2 (240)
L7_USER_ATTRIBUTE2 VARCHAR2 (240)
L7_USER_ATTRIBUTE3 VARCHAR2 (240)
L7_USER_ATTRIBUTE4 VARCHAR2 (240)
L7_USER_ATTRIBUTE5 VARCHAR2 (240)
L8_CAMPAIGN_PK VARCHAR2 (320)
L8_CAMPAIGN_DP VARCHAR2 (240)
L8_NAME VARCHAR2 (240)
L8_CAMPAIGN_ID NUMBER

L8_SOURCE_CODE VARCHAR2 (40)
L8_ROLLUP_TYPE VARCHAR2 (40)
L8_CAMPAIGN_TYPE VARCHAR2 (40)
L8_FORECASTED_PLAN_START_DATE DATE

L8_FORECASTED_PLAN_END_DATE DATE

L8_FORECASTED_EXEC_START_DATE DATE

L8_FORECASTED_EXEC_END_DATE DATE

L8_ACTUAL_PLAN_START_DATE DATE

L8_ACTUAL_PLAN_END_DATE DATE

L8_ACTUAL_EXEC_START_DATE DATE

L8_ACTUAL_EXEC_END_DATE DATE

L8_CAMPAIGN_NAME VARCHAR2 (240)
L8_DESCRIPTION VARCHAR2 (4000)
L8_INSTANCE VARCHAR2 (40)
L8_USER_ATTRIBUTE1 VARCHAR2 (240)
L8_USER_ATTRIBUTE2 VARCHAR2 (240)
L8_USER_ATTRIBUTE3 VARCHAR2 (240)
L8_USER_ATTRIBUTE4 VARCHAR2 (240)
L8_USER_ATTRIBUTE5 VARCHAR2 (240)
L9_CAMPAIGN_PK VARCHAR2 (320)
L9_CAMPAIGN_DP VARCHAR2 (240)
L9_NAME VARCHAR2 (240)
L9_CAMPAIGN_ID NUMBER

L9_SOURCE_CODE VARCHAR2 (40)
L9_ROLLUP_TYPE VARCHAR2 (40)
L9_CAMPAIGN_TYPE VARCHAR2 (40)
L9_FORECASTED_PLAN_START_DATE DATE

L9_FORECASTED_PLAN_END_DATE DATE

L9_FORECASTED_EXEC_START_DATE DATE

L9_FORECASTED_EXEC_END_DATE DATE

L9_ACTUAL_PLAN_START_DATE DATE

L9_ACTUAL_PLAN_END_DATE DATE

L9_ACTUAL_EXEC_START_DATE DATE

L9_ACTUAL_EXEC_END_DATE DATE

L9_CAMPAIGN_NAME VARCHAR2 (240)
L9_DESCRIPTION VARCHAR2 (4000)
L9_INSTANCE VARCHAR2 (40)
L9_USER_ATTRIBUTE1 VARCHAR2 (240)
L9_USER_ATTRIBUTE2 VARCHAR2 (240)
L9_USER_ATTRIBUTE3 VARCHAR2 (240)
L9_USER_ATTRIBUTE4 VARCHAR2 (240)
L9_USER_ATTRIBUTE5 VARCHAR2 (240)
L10_CAMPAIGN_SCHEDULE_PK VARCHAR2 (320)
L10_CAMPAIGN_SCHEDULE_DP VARCHAR2 (240)
L10_NAME VARCHAR2 (240)
L10_LEVEL_NAME VARCHAR2 (80)
L10_CAMPAIGN_SCHEDULE_ID NUMBER

L10_SOURCE_CODE VARCHAR2 (40)
L10_FREQUENCY NUMBER

L10_FREQUENCY_UOM_CODE VARCHAR2 (40)
L10_DELIVERABLE_ID NUMBER

L10_ACTIVITY_OFFER_ID NUMBER

L10_FORECASTED_START_DATE_TIME DATE

L10_FORECASTED_END_DATE_TIME DATE

L10_ACTUAL_START_DATE_TIME DATE

L10_ACTUAL_END_DATE_TIME DATE

L10_INSTANCE VARCHAR2 (40)
L10_USER_ATTRIBUTE1 VARCHAR2 (240)
L10_USER_ATTRIBUTE2 VARCHAR2 (240)
L10_USER_ATTRIBUTE3 VARCHAR2 (240)
L10_USER_ATTRIBUTE4 VARCHAR2 (240)
L10_USER_ATTRIBUTE5 VARCHAR2 (240)
L10_LAST_UPDATE_DATE DATE

L10_CREATION_DATE DATE

SECURITY_GROUP_ID NUMBER

ROW_ID1 ROWID (10)
ROW_ID2 ROWID (10)
OPERATION_CODE1 VARCHAR2 (40)
OPERATION_CODE2 VARCHAR2 (40)
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
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM BIM.EDW_BIM_CMPGNS_M_TEMP;

Dependencies

[top of page]

BIM.EDW_BIM_CMPGNS_M_TEMP does not reference any database object

BIM.EDW_BIM_CMPGNS_M_TEMP is referenced by following:

SchemaAPPS
SynonymEDW_BIM_CMPGNS_M_TEMP