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

VIEW: BIM.BIM_LEAD_CONV_SUMM#

Object Details
Object Name: BIM_LEAD_CONV_SUMM#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes
PERIOD_NAME VARCHAR2 (25) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PERIOD_START_DATE DATE
Yes
PERIOD_END_DATE DATE
Yes
MEDIA_ID NUMBER
Yes
CHANNEL_ID VARCHAR2 (80) Yes
MARKET_SEGMENT_ID NUMBER
Yes
SALES_CHANNEL_CODE VARCHAR2 (30) Yes
GEOGRAPHY_CODE VARCHAR2 (240) Yes
NUM_OF_LEADS NUMBER

NUM_OF_OPPORTUNITIES NUMBER

NUM_OF_ORDERS NUMBER

NUM_OF_ORDERS_FROM_LEADS NUMBER

NUM_OF_ORDERS_FROM_OPPS NUMBER

SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT CAMPAIGN_ID
,      PERIOD_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      MEDIA_ID
,      CHANNEL_ID
,      MARKET_SEGMENT_ID
,      SALES_CHANNEL_CODE
,      GEOGRAPHY_CODE
,      NUM_OF_LEADS
,      NUM_OF_OPPORTUNITIES
,      NUM_OF_ORDERS
,      NUM_OF_ORDERS_FROM_LEADS
,      NUM_OF_ORDERS_FROM_OPPS
,      SECURITY_GROUP_ID
FROM BIM.BIM_LEAD_CONV_SUMM#;

Dependencies

[top of page]

BIM.BIM_LEAD_CONV_SUMM# references the following:

SchemaBIM
TableBIM_LEAD_CONV_SUMM
BIM.BIM_LEAD_CONV_SUMM# is referenced by following:

SchemaAPPS
SynonymBIM_LEAD_CONV_SUMM