Product: | ASF - Sales Online |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OPP.LEAD_ID
, OPP.LEAD_NUMBER
, OPP.ADDRESS_ID
, OPP.PARENT_PROJECT
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.STATUS
, ASSTATUSES.MEANING STATUS_NAME
, OPP.CUSTOMER_ID
, PARTY.CUSTOMER_NAME
, PARTY.PARTY_TYPE
, OPP.METHODOLOGY_CODE
, ASL3.MEANING METHODOLOGY
, OPP.SOURCE_PROMOTION_ID
, OPP.OFFER_ID
, OPP.SALES_STAGE_ID
, STGTL.NAME SALES_STAGE
, OPP.CHANNEL_CODE
, ASOCHANNELS.SALES_CHANNEL CHANNEL
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.WIN_PROBABILITY
, OPP.CLOSE_REASON CLOSE_REASON_CODE
, ASL2.MEANING CLOSE_REASON
, OPP.DESCRIPTION
, OPP.NO_OPP_ALLOWED_FLAG
, OPP.DELETE_ALLOWED_FLAG
, OPP.ATTRIBUTE_CATEGORY
, OPP.ATTRIBUTE1
, OPP.ATTRIBUTE2
, OPP.ATTRIBUTE3
, OPP.ATTRIBUTE4
, OPP.ATTRIBUTE5
, OPP.ATTRIBUTE6
, OPP.ATTRIBUTE7
, OPP.ATTRIBUTE8
, OPP.ATTRIBUTE9
, OPP.ATTRIBUTE10
, OPP.ATTRIBUTE11
, OPP.ATTRIBUTE12
, OPP.ATTRIBUTE13
, OPP.ATTRIBUTE14
, OPP.ATTRIBUTE15
, PARTY.CUSTOMER_CATEGORY_CODE
, ASL4.MEANING CUSTOMER_CATEGORY
, OPP.ORG_ID
FROM AS_LEADS_ALL OPP
, AS_PARTY_CUSTOMERS_V PARTY
, ASO_I_SALES_CHANNELS_V ASOCHANNELS
, AS_SALES_STAGES_ALL_TL STGTL
, AS_LOOKUPS ASL2
, AS_LOOKUPS ASL3
, AS_LOOKUPS ASL4
, AS_STATUSES_TL ASSTATUSES
WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.CHANNEL_CODE = ASOCHANNELS.SALES_CHANNEL_CODE (+)
AND OPP.CLOSE_REASON = ASL2.LOOKUP_CODE (+)
AND ASL2.LOOKUP_TYPE (+) = 'CLOSE_REASON'
AND OPP.METHODOLOGY_CODE = ASL3.LOOKUP_CODE (+)
AND ASL3.LOOKUP_TYPE (+) = 'METHODOLOGY_TYPE'
AND PARTY.CUSTOMER_CATEGORY_CODE = ASL4.LOOKUP_CODE (+)
AND ASL4.LOOKUP_TYPE (+) = 'VEHICLE_RESPONSE_CODE'
AND OPP.SALES_STAGE_ID = STGTL.SALES_STAGE_ID (+)
AND STGTL.LANGUAGE (+) = USERENV('LANG')
AND OPP.STATUS = ASSTATUSES.STATUS_CODE (+)
AND ASSTATUSES.LANGUAGE (+) = USERENV('LANG')