[Home] [Help]
View: ASF_LEAD_COMPETITORS_LOV_V
Product: | ASF - Sales Online |
Description: | Lead Competitors LOV view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.COMPETITOR_ID
, HZ.PARTY_NAME
, HZ.ADDRESS1
, HZ.ADDRESS2
, HZ.ADDRESS3
, HZ.ADDRESS4
, HZ.CITY
, HZ.PROVINCE
, HZ.COUNTY
, HZ.STATE
, HZ.POSTAL_CODE
, HZ.COUNTRY
, HZ.STATUS
, A.LEAD_COMPETITOR_ID
, A.LEAD_ID
FROM AS_LEAD_COMPETITORS A
, HZ_PARTIES HZ
WHERE A.COMPETITOR_ID = HZ.PARTY_ID
Columns
Name |
PARTY_ID |
PARTY_NAME |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
PROVINCE |
COUNTY |
STATE |
POSTAL_CODE |
COUNTRY |
STATUS |
LEAD_COMPETITOR_ID |
LEAD_ID |