[Home] [Help]
View: AS_POLT_SC_MEMBERS_V
Product: | AS - Sales Foundation |
Description: | Distinct sales credit members view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT SC.LEAD_ID
, NVL(SC.PERSON_ID
, -1)
, NVL(SC.SALESFORCE_ID
, -1)
, NVL(SC.SALESGROUP_ID
, -1)
, NVL(SC.PARTNER_CUSTOMER_ID
, -1)
, NVL(SC.PARTNER_ADDRESS_ID
, -1)
FROM AS_SALES_CREDITS SC
Columns
Name |
LEAD_ID |
PERSON_ID |
SALESFORCE_ID |
SALESGROUP_ID |
PARTNER_CUSTOMER_ID |
PARTNER_ADDRESS_ID |