VIEW: APPS.AST_OPPORTUNITY_LOG_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')