Query to get the Approved Supplier Information for the Item
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:
    March 16, 2015 at 10:35 AM

    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:
    March 25, 2015 at 12:05 AM

    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:
    May 6, 2015 at 12:39 AM

    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:
    October 5, 2015 at 5:00 AM

    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:
    October 8, 2015 at 12:09 AM


    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:
    October 14, 2015 at 4:44 AM

    Latest Govt Bank Railway Jobs 2016

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


  7. Unknown Says:
    December 9, 2015 at 8:20 PM

    GSSSB 2480 Revenue Talati Bharti Recruitment 2016

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


  8. Unknown Says:
    December 9, 2015 at 9:31 PM

    Latest Govt Jobs Notification 2016

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


  9. Sekhar Byna Says:
    February 28, 2016 at 8:06 PM

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


  10. Unknown Says:
    March 21, 2016 at 11:27 PM

    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:
    May 12, 2016 at 5:32 AM

    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





  14. Unknown Says:
    November 3, 2016 at 5:43 AM

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


  15. Unknown Says:
    November 4, 2016 at 6:07 AM

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


  16. vignesjoseph Says:
    June 22, 2017 at 2:53 AM

    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





  20. Unknown Says:
    April 8, 2018 at 6:15 AM

    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


  21. Unknown Says:
    April 29, 2018 at 10:22 PM

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


    Weblogic Admin Training


  22. Peter Johnson Says:
    June 25, 2018 at 9:39 PM

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

    67500/12


  23. Unknown Says:
    July 13, 2018 at 5:01 AM

    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.



  25. 24Layouts Says:
    August 9, 2018 at 4:55 AM

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

    Plots for Sale in Vizag



  27. nivatha Says:
    August 30, 2018 at 2:43 AM

    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


  28. Unknown Says:
    September 8, 2018 at 12:23 AM

    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


  29. sathya shri Says:
    September 13, 2018 at 10:02 PM
    This comment has been removed by the author.

  30. James jones Says:
    September 19, 2018 at 10:57 PM

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


  31. ganga pragya Says:
    September 21, 2018 at 7:47 AM


    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



  33. Unknown Says:
    October 4, 2018 at 3:54 AM

    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


  34. rohini Says:
    October 16, 2018 at 12:19 AM

    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



  36. Prityyou Says:
    October 22, 2018 at 1:55 AM

    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







  42. gowthunan Says:
    October 30, 2018 at 5:11 AM

    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


  43. sai Says:
    November 1, 2018 at 3:31 AM

    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


  44. Unknown Says:
    November 2, 2018 at 12:34 AM

    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


  45. prabha Says:
    November 2, 2018 at 4:43 AM

    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





  49. Unknown Says:
    November 14, 2018 at 2:38 AM

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




  52. sunshineprofe Says:
    November 27, 2018 at 9:07 PM

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











  62. rohini Says:
    February 18, 2019 at 3:54 AM

    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


  63. Anonymous Says:
    March 10, 2019 at 1:35 AM

    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



  65. Soumitasai Says:
    March 20, 2019 at 9:23 PM

    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


  66. cdcdcdcd Says:
    March 31, 2019 at 6:10 AM



    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




  69. Unknown Says:
    May 7, 2019 at 4:38 AM

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



  71. sasireka Says:
    July 6, 2019 at 7:59 AM

    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


  72. jaanu Says:
    July 23, 2019 at 10:49 PM

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



  74. Sivakumari.B Says:
    August 27, 2019 at 6:23 AM

    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!


  75. Garrick Co Ida Says:
    December 6, 2019 at 1:23 AM

    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.






  80. bavisthra Says:
    April 20, 2020 at 1:46 AM

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

    Business Analytics Course


  81. Rashika Says:
    May 18, 2020 at 9:50 AM

    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




  84. datasciencecourse Says:
    June 4, 2020 at 10:07 PM

    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




  87. devi Says:
    July 25, 2020 at 10:35 AM

    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


  88. Devi Says:
    August 7, 2020 at 1:31 AM

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


  89. Tableau Training in Hyderabad Says:
    December 4, 2020 at 9:28 PM



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


    Plots in PHARMA CITY


  90. Ranjith Says:
    January 3, 2021 at 8:36 AM

    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




  93. Free CSEET Online Classes Says:
    July 16, 2021 at 4:18 AM

    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/


  94. Subhagruha Projects Says:
    August 16, 2021 at 10:20 PM

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


  95. UNIQUE ACADEMY Says:
    September 13, 2021 at 10:19 PM

    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/


  96. UNIQUE ACADEMY Says:
    October 30, 2021 at 7:35 AM

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


  97. Oliver Says:
    November 1, 2021 at 11:30 PM

    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.




  100. SwarnApp Says:
    January 28, 2023 at 3:32 AM

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


  101. SwarnApp Says:
    April 20, 2023 at 5:56 AM

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


  102. AlexaJade Says:
    July 8, 2023 at 2:12 AM

    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.


  103. iteducationcentre Says:
    September 2, 2023 at 12:36 AM

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


  104. Anonymous Says:
    September 9, 2023 at 4:07 AM

    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

Subscribe to: Post Comments (Atom)