tutorailwale

Query For Workflow Mailer Configurations SELECT p.parameter_id,p.parameter_name,v.parameter_value valueFROM apps.fnd_svc_comp_param_vals_v v,apps.fnd_svc_comp_params_b p,apps.fnd_svc_components cWHERE c.component_type = ‘WF_MAILER’AND v.component_id = c.component_idAND v.parameter_id = p.parameter_idAND p.parameter_name IN (‘OUTBOUND_SERVER’,’INBOUND_SERVER’,’ACCOUNT’,‘FROM’,‘NODENAME’,’REPLYTO’,’DISCARD’,’PROCESS’,‘INBOX’)ORDER BY … Read more

Query To Find All Responsibilities Assigned To a User SELECT UNIQUE u.user_id,Substr (u.user_name, 1, 30) user_name,Substr (r.responsibility_name, 1, 60) responsiblity,Substr (a.application_name, 1, 50) applicationFROM fnd_user … Read more

Query To Get All Users Assigned To Given Responsibility SELECT UNIQUE u.user_id,Substr(u.user_name, 1, 30) user_name,Substr(r.responsibility_name, 1, 60) responsibility,Substr(a.application_name, 1, 50) applicationFROM fnd_user u,find_user_resp_groups g,find_application_tl a,find_responsibility_tl … Read more

Query To Find All Reports Registered Within Given Application SELECT fa.application_short_name,fcpv.user_concurrent_program_name,description,Decode (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’,‘Q’, ‘SQLPLUS’, ‘H’, ‘Host’, ‘L’, ‘SQLLOADER’,‘A’, ‘Spawned’,‘I’, ‘PL/SQL Stored … Read more

Query To Find Responsibility Name from a Concurrent Program SELECT DISTINCT FCPL.user_concurrent_program_name,FCP.concurrent_program_name,FAPP.application_name,FRG.request_group_name,FNRTL.responsibility_nameFROM apps.fnd_request_groups FRG,apps.fnd_application_tl FAPP,apps.fnd_request_group_units FRGU,apps.fnd_concurrent_programs FCP,apps.fnd_concurrent_programs_tl FCPL,apps.fnd_responsibility FNR,apps.fnd_responsibility_tl FNRTLWHERE FRG.application_id=fapp.application_idAND FRG.application_id=FRGU.application_idAND FRG.request_group_id=FRGU.request_group_idAND FRG.request_group_id=FNR.request_group_idAND FRG.application_id=FNR.application_idAND … Read more

Query To Count the number of reports registered In Each Module SELECT fa.application_short_name,Decode (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’,‘Q’, ‘SQLPlus’, ‘H’, ‘Host’, ‘L’, ‘SQLLoader’,‘A’, ‘Spawned’,‘I’, … Read more

Query To Find Scheduled Concurrent Request SELECT cr.request_id,Decode(cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’|| cr.description,cp.user_concurrent_program_name)NAME,argument_text,cr.resubmit_interval,Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’))schedule_type,Decode(Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’)),‘PERIODICALLY’, ‘EVERY ‘|| … Read more

Query To Check Scheduled Concurrent Requests SELECT fcr.request_id,fcr.parent_request_id,fu.user_name, requestor,To_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE,fr.responsibility_keyresponsibility,fcp.concurrent_program_name,fcpt.user_concurrent_program_name,Decode(fcr.status_code, ‘A’, ‘Waiting’,‘B’, ‘Resuming’,‘C’, ‘Normal’,‘D’, ‘Cancelled’,‘E’, ‘Error’,‘F’, ‘Scheduled’,‘G’, ‘Warning’,‘H’, ‘On Hold’,‘I’, ‘Normal’,‘M’, ‘No Manager’,‘Q’, … Read more

Query To Find All Reports Status With User Name SELECT /*+ choose */ U.user_name User_name,fcr.request_id, request_id,To_char(Round(( Nvl(fcr.actual_completion_date,SYSDATE) –fcr.actual_start_date ) *1440)) TIME,c.concurrent_program_name|| ‘ – ‘|| Substr(fcrv.program, … Read more

Query To Count Pending Request SELECT/*+ choose */ Count(*)FROM fnd_concurrent_requests fcr,fnd_concurrent_programs c,fnd_conc_req_summary_v fcrvWHERE fcr.concurrent_program_id = c.concurrent_program_idAND fcr.program_application_id = c.application_idAND fcr.concurrent_program_id = fcrv.concurrent_program_idAND fcr.request_id = fcrv.request_idAND … Read more