Product: | ICX - Oracle iProcurement |
---|---|
Description: | Web Customer Salesrep Contacts List View |
Implementation/DBA Data: | Not implemented in this database |
SELECT IAS.PERSON_ID
, IAS.ROW_ID
, IAS.SALESFORCE_ID
, CUST.CUSTOMER_ID
, CUST.CONTACT_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.FISCAL_YEAREND_MONTH
, CUST.NET_WORTH
, CUST.NUM_OF_EMPLOYEES
, CUST.TAX_CODE
, CUST.YEAR_ESTABLISHED
, CUST.SHIP_VIA
, CUST.FREIGHT_TERM
, CUST.PAYMENT_TERM_ID
, CUST.COMPETITOR_FLAG
, CUST.JGZZ_FISCAL_CODE
, CUST.DO_NOT_MAIL_FLAG
, CUST.ADDRESS_ID
, CUST.COUNTRY
, CUST.ADDRESS
, CUST.ADDRESS1
, CUST.ADDRESS2
, CUST.ADDRESS3
, CUST.ADDRESS4
, CUST.CITY
, CUST.POSTAL_CODE
, CUST.STATE
, CUST.PROVINCE
, CUST.COUNTY
, CUST.BILL_TO_FLAG
, CUST.MARKET_FLAG
, CUST.SHIP_TO_FLAG
, CUST.ADDRESS_STYLE
, CUST.KEY_ACCOUNT_FLAG
, CUST.REFERENCE_USE_FLAG
, CUST.PHONE_ID
, CUST.PHONE_NUMBER
, CUST.PHONE_TYPE
, CUST.AREA_CODE
, CUST.EXTENSION
, CUST.PRIMARY_FLAG
, CUST.FULL_NAME
, CUST.LAST_NAME
, CUST.FIRST_NAME
, CUST.TITLE
, CUST.JOB_TITLE
, CUST.MAIL_STOP
, CUST.JOB_TITLE_CODE
, CUST.PRIMARY_ROLE
, CUST.DO_NOT_MAIL_FLAG
, CUST.SUFFIX
, CUST.EMAIL_ADDRESS
, CUST.SEX_CODE
, CUST.SALUTATION
, CUST.DEPARTMENT_CODE
, CUST.DEPARTMENT
, CUST.CONTACT_PHONE_ID
, CUST.CONTACT_PHONE_NUMBER
, CUST.CONTACT_PHONE_TYPE
, CUST.CONTACT_AREA_CODE
, CUST.CONTACT_EXTENSION
, CUST.CONTACT_PRIMARY_FLAG
, CUST.CONT_MAILING_ADDRESS_ID
, CUST.CONT_COUNTRY
, CUST.CONT_ADDRESS
, CUST.CONT_ADDRESS1
, CUST.CONT_ADDRESS2
, CUST.CONT_ADDRESS3
, CUST.CONT_ADDRESS4
, CUST.CONT_CITY
, CUST.CONT_POSTAL_CODE
, CUST.CONT_STATE
, CUST.CONT_PROVINCE
, CUST.CONT_COUNTY
, CUST.ORG_ID
FROM ICX_CUSTOMER_CONTACTS_V CUST
, AS_SALES_TEAM_DISTINCT_V IAS
WHERE IAS.PARTNER_CUSTOMER_ID IS NULL
AND IAS.PARTNER_ADDRESS_ID IS NULL
AND IAS.CUSTOMER_ID = CUST.CUSTOMER_ID
AND IAS.ADDRESS_ID = CUST.ADDRESS_ID
AND NVL(CUST.ORG_ID
, -9999) = NVL(IAS.ORG_ID
, -9999)