[Home] [Help]
View: EDW_BIM_OPPR_OPRNTIES_LTC_IV
Product: | BIM - Marketing Intelligence(Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ROWID ROW_ID
, WIN_PROBABILITY
, TOTAL_AMOUNT
, SALES_STAGE_ID
, PRICE_LIST_ID
, OPPORTUNITY_PK_KEY
, OPPORTUNITY_LEAD_ID
, INITIATING_CONTACT_ID
, CLOSE_COMPETITOR_ID
, ALL_FK_KEY
, SOURCE_PROMOTION_ID
, ADDRESS_ID
, CUSTOMER_ID
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, RANK
, PARENT_PROJECT
, OPP_LEAD_NUMBER
, OPP_DESCRIPTION
, OPPORTUNITY_PK
, OPPORTUNITY_DP
, NO_OPP_ALLOWED_FLAG
, NAME
, LEAD_SOURCE_CODE
, INSTANCE
, END_USER_CUSTOMER_NAME
, DELETE_ALLOWED_FLAG
, DECISION_DATE_FLAG
, CURRENCY_CODE
, CLOSE_REASON
, CLOSE_COMPETITOR_CODE
, CLOSE_COMPETITOR
, CLOSE_COMMENT
, ORIG_SYSTEM_REFERENCE
, DECISION_TIMEFRAME_CODE
, VEHICLE_RESPONSE_CODE
, DELETED_FLAG
, ALL_FK
, CHANNEL_CODE
, DECISION_DATE
, SECURITY_GROUP_ID
, USER_ATTRIBUTE5 OPERATION_CODE
FROM EDW_BIM_OPPR_OPRNTIES_LTC
Columns
Name |
ROW_ID |
WIN_PROBABILITY |
TOTAL_AMOUNT |
SALES_STAGE_ID |
PRICE_LIST_ID |
OPPORTUNITY_PK_KEY |
OPPORTUNITY_LEAD_ID |
INITIATING_CONTACT_ID |
CLOSE_COMPETITOR_ID |
ALL_FK_KEY |
SOURCE_PROMOTION_ID |
ADDRESS_ID |
CUSTOMER_ID |
USER_ATTRIBUTE5 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE1 |
RANK |
PARENT_PROJECT |
OPP_LEAD_NUMBER |
OPP_DESCRIPTION |
OPPORTUNITY_PK |
OPPORTUNITY_DP |
NO_OPP_ALLOWED_FLAG |
NAME |
LEAD_SOURCE_CODE |
INSTANCE |
END_USER_CUSTOMER_NAME |
DELETE_ALLOWED_FLAG |
DECISION_DATE_FLAG |
CURRENCY_CODE |
CLOSE_REASON |
CLOSE_COMPETITOR_CODE |
CLOSE_COMPETITOR |
CLOSE_COMMENT |
ORIG_SYSTEM_REFERENCE |
DECISION_TIMEFRAME_CODE |
VEHICLE_RESPONSE_CODE |
DELETED_FLAG |
ALL_FK |
CHANNEL_CODE |
DECISION_DATE |
SECURITY_GROUP_ID |
OPERATION_CODE |