Scribd Logo
Upload

Welcome to Scribd!

  • 96 views

    Party & Relationship: Oracle Application Technical

    Uploaded by

    kumar_amit_99
    This document provides an overview of the key tables and relationships in an Oracle application for managing party, customer, and profile data. It lists core tables for parties, customer accounts, account sites, locations, relationships, contact points and profiles for customers, persons, and organizations along with their primary keys and relationships between tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Party & Relationship: Oracle Application Technical

    Uploaded by

    kumar_amit_99
    96 views1 page
    This document provides an overview of the key tables and relationships in an Oracle application for managing party, customer, and profile data. It lists core tables for parties, customer accounts, account sites, locations, relationships, contact points and profiles for customers, persons, and organizations along with their primary keys and relationships between tables.

    Original Description:

    HZ Tables

    Original Title

    HZ Tables

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of the key tables and relationships in an Oracle application for managing party, customer, and profile data. It lists core tables for parties, customer accounts, account sites, locations, relationships, contact points and profiles for customers, persons, and organizations along with their primary keys and relationships between tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    96 views1 page

    Party & Relationship: Oracle Application Technical

    Uploaded by

    kumar_amit_99
    This document provides an overview of the key tables and relationships in an Oracle application for managing party, customer, and profile data. It lists core tables for parties, customer accounts, account sites, locations, relationships, contact points and profiles for customers, persons, and organizations along with their primary keys and relationships between tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    Oracle application technical

    HZ_PARTIES
    PARTY_ID
    HZ_CUST_ACCOUNTS
    CUST_ACCOUNT_ID
    PARTY_ID
    HZ_CUST_ACCT_SITES_ALL
    CUST_ACCT_SITE_ID
    CUST_ACCOUNT_ID
    PARTY_SITE_ID
    HZ_CUST_SITE_USES_ALL
    SITE_USE_ID
    CUST_ACCT_SITE_ID
    HZ_PARTY_SITES
    PARTY_SITE_ID
    LOCATION_ID
    PARTY_ID
    HZ_LOCATIONS
    LOCATION_ID
    HZ_RELATIONSHIPS
    RELATIONSHIP_ID
    SUBJECT_ID
    OBJECT_ID
    PARTY_ID
    HZ_PARTIES (Contact Person)
    PARTY_ID
    Party & Relationship
    SUBJECT_ID
    OBJECT_ID
    PARTY_ID
    CUST_ACCOUNT_ID
    CUST_ACCT_SITE_ID
    PARTRY_ID of Relationship
    HZ_CONTACT_POINTS
    CONTACT_POINT_ID
    OWNER_TABLE_ID
    OWNER_TABLE_TYPE
    PARTY_ID
    CUST_ACCT_SITE_ID
    LOCATION_ID
    OWNER_TABLE_ID = PARTY_SITE_ID
    OWNER_TABLE_ID = PARTY_ID
    OWNER_TABLE_ID = PARTY_ID
    HZ_CUSTOMER_PROFILES
    CUST_ACCOUNT_PROFILE_ID
    CUST_ACCOUNT_ID
    SITE_USE_ID
    PROFILE_CLASS_ID
    SITE_USE_ID
    HZ_CUST_PROFILE_AMTS
    CUST_ACCT_PROFILE_AMT_ID
    CUST_ACCOUNT_PROFILE_ID
    CUST_ACCOUNT_PROFILE_ID
    HZ_PERSON_PROFILES
    PERSON_PROFILE_ID
    PARTY_ID
    PARTY_ID
    HZ_ORGANIZATION_PROFILES
    ORGANIZATION_PROFILE_ID
    PARTY_ID
    PARTY_ID
    HZ_CUST_ACCT_RELATE_ALL
    CUST_ACCOUNT_ID
    RELATED_CUST_ACCOUNT_ID

    You might also like