VIEW: APPS.AMS_ORG_CONTACT_ROLES_V

Source

View Text - Preformatted

SELECT hocr.ORG_CONTACT_ROLE_ID ,hocr.ORG_CONTACT_ID ,hocr.CREATION_DATE ,hocr.CREATED_BY ,hocr.LAST_UPDATE_DATE ,hocr.LAST_UPDATED_BY ,hocr.LAST_UPDATE_LOGIN ,hocr.ORIG_SYSTEM_REFERENCE ,hocr.ROLE_LEVEL ,hocr.ROLE_TYPE ,hocr.PRIMARY_FLAG ,hocr.PRIMARY_CONTACT_PER_ROLE_TYPE ,hocr.REQUEST_ID ,hocr.PROGRAM_APPLICATION_ID ,hocr.PROGRAM_ID ,hocr.PROGRAM_UPDATE_DATE ,hocr.WH_UPDATE_DATE ,hocr.created_by CREATED_BY_NAME ,hocr.last_update_login LAST_UPDATE_LOGIN_NAME ,hocr.last_updated_by LAST_UPDATED_BY_NAME FROM HZ_ORG_CONTACT_ROLES hocr, HZ_PARTIES hp, HZ_ORG_CONTACTS HOC, HZ_RELATIONSHIPS HPR WHERE hp.party_id = hpr.object_id and hpr.directional_flag = 'F' and hpr.relationship_id = hoc.party_relationship_id and hoc.org_contact_id = hocr.org_contact_id and ( hpr.end_date is null or sysdate <= hpr.end_date) AND HPR.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED' AND hp.STATUS = 'A' AND hp.PARTY_TYPE = 'ORGANIZATION'

View Text - HTML Formatted

SELECT HOCR.ORG_CONTACT_ROLE_ID
, HOCR.ORG_CONTACT_ID
, HOCR.CREATION_DATE
, HOCR.CREATED_BY
, HOCR.LAST_UPDATE_DATE
, HOCR.LAST_UPDATED_BY
, HOCR.LAST_UPDATE_LOGIN
, HOCR.ORIG_SYSTEM_REFERENCE
, HOCR.ROLE_LEVEL
, HOCR.ROLE_TYPE
, HOCR.PRIMARY_FLAG
, HOCR.PRIMARY_CONTACT_PER_ROLE_TYPE
, HOCR.REQUEST_ID
, HOCR.PROGRAM_APPLICATION_ID
, HOCR.PROGRAM_ID
, HOCR.PROGRAM_UPDATE_DATE
, HOCR.WH_UPDATE_DATE
, HOCR.CREATED_BY CREATED_BY_NAME
, HOCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, HOCR.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM HZ_ORG_CONTACT_ROLES HOCR
, HZ_PARTIES HP
, HZ_ORG_CONTACTS HOC
, HZ_RELATIONSHIPS HPR
WHERE HP.PARTY_ID = HPR.OBJECT_ID
AND HPR.DIRECTIONAL_FLAG = 'F'
AND HPR.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
AND HOC.ORG_CONTACT_ID = HOCR.ORG_CONTACT_ID
AND ( HPR.END_DATE IS NULL OR SYSDATE <= HPR.END_DATE)
AND HPR.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'