VIEW: APPS.AST_LM_OPP_QUICK_SGRP_V

Source

View Text - Preformatted

SELECT opp.lead_id ,opp.lead_number ,opp.customer_id ,opp.org_id ,party.party_name customer_name ,party.party_type ,opp.address_id ,opp.sales_stage_id ,astg.description sales_stage ,opp.status status_code ,asts.meaning status ,opp.channel_code ,oe.meaning channel ,opp.total_amount ,opp.parent_project ,opp.win_probability ,sgm.group_id ,sg.group_name ,opp.decision_date close_date ,opp.creation_date ,opp.created_by ,opp.last_update_date ,opp.last_updated_by ,opp.description opportunity_name ,opp.source_promotion_id from as_leads_all opp, hz_parties party, as_statuses_tl asts, as_sales_stages_all_tl astg, oe_lookups oe, as_accesses_all acc, jtf_rs_group_members sgm, jtf_rs_groups_tl sg WHERE opp.customer_id = party.party_id and opp.status = asts.status_code and asts.language = userenv('LANG') and opp.sales_stage_id = astg.sales_stage_id and astg.language = userenv('LANG') and opp.channel_code = oe.lookup_code and oe.lookup_type = 'SALES_CHANNEL' and opp.lead_id = acc.lead_id and acc.salesforce_id = sgm.resource_id and sgm.group_id = sg.group_id and sg.language = userenv('LANG')

View Text - HTML Formatted

SELECT OPP.LEAD_ID
, OPP.LEAD_NUMBER
, OPP.CUSTOMER_ID
, OPP.ORG_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.PARTY_TYPE
, OPP.ADDRESS_ID
, OPP.SALES_STAGE_ID
, ASTG.DESCRIPTION SALES_STAGE
, OPP.STATUS STATUS_CODE
, ASTS.MEANING STATUS
, OPP.CHANNEL_CODE
, OE.MEANING CHANNEL
, OPP.TOTAL_AMOUNT
, OPP.PARENT_PROJECT
, OPP.WIN_PROBABILITY
, SGM.GROUP_ID
, SG.GROUP_NAME
, OPP.DECISION_DATE CLOSE_DATE
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.DESCRIPTION OPPORTUNITY_NAME
, OPP.SOURCE_PROMOTION_ID
FROM AS_LEADS_ALL OPP
, HZ_PARTIES PARTY
, AS_STATUSES_TL ASTS
, AS_SALES_STAGES_ALL_TL ASTG
, OE_LOOKUPS OE
, AS_ACCESSES_ALL ACC
, JTF_RS_GROUP_MEMBERS SGM
, JTF_RS_GROUPS_TL SG
WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.STATUS = ASTS.STATUS_CODE
AND ASTS.LANGUAGE = USERENV('LANG')
AND OPP.SALES_STAGE_ID = ASTG.SALES_STAGE_ID
AND ASTG.LANGUAGE = USERENV('LANG')
AND OPP.CHANNEL_CODE = OE.LOOKUP_CODE
AND OE.LOOKUP_TYPE = 'SALES_CHANNEL'
AND OPP.LEAD_ID = ACC.LEAD_ID
AND ACC.SALESFORCE_ID = SGM.RESOURCE_ID
AND SGM.GROUP_ID = SG.GROUP_ID
AND SG.LANGUAGE = USERENV('LANG')