FND Design Data [Home] [Help]

View: RA_HCONTACTS

Product: AR - Receivables
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT ACCT_ROLE.ROWID
, ACCT_ROLE.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */
, ACCT_ROLE.LAST_UPDATE_DATE
, ACCT_ROLE.LAST_UPDATED_BY
, ACCT_ROLE.CREATION_DATE
, ACCT_ROLE.CREATED_BY
, ACCT_ROLE.CUST_ACCOUNT_ID /* CUSTOMER_ID */
, ACCT_ROLE.STATUS
, ACCT_ROLE.ORIG_SYSTEM_REFERENCE /* ORIG_SYSTEM_REFERENCE */
, SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50)
, ORG_CONT.LAST_UPDATE_LOGIN
, PARTY.PERSON_PRE_NAME_ADJUNCT
, SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)
, ORG_CONT.JOB_TITLE
, ORG_CONT.MAIL_STOP
, ACCT_ROLE.CUST_ACCT_SITE_ID /* ADDRESS_ID */
, ACCT_ROLE.ATTRIBUTE_CATEGORY
, ACCT_ROLE.ATTRIBUTE1
, ACCT_ROLE.ATTRIBUTE2
, ACCT_ROLE.ATTRIBUTE3
, ACCT_ROLE.ATTRIBUTE4
, ACCT_ROLE.ATTRIBUTE5
, ACCT_ROLE.ATTRIBUTE6
, ACCT_ROLE.ATTRIBUTE7
, ACCT_ROLE.ATTRIBUTE8
, ACCT_ROLE.ATTRIBUTE9
, ACCT_ROLE.ATTRIBUTE10
, ACCT_ROLE.REQUEST_ID
, ACCT_ROLE.PROGRAM_APPLICATION_ID
, ACCT_ROLE.PROGRAM_ID
, ACCT_ROLE.PROGRAM_UPDATE_DATE /*THE KEY IS TAKEN
FROM HZ_PARTIES TABLE AS PERSON KEY IS STORED THERE - BUG 1199439
, 1354647*/
, PARTY.CUSTOMER_KEY /* ORG_CONT.CONTACT_KEY */
, NULL /* CONTACT_PERSONAL_INFORMATION */
, ORG_CONT.DECISION_MAKER_FLAG
, ORG_CONT.JOB_TITLE_CODE
, ORG_CONT.MANAGED_BY
, PARTY.LANGUAGE_NAME /* NATIVE_LANGUAGE */
, ORG_CONT.REFERENCE_USE_FLAG
, ORG_CONT.CONTACT_NUMBER
, ACCT_ROLE.ATTRIBUTE11
, ACCT_ROLE.ATTRIBUTE25
, NULL /* OTHER_LANGUAGE_1 */
, NULL /* OTHER_LANGUAGE_2 */
, ORG_CONT.RANK
, ACCT_ROLE.PRIMARY_FLAG /* PRIMARY_ROLE */
, ACCT_ROLE.ATTRIBUTE12
, ACCT_ROLE.ATTRIBUTE13
, ACCT_ROLE.ATTRIBUTE14
, ACCT_ROLE.ATTRIBUTE15
, ACCT_ROLE.ATTRIBUTE16
, ACCT_ROLE.ATTRIBUTE17
, ACCT_ROLE.ATTRIBUTE18
, ACCT_ROLE.ATTRIBUTE19
, ACCT_ROLE.ATTRIBUTE20
, ACCT_ROLE.ATTRIBUTE21
, ACCT_ROLE.ATTRIBUTE22
, ACCT_ROLE.ATTRIBUTE23
, ACCT_ROLE.ATTRIBUTE24
, PARTY.DO_NOT_MAIL_FLAG
, PARTY.PERSON_NAME_SUFFIX /* SUFFIX */
, REL_PARTY.EMAIL_ADDRESS /* CONTACT'S EMAIL IS RELATIONSHIP PARTY'S EMAIL - 1276469 */
, ORG_CONT.MAILING_ADDRESS_ID /* MAILING_ADDRESS_ID */
, ORG_CONT.MATCH_GROUP_ID /* MATCH_GROUP_ID */
, NULL /* SEX_CODE */
, NULL /* SALUTATION */
, ORG_CONT.DEPARTMENT_CODE
, ORG_CONT.DEPARTMENT
, NULL /* LAST_NAME_ALT */
, NULL /* FIRST_NAME_ALT */
, PARTY.PARTY_ID
, ORG_CONT.ORG_CONTACT_ID
, PARTY.LAST_UPDATE_DATE
, REL.LAST_UPDATE_DATE
, ORG_CONT.LAST_UPDATE_DATE
, REL.RELATIONSHIP_ID
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, HZ_CUST_ACCOUNTS ROLE_ACCT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /*
AND REL.DIRECTIONAL_FLAG = 'F' */

Columns

Name
ROW_ID
CONTACT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
CUSTOMER_ID
STATUS
ORIG_SYSTEM_REFERENCE
LAST_NAME
LAST_UPDATE_LOGIN
TITLE
FIRST_NAME
JOB_TITLE
MAIL_STOP
ADDRESS_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CONTACT_KEY
CONTACT_PERSONAL_INFORMATION
DECISION_MAKER_FLAG
JOB_TITLE_CODE
MANAGED_BY
NATIVE_LANGUAGE
REFERENCE_USE_FLAG
CONTACT_NUMBER
ATTRIBUTE11
ATTRIBUTE25
OTHER_LANGUAGE_1
OTHER_LANGUAGE_2
RANK
PRIMARY_ROLE
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
DO_NOT_MAIL_FLAG
SUFFIX
EMAIL_ADDRESS
MAILING_ADDRESS_ID
MATCH_GROUP_ID
SEX_CODE
SALUTATION
DEPARTMENT_CODE
DEPARTMENT
LAST_NAME_ALT
FIRST_NAME_ALT
CONTACT_PARTY_ID
ORG_CONTACT_ID
PARTY_LAST_UPDATE_DATE
REL_LAST_UPDATE_DATE
ORG_CONT_LAST_UPDATE_DATE
PARTY_RELATIONSHIP_ID