[Home] [Help]
View: AS_DIST_SC_MEMBERS_V
Product: | AS - Sales Foundation |
Description: | Distinct view of sales credit members |
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)
, NVL(PEOPLE.FIRST_NAME
, -1)
, NVL(PEOPLE.LAST_NAME
, -1)
, NVL(SG.NAME
, -1)
, NVL(CUST.CUSTOMER_NAME
, -1)
, NVL(ADDR.CITY
, -1)
FROM AS_SALES_GROUPS SG
, PER_ALL_PEOPLE_F PEOPLE
, RA_ADDRESSES ADDR
, RA_CUSTOMERS CUST
, AS_SALES_CREDITS SC
WHERE SC.PARTNER_CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND SC.PARTNER_ADDRESS_ID = ADDR.ADDRESS_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)
AND SC.PERSON_ID = PEOPLE.PERSON_ID(+)
AND SC.SALESGROUP_ID = SG.SALES_GROUP_ID(+)
Columns
Name |
LEAD_ID |
PERSON_ID |
SALESFORCE_ID |
SALESGROUP_ID |
PARTNER_CUSTOMER_ID |
PARTNER_ADDRESS_ID |
EMPLOYEE_FIRST_NAME |
EMPLOYEE_LAST_NAME |
SALES_GROUP_NAME |
CUSTOMER_NAME |
CITY |