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: EDW_BIM_OPPR_OPRNTIES_LCV

Product:	BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT OPP.LEAD_ID || '-' || INST.INSTANCE_CODE OPPORTUNITY_PK
, 'ALL' ALL_FK
, OPP.DESCRIPTION OPPORTUNITY_DP
, OPP.DESCRIPTION NAME
, OPP.LEAD_ID OPPORTUNITY_LEAD_ID
, OPP.LEAD_NUMBER OPP_LEAD_NUMBER
, OPP.DESCRIPTION OPP_DESCRIPTION
, OPP.PARENT_PROJECT PARENT_PROJECT
, OPP.WIN_PROBABILITY WIN_PROBABILITY
, OPP.LEAD_SOURCE_CODE LEAD_SOURCE_CODE
, OPP.TOTAL_AMOUNT TOTAL_AMOUNT
, OPP.CURRENCY_CODE CURRENCY_CODE
, OPP.CLOSE_REASON CLOSE_REASON
, OPP.DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE
, OPP.VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, OPP.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, OPP.DELETED_FLAG DELETED_FLAG
, INST.INSTANCE_CODE INSTANCE
, OPP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OPP.CREATION_DATE CREATION_DATE
FROM AS_LEADS_ALL OPP
, EDW_LOCAL_INSTANCE INST
WHERE OPP.DELETED_FLAG IS NULL OR OPP.DELETED_FLAG <> 'Y' WITH READ ONLY

Columns

Name
OPPORTUNITY_PK
ALL_FK
OPPORTUNITY_DP
NAME
OPPORTUNITY_LEAD_ID
OPP_LEAD_NUMBER
OPP_DESCRIPTION
PARENT_PROJECT
WIN_PROBABILITY
LEAD_SOURCE_CODE
TOTAL_AMOUNT
CURRENCY_CODE
CLOSE_REASON
DECISION_TIMEFRAME_CODE
VEHICLE_RESPONSE_CODE
ORIG_SYSTEM_REFERENCE
DELETED_FLAG
INSTANCE
LAST_UPDATE_DATE
CREATION_DATE