This View retrieves the Related Customer Accounts for a given Customer Account and also specifies the Relationship type (Contact of, Employee of , etc)
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT CUST_ACCOUNT_ID , RELATED_CUST_ACCOUNT_ID , RELATIONSHIP_TYPE , BILL_TO_FLAG , SHIP_TO_FLAG , ORG_ID FROM HZ_CUST_ACCT_RELATE WHERE STATUS = 'A'
[Home] [Help]