1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Hz_cust_acct_sites_all vs hz_party_sites

Discussion in 'Oracle Apps Technical' started by sambhaji, Oct 31, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,


    Please tell the difference between Hz_cust_acct_sites_all vs hz_party_sites, difference between two sites??


    And also what is basically customer account is?

    Regards
    Sambhaji
     
  2. Raviprakash

    Raviprakash Forum Genius

    Messages:
    14
    Likes Received:
    2
    Trophy Points:
    785
    The HZ_CUST_ACCT_SITES_ALL table stores all customer account sites across all operating units.
    The primary key for this table is CUST_ACCT_SITE_ID.

    Few Important Columns are

    CUST_ACCT_SITE_ID: Customer site identifier
    CUST_ACCOUNT_ID: Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table
    PARTY_SITE_ID: Identifier for a party site. Foreign key to the HZ_PARTY_SITES table
    BILL_TO_FLAG: Indicates if this is a Bill-To site.
    SHIP_TO_FLAG: Indicates if this is a Ship-To site.
    MARKET_FLAG: Indicates if this is a Marketing site.

    The HZ_PARTY_SITES table links a party (HZ_PARTIES) and a location (HZ_LOCATIONS) and stores location-specific party information.
    The primary key for this table is PARTY_SITE_ID.

    Few Important Columns are

    PARTY_SITE_ID: Party site identifier.
    PARTY_ID: Identifier for the party. Foreign key to the HZ_PARTIES table.
    LOCATION_ID: Identifier for the party site. Foreign key to the HZ_LOCATIONS table.
    PARTY_SITE_NUMBER: Party site number.
    PARTY_SITE_NAME: User-defined name for the site.
    ADDRESSEE: Addressee information.

    The HZ_CUST_ACCT_SITES_ALL and The HZ_PARTY_SITES linked to the PARTY_SITE_ID.


    select * from HZ_CUST_ACCT_SITES_ALL hzasa,HZ_PARTY_SITES hzps where hzasa.PARTY_SITE_ID=hzps.PARTY_SITE_ID