Oracle Application : Open FND Attachment

PL/SQL code to open FND Attachment

 gfm_agent VARCHAR2(255);
 Get the web context : gfm_agent := fnd_web_config.gfm_agent;
 Get the attachment id.
Sample SQL :
SELECT
media_id
FROM
FND_ATTACHED_DOCS_FORM_VL
WHERE
function_name=decode(0,1,null,'OEXOEBSO')
AND function_Type=decode(0,1,null,'O')
AND (security_type=4 OR publish_flag='Y')
AND ((entity_name= 'OE_ORDER_HEADERS'
AND pk1_value = cp_header_id ))
AND category_description = 'Signed Agreement';


 Construct URL to open the attachment.
fnd_gfm.construct_download_URL(gfm_agent,l_media_id, FALSE);
replace(replace(l_url,'&','%38'),'%','%37');
 Open the attachment.
fnd_utilities.open_url ( l_url);