VIEW: APPS.AST_OPPORTUNITY_V

Source

View Text - Preformatted

SELECT LEAD.LEAD_ID ,LEAD.LEAD_NUMBER ,STATUS.STATUS_CODE ,STATUS.MEANING ,PARTY.PARTY_ID ,LOCATION.LOCATION_ID ,LOCATION.ADDRESS1 ,LOCATION.ADDRESS2 ,LOCATION.ADDRESS3 ,LOCATION.ADDRESS4 ,LOCATION.CITY ,LOCATION.STATE ,LOCATION.POSTAL_CODE ,LOCATION.COUNTRY ,PARTY.PARTY_NAME ,PARTY.PARTY_NUMBER ,PARTY.PARTY_TYPE ,PARTY.PERSON_FIRST_NAME ,PARTY.PERSON_MIDDLE_NAME ,PARTY.PERSON_LAST_NAME ,LEAD.CLOSE_REASON ,SALES.SALES_STAGE_ID ,SALES.NAME ,SOLKP.LOOKUP_CODE ,LEAD.TOTAL_AMOUNT ,LEAD.CURRENCY_CODE ,LEAD.DECISION_DATE ,LEAD.WIN_PROBABILITY ,LEAD.DESCRIPTION ,PROM.NAME ,SOLKP.MEANING ,SALES.MIN_WIN_PROBABILITY ,SALES.MAX_WIN_PROBABILITY ,LEAD.PARENT_PROJECT ,LEAD.NO_OPP_ALLOWED_FLAG ,LEAD.DELETE_ALLOWED_FLAG ,LEAD.LAST_UPDATE_DATE ,LEAD.LAST_UPDATED_BY ,LEAD.CREATION_DATE ,LEAD.CREATED_BY ,LEAD.SOURCE_PROMOTION_ID ,LEAD.ATTRIBUTE_CATEGORY ,LEAD.ATTRIBUTE1 ,LEAD.ATTRIBUTE2 ,LEAD.ATTRIBUTE3 ,LEAD.ATTRIBUTE4 ,LEAD.ATTRIBUTE5 ,LEAD.ATTRIBUTE6 ,LEAD.ATTRIBUTE7 ,LEAD.ATTRIBUTE8 ,LEAD.ATTRIBUTE9 ,LEAD.ATTRIBUTE10 ,LEAD.ATTRIBUTE11 ,LEAD.ATTRIBUTE12 ,LEAD.ATTRIBUTE13 ,LEAD.ATTRIBUTE14 ,LEAD.ATTRIBUTE15 ,PARTY.ORGANIZATION_NAME_PHONETIC ,PARTY.VALIDATED_FLAG ,LEAD.OFFER_ID ,LEAD.VEHICLE_RESPONSE_CODE ,LEAD.METHODOLOGY_CODE FROM AS_STATUSES_VL STATUS, AS_LEADS_ALL LEAD, SO_LOOKUPS SOLKP, AS_PROMOTIONS_ALL PROM, AS_SALES_STAGES_ALL_B SALES, HZ_PARTIES PARTY, HZ_PARTY_SITES SITE, HZ_LOCATIONS LOCATION WHERE lead.status = Status.status_code (+) and Solkp.lookup_type(+) = 'SALES_CHANNEL' and lead.channel_code = solkp.lookup_code(+) and lead.source_promotion_id = prom.promotion_id(+) and lead.sales_stage_id = sales.sales_stage_id(+) and lead.customer_id = party.party_id and party.party_id = site.party_id and location.location_id = site.location_id and lead.address_id = location.location_id

View Text - HTML Formatted

SELECT LEAD.LEAD_ID
, LEAD.LEAD_NUMBER
, STATUS.STATUS_CODE
, STATUS.MEANING
, PARTY.PARTY_ID
, LOCATION.LOCATION_ID
, LOCATION.ADDRESS1
, LOCATION.ADDRESS2
, LOCATION.ADDRESS3
, LOCATION.ADDRESS4
, LOCATION.CITY
, LOCATION.STATE
, LOCATION.POSTAL_CODE
, LOCATION.COUNTRY
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, PARTY.PARTY_TYPE
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, LEAD.CLOSE_REASON
, SALES.SALES_STAGE_ID
, SALES.NAME
, SOLKP.LOOKUP_CODE
, LEAD.TOTAL_AMOUNT
, LEAD.CURRENCY_CODE
, LEAD.DECISION_DATE
, LEAD.WIN_PROBABILITY
, LEAD.DESCRIPTION
, PROM.NAME
, SOLKP.MEANING
, SALES.MIN_WIN_PROBABILITY
, SALES.MAX_WIN_PROBABILITY
, LEAD.PARENT_PROJECT
, LEAD.NO_OPP_ALLOWED_FLAG
, LEAD.DELETE_ALLOWED_FLAG
, LEAD.LAST_UPDATE_DATE
, LEAD.LAST_UPDATED_BY
, LEAD.CREATION_DATE
, LEAD.CREATED_BY
, LEAD.SOURCE_PROMOTION_ID
, LEAD.ATTRIBUTE_CATEGORY
, LEAD.ATTRIBUTE1
, LEAD.ATTRIBUTE2
, LEAD.ATTRIBUTE3
, LEAD.ATTRIBUTE4
, LEAD.ATTRIBUTE5
, LEAD.ATTRIBUTE6
, LEAD.ATTRIBUTE7
, LEAD.ATTRIBUTE8
, LEAD.ATTRIBUTE9
, LEAD.ATTRIBUTE10
, LEAD.ATTRIBUTE11
, LEAD.ATTRIBUTE12
, LEAD.ATTRIBUTE13
, LEAD.ATTRIBUTE14
, LEAD.ATTRIBUTE15
, PARTY.ORGANIZATION_NAME_PHONETIC
, PARTY.VALIDATED_FLAG
, LEAD.OFFER_ID
, LEAD.VEHICLE_RESPONSE_CODE
, LEAD.METHODOLOGY_CODE
FROM AS_STATUSES_VL STATUS
, AS_LEADS_ALL LEAD
, SO_LOOKUPS SOLKP
, AS_PROMOTIONS_ALL PROM
, AS_SALES_STAGES_ALL_B SALES
, HZ_PARTIES PARTY
, HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOCATION
WHERE LEAD.STATUS = STATUS.STATUS_CODE (+)
AND SOLKP.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND LEAD.CHANNEL_CODE = SOLKP.LOOKUP_CODE(+)
AND LEAD.SOURCE_PROMOTION_ID = PROM.PROMOTION_ID(+)
AND LEAD.SALES_STAGE_ID = SALES.SALES_STAGE_ID(+)
AND LEAD.CUSTOMER_ID = PARTY.PARTY_ID
AND PARTY.PARTY_ID = SITE.PARTY_ID
AND LOCATION.LOCATION_ID = SITE.LOCATION_ID
AND LEAD.ADDRESS_ID = LOCATION.LOCATION_ID