View: AS_ACCOUNT_LEADS_V

View Text

SELECT LEAD.LEAD_ID
, LEAD.LEAD_NUMBER
, LEAD.STATUS
, LEAD.DESCRIPTION
, ASLKP.MEANING
, LEAD.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, LEAD.ADDRESS_ID
, LEAD.ADDRESS_ID
, ADDR.ADDRESS1
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME
FROM AS_LOOKUPS ASLKP
, FND_TERRITORIES_TL TERR
, RA_CUSTOMERS CUST
, RA_ADDRESSES ADDR
, AS_OPPORTUNITIES LEAD
WHERE LEAD.CUSTOMER_ID = CUST.CUSTOMER_ID
AND 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