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!

Table containing vat registration number of customers

Discussion in 'Oracle Financials' started by Ragav, Oct 11, 2015.

  1. Ragav

    Ragav Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Chennai
    I am working with oracle e-business suite 11i version. I want to know the table name containing the VAT registration number of customers.
     
  2. VijayAP

    VijayAP Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Bangalore
    Hello,

    Try the below sql query.

    Select table_name from all_tab_columns where table_name like 'RA_%' and column_name ='VAT_REGISTRATION_NUM';
    it will give you all table names.

    Thanks
    Vijay