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

VIEW: BIM.BIM_CUSTOMER_REV_SUMM#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER
Yes
CUST_ACCOUNT_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
FIRST_ORDER_DATE DATE
Yes
CAMPAIGN_ID NUMBER
Yes
MEDIA_ID NUMBER
Yes
CHANNEL_ID VARCHAR2 (80) Yes
MARKET_SEGMENT_ID NUMBER
Yes
TARGET_SEGMENT_ID NUMBER
Yes
SALES_CHANNEL_CODE VARCHAR2 (30) Yes
INTEREST_TYPE_ID NUMBER
Yes
PRIMARY_INTEREST_CODE_ID NUMBER
Yes
SECONDARY_INTEREST_CODE_ID NUMBER
Yes
BILL_TO_GEOGRAPHY_CODE VARCHAR2 (240) Yes
SHIP_TO_GEOGRAPHY_CODE VARCHAR2 (240) Yes
INITIATED_REVENUE NUMBER

SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT CUSTOMER_ID
,      CUST_ACCOUNT_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
,      FIRST_ORDER_DATE
,      CAMPAIGN_ID
,      MEDIA_ID
,      CHANNEL_ID
,      MARKET_SEGMENT_ID
,      TARGET_SEGMENT_ID
,      SALES_CHANNEL_CODE
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      BILL_TO_GEOGRAPHY_CODE
,      SHIP_TO_GEOGRAPHY_CODE
,      INITIATED_REVENUE
,      SECURITY_GROUP_ID
FROM BIM.BIM_CUSTOMER_REV_SUMM#;

Dependencies

[top of page]

BIM.BIM_CUSTOMER_REV_SUMM# references the following:

SchemaBIM
TableBIM_CUSTOMER_REV_SUMM
BIM.BIM_CUSTOMER_REV_SUMM# is referenced by following:

SchemaAPPS
SynonymBIM_CUSTOMER_REV_SUMM