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: AMS_LT_ORG_CONTACT_V

Product:	AMS - Marketing
Description:	Data Source view to get information about b2b contacts
Implementation/DBA Data:	APPS.AMS_LT_ORG_CONTACT_V

View Text

SELECT C.ORG_CONTACT_ID CONTACT_ID
, C.CONTACT_NUMBER
, C.PARTY_SITE_ID
, C.DECISION_MAKER_FLAG
, C.REFERENCE_USE_FLAG
, C.RANK
, C.TITLE
, C.JOB_TITLE
, C.JOB_TITLE_CODE
, C.DEPARTMENT
, C.DEPARTMENT_CODE
, C.MANAGED_BY
, C.MAILING_ADDRESS_ID
, C.MAIL_STOP
, C.NATIVE_LANGUAGE
, C.OTHER_LANGUAGE_1
, C.OTHER_LANGUAGE_2
, C.PARTY_RELATIONSHIP_ID
FROM HZ_ORG_CONTACTS C
WHERE C.STATUS = 'A'

Columns

Name
CONTACT_ID
CONTACT_NUMBER
PARTY_SITE_ID
DECISION_MAKER_FLAG
REFERENCE_USE_FLAG
RANK
TITLE
JOB_TITLE
JOB_TITLE_CODE
DEPARTMENT
DEPARTMENT_CODE
MANAGED_BY
MAILING_ADDRESS_ID
MAIL_STOP
NATIVE_LANGUAGE
OTHER_LANGUAGE_1
OTHER_LANGUAGE_2
PARTY_RELATIONSHIP_ID