View: AST_OPPORTUNITY_DET_V

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

View Text

SELECT OPP.ROWID
, OPP.LEAD_ID
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.LAST_UPDATE_LOGIN
, OPP.REQUEST_ID
, OPP.PROGRAM_APPLICATION_ID
, OPP.PROGRAM_ID
, OPP.PROGRAM_UPDATE_DATE
, OPP.LEAD_NUMBER
, OPP.ORG_ID
, OPP.STATUS
, OPP.CUSTOMER_ID
, OPP.ADDRESS_ID
, OPP.AUTO_ASSIGNMENT_TYPE
, OPP.PRM_ASSIGNMENT_TYPE
, OPP.DECISION_TIMEFRAME_CODE
, OPP.VEHICLE_RESPONSE_CODE
, OPP.BUDGET_STATUS_CODE
, OPP.PRM_IND_CLASSIFICATION_CODE
, OPP.PRM_LEAD_TYPE
, OPP.CLOSE_COMPETITOR_CODE
, OPP.DELETED_FLAG
, OPP.CUSTOMER_BUDGET
, OPP.ORIGINAL_LEAD_ID
, OPP.INCUMBENT_PARTNER_RESOURCE_ID
, OPP.INCUMBENT_PARTNER_PARTY_ID
, OPP.FOLLOWUP_DATE
, OPP.PRM_EXEC_SPONSOR_FLAG
, OPP.PRM_PRJ_LEAD_IN_PLACE_FLAG
, OPP.METHODOLOGY_CODE
, OPP.OFFER_ID
, OPP.LEAD_SOURCE_CODE
, OPP.ORIG_SYSTEM_REFERENCE
, OPP.SALES_STAGE_ID
, OPP.CHANNEL_CODE
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.WIN_PROBABILITY
, OPP.CLOSE_REASON
, OPP.CLOSE_COMPETITOR
, OPP.CLOSE_COMPETITOR_ID
, OPP.CLOSE_COMMENT
, OPP.DESCRIPTION
, OPP.RANK
, OPP.END_USER_CUSTOMER_NAME
, OPP.SOURCE_PROMOTION_ID
, OPP.END_USER_CUSTOMER_ID
, OPP.END_USER_ADDRESS_ID
, OPP.ATTRIBUTE_CATEGORY
, OPP.ATTRIBUTE1
, OPP.ATTRIBUTE2
, OPP.ATTRIBUTE3
, OPP.ATTRIBUTE4
, OPP.ATTRIBUTE5
, OPP.ATTRIBUTE6
, OPP.ATTRIBUTE7
, OPP.ATTRIBUTE8
, OPP.ATTRIBUTE9
, OPP.ATTRIBUTE10
, OPP.ATTRIBUTE11
, OPP.ATTRIBUTE12
, OPP.ATTRIBUTE13
, OPP.ATTRIBUTE14
, OPP.ATTRIBUTE15
, OPP.PARENT_PROJECT
, OPP.NO_OPP_ALLOWED_FLAG
, OPP.DELETE_ALLOWED_FLAG
, OPP.PRICE_LIST_ID
, PARTY.PARTY_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PARTY_TYPE
, PARTY.CATEGORY_CODE
, PARTY.PARTY_NUMBER
, PARTY.VALIDATED_FLAG
, ASOCHANNELS.MEANING
, STGTL.NAME
, ASSTATUSES.MEANING
, OPP.FREEZE_FLAG
, OPP.SALES_METHODOLOGY_ID
, OPP.OWNER_SALESFORCE_ID
, OPP.OWNER_SALES_GROUP_ID
, OPP.PRM_REFERRAL_CODE
, OPP.TOTAL_REVENUE_OPP_FORECAST_AMT
FROM AS_LEADS_ALL OPP
, HZ_PARTIES PARTY
, OE_LOOKUPS ASOCHANNELS
, AS_SALES_STAGES_ALL_TL STGTL
, AS_STATUSES_TL ASSTATUSES
WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.CHANNEL_CODE = ASOCHANNELS.LOOKUP_CODE(+)
AND ASOCHANNELS.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND OPP.SALES_STAGE_ID = STGTL.SALES_STAGE_ID(+)
AND STGTL.LANGUAGE(+) = USERENV('LANG')
AND OPP.STATUS = ASSTATUSES.STATUS_CODE
AND ASSTATUSES.LANGUAGE = USERENV('LANG')

Columns