Skip to content

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

TABLE: BIM.EDW_BIM_CAMP_CMPGNS_L1_LSTG

Object Details
Object Name: EDW_BIM_CAMP_CMPGNS_L1_LSTG
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_CAMP_CMPGNS_L1_LSTG
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_CAMP_CMPGNS_L1_LSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCAMPAIGN_PK
EDW_BIM_CAMP_CMPGNS_L1_LSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_PK VARCHAR2 (320)
Unique Identifier for Campaign
ROW_ID ROWID (10)
Row Identifier
PARENT_CAMPAIGN_FK VARCHAR2 (320)
Foerign Key to Campaign Level 2
PARENT_CAMPAIGN_FK_KEY NUMBER

System Generated Foerign Key to Campaign Level 2
CAMPAIGN_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely
NAME VARCHAR2 (240)
Reserved for future use in Express deprecated
CAMPAIGN_ID NUMBER

Unique identifier of Campaign
SOURCE_CODE VARCHAR2 (40)
Source Code for Campaign
ROLLUP_TYPE VARCHAR2 (40)
Rollup Type for Campaign (Execution or Rollup)
CAMPAIGN_TYPE VARCHAR2 (40)
Purpose of the Campaign
FORECASTED_PLAN_START_DATE DATE

Forecasted Plan Start Date
FORECASTED_PLAN_END_DATE DATE

Forecasted Plan End Date
FORECASTED_EXEC_START_DATE DATE

Forecasted Execution Start Date
FORECASTED_EXEC_END_DATE DATE

Forecasted Execution End Date
ACTUAL_PLAN_START_DATE DATE

Actual Plan Start Date
ACTUAL_PLAN_END_DATE DATE

Actual Plan End Date
ACTUAL_EXEC_START_DATE DATE

Actual Execution Start Date
ACTUAL_EXEC_END_DATE DATE

Actual Execution End Date
CAMPAIGN_NAME VARCHAR2 (240)
Name of the Campaign
DESCRIPTION VARCHAR2 (4000)
Long Description of the Campaign
INSTANCE VARCHAR2 (40)
Instance Identifier
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
REQUEST_ID NUMBER

Standard Who Column
OPERATION_CODE VARCHAR2 (40)
Code used during warehouse collection
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
SECURITY_GROUP_ID NUMBER

Standard Who Column
Query Text

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


SELECT CAMPAIGN_PK
,      ROW_ID
,      PARENT_CAMPAIGN_FK
,      PARENT_CAMPAIGN_FK_KEY
,      CAMPAIGN_DP
,      NAME
,      CAMPAIGN_ID
,      SOURCE_CODE
,      ROLLUP_TYPE
,      CAMPAIGN_TYPE
,      FORECASTED_PLAN_START_DATE
,      FORECASTED_PLAN_END_DATE
,      FORECASTED_EXEC_START_DATE
,      FORECASTED_EXEC_END_DATE
,      ACTUAL_PLAN_START_DATE
,      ACTUAL_PLAN_END_DATE
,      ACTUAL_EXEC_START_DATE
,      ACTUAL_EXEC_END_DATE
,      CAMPAIGN_NAME
,      DESCRIPTION
,      INSTANCE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      REQUEST_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
,      SECURITY_GROUP_ID
FROM BIM.EDW_BIM_CAMP_CMPGNS_L1_LSTG;

Dependencies

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L1_LSTG does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L1_LSTG is referenced by following:

SchemaAPPS
SynonymEDW_BIM_CAMP_CMPGNS_L1_LSTG