Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASL.LEAD_NUMBER
, '_LA:ASL.LEAD_SOURCE_CODE:AS_LOOKUPS:LEAD_SOURCE:MEANING'
, ASL.ORIG_SYSTEM_REFERENCE
, '_LA:ASL.STATUS:AS_LOOKUPS:LEAD_STATUS:MEANING'
, '_LA:ASL.CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, ASL.DECISION_DATE
, ASL.WIN_PROBABILITY
, ASL.TOTAL_AMOUNT
, ASL.CURRENCY_CODE
, '_LA:ASL.CLOSE_REASON:AS_LOOKUPS:CLOSE_REASON:MEANING'
, ASL.CLOSE_COMPETITOR_CODE
, ASL.CLOSE_COMPETITOR
, ASL.CLOSE_COMMENT
, ASL.DESCRIPTION
, '_LA:ASL.RANK:AS_LOOKUPS:RANK:MEANING'
, ASL.PARENT_PROJECT
, '_LA:ASL.NO_OPP_ALLOWED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:ASL.DELETE_ALLOWED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_DF:AS:AS_LEADS:ASL' -- ID
, ASL.LEAD_ID
, ASL.CUSTOMER_ID
, ASL.ADDRESS_ID
, ASL.ORG_ID
, ASL.SALES_STAGE_ID
, ASL.INITIATING_CONTACT_ID
, ASL.CLOSE_COMPETITOR_ID
, ASL.SOURCE_PROMOTION_ID
, ASL.END_USER_CUSTOMER_ID
, ASL.END_USER_ADDRESS_ID
, ASL.PRICE_LIST_ID -- WHO
, ASL.LAST_UPDATE_DATE
, ASL.LAST_UPDATED_BY
, ASL.CREATION_DATE
, ASL.CREATED_BY
FROM AS_LEADS_ALL ASL
WHERE '_SEC:ASL.ORG_ID' IS NOT NULL WITH READ ONLY