[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 |