Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials
Home/ Questions/Q 81698
Next
In Process

Oraask Latest Questions

Question
Beter
  • 0
  • 0
BeterExplorer
Asked: February 21, 20232023-02-21T18:30:55+03:00 2023-02-21T18:30:55+03:00In: Oracle EBS Queries

Query to Get Supplier Details in Oracle APPS R12

  • 0
  • 0

Could you please somebody help me with a query to list supplier details in Oracle Apps R12

1
  • 1 1 Answer
  • 5k Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    Related Questions

    • How to Initialize Oracle APPS session using SQL Developer
    • Return to Vendor Tables in Oracle APPS R12
    • Query to get posted AP invoice in Oracle APPS R12
    • Query to Get Chart of Account Description in Oracle APPS R12
    • What are GL Tables in Oracle APPS R12

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. Hassan AbdElrahman
      Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
      2023-02-22T00:03:02+03:00Added an answer on February 22, 2023 at 12:03 am
      This answer was edited.

      Hi Beter, Please find below a query to get the master supplier informations:

      SELECT HOU.NAME OU_NAME
      ,APPS.ORG_ID
      ,APS.SEGMENT1 SUPPLIER_NUMBER
      ,APS.VENDOR_TYPE_LOOKUP_CODE SUPPLIER_TYPE
      ,APS.VENDOR_NAME SUPPLIER_NAME
      ,APS.VENDOR_NAME_ALT SUPPLIER_NAME_ALT
      ,APS.NUM_1099 TAXPAYER_ID
      ,APS.VAT_REGISTRATION_NUM TAX_REGISTRATION_NUM
      ,APS.ALLOW_AWT_FLAG SUPPLIER_ALLOW_WITHHOLDING_TAX
      ,DECODE (APS.END_DATE_ACTIVE, NULL, 'ACTIVE', 'IN ACTIVE') ACTIVE_CODE
      ,APPS.VENDOR_SITE_ID
      ,APPS.INACTIVE_DATE
      ,APPS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
      ,APPS.VENDOR_SITE_CODE_ALT SITE_CODE_ALT
      ,APPS.ALLOW_AWT_FLAG SITE_ALLOW_WITHHOLDING_TAX
      ,APPS.ADDRESS_LINE1
      ,APPS.ADDRESS_LINE2
      ,APPS.ADDRESS_LINE3
      ,APPS.ADDRESS_LINE4
      ,APPS.CITY
      ,APPS.STATE
      ,APPS.ZIP POST_CODE
      ,APPS.SUPPLIER_NOTIF_METHOD SITE_PO_NOTIF_METHOD
      ,APPS.EMAIL_ADDRESS SITE_PO_EMAIL
      ,APS.PAY_GROUP_LOOKUP_CODE
      FROM AP_SUPPLIERS APS, AP_SUPPLIER_SITES_ALL APPS, HR_OPERATING_UNITS HOU
      WHERE APS.VENDOR_ID = APPS.VENDOR_ID(+)
      AND APS.END_DATE_ACTIVE IS NULL
      AND APPS.INACTIVE_DATE IS NULL
      AND HOU.ORGANIZATION_ID(+) = APPS.ORG_ID;

      Above query will list all suppliers details: OU_NAME, ORG_ID, SUPPLIER_NUMBER, SUPPLIER_TYPE, SUPPLIER_NAME, SUPPLIER_NAME_ALT, TAXPAYER_ID, TAX_REGISTRATION_NUM, SUPPLIER_ALLOW_WITHHOLDING_TAX, ACTIVE_CODE, VENDOR_SITE_ID, INACTIVE_DATE, SUPPLIER_SITE_CODE, SITE_CODE_ALT, SITE_ALLOW_WITHHOLDING_TAX, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4 ,CITY, STATE, POST_CODE, SITE_PO_NOTIF_METHOD, and SITE_PO_EMAIL. And the list is open to add any other column/s you prefer. Note: If you are looking also about other details for the supplier you can find them in the list below:

      • Supplier Bank Details Query

       

      Hope this helps.

        • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    Adv 250x250

    Explore

    • Categories
    • Questions
      • New Questions
      • Trending Questions
      • Must read Questions
      • Hot Questions
    • Dev Tools
      • Online Compiler
      • Base64 Converter
    • Wiki
      • SQL Tutorials
      • Java Tutorials
      • Python Tutorials
      • JavaScript Tutorials

    Footer

    Oraask

    About

    Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

    About Us

    • About Us
    • Contact Us

    Legal Stuff

    • Privacy Policy
    • Terms & Conditions

    Follow

    Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

    © 2019 Oraask. All Rights Reserved
    With Love by Oraask.

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.