View: AS_DIST_SC_MEMBERS_V

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