re: party relationship

Hi,

Does anyone have a query to pull details shown under Party relationships tab of customers.

We may have a customer with relationship setup. We tried selecting from HZ_PARTY_RELATIONSHIP_V , but not getting complete details.

Customer:   ABC Group Inc.

Party relationship tab

ABC -2                     Subsidiary

============================================================================

If we query customer ABC-2:

It would show party relationship

ABC Group Inc           Parent of Subsidiary

=============================================================================

So in the report, like a Parent and Subsidiary report. Relationships have been setup.

Customer Name     Parent                             Relationship Role

---------------------      ------------------------------    -----------------------

ABC Group Inc                                                Parent of Subsidiary

ABC-2                   ABC Group Inc                   Subsidiary

thanks