Re: Jobs not yet expired

From: cvnkrishna <vamsikrishna.chikkam_at_gmail.com>
Date: 3 Feb 2007 09:37:41 -0800
Message-ID: <1170524261.778045.204750@q2g2000cwa.googlegroups.com>

Hi,

1. Oracle Application Version: 11.0.3 RDBMS version: 8.1.7.3
2. My query is ;

SELECT

	a.hold_flag,
	a.request_id request_id,
        a.program program,
   decode(a.status_code,'C','Normal',
      decode(a.status_code,'E','Error',
         decode(a.status_code,'G','Warning',a.status_code,
             decode(a.status_code,'W','Paused',a.status_code,
                decode(a.status_code,'R','Running',a.status_code,
 

decode(a.status_code,'X','Terminated',a.status_code)))))) Status,

   a.phase_code Phase,
   a.request_id "REQ ID",

   to_char(a.actual_start_date,'DY') Day,
   to_char(a.actual_start_date,'dd-MON-yy hh24:mi:ss') Started,
   to_char(a.actual_completion_date,'dd-MON-yy hh24:mi:ss') Completed,

   substr(to_number(((a.actual_completion_date - a.actual_start_date)*24)*60),1,5) Minutes,

   a.program Name,
   a.argument_text,
   a.requestor,
   a.completion_text,
   a.parent_request_id,
   b.resubmit_end_date

FROM fnd_conc_req_summary_v a,
fnd_conc_requests_form_v b
WHERE 1 = 1
-- AND lower(a.program) like '%dvd%'
AND a.phase_code = b.phase_code
AND a.request_id = b.request_id
and b.resubmit_end_date is not null
ORDER BY a.actual_start_date desc;

My Problem come here is the result using Application (Concurrent--> Requests) when doing "Find Requests" with only "Status = Scheduled" the result varies with my result using above result.

When I tried query my script with "a.request_id in
(28548793,28548792,28548791,28548790,28548770,28547280)" and removing
"b.resubmit_end_date is not null" condition, Found that "resubmit_end_date" is null.

Not sure Exactly m I diverted from the my requirement..
(1) Extract all jobs that are not yet "expired", but do have a "expiry
date" that will be reached
at some point
2) List all the jobs with their corresponding "Expiry Date" )

In advance thanks,

Regards,

Vamsi Chikkam Received on Sat Feb 03 2007 - 11:37:41 CST