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

Product:	AS - Sales Foundation
Description:	Opportunity contacts view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT L.ROWID ROW_ID
, L.CREATED_BY
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.LAST_UPDATE_DATE
, L.LAST_UPDATE_LOGIN
, L.LEAD_NUMBER OPPORTUNITY_NUMBER
, L.DECISION_DATE CLOSE_DATE
, L.WIN_PROBABILITY
, L.DESCRIPTION MAIN_INTEREST
, ASLKP1.MEANING STATUS
, ASLKP2.MEANING CHANNEL
, LC.CUSTOMER_ID
, LC.ADDRESS_ID
, LC.LEAD_ID
, LC.LEAD_CONTACT_ID
, LC.CONTACT_ID
, L.STATUS STATUS_CODE
, L.CHANNEL_CODE
FROM AS_OPPORTUNITIES L
, AS_OPPORTUNITY_CONTACTS LC
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
WHERE L.LEAD_ID = LC.LEAD_ID
AND L.STATUS = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'LEAD_STATUS'
AND L.CHANNEL_CODE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'LEAD_CHANNEL'

Columns

Name
ROW_ID
CREATED_BY
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LEAD_NUMBER
CLOSE_DATE
WIN_PROBABILITY
MAIN_INTEREST
STATUS
CHANNEL
CUSTOMER_ID
ADDRESS_ID
LEAD_ID
LEAD_CONTACT_ID
CONTACT_ID
STATUS_CODE
CHANNEL_CODE