View: AST_OPPORTUNITY_LOGS_V

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

View Text

SELECT LOG.LOG_ID
, LOG.LEAD_ID
, LOG.LAST_UPDATE_DATE
, LOG.LAST_UPDATED_BY
, RES.SOURCE_NAME LAST_UPDATED_BYNAME
, LOG.CREATION_DATE
, LOG.CREATED_BY
, LOG.LAST_UPDATE_LOGIN
, LOG.ORG_ID
, LOG.CUSTOMER_ID
, LOG.ADDRESS_ID
, TRIM(DECODE(JRS2.CATEGORY
, 'EMPLOYEE'
, JRS2.SOURCE_NAME
, 'PARTY'
, JRS2.SOURCE_NAME
, NULL)) OWNER
, OWNGRP.GROUP_NAME OWNER_GROUP_NAME
, LOG.STATUS_CODE
, ASOCHANNELS.MEANING SALES_CHANNEL
, STGTL.NAME SALES_STAGE
, ASSTATUSES.MEANING STATUS
, LOG.SALES_STAGE_ID
, LOG.WIN_PROBABILITY
, LOG.DECISION_DATE
, LOG.TOTAL_AMOUNT
, LOG.CURRENCY_CODE
, SC1.NAME SOURCE_NAME
, LOG.CHANNEL_CODE
, LOG.DESCRIPTION
, TRIM(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(NULL
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.COUNTRY
, LOC.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, FND_PROFILE.VALUE('AST_DEFAULT_COUNTRY')
, NULL
, NULL
, 2000
, 1
, 1)) LOCATION
, COMPET.PARTY_NAME
, LOG.VEHICLE_RESPONSE_CODE
, SC2.NAME OFFER_NAME
, SM.SALES_METHODOLOGY_NAME
FROM AS_LEADS_LOG LOG
, JTF_RS_RESOURCE_EXTNS JRS2
, HZ_PARTY_SITES PS
, HZ_LOCATIONS LOC
, JTF_RS_GROUPS_TL SG
, HZ_PARTIES COMPET
, AST_OFFER_ONLY_V SC2
, AST_SOURCE_ONLY_V SC1
, AS_SALES_METHODOLOGY_TL SM
, OE_LOOKUPS ASOCHANNELS
, AS_SALES_STAGES_ALL_TL STGTL
, AS_STATUSES_TL ASSTATUSES
, JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_GROUPS_TL OWNGRP
WHERE JRS2.RESOURCE_ID(+) = LOG.OWNER_SALESFORCE_ID
AND LOC.LOCATION_ID(+) = PS.LOCATION_ID
AND PS.PARTY_SITE_ID(+) = LOG.ADDRESS_ID
AND SG.GROUP_ID(+) = LOG.OWNER_SALES_GROUP_ID
AND SG.LANGUAGE(+) = USERENV('LANG')
AND COMPET.PARTY_ID(+) = LOG.CLOSE_COMPETITOR_ID
AND SC2.SOURCE_CODE_ID(+) = LOG.OFFER_ID
AND SC1.SOURCE_CODE_ID(+) = LOG.SOURCE_PROMOTION_ID
AND SM.SALES_METHODOLOGY_ID(+) = LOG.SALES_METHODOLOGY_ID
AND LOG.CHANNEL_CODE = ASOCHANNELS.LOOKUP_CODE(+)
AND ASOCHANNELS.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND LOG.SALES_STAGE_ID = STGTL.SALES_STAGE_ID(+)
AND STGTL.LANGUAGE(+) = USERENV('LANG')
AND LOG.STATUS_CODE = ASSTATUSES.STATUS_CODE
AND ASSTATUSES.LANGUAGE = USERENV('LANG')
AND LOG.OWNER_SALES_GROUP_ID = OWNGRP.GROUP_ID (+)
AND OWNGRP.LANGUAGE (+) = USERENV('LANG')
AND SM.LANGUAGE(+) = USERENV('LANG')
AND RES.USER_ID = LOG.LAST_UPDATED_BY

Columns