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!

To find the connection name

Discussion in 'Oracle Apps Technical' started by vinodkumar2305, Jun 17, 2015.

  1. Use this query to find the mailer address to be used in SMTP

    Code (SQL):
    SELECT b.component_name,
    c.parameter_name,
    a.parameter_value
    FROM apps.fnd_svc_comp_param_vals a,
    apps.fnd_svc_components b,
    apps.fnd_svc_comp_params_b c
    WHERE b.component_id = a.component_id
    AND b.component_type = c.component_type
    AND c.parameter_id = a.parameter_id
    AND c.encrypted_flag = 'N'
    AND b.component_name LIKE '%Mailer%'
    AND c.parameter_name IN ('INBOUND_SERVER','OUTBOUND_SERVER', 'REPLYTO')
    ORDER BY c.parameter_name;