VIEW: APPS.AST_MYTEAM_SALESOPP_UWQ_R_S_V

Source

View Text - Preformatted

SELECT distinct OPP.LEAD_ID , OPP.DESCRIPTION , OPP.TOTAL_AMOUNT , OPP.LAST_UPDATE_DATE , OPP.LAST_UPDATED_BY , OPP.CUSTOMER_ID PARTY_ID , OPP.ORG_ID, OPP.SALES_STAGE_ID , OPP.LEAD_NUMBER , OPP.STATUS STATUS_CODE , OPP.WIN_PROBABILITY , ACC.SALESFORCE_ID RESOURCE_ID , 'OPPORTUNITY' OBJECT_CODE , 'RS_INDIVIDUAL' RESOURCE_TYPE , OPP.CUSTOMER_BUDGET , OPP.DECISION_DATE , OPP.CREATION_DATE , OPP.CHANNEL_CODE , OPP.CURRENCY_CODE , OPP.PARENT_PROJECT , OPP.DECISION_TIMEFRAME_CODE , null DECISION_TIMEFRAME, ACC.OPEN_FLAG FROM AS_LEADS_ALL OPP, AS_ACCESSES_ALL ACC WHERE OPP.LEAD_ID = ACC.LEAD_ID AND ACC.OPEN_FLAG = 'Y'

View Text - HTML Formatted

SELECT DISTINCT OPP.LEAD_ID
, OPP.DESCRIPTION
, OPP.TOTAL_AMOUNT
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CUSTOMER_ID PARTY_ID
, OPP.ORG_ID
, OPP.SALES_STAGE_ID
, OPP.LEAD_NUMBER
, OPP.STATUS STATUS_CODE
, OPP.WIN_PROBABILITY
, ACC.SALESFORCE_ID RESOURCE_ID
, 'OPPORTUNITY' OBJECT_CODE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, OPP.CUSTOMER_BUDGET
, OPP.DECISION_DATE
, OPP.CREATION_DATE
, OPP.CHANNEL_CODE
, OPP.CURRENCY_CODE
, OPP.PARENT_PROJECT
, OPP.DECISION_TIMEFRAME_CODE
, NULL DECISION_TIMEFRAME
, ACC.OPEN_FLAG
FROM AS_LEADS_ALL OPP
, AS_ACCESSES_ALL ACC
WHERE OPP.LEAD_ID = ACC.LEAD_ID
AND ACC.OPEN_FLAG = 'Y'