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
45 Responses
  1. Thanks for Information Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business.Oracle Apps Technical Online Training


  2. Cub Training Says:

    Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.


  3. vignesh m Says:

    Hi this is raj i am having 3 years of experience as a php developer and i am certified. i have knowledge on OOPS concepts in php but dont know indepth. After learning hadoop will be enough to get a good career in IT with good package? and i crossed hadoop training in chennai website where someone please help me to identity the syllabus covers everything or not??
    Thanks,
    raj


  4. 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


  5. Andria BZ Says:

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


  6. 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


  7. Stephen Says:

    There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.


  8. www.oracleonlinetraining.com is providing Oracle APPS Functional and Technical

    training contact us:+91-9533456356, by real time experts in USA,UK,Canada,

    Australia.Oracle apps finance online training,oracle Apps SCM online

    training,Oracle apps technical online training,oracle Apps 11g online

    training,Oracle apps manufacturing training,Oracle Apps Supply Chain Management training

    full course details please visit our website http://oracleonlinetraining.com/




  9. Rohini T Says:

    if possible share with us...Very useful information is providing by ur blog.here is a way to find Oracle Training In Chennai


  10. Rohini T Says:

    i wondered keep share this sites .if anyone wants realtime training Greens technolog chennai in Adyar visit this blog..performance tuning training In Chennai and more Oracle Training In Chennai


  11. Rohini T Says:

    once again sharing this informative blog .Datastage training In Chennai It uses a graphical notation to construct data integration solutions and is available in various versions may visit greens technology chennai in adyar Greens Technologys Training In Chennai


  12. Rohini T Says:

    i gain the knowledge of Java programs easy to add functionalities play online games, chating with others and industry oriented coaching available from greens technology chennai in Adyar may visit.Core java training In Chennai


  13. Rohini T Says:

    I have read your blog and I got very useful and knowledgeable information from your blog. It’s really a very nice article Greens Technologies Training In Chennai


  14. Rohini T Says:

    fantastic presentation .We are charging very competitive in the market which helps to bring more oracle professionals into this market. may update this blog . Oracle training In Chennai which No1:Greens Technologies In Chennai


  15. Rohini T 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


  16. Pooja Doss Says:

    There are lots of information about latest technology and how to get trained in them, like Best Hadoop Training In Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..


  17. Pooja Doss Says:

    I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    SalesForce Training in Chennai


  18. Pooja Doss Says:

    Pretty article! I found some useful information in your blog, it was awesome to read,thanks for sharing this great content to my vision, keep sharing..
    Unix Training In Chennai


  19. Pooja Doss Says:

    This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic
    Android Training In Chennai In Chennai


  20. Pooja Doss Says:

    I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job.
    SAP Training in Chennai


  21. Pooja Doss Says:

    Oracle Training in chennai
    Thanks for sharing such a great information..Its really nice and informative..


  22. Pooja Doss Says:

    Selenium Training in Chennai
    Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..


  23. Pooja Doss Says:

    Data warehousing Training in Chennai
    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..


  24. Pooja Doss Says:

    Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Websphere Training in Chennai


  25. Pooja Doss Says:

    Oracle DBA Training in Chennai
    Thanks for sharing this informative blog. I did Oracle DBA Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..


  26. Saranya D Says:



    hai you have to learned to lot of information about c# .net Gain the knowledge and hands-on experience you need to successfully design, build and deploy applications with c#.net.
    C-Net-training-in-chennai


  27. Saranya D Says:


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


  28. Saranya D Says:



    hai If you are interested in asp.net training, our real time working.
    asp.net Training in Chennai.
    Asp-Net-training-in-chennai.html


  29. Saranya D Says:


    Amazing blog if our training additional way as an silverlight training trained as individual, you will be able to understand other applications more quickly and continue to build your skill set which will assist you in getting hi-tech industry jobs as possible in future courese of action..visit this blog
    silverlight-training.html
    greenstechnologies.in:


  30. Saranya D Says:


    awesome Job oriented sharepoint training in Chennai is offered by our institue is mainly focused on real time and industry oriented. We provide training from beginner’s level to advanced level techniques thought by our experts.
    if you have more details visit this blog.
    SharePoint-training-in-chennai.html


  31. Saranya D Says:


    if share valuable information about cloud computing training courses, certification, online resources, and private training for Developers, Administrators, and Data Analysts may visit
    Cloud-Computing-course-content.html


  32. Saranya D Says:



    I also wanted to share few links related to oracle scm training Check this site.if share indepth oracle training.Go here if you’re looking for information on oracle training.
    Oracle-SCM-training-in-Chennai.html


  33. Saranya D Says:



    awesome Job oriented sharepoint training in Chennai is offered by our institue is mainly focused on real time and industry oriented. We provide training from beginner’s level to advanced level techniques thought by our experts.
    if you have more details visit this blog.
    SharePoint-training-in-chennai.html


  34. Latest Govt Bank Railway Jobs 2016

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


  35. Latest Govt Bank Jobs Notification 2016

    Great collection of information, Very Impressive Article


  36. Akasha Says:

    Thanks for sharing this informative blog..
    Struts Training In Chennai


  37. Akula Rahul Says:

    GSSSB 2480 Revenue Talati Bharti Recruitment 2016

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


  38. Latest Govt Jobs Notification 2016

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


  39. Jhon David Says:

    Well Said. The content provided is true up to my knowledge. This made me to understand the concepts very clear. Thanks for sharing this wonderful information in here. Keep blogging article like this. I have bookmarked this page for future reference as well.


    Hadoop Training Chennai | Big Data Training Chennai | JAVA Course in Chennai



  40. Savitha Says:

    Excellent information with unique content and it is very useful to know about the information based on blogs.
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    SAS Training In Chennai


  41. Sekhar Byna Says:

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


  42. Jessy Candy 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


  43. Jessy Candy Says:

    Thanks for posting this useful information,
    It is very useful to who are searching for oracle apps technical online training .



Post a Comment