View: AST_LM_OPP_QUICK_SREP_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_LM_OPP_QUICK_SREP_V

View Text

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
, SP.RESOURCE_ID
, SP.SOURCE_FIRST_NAME
, SP.SOURCE_LAST_NAME
, SP.SOURCE_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_RESOURCE_EXTNS SP
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 = SP.RESOURCE_ID

Columns