VIEW: APPS.AMS_LEAD_ACCOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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