Monday, October 23, 2017

Query to get WebADI Details in Oracle APPS

SELECT i.application_id,
       i.user_name,
       bi.interface_name,
       i.integrator_code,
       bi.upload_param_list_code,
       ba.attribute_code,
       ba.attribute1,
       ba.attribute2,
       l.layout_code
  FROM bne_integrators_vl i,
       bne_layouts_b l,
       bne_interfaces_b bi,
       bne_param_lists_b bpl,
       bne_attributes ba
 WHERE 1 = 1
   AND i.user_name = 'General Ledger - Historical Rates' -- <<WebADI Name>>
   AND bi.integrator_code = i.integrator_code
   AND i.integrator_code = l.integrator_code
   AND bi.upload_param_list_code = bpl.param_list_code
   AND bpl.attribute_code = ba.attribute_code

Attribute1 holds package or procedure used in WebADI.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)