VIEW: APPS.AMS_LT_ORG_CONTACT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'