Group Team
This query can be used to get the Approved Supplier List information for the items.

Query is tested in R12 instance.

SELECT ood.organization_code "ORGANIZATION CODE",
              msib.segment1 "ITEM_NUMBER",
              pv.vendor_name "SUPPLIER NAME",
              pv.segment1 "VENDOR NUMBER",
              pvsa.vendor_site_code "SUPPLIER SITE CODE",
              pas.status "SOURCE_ASL_STATUS",
              paa.consigned_from_supplier_flag "CONSIGNED FROM SUPPLIER?"
  FROM APPS.po_approved_supplier_list asl,
              APPS.po_vendors pv,
              APPS.po_vendor_sites_all pvsa,
              APPS.org_organization_definitions ood,
              APPS.mtl_system_items_b msib,
              APPS.po_asl_attributes paa,
             APPS.po_asl_statuses pas
WHERE pv.vendor_id = asl.vendor_id
   AND pvsa.vendor_site_id = asl.vendor_site_id
   AND ood.organization_id = asl.using_organization_id
   AND ood.operating_unit = pvsa.org_id
   AND asl.item_id = msib.inventory_item_id
   AND asl.using_organization_id = msib.organization_id
   AND ood.organization_id = msib.organization_id
   AND asl.asl_id = paa.asl_id
   AND asl.using_organization_id = paa.using_organization_id
   AND msib.organization_id = paa.using_organization_id
   AND ood.organization_id = paa.using_organization_id
   AND asl.asl_status_id = pas.status_id
   AND msib.segment1 = :ITEM NUMBER
Labels: edit post
104 Responses
  1. Sekhar Byna Says:

    Very intersting notes on ebusiness Suite
    Please do share your articles like this.THis link also useful to Find info On Oracle apps-jobs,interview tips,Resume preparation,functional issuesOracle eBusiness Suite


  2. Unknown Says:

    Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.Hadoop training in chennai


  3. Unknown Says:

    Thanks for sharing the information.Oracle Applications not a single application, it is a collection of a bunch of applications collected as accounts payable, purchasing, accounts receivable, inventory, human resources, order management, general ledger and fixed assets, etc.

    We are providing best online training for oracle apps technical.For more details please go through the site
    ORACLE APPS TECHNICAL Online Training


  4. Unknown Says:

    Excellent post, I agree with you 100%! I’m always scouring the oracle for new information and learning whatever I can, and in doing so I sometimes leave comments on blogs.Oracle Training In Chennai


  5. Anonymous Says:


    Looking for real-time training institue.Get details now may if share this link visit
    VB-Net-training-in-chennai.html
    oraclechennai.in:


  6. Unknown Says:

    Latest Govt Bank Railway Jobs 2016

    Nice post with awesome explanation................


  7. Unknown Says:

    GSSSB 2480 Revenue Talati Bharti Recruitment 2016

    Use full information of the post, thank you sir ..........


  8. Unknown Says:

    Latest Govt Jobs Notification 2016

    Thanks to sharing this nice information, I really appreciate your thinking..................


  9. Sekhar Byna Says:

    Nice information you can also find Oracle APPS techno functional Snippets on
    Oracle APPS techno functional Tutorials


  10. Unknown Says:

    Thanks for sharing these information. It’s a very nice topic. We IT hub Online Training are good in giving the oracle apps technical Training


  11. Divit Says:

    Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.

    Hadoop Certification in Chennai





  12. Unknown Says:

    Thanks for posting this useful information,
    load runner training in chennai


  13. Unknown Says:

    Thanks for the useful tips with us..
    ios training in chennai


  14. vignesjoseph Says:

    We share this new idea is very helpful to me.I read that our website blog this content some Quality of information in your blog.
    Hadoop Training in Chennai
    Hadoop Training Institute in Chennai





  15. Unknown Says:

    I read your blog it's really good, thanks for sharing valuable information with us.
    Excellent Article, Nice to read your article, very informative.
    Excellent article Top AC mechanics Professional Camera sellers ChennaiCatering Service in ChennaiTop Educational Institute Chennai

    Excellent Article
    swimmingpool contractor chennai
    swimmingpool equipment dealer chennai
    swimmingpool consultant chennai


  16. Unknown Says:

    Really very good informative blog.Useful information for all..Thanks for sharing.


    Weblogic Admin Training


  17. Really Thanks For Posting Such an Info...Thanks for Sharing...

    67500/12


  18. Unknown Says:

    This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. digital transformation consulting Thanks for posting.



  19. 24Layouts Says:

    Thanks For Sharing Such an Informative Post.....

    Plots for Sale in Vizag



  20. nivatha Says:

    Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
    Devops training in velachry
    Devops training in OMR
    Deops training in annanagar
    Devops training in chennai
    Devops training in marathahalli
    Devops training in rajajinagar
    Devops training in BTM Layout


  21. Unknown Says:

    Hello I am so delighted I found your blog, I really found you by mistake, while I was looking on Yahoo for something else, anyways I am here now and would just like to say thanks for a tremendous post. Please do keep up the great work.

    java training in chennai | java training in bangalore

    java online training | java training in pune

    selenium training in chennai

    selenium training in bangalore


  22. sathya shri Says:
    This comment has been removed by the author.

  23. James jones Says:

    living room furnitures that are light colored can make your living room look larger“ Supplier Management in Japan


  24. ganga pragya Says:


    This is very good content you share on this blog. it's very informative and provide me future related information.

    angularjs-Training in velachery

    angularjs-Training in annanagar

    angularjs Training in chennai

    angularjs Training in chennai



  25. Unknown Says:

    I know you feel more happy when you get things done and best of all those things are your most precious treasure.
    python training in chennai
    python training in Bangalore
    Python training institute in chennai


  26. rohini Says:

    Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.


    selenium training in electronic city | selenium training in electronic city | Selenium Training in Chennai | Selenium online Training | Selenium Training in Pune | Selenium Training in Bangalore



  27. Prityyou Says:

    Awwsome informative blog ,Very good information thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Aviation Academy in Chennai | Aviation Courses in Chennai | Best Aviation Academy in Chennai | Aviation Institute in Chennai | Aviation Training in Chennai







  28. gowthunan Says:

    It has been just unfathomably liberal with you to give straightforwardly what precisely numerous people would've promoted for an eBook to wind up making some money for their end, basically given that you could have attempted it in the occasion you needed.
    iosh course in chennai


  29. sai Says:

    The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
    Python training in bangalore
    Python course in pune
    Python training in bangalore


  30. Unknown Says:

    Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    excel advanced excel training in bangalore | Devops Training in Chennai


  31. prabha Says:

    Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in btm

    angularjs Training in electronic-city





  32. Unknown Says:

    excellent blog one of the most and finest & informative blog and i started following JNTU 99




  33. Appreciating the persistence, you put into your blog and detailed information you provide.
    nebosh igc courses in chennai











  34. rohini Says:

    From your discussion I have understood that which will be better for me and which is easy to use. Really, I have liked your brilliant discussion. I will comThis is great helping material for every one visitor. You have done a great responsible person. i want to say thanks owner of this blog.
    Authorized iphone service center in Chennai | iphone service center in chennai | Mobile service center in chennai | Authorized iphone service center in Chennai | iphone service center in chennai


  35. Anonymous Says:

    Thanks for your great and helpful presentation I like your good service. I always appreciate your post. That is very interesting I love reading and I am always searching for informative information like this.Also Checkout: blockchain technology training chennai | blockchain training institute in chennai | blockchain courses in chennai | blockchain training center in chennai



  36. Soumitasai Says:

    Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.


    Check out : big data training in velachery
    big data hadoop training cost in chennai
    big data training in chennai omr
    big data training in chennai velachery


  37. cdcdcdcd Says:



    Nice posting..thanks.
    Ijin..info investasi lahan keluarga di San Diego Hills memorial Park bebas biaya perawatan dan kebersihan selamanya klik
    Still Hunting Method
    Hunting psych tips Survival Tips Travel Touring Tips




  38. Unknown Says:

    1. many peoples want to join random whatsapp groups . On this website you can join unlimited groups . click and get unlimited whatsapp group links



  39. sasireka Says:

    Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. 

    ReactJS Online Training


  40. jaanu Says:

    Thanks a lot for one’s intriguing write-up. It’s actually exceptional. Searching ahead for this sort of revisions.
    AI course malaysia



  41. Sivakumari.B Says:

    Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
    If you are looking for any Data science Related information please visit our website best course for data science page!


  42. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. Machine Learning Final Year Projects In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.






  43. bavisthra Says:

    Study ExcelR Business Analytics Course where you get a great experience and better knowledge.

    Business Analytics Course


  44. Rashika Says:

    hank you for sharing very good post, it was so Nice to read and useful to improve my knowledge as updated one, keep blogging.
    It’s great to come across a blog every once in a while that isn’t
    AWS training in chennai | AWS training in anna nagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery




  45. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.

    Correlation vs Covariance




  46. devi Says:

    This is the information that I was looking for.. Thanks for the efforts you put to gather such a nice content and posted here. Wonderful job!! let me tell you one thing that is it is very useful for who is looking for..Thanks for sharing this interesting and useful blog..
    Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training


  47. Devi Says:

    Thanks for Sharing This Article.It is very so much valuable content. oracle training in chennai




  48. Nice article and thanks for sharing with us. Its very informative


    Plots in PHARMA CITY


  49. Ranjith Says:

    Great post! I am actually getting ready to across this information, i am very happy to this commands.Also great blog here with all of the valuable information you have.Well done, its a great knowledge.

    python Training in chennai

    python Course in chennai




  50. we are here for you guys to enhance your skills during this period. Our institution offering you CS executive classes and free CSEET classes. So guys for more info contact us or visit us at website https://uniqueacademyforcommerce.com/


  51. Excellent blog. Lots of useful information here, thanks for your effort!
    Gated community Plots in Vizag


  52. Amazing opportunities came with amazing time and here is our institution offering you CS executive classes and a free of cost CSEET classes. So what are you waiting for contact us or visit our website
    cs executive
    freecseetvideolectures/


  53. hi thanku so much this information this blog is very useful
    cs executive
    freecseetvideolectures/


  54. Oliver Says:

    The Universal Currency Converter Is The Most Reliable And Accurate CHF USD Currency Conversion Tool On The Internet. It Is Fast And Easy To Use, And Supports Over 150 World Currencies.




  55. SwarnApp Says:

    Very useful and informative blog.
    jewellery shop management software
    Jewellery Shop Management Software


  56. SwarnApp Says:

    Very useful and informative blog.
    Jewellery ERP Software Dubai
    Jewellery ERP Software Dubai


  57. AlexaJade Says:

    Choosing Passexam4sure for my CyberArk CAU201 Exam preparation was a game-changer. The study materials were well-structured and organized, making it easy to grasp the intricate concepts of CyberArk. The practice exams were an excellent way to assess my progress and improve my test-taking skills. Passexam4sure's resources are reliable and comprehensive, giving me the confidence to face the CyberArk CAU201 Dumps. I'm grateful to Passexam4sure for helping me achieve my certification goals.


  58. i really appreciate your efforts for writing this blog.Thanks for posting.
    Keep posting.
    SQL training in Pune


  59. great, valuable post , i have learned many intresting thing about sql from your blog, thanks . keep posting and checking out my blog if your intresting in python course in satara


Post a Comment