query to get BI discoverer reports assigned to a user in R12

/* query to get BI discoverer reports assigned to a user in R12*/ SELECT distinct doc_name, folder_name, qs_doc_owner, owner_full_name, owner_email, report_user_name, report_user_email/*, MAX (qs_created_date)*//*,qs_created_by,user_id*/ FROM (SELECT doc.doc_name, obj.obj_name folder_name, bas.ba_name, qpp.qs_doc_owner, fu.description report_user_name, fu.email_address report_user_email, fu.user_name, /*MAX (qpp.qs_created_date) qs_created_date,*/ fu.end_date, (SELECT email_address FROM apps.fnd_user WHERE user_name = qpp.qs_doc_owner) owner_full_name, (SELECT description FROM apps.fnd_user WHERE user_name = qpp.qs_doc_owner) owner_email,qpp.qs_created_by,fu.user_id FROM eul4_us.eul5_documents doc, eul4_us.eul5_elem_xrefs xref, eul4_us.eul5_expressions EXP, eul4_us.eul5_objs obj, eul4_us.eul5_ba_obj_links bol, eul4_us.eul5_bas bas, eul4_us.eul5_qpp_stats qpp, apps.fnd_user fu WHERE xref.ex_from_id = doc.doc_id AND xref.ex_to_id = EXP.exp_id AND obj.obj_id = EXP.it_obj_id AND bol.bol_obj_id = obj.obj_id AND bas.ba_id = bol.bol_ba_id AND doc.doc_name = qpp.qs_doc_name AND TRUNC (SUBSTR (qpp.qs_created_by, 2)) * 1 = fu.user_id AND (upper(fu.email_address) like upper('%Pius.Piyush%%') OR qpp.qs_doc_owner like '%18032%' ) /*AND bas.ba_name NOT IN ('Purchasing', 'Items', 'Work In Process', 'Order Entry and Shipping', 'Cost Management', 'Planning') AND bas.ba_name NOT LIKE 'Bills%Of%'*/ GROUP BY doc.doc_name, obj.obj_name, bas.ba_name, qpp.qs_doc_owner, fu.user_name, fu.end_date, fu.description, fu.email_address,qpp.qs_created_by,fu.user_id) GROUP BY doc_name, folder_name, qs_doc_owner, report_user_name, report_user_email, owner_full_name, owner_email,qs_created_by,user_id

jpx import command in oaf in linux For VO extension

jpx import command in oaf in linux For VO extension java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxeaa/xxVoExtnsnAppraisal0.jpx -username apps -password appspswd -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 10.999.51.999)(PORT=4444))(CONNECT_DATA=(SID=TSMOKE)))" ================== java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxeaa/xxVoExtnsnAppraisal0.jpx -username apps -password appspswd -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 10.999.51.999)(PORT=4444))(CONNECT_DATA=(SID=STMOKE)))" Imported document : /oracle/apps/per/selfservice/appraisals/server/customizations/site/0/AppraisalVO Import completed successfully []$