Product: | AR - Receivables |
---|---|
Description: | (Release 11.5 Only) |
Implementation/DBA Data: | APPS.AR_CONTACT_ROLES_V |
SELECT ROLE_RES.ROWID
, ROLE_RES.RESPONSIBILITY_ID
, ROLE_RES.LAST_UPDATE_DATE
, ROLE_RES.LAST_UPDATED_BY
, ROLE_RES.CREATION_DATE
, ROLE_RES.CREATED_BY
, ROLE_RES.LAST_UPDATE_LOGIN
, ROLE_RES.RESPONSIBILITY_TYPE
, ROLE_RES.CUST_ACCOUNT_ROLE_ID
, ROLE_RES.ORIG_SYSTEM_REFERENCE
, ROLE_RES.PRIMARY_FLAG
, ARLKP1.MEANING
, ROLE_RES.ATTRIBUTE_CATEGORY
, ROLE_RES.ATTRIBUTE1
, ROLE_RES.ATTRIBUTE2
, ROLE_RES.ATTRIBUTE3
, ROLE_RES.ATTRIBUTE4
, ROLE_RES.ATTRIBUTE5
, ROLE_RES.ATTRIBUTE6
, ROLE_RES.ATTRIBUTE7
, ROLE_RES.ATTRIBUTE8
, ROLE_RES.ATTRIBUTE9
, ROLE_RES.ATTRIBUTE10
, ROLE_RES.ATTRIBUTE11
, ROLE_RES.ATTRIBUTE12
, ROLE_RES.ATTRIBUTE13
, ROLE_RES.ATTRIBUTE14
, ROLE_RES.ATTRIBUTE15
, ROLE_RES.OBJECT_VERSION_NUMBER
FROM HZ_ROLE_RESPONSIBILITY ROLE_RES
, AR_LOOKUPS ARLKP1
WHERE ROLE_RES.RESPONSIBILITY_TYPE = ARLKP1.LOOKUP_CODE(+)
AND ARLKP1.LOOKUP_TYPE(+) = 'SITE_USE_CODE'