1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to get the Vendor Details in Oracle E-Business Suite

Discussion in 'Oracle Apps Technical' started by prudhvi_karanam, Dec 30, 2011.

  1. Introduction

    Use the Below Query to get the Vendor Details.

    The code

    Use Below Parameters:

    1. Give the Vendor Number From and To(Optional)
    2. Vendor Name(Optional)

    Code (SQL):

    SELECT  
    PO.SEGMENT1 VENDOR_NUMBER,
    PO.VENDOR_NAME,
    PO.VENDOR_NAME_ALT,
    PO.VENDOR_TYPE_LOOKUP_CODE,
    POS.VENDOR_SITE_CODE
    ,VENDOR_SITE_CODE_ALT
    ,POS.ADDRESS_LINE1
    ,POS.ADDRESS_LINE2
    ,POS.ADDRESS_LINE3
    ,POS.ADDRESS_LINE4
    ,POS.CITY
    ,POS.COUNTRY
    ,POS.ZIP
    ,POS.COUNTY
    ,POS.STATE
    ,POS.INVOICE_CURRENCY_CODE
    ,POS.PAYMENT_CURRENCY_CODE
    ,POS.PAYMENT_METHOD_LOOKUP_CODE
    ,POS.PAY_GROUP_LOOKUP_CODE
    ,HR.NAME
    ,INACTIVE_DATE
    ,GLCC.CONCATENATED_SEGMENTS LIABILITY_ACCOUNT
    ,GLCCP.CONCATENATED_SEGMENTS PREPAY_ACCOUNT
    ,POS.EMAIL_ADDRESS
    FROM AP_SUPPLIERS PO,AP_SUPPLIER_SITES_ALL POS
    ,GL_CODE_COMBINATIONS_KFV GLCC,GL_CODE_COMBINATIONS_KFV GLCCP
    , HR_OPERATING_UNITS HR
    WHERE PO.VENDOR_ID=POS.VENDOR_ID
    AND GLCC.CODE_COMBINATION_ID=POS.ACCTS_PAY_CODE_COMBINATION_ID
    AND GLCCP.CODE_COMBINATION_ID=POS.PREPAY_CODE_COMBINATION_ID
    AND HR.ORGANIZATION_ID=POS.ORG_ID
    AND PO.SEGMENT1 BETWEEN NVL(:P_SUPPLIER_NUMBER_FROM,PO.SEGMENT1) AND NVL(:P_SUPPLIER_NUMBER_TO,PO.SEGMENT1)
    AND PO.VENDOR_NAME=NVL(:P_VENDOR_NAME,PO.VENDOR_NAME)
    ORDER BY 1;
     
     
  2. Amit Gupta

    Amit Gupta Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Bangalore
    I think what we were looking for oracle implementation vendor that can provide implematation, migration and support services for various oracle products and solutions. I found some vendors though for example ALTEN Calsoft labs. These are typically services companies.