Product: | AR - Receivables |
---|---|
Description: | (Release 11.5 Only) |
Implementation/DBA Data: | APPS.AR_CUSTOMER_RELATIONSHIPS_V |
SELECT REL.ROWID
, REL.RELATED_CUST_ACCOUNT_ID
, REL.CUST_ACCOUNT_ID
, REL.LAST_UPDATE_DATE
, REL.OBJECT_VERSION_NUMBER
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.RELATIONSHIP_TYPE
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, REL.STATUS
, REL.COMMENTS
, REL.CUSTOMER_RECIPROCAL_FLAG
, REL.RELATIONSHIP_TYPE
, L.MEANING
, REL.REQUEST_ID
, REL.PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE
, REL.ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1
, REL.ATTRIBUTE2
, REL.ATTRIBUTE3
, REL.ATTRIBUTE4
, REL.ATTRIBUTE5
, REL.ATTRIBUTE6
, REL.ATTRIBUTE7
, REL.ATTRIBUTE8
, REL.ATTRIBUTE9
, REL.ATTRIBUTE10
, REL.ATTRIBUTE11
, REL.ATTRIBUTE12
, REL.ATTRIBUTE13
, REL.ATTRIBUTE14
, REL.ATTRIBUTE15
, REL.BILL_TO_FLAG
, REL.SHIP_TO_FLAG
FROM HZ_CUST_ACCT_RELATE REL
, HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
, AR_LOOKUPS L
WHERE REL.RELATED_CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND L.LOOKUP_CODE = REL.RELATIONSHIP_TYPE
AND L.LOOKUP_TYPE = 'RELATIONSHIP_TYPE'