VIEW: APPS.AS_SALES_OPP_UWQ_V

Source

View Text - Preformatted

SELECT OPP.LEAD_ID , OPP.DESCRIPTION , OPP.TOTAL_AMOUNT , OPP.LAST_UPDATE_DATE , OPP.LAST_UPDATED_BY , OPP.CUSTOMER_ID PARTY_ID , PARTY.PARTY_NAME , OPP.SALES_STAGE_ID , SS.NAME SALES_STAGE_NAME , OPP.LEAD_NUMBER , OPP.STATUS STATUS_CODE , ST.MEANING STATUS_MEANING , OPP.WIN_PROBABILITY , FP.MEANING PROBABILITY_MEANING , ACC.SALESFORCE_ID RESOURCE_ID , ACC.SALES_GROUP_ID RESOURCE_GROUP_ID ,'OPPORTUNITY' OBJECT_CODE , DECODE(RES.CATEGORY ,'EMPLOYEE', 'RS_EMPLOYEE','PARTNER','RS_PARTNER',NULL) RESOURCE_TYPE , OPP.CUSTOMER_BUDGET , OPP.DECISION_DATE , OPP.CREATION_DATE , OPP.CHANNEL_CODE , ASOSC.SALES_CHANNEL , OPP.CURRENCY_CODE , OPP.PARENT_PROJECT , OPP.DECISION_TIMEFRAME_CODE , ASLUP.MEANING DECISION_TIMEFRAME FROM AS_LEADS_ALL OPP, JTF_RS_RESOURCE_EXTNS RES, AS_SALES_STAGES_ALL_TL SS, AS_FORECAST_PROB_ALL_TL FP, AS_ACCESSES_ALL ACC, HZ_PARTIES PARTY, AS_STATUSES_TL ST, AS_STATUSES_B STB, ASO_I_SALES_CHANNELS_V ASOSC, AS_LOOKUPS ASLUP WHERE OPP.STATUS = STB.STATUS_CODE AND STB.STATUS_CODE = ST.STATUS_CODE AND ST.LANGUAGE = USERENV('LANG') AND OPP.CUSTOMER_ID = PARTY.PARTY_ID AND OPP.SALES_STAGE_ID = SS.SALES_STAGE_ID AND SS.LANGUAGE = USERENV('LANG') AND OPP.WIN_PROBABILITY = FP.PROBABILITY_VALUE AND FP.LANGUAGE = USERENV('LANG') AND OPP.LEAD_ID = ACC.LEAD_ID AND ACC.SALESFORCE_ID = RES.RESOURCE_ID AND ASOSC.SALES_CHANNEL_CODE = OPP.CHANNEL_CODE AND ASLUP.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME' AND ASLUP.LOOKUP_CODE(+) = OPP.DECISION_TIMEFRAME_CODE and stb.OPP_OPEN_STATUS_FLAG = 'Y'

View Text - HTML Formatted

SELECT OPP.LEAD_ID
, OPP.DESCRIPTION
, OPP.TOTAL_AMOUNT
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CUSTOMER_ID PARTY_ID
, PARTY.PARTY_NAME
, OPP.SALES_STAGE_ID
, SS.NAME SALES_STAGE_NAME
, OPP.LEAD_NUMBER
, OPP.STATUS STATUS_CODE
, ST.MEANING STATUS_MEANING
, OPP.WIN_PROBABILITY
, FP.MEANING PROBABILITY_MEANING
, ACC.SALESFORCE_ID RESOURCE_ID
, ACC.SALES_GROUP_ID RESOURCE_GROUP_ID
, 'OPPORTUNITY' OBJECT_CODE
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, NULL) RESOURCE_TYPE
, OPP.CUSTOMER_BUDGET
, OPP.DECISION_DATE
, OPP.CREATION_DATE
, OPP.CHANNEL_CODE
, ASOSC.SALES_CHANNEL
, OPP.CURRENCY_CODE
, OPP.PARENT_PROJECT
, OPP.DECISION_TIMEFRAME_CODE
, ASLUP.MEANING DECISION_TIMEFRAME
FROM AS_LEADS_ALL OPP
, JTF_RS_RESOURCE_EXTNS RES
, AS_SALES_STAGES_ALL_TL SS
, AS_FORECAST_PROB_ALL_TL FP
, AS_ACCESSES_ALL ACC
, HZ_PARTIES PARTY
, AS_STATUSES_TL ST
, AS_STATUSES_B STB
, ASO_I_SALES_CHANNELS_V ASOSC
, AS_LOOKUPS ASLUP
WHERE OPP.STATUS = STB.STATUS_CODE
AND STB.STATUS_CODE = ST.STATUS_CODE
AND ST.LANGUAGE = USERENV('LANG')
AND OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.SALES_STAGE_ID = SS.SALES_STAGE_ID
AND SS.LANGUAGE = USERENV('LANG')
AND OPP.WIN_PROBABILITY = FP.PROBABILITY_VALUE
AND FP.LANGUAGE = USERENV('LANG')
AND OPP.LEAD_ID = ACC.LEAD_ID
AND ACC.SALESFORCE_ID = RES.RESOURCE_ID
AND ASOSC.SALES_CHANNEL_CODE = OPP.CHANNEL_CODE
AND ASLUP.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'
AND ASLUP.LOOKUP_CODE(+) = OPP.DECISION_TIMEFRAME_CODE
AND STB.OPP_OPEN_STATUS_FLAG = 'Y'