VIEW: APPS.AST_ORG_CONTACT_ROLES_V

Source

View Text - Preformatted

SELECT ORG_CONT_ROLES.ROWID , ORG_CONT_ROLES.org_contact_role_id , ORG_CONT_ROLES.org_contact_id , ORG_CONT_ROLES.role_type , LKUP1.meaning , ORG_CONT_ROLES.created_by , ORG_CONT_ROLES.role_level , ORG_CONT_ROLES.primary_flag , ORG_CONT_ROLES.creation_date , ORG_CONT_ROLES.orig_system_reference , ORG_CONT_ROLES.last_update_login , ORG_CONT_ROLES.last_update_date , ORG_CONT_ROLES.last_updated_by , ORG_CONT_ROLES.request_id , ORG_CONT_ROLES.program_application_id , ORG_CONT_ROLES.program_id , ORG_CONT_ROLES.program_update_date , ORG_CONT_ROLES.attribute_category , ORG_CONT_ROLES.attribute1 , ORG_CONT_ROLES.attribute2 , ORG_CONT_ROLES.attribute3 , ORG_CONT_ROLES.attribute4 , ORG_CONT_ROLES.attribute5 , ORG_CONT_ROLES.attribute6 , ORG_CONT_ROLES.attribute7 , ORG_CONT_ROLES.attribute8 , ORG_CONT_ROLES.attribute9 , ORG_CONT_ROLES.attribute10 , ORG_CONT_ROLES.attribute11 , ORG_CONT_ROLES.attribute12 , ORG_CONT_ROLES.attribute13 , ORG_CONT_ROLES.attribute14 , ORG_CONT_ROLES.attribute15 , ORG_CONT_ROLES.primary_contact_per_role_type , ORG_CONT_ROLES.status , LKUP2.meaning , ORG_CONT_ROLES.OBJECT_VERSION_NUMBER , ORG_CONT_ROLES.CREATED_BY_MODULE , ORG_CONT_ROLES.APPLICATION_ID FROM HZ_ORG_CONTACT_ROLES ORG_CONT_ROLES , AR_LOOKUPS LKUP1 , AR_LOOKUPS LKUP2 WHERE ORG_CONT_ROLES.role_type = LKUP1.lookup_code(+) AND LKUP1.lookup_type(+) = 'CONTACT_ROLE_TYPE' AND ORG_CONT_ROLES.status = LKUP2.lookup_code(+) AND LKUP2.lookup_type(+) = 'REGISTRY_STATUS' AND ORG_CONT_ROLES.status in ('A','I')

View Text - HTML Formatted

SELECT ORG_CONT_ROLES.ROWID
, ORG_CONT_ROLES.ORG_CONTACT_ROLE_ID
, ORG_CONT_ROLES.ORG_CONTACT_ID
, ORG_CONT_ROLES.ROLE_TYPE
, LKUP1.MEANING
, ORG_CONT_ROLES.CREATED_BY
, ORG_CONT_ROLES.ROLE_LEVEL
, ORG_CONT_ROLES.PRIMARY_FLAG
, ORG_CONT_ROLES.CREATION_DATE
, ORG_CONT_ROLES.ORIG_SYSTEM_REFERENCE
, ORG_CONT_ROLES.LAST_UPDATE_LOGIN
, ORG_CONT_ROLES.LAST_UPDATE_DATE
, ORG_CONT_ROLES.LAST_UPDATED_BY
, ORG_CONT_ROLES.REQUEST_ID
, ORG_CONT_ROLES.PROGRAM_APPLICATION_ID
, ORG_CONT_ROLES.PROGRAM_ID
, ORG_CONT_ROLES.PROGRAM_UPDATE_DATE
, ORG_CONT_ROLES.ATTRIBUTE_CATEGORY
, ORG_CONT_ROLES.ATTRIBUTE1
, ORG_CONT_ROLES.ATTRIBUTE2
, ORG_CONT_ROLES.ATTRIBUTE3
, ORG_CONT_ROLES.ATTRIBUTE4
, ORG_CONT_ROLES.ATTRIBUTE5
, ORG_CONT_ROLES.ATTRIBUTE6
, ORG_CONT_ROLES.ATTRIBUTE7
, ORG_CONT_ROLES.ATTRIBUTE8
, ORG_CONT_ROLES.ATTRIBUTE9
, ORG_CONT_ROLES.ATTRIBUTE10
, ORG_CONT_ROLES.ATTRIBUTE11
, ORG_CONT_ROLES.ATTRIBUTE12
, ORG_CONT_ROLES.ATTRIBUTE13
, ORG_CONT_ROLES.ATTRIBUTE14
, ORG_CONT_ROLES.ATTRIBUTE15
, ORG_CONT_ROLES.PRIMARY_CONTACT_PER_ROLE_TYPE
, ORG_CONT_ROLES.STATUS
, LKUP2.MEANING
, ORG_CONT_ROLES.OBJECT_VERSION_NUMBER
, ORG_CONT_ROLES.CREATED_BY_MODULE
, ORG_CONT_ROLES.APPLICATION_ID
FROM HZ_ORG_CONTACT_ROLES ORG_CONT_ROLES
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
WHERE ORG_CONT_ROLES.ROLE_TYPE = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'CONTACT_ROLE_TYPE'
AND ORG_CONT_ROLES.STATUS = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'REGISTRY_STATUS'
AND ORG_CONT_ROLES.STATUS IN ('A'
, 'I')