eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.EDW_BIM_OPPR_OPRNTIES_LTC#

Source

View Text - Preformatted


select OPPORTUNITY_PK OPPORTUNITY_PK, OPPORTUNITY_PK_KEY OPPORTUNITY_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, OPPORTUNITY_DP OPPORTUNITY_DP, NAME NAME, OPPORTUNITY_LEAD_ID OPPORTUNITY_LEAD_ID, OPP_LEAD_NUMBER OPP_LEAD_NUMBER, WIN_PROBABILITY WIN_PROBABILITY, SALES_STAGE_ID SALES_STAGE_ID, PRICE_LIST_ID PRICE_LIST_ID, INITIATING_CONTACT_ID INITIATING_CONTACT_ID, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, ADDRESS_ID ADDRESS_ID, CUSTOMER_ID CUSTOMER_ID, RANK RANK, PARENT_PROJECT PARENT_PROJECT, NO_OPP_ALLOWED_FLAG NO_OPP_ALLOWED_FLAG, LEAD_SOURCE_CODE LEAD_SOURCE_CODE, END_USER_CUSTOMER_NAME END_USER_CUSTOMER_NAME, DELETE_ALLOWED_FLAG DELETE_ALLOWED_FLAG, DECISION_DATE_FLAG DECISION_DATE_FLAG, CURRENCY_CODE CURRENCY_CODE, TOTAL_AMOUNT TOTAL_AMOUNT, CLOSE_REASON CLOSE_REASON, CLOSE_COMPETITOR_CODE CLOSE_COMPETITOR_CODE, CLOSE_COMPETITOR CLOSE_COMPETITOR, CLOSE_COMMENT CLOSE_COMMENT, CHANNEL_CODE CHANNEL_CODE, DECISION_DATE DECISION_DATE, OPP_DESCRIPTION OPP_DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE, DELETED_FLAG DELETED_FLAG from "BIM"."EDW_BIM_OPPR_OPRNTIES_LTC"

View Text - HTML Formatted

SELECT OPPORTUNITY_PK OPPORTUNITY_PK
, OPPORTUNITY_PK_KEY OPPORTUNITY_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, OPPORTUNITY_DP OPPORTUNITY_DP
, NAME NAME
, OPPORTUNITY_LEAD_ID OPPORTUNITY_LEAD_ID
, OPP_LEAD_NUMBER OPP_LEAD_NUMBER
, WIN_PROBABILITY WIN_PROBABILITY
, SALES_STAGE_ID SALES_STAGE_ID
, PRICE_LIST_ID PRICE_LIST_ID
, INITIATING_CONTACT_ID INITIATING_CONTACT_ID
, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, ADDRESS_ID ADDRESS_ID
, CUSTOMER_ID CUSTOMER_ID
, RANK RANK
, PARENT_PROJECT PARENT_PROJECT
, NO_OPP_ALLOWED_FLAG NO_OPP_ALLOWED_FLAG
, LEAD_SOURCE_CODE LEAD_SOURCE_CODE
, END_USER_CUSTOMER_NAME END_USER_CUSTOMER_NAME
, DELETE_ALLOWED_FLAG DELETE_ALLOWED_FLAG
, DECISION_DATE_FLAG DECISION_DATE_FLAG
, CURRENCY_CODE CURRENCY_CODE
, TOTAL_AMOUNT TOTAL_AMOUNT
, CLOSE_REASON CLOSE_REASON
, CLOSE_COMPETITOR_CODE CLOSE_COMPETITOR_CODE
, CLOSE_COMPETITOR CLOSE_COMPETITOR
, CLOSE_COMMENT CLOSE_COMMENT
, CHANNEL_CODE CHANNEL_CODE
, DECISION_DATE DECISION_DATE
, OPP_DESCRIPTION OPP_DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE
, DELETED_FLAG DELETED_FLAG
FROM "BIM"."EDW_BIM_OPPR_OPRNTIES_LTC"