0 Replies Latest reply on Nov 27, 2013 2:33 PM by ef2019c7-080c-4475-9cf4-2cf1b1057a41

    Joins b/w Vendors from Suppliers tables and Territory (jtf) tables R12

    ef2019c7-080c-4475-9cf4-2cf1b1057a41

      Hi,

       

      I m trying to get the details of vendors using ap_suppliers & ap_supplier_sites_all.

      once i get vendor details, I should see if these vendors exist in Territory tables ( jtf_terr_rsc_all  jtf_terr_qual_all  jtf_terr_values_all  jtf_terr_all)

       

      Could you let me know logic and joins.

       

      Thanks.