DB Link Script

- 

CREATE DATABASE LINK one_next
 CONNECT TO apps-- User Name 2 nd Db or Instance 
 IDENTIFIED BY apps-- pwd  2 nd Db or Instance  USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.0.183)(PORT = 1523)) ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = prod) 
    ) 
  )';
after creating Db Link Access The 3rd party Ex: select * from po_vendors@one_next
































Comments











Post a Comment



















Popular posts from this blog









Oracle Shipping Network SQL Query






-















 Useful Script for Oracle Shipping Network , I wrote custom function for GL Code , you may find below   SELECT a.from_organization_code, a.from_organization_name,         a.to_organization_code, a.to_organization_name,  DECODE (a.intransit_type,                   2, 'Intransit',                   1, 'Direct'                  ) "Transfer Type",         (SELECT meaning            FROM apps.mfg_lookups           WHERE lookup_type = 'MTL_FOB_POINT'             AND lookup_code = a.fob_point) fob_point,         a.elemental_visibility_enabled, DECODE (a.routing_header_id,                   1, 'Standard',                   2, 'Insp...








Click for more










Advance Supply Chaining Scripts - ASCP Full Pegging Concept Script






-















 ASCP Pegging Script   SELECT DISTINCT msc.organization_code m_organization_code,                        msc.category_name m_category_name,                        item_segments m_item_segments,                        msc.description m_description,                        order_type_text m_order_type_text,                        TO_CHAR (new_due_date) m_new_due_date,                        TO_CHAR (quantity_rate) m_quantity_rate,                                               --                TO_CHAR (msc.disposition_...








Click for more










How to call Auto invoice Import Program  from Back end






-















 Autoinvoice Import Program takes following parameters :   argv[0]  program name  argv[1]  parallel module name  [MAIN|PU?]  argv[2]  running mode  [V|T|P]  argv[3]  batch source id  argv[4]  batch source name  argv[5]  default date  argv[6]  concatenated transaction flexfield attribute value  argv[7]  transaction type id  argv[8]  low bill to customer number  argv[9]  high bill to customer number  argv[10]  low bill to customer name  argv[11] high bill to customer name  argv[12] low gl date  argv[13] high gl date  argv[14] low ship date  argv[15] high ship date  argv[16] low transaction number  argv[17] high transaction number  argv[18] low sales order  argv[19] high sales order  argv[20] low invoice date  argv[21] high invoice date  argv[22] low ship to customer number  argv[23] high ship to customer number  argv[24] low ship to customer name  argv[25] high ship to customer name  argv[26] Call RAXTRX from RAXMTR flag  ar...








Click for more