Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT LEAD.LEAD_NUMBER
, '_LA:LEAD.LEAD_SOURCE_CODE:AS_LOOKUPS:LEAD_SOURCE:MEANING'
, LEAD.ORIG_SYSTEM_REFERENCE
, '_LA:LEAD.STATUS:AS_LOOKUPS:LEAD_STATUS:MEANING'
, '_LA:LEAD.CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, LEAD.DECISION_DATE
, LEAD.WIN_PROBABILITY
, LEAD.TOTAL_AMOUNT
, LEAD.CURRENCY_CODE
, '_LA:LEAD.CLOSE_REASON:AS_LOOKUPS:CLOSE_REASON:MEANING'
, LEAD.CLOSE_COMPETITOR
, LEAD.CLOSE_COMMENT
, LEAD.DESCRIPTION
, '_LA:LEAD.RANK:AS_LOOKUPS:RANK:MEANING'
, '_LA:LEAD.NO_OPP_ALLOWED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:LEAD.DELETE_ALLOWED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, LEAD.PARENT_PROJECT --
, '_DF:AS:ATTRIBUTES:LEAD' -- RESOLVED FK
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, ADDR.CITY
, CUST.STATUS
, ADDR.STATUS
, CUST3.CUSTOMER_NUMBER
, CUST3.CUSTOMER_NAME
, CUST2.CUSTOMER_NUMBER
, CUST2.CUSTOMER_NAME
, ADDR2.CITY
, STAGE.NAME
, PROM.NAME
, STAGE.MIN_WIN_PROBABILITY
, STAGE.MAX_WIN_PROBABILITY
, PROB.MEANING
, SOPL.NAME
, CUR.NAME
, PARA.ORGANIZATION_CODE
, ORG.NAME -- ID
, LEAD.LEAD_ID
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.SALES_STAGE_ID
, LEAD.CLOSE_COMPETITOR_ID
, LEAD.SOURCE_PROMOTION_ID
, LEAD.END_USER_CUSTOMER_ID
, LEAD.END_USER_ADDRESS_ID
, LEAD.PRICE_LIST_ID -- WHO
, LEAD.LAST_UPDATE_DATE
, LEAD.LAST_UPDATED_BY
, LEAD.CREATION_DATE
, LEAD.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_CURRENCIES_VL CUR
, SO_PRICE_LISTS SOPL
, AS_PROMOTIONS_ALL PROM
, AS_SALES_STAGES_ALL STAGE
, AS_FORECAST_PROB_ALL PROB
, RA_CUSTOMERS CUST
, RA_CUSTOMERS CUST2
, RA_CUSTOMERS CUST3
, RA_ADDRESSES_ALL ADDR
, RA_ADDRESSES_ALL ADDR2
, AS_LEADS_ALL LEAD
WHERE LEAD.ORG_ID = PARA.ORGANIZATION_ID (+)
AND LEAD.ORG_ID = ORG.ORGANIZATION_ID (+)
AND LEAD.CURRENCY_CODE = CUR.CURRENCY_CODE (+)
AND LEAD.PRICE_LIST_ID = SOPL.PRICE_LIST_ID (+)
AND LEAD.SOURCE_PROMOTION_ID = PROM.PROMOTION_ID (+)
AND LEAD.SALES_STAGE_ID = STAGE.SALES_STAGE_ID (+)
AND LEAD.WIN_PROBABILITY = PROB.PROBABILITY_VALUE (+)
AND LEAD.END_USER_CUSTOMER_ID = CUST2.CUSTOMER_ID (+)
AND LEAD.CLOSE_COMPETITOR_ID = CUST3.CUSTOMER_ID (+)
AND LEAD.END_USER_ADDRESS_ID = ADDR2.ADDRESS_ID (+)
AND LEAD.ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND LEAD.CUSTOMER_ID = CUST.CUSTOMER_ID (+)
AND '_SEC:LEAD.ORG_ID' IS NOT NULL WITH READ ONLY