Home/ Questions/Q 81698
Next
In Process
Question
Beter
  • 0
Explorer
Asked: 2023-02-21T18:30:55+03:00 In:

Query to Get Supplier Details in Oracle APPS R12

  • 0

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

Share

    Related Questions

    1 Answer

    1. Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
      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:

       

      Hope this helps.

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,