5 Replies Latest reply: Jan 20, 2013 6:09 AM by Kashif M RSS

    hz_parties and po_vendors

    800528
      hi

      what is difference between hz_parties and po_vendors ,in po_vendors a column party_id is there ,is that same as hz_parties party_id ,what is mean for that ?

      please help me in this regard
        • 1. Re: hz_parties and po_vendors
          user-Keen
          Dear.

          Hz_parties is included all supplier information, however, in po_vendors showing only those suppliers was called in PO.

          --thanks                                                                                                                                                                                                                                                                                           
          • 2. Re: hz_parties and po_vendors
            PranitSaha
            797525 wrote:
            hi

            what is difference between hz_parties and po_vendors ,in po_vendors a column party_id is there ,is that same as hz_parties party_id ,what is mean for that ?

            please help me in this regard
            PARTY_ID in HZ_PARTIES is the primary key while the same in the PO_VENDORS is the foreign key.
            • 3. Re: hz_parties and po_vendors
              rajuG
              Hi,

              The part_id in po_vendors and hz_parties both are same only

              po_vendors table gives the only the supplier information..

              But the hz_parties gives all the information related to the suppliers,customers,persons and inventory organizations with reference to the column name as 'party_name'.

              Regards
              Raju
              • 4. Re: hz_parties and po_vendors
                ravins
                wat is the importance of enabled_flag column in po_vendors table.
                • 5. Re: hz_parties and po_vendors
                  Kashif M
                  Would suggest to go through for detail info on
                  http://etrm.oracle.com/pls/et1211d9/etrm_search.search
                  thanks