Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_ORG_CONTACT_ROLES_V |
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')