View: AST_OPPORTUNITY_LOG_V

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

View Text

SELECT OPP.LOG_ID
, OPP.LEAD_ID
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.LAST_UPDATE_LOGIN
, OPP.ORG_ID
, OPP.STATUS_CODE
, OPP.CUSTOMER_ID
, OPP.ADDRESS_ID
, OPP.VEHICLE_RESPONSE_CODE
, OPP.OFFER_ID
, OPP.SALES_STAGE_ID
, OPP.CHANNEL_CODE
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.WIN_PROBABILITY
, OPP.CLOSE_COMPETITOR_ID
, OPP.DESCRIPTION
, OPP.SOURCE_PROMOTION_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.SALES_METHODOLOGY_ID
, OPP.OWNER_SALESFORCE_ID
, OPP.OWNER_SALES_GROUP_ID
, OPP.SECURITY_GROUP_ID
, OPP.LOG_MODE
, FP.MEANING PROBABILITY_MEANING
, RES.SOURCE_NAME LAST_UPDATED_BYNAME
, SM.SALES_METHODOLOGY_NAME
, LOCATION.ADDRESS1
, LOCATION.ADDRESS2
, LOCATION.CITY
, LOCATION.STATE
, LOCATION.COUNTRY
, LOCATION.PROVINCE
, LOCATION.POSTAL_CODE
, OWNRES.SOURCE_NAME OWNER_NAME
, OWNGRP.GROUP_NAME
, OWNGRP.GROUP_DESC
FROM AS_LEADS_LOG OPP
, HZ_PARTIES PARTY
, OE_LOOKUPS ASOCHANNELS
, AS_SALES_STAGES_ALL_TL STGTL
, AS_STATUSES_TL ASSTATUSES
, AS_SALES_METHODOLOGY_TL SM
, AS_FORECAST_PROB_ALL_TL FP
, JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_RESOURCE_EXTNS OWNRES
, JTF_RS_GROUPS_TL OWNGRP
, HZ_LOCATIONS LOCATION
, HZ_PARTY_SITES SITES
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_CODE = ASSTATUSES.STATUS_CODE
AND ASSTATUSES.LANGUAGE = USERENV('LANG')
AND OPP.WIN_PROBABILITY = FP.PROBABILITY_VALUE
AND FP.LANGUAGE = USERENV('LANG')
AND RES.USER_ID = OPP.LAST_UPDATED_BY
AND OPP.OWNER_SALESFORCE_ID = OWNRES.RESOURCE_ID (+)
AND LOCATION.LOCATION_ID (+) = SITES.LOCATION_ID
AND OPP.ADDRESS_ID = SITES.PARTY_SITE_ID(+)
AND OPP.SALES_METHODOLOGY_ID = SM.SALES_METHODOLOGY_ID(+)
AND SM.LANGUAGE (+) = USERENV('LANG')
AND OPP.OWNER_SALES_GROUP_ID = OWNGRP.GROUP_ID (+)
AND OWNGRP.LANGUAGE (+) = USERENV('LANG')

Columns