[Home] [Help]
View: EDW_BIM_OPPR_OPRNTIES_LTC_IV
| Product: | BIM - Marketing Intelligence |
|---|
| 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 |