eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_SALESREP_CONTACTS_V

Product:	ICX - Oracle iProcurement
Description:	Web Customer Salesrep Contacts List View
Implementation/DBA Data:	Not implemented in this database

View Text

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)

Columns

Name
PERSON_ID
ROW_ID
SALESFORCE_ID
CUSTOMER_ID
CONTACT_ID
CUSTOMER_NAME
CUSTOMER_NUMBER
FISCAL_YEAREND_MONTH
NET_WORTH
NUM_OF_EMPLOYEES
TAX_CODE
YEAR_ESTABLISHED
SHIP_VIA
FREIGHT_TERM
PAYMENT_TERM_ID
COMPETITOR_FLAG
JGZZ_FISCAL_CODE
DO_NOT_MAIL_FLAG
ADDRESS_ID
COUNTRY
ADDRESS
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
POSTAL_CODE
STATE
PROVINCE
COUNTY
BILL_TO_FLAG
MARKET_FLAG
SHIP_TO_FLAG
ADDRESS_STYLE
KEY_ACCOUNT_FLAG
REFERENCE_USE_FLAG
PHONE_ID
PHONE_NUMBER
PHONE_TYPE
AREA_CODE
EXTENSION
PRIMARY_FLAG
FULL_NAME
LAST_NAME
FIRST_NAME
TITLE
JOB_TITLE
MAIL_STOP
JOB_TITLE_CODE
PRIMARY_ROLE
CON_DO_NOT_MAIL_FLAG
SUFFIX
EMAIL_ADDRESS
SEX_CODE
SALUTATION
DEPARTMENT_CODE
DEPARTMENT
CONTACT_PHONE_ID
CONTACT_PHONE_NUMBER
CONTACT_PHONE_TYPE
CONTACT_AREA_CODE
CONTACT_EXTENSION
CONTACT_PRIMARY_FLAG
CONT_MAILING_ADDRESS_ID
CONT_COUNTRY
CONT_ADDRESS
CONT_ADDRESS1
CONT_ADDRESS2
CONT_ADDRESS3
CONT_ADDRESS4
CONT_CITY
CONT_POSTAL_CODE
CONT_STATE
CONT_PROVINCE
CONT_COUNTY
ORG_ID