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!

Unable to find supplier number

Discussion in 'SQL PL/SQL' started by kartheekbk, Nov 3, 2014.

  1. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi Forum,

    I'm unable to find the supplier number(segment1) with the below queries, I have fetched vendor_id and vendor_site_id but still not got any records for segment1

    select vendor_id from ap_supplier_sites_all where vendor_site_id = 41234
    i got vendor_id as : 56789

    select * from ap_suppliers where vendor_id= 56789
    but found no records.

    Please let me know, what could be the issue for this ?

    is it possible to know the supplier name and number in front end application(oracleEBS) with vendor site id and vendor id ?

    Please help to get this issue resolved. Thanks!

    Regards,
    Kartheek B
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Kartheek,

    1. Run the below query and let us know whether it is returning the rows or not? If returning just check the count , creation date for all are same. Try to find how those records are inserted.


    Code (SQL):
     SELECT *
    FROM  ap_supplier_sites_all assa
    WHERE NOT EXISTS ( SELECT 'X' FROM ap_suppliers asa WHERE asa.vendor_id = assa.vendor_id)

    2. Based on below queries just check whether you are able to find the vendor or not??
    Code (SQL):

    SELECT party_site_id
    FROM ap_supplier_sites_all
    WHERE vendor_site_id = 41234

    SELECT party_id
    FROM hz_party_sites
    WHERE party_site_id = <>


    SELECT *
    FROM hz_parties
    WHERE party_id = <>

    SELECT * FROM ap_suppliers
    WHERE party_id = <>


    Regards
    Sambasiva Reddy.K
     
  3. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi Sambasiva, thanks for your reply.

    Below are the results,

    for 1st Query,
    I got 4 records where one records has different creaion date and other 3 records has same date.
    Also noted that all are created by the same user id.

    for 2nd Query,
    first statement itself failed as no party_site_id fetched.

    advise me for next steps.