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.

VIEW: BIM.EDW_BIM_OPPORTUNITIES_M#

Source

View Text - Preformatted


select L2_OPPLINE_PK_KEY L2_OPPLINE_PK_KEY, L1_OPPORTUNITY_PK_KEY L1_OPPORTUNITY_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_OPPORTUNITY_PK L1_OPPORTUNITY_PK, L1_OPPORTUNITY_DP L1_OPPORTUNITY_DP, L1_NAME L1_NAME, L1_OPPORTUNITY_LEAD_ID L1_OPPORTUNITY_LEAD_ID, L1_OPP_LEAD_NUMBER L1_OPP_LEAD_NUMBER, L1_WIN_PROBABILITY L1_WIN_PROBABILITY, L1_SALES_STAGE_ID L1_SALES_STAGE_ID, L1_PRICE_LIST_ID L1_PRICE_LIST_ID, L1_INITIATING_CONTACT_ID L1_INITIATING_CONTACT_ID, L1_CLOSE_COMPETITOR_ID L1_CLOSE_COMPETITOR_ID, L1_SOURCE_PROMOTION_ID L1_SOURCE_PROMOTION_ID, L1_ADDRESS_ID L1_ADDRESS_ID, L1_CUSTOMER_ID L1_CUSTOMER_ID, L1_RANK L1_RANK, L1_PARENT_PROJECT L1_PARENT_PROJECT, L1_NO_OPP_ALLOWED_FLAG L1_NO_OPP_ALLOWED_FLAG, L1_LEAD_SOURCE_CODE L1_LEAD_SOURCE_CODE, L1_END_USER_CUSTOMER_NAME L1_END_USER_CUSTOMER_NAME, L1_DELETE_ALLOWED_FLAG L1_DELETE_ALLOWED_FLAG, L1_DECISION_DATE_FLAG L1_DECISION_DATE_FLAG, L1_CURRENCY_CODE L1_CURRENCY_CODE, L1_TOTAL_AMOUNT L1_TOTAL_AMOUNT, L1_CLOSE_REASON L1_CLOSE_REASON, L1_CLOSE_COMPETITOR_CODE L1_CLOSE_COMPETITOR_CODE, L1_CLOSE_COMPETITOR L1_CLOSE_COMPETITOR, L1_CLOSE_COMMENT L1_CLOSE_COMMENT, L1_CHANNEL_CODE L1_CHANNEL_CODE, L1_DECISION_DATE L1_DECISION_DATE, L1_OPP_DESCRIPTION L1_OPP_DESCRIPTION, L1_INSTANCE L1_INSTANCE, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5, L2_OPPLINE_PK L2_OPPLINE_PK, L2_OPPLINE_DP L2_OPPLINE_DP, L2_NAME L2_NAME, L2_OPP_LEAD_LINE_ID L2_OPP_LEAD_LINE_ID, L2_LEAD_ID L2_LEAD_ID, L2_WIN_PROBABILITY L2_WIN_PROBABILITY, L2_SALES_STAGE_ID L2_SALES_STAGE_ID, L2_PRICE_VOLUME_MARGIN L2_PRICE_VOLUME_MARGIN, L2_PRICE L2_PRICE, L2_ORIG_OPPORTUNITY_LINE_ID L2_ORIG_OPPORTUNITY_LINE_ID, L2_ORIGINAL_LEAD_LINE_ID L2_ORIGINAL_LEAD_LINE_ID, L2_QUOTED_LINE_FLAG L2_QUOTED_LINE_FLAG, L2_CHANNEL_CODE L2_CHANNEL_CODE, L2_SHIP_DATE L2_SHIP_DATE, L2_DECISION_DATE L2_DECISION_DATE, L2_INSTANCE L2_INSTANCE, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5, L2_LAST_UPDATE_DATE L2_LAST_UPDATE_DATE, L2_CREATION_DATE L2_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, L1_ORIG_SYSTEM_REFERENCE L1_ORIG_SYSTEM_REFERENCE, L1_VEHICLE_RESPONSE_CODE L1_VEHICLE_RESPONSE_CODE, L1_DECISION_TIMEFRAME_CODE L1_DECISION_TIMEFRAME_CODE, L1_DELETED_FLAG L1_DELETED_FLAG from "BIM"."EDW_BIM_OPPORTUNITIES_M"

View Text - HTML Formatted

SELECT L2_OPPLINE_PK_KEY L2_OPPLINE_PK_KEY
, L1_OPPORTUNITY_PK_KEY L1_OPPORTUNITY_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_OPPORTUNITY_PK L1_OPPORTUNITY_PK
, L1_OPPORTUNITY_DP L1_OPPORTUNITY_DP
, L1_NAME L1_NAME
, L1_OPPORTUNITY_LEAD_ID L1_OPPORTUNITY_LEAD_ID
, L1_OPP_LEAD_NUMBER L1_OPP_LEAD_NUMBER
, L1_WIN_PROBABILITY L1_WIN_PROBABILITY
, L1_SALES_STAGE_ID L1_SALES_STAGE_ID
, L1_PRICE_LIST_ID L1_PRICE_LIST_ID
, L1_INITIATING_CONTACT_ID L1_INITIATING_CONTACT_ID
, L1_CLOSE_COMPETITOR_ID L1_CLOSE_COMPETITOR_ID
, L1_SOURCE_PROMOTION_ID L1_SOURCE_PROMOTION_ID
, L1_ADDRESS_ID L1_ADDRESS_ID
, L1_CUSTOMER_ID L1_CUSTOMER_ID
, L1_RANK L1_RANK
, L1_PARENT_PROJECT L1_PARENT_PROJECT
, L1_NO_OPP_ALLOWED_FLAG L1_NO_OPP_ALLOWED_FLAG
, L1_LEAD_SOURCE_CODE L1_LEAD_SOURCE_CODE
, L1_END_USER_CUSTOMER_NAME L1_END_USER_CUSTOMER_NAME
, L1_DELETE_ALLOWED_FLAG L1_DELETE_ALLOWED_FLAG
, L1_DECISION_DATE_FLAG L1_DECISION_DATE_FLAG
, L1_CURRENCY_CODE L1_CURRENCY_CODE
, L1_TOTAL_AMOUNT L1_TOTAL_AMOUNT
, L1_CLOSE_REASON L1_CLOSE_REASON
, L1_CLOSE_COMPETITOR_CODE L1_CLOSE_COMPETITOR_CODE
, L1_CLOSE_COMPETITOR L1_CLOSE_COMPETITOR
, L1_CLOSE_COMMENT L1_CLOSE_COMMENT
, L1_CHANNEL_CODE L1_CHANNEL_CODE
, L1_DECISION_DATE L1_DECISION_DATE
, L1_OPP_DESCRIPTION L1_OPP_DESCRIPTION
, L1_INSTANCE L1_INSTANCE
, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5
, L2_OPPLINE_PK L2_OPPLINE_PK
, L2_OPPLINE_DP L2_OPPLINE_DP
, L2_NAME L2_NAME
, L2_OPP_LEAD_LINE_ID L2_OPP_LEAD_LINE_ID
, L2_LEAD_ID L2_LEAD_ID
, L2_WIN_PROBABILITY L2_WIN_PROBABILITY
, L2_SALES_STAGE_ID L2_SALES_STAGE_ID
, L2_PRICE_VOLUME_MARGIN L2_PRICE_VOLUME_MARGIN
, L2_PRICE L2_PRICE
, L2_ORIG_OPPORTUNITY_LINE_ID L2_ORIG_OPPORTUNITY_LINE_ID
, L2_ORIGINAL_LEAD_LINE_ID L2_ORIGINAL_LEAD_LINE_ID
, L2_QUOTED_LINE_FLAG L2_QUOTED_LINE_FLAG
, L2_CHANNEL_CODE L2_CHANNEL_CODE
, L2_SHIP_DATE L2_SHIP_DATE
, L2_DECISION_DATE L2_DECISION_DATE
, L2_INSTANCE L2_INSTANCE
, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1
, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2
, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3
, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4
, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5
, L2_LAST_UPDATE_DATE L2_LAST_UPDATE_DATE
, L2_CREATION_DATE L2_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, L1_ORIG_SYSTEM_REFERENCE L1_ORIG_SYSTEM_REFERENCE
, L1_VEHICLE_RESPONSE_CODE L1_VEHICLE_RESPONSE_CODE
, L1_DECISION_TIMEFRAME_CODE L1_DECISION_TIMEFRAME_CODE
, L1_DELETED_FLAG L1_DELETED_FLAG
FROM "BIM"."EDW_BIM_OPPORTUNITIES_M"