[Home] [Help]
View: AS_CUSTOMER_LEADS_V
Product: | AS - Sales Foundation |
Description: | Customer leads view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LEAD.LEAD_ID
, LEAD.LEAD_NUMBER
, LEAD.STATUS
, LEAD.DESCRIPTION
, LEAD.RANK
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.ADDRESS_ID
, ADDR.ADDRESS1
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME
, ASLKP.MEANING
FROM AS_LOOKUPS ASLKP
, FND_TERRITORIES_TL TERR
, RA_ADDRESSES ADDR
, AS_OPPORTUNITIES LEAD
WHERE LEAD.ADDRESS_ID = ADDR.ADDRESS_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND LEAD.STATUS = ASLKP.LOOKUP_CODE(+)
AND ASLKP.LOOKUP_TYPE(+) = 'LEAD_STATUS'
Columns
Name |
LEAD_ID |
LEAD_NUMBER |
STATUS_CODE |
DESCRIPTION |
RANK_CODE |
CUSTOMER_ID |
ACCOUNT_CODE |
ADDRESS_ID |
ADDRESS1 |
CITY |
STATE |
PROVINCE |
POSTAL_CODE |
COUNTRY |
STATUS |