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!

How to get supplier's address information in Oracle R12

Discussion in 'General' started by RIAZ, May 30, 2010.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    hi,

    In Oracle R12, user entering supplier's information on a web page and save it... I am trying to get the supplier's phone/fax related information from AP_SUPPLIER_SITES_ALL but failing...

    Note: If user entering the phone/fax related information on communication (web page) then i am able to retrieve the information from AP_SUPPLIER_SITES_ALL or if user enable the check box 'enable address for all site' (on web page) than i am able to get information from AP_SUPPLIER_SITES_ALL.

    I want to know where supplier's information is stored at first save... or what are the tables for newly designed web pages in Oracle R12 applications ?

    waiting for reply...
     
  2. RAHULKOTHARI

    RAHULKOTHARI Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    am new to this but, i guess AP_VENDOR_SITES_ALL..
    try the tables wit vendor instead of supplier..

    sorry if i misguide u...:-(