[Home] [Help]
View: IBE_OE_CONTACTS_V
Product: | IBE - iStore |
Description: | This view is used to retrieve the Order's Billling or Shipping Contact name |
Implementation/DBA Data: |
APPS.IBE_OE_CONTACTS_V
|
View Text
SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, ACCT_ROLE.CUST_ACCT_SITE_ID ORG_ID
, ACCT_ROLE.CUST_ACCOUNT_ID
, ACCT.ACCOUNT_NUMBER
, ACCT.PARTY_ID
, REL.PARTY_ID
, REL.SUBJECT_ID
, PARTY.PERSON_FIRST_NAME||' '||PARTY.PERSON_LAST_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ORG_CONT.JOB_TITLE
, ACCT_ROLE.STATUS
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCT
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
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_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.OBJECT_ID = ACCT.PARTY_ID
AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID
Columns
Name |
CUST_ACCOUNT_ROLE_ID |
CUST_ACCT_SITE_ID |
CUST_ACCOUNT_ID |
ACCOUNT_NUMBER |
COMPANY_PARTY_ID |
REL_PARTY_ID |
PERSON_PARTY_ID |
PARTY_NAME |
FIRST_NAME |
LAST_NAME |
JOB_TITLE |
STATUS |