View: AMS_LEAD_ACCOUNTS_V

Product:	AMS - Marketing
Description:	This view is used by Discoverer Business Area : List Generation Folders to retrieve customers and sites linked to an opportunity.
Implementation/DBA Data:	APPS.AMS_LEAD_ACCOUNTS_V

View Text

SELECT AL.LEAD_ID
, AL.DESCRIPTION
, SSA.NAME SALES_STAGE
, AL.WIN_PROBABILITY || '%' WIN_PROBABILITY
, AL.STATUS OPP_STATUS
, AL.TOTAL_AMOUNT
, AL.CURRENCY_CODE
, AL.CHANNEL_CODE
, AL.CLOSE_REASON
, AL.ATTRIBUTE1 INITIATIVES
, AL.ATTRIBUTE2 FORECAST_SPONSOR
, AL.ATTRIBUTE3 SEGMENTED
, AL.ATTRIBUTE4 SOLUTION_TYPE
, AL.ATTRIBUTE6 PROJECT_NAME_NUMBER
, AL.ATTRIBUTE8 ACTION_TO_CLOSE
, AL.ATTRIBUTE9 LEAD_SOURCE
, AL.ATTRIBUTE10 ORDER_NUMBER
, AL.ATTRIBUTE11 INTERNAL_PROCESS_STATUS
, AL.ATTRIBUTE12 NEW_ACCOUNT
, AIT.INTEREST_TYPE OPP_INTEREST_TYPE
, AIT.INTEREST_TYPE||'/'||AICP.CODE OPP_PRIMARY_INTEREST
, AIT.INTEREST_TYPE||'/'||AICP.CODE||'/'||AICS.CODE OPP_SECONDARY_INTEREST
, AL.ADDRESS_ID
, AL.CUSTOMER_ID
FROM AS_LEADS_ALL AL
, AS_LEAD_LINES_ALL ALA
, AS_INTERESTS_ALL AI
, AS_INTEREST_TYPES_VL AIT
, AS_INTEREST_CODES_VL AICP
, AS_INTEREST_CODES_VL AICS
, AS_SALES_STAGES_ALL_VL SSA
WHERE AI.LEAD_ID(+) = AL.LEAD_ID
AND ALA.LEAD_ID(+) = AL.LEAD_ID
AND SSA.SALES_STAGE_ID(+) = AL.SALES_STAGE_ID
AND ALA.INTEREST_TYPE_ID = AIT.INTEREST_TYPE_ID
AND ALA.PRIMARY_INTEREST_CODE_ID = AICP.INTEREST_CODE_ID(+)
AND ALA.SECONDARY_INTEREST_CODE_ID = AICS.INTEREST_CODE_ID(+)
AND AL.LEAD_ID > 0

Columns