VIEW: APPS.AST_OPPORTUNITY_LOGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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