Hi Guys,

Pl. help me write a query.

I have a foll. qry.

select fcp.concurrent_program_name||' - '||
fcpt.user_concurrent_program_name "Program"
,count(*) "SLA miss count"
from
sla_request_data gsrd,
fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt
where
gsrd.request_id = fcr.request_id
and fcr.concurrent_program_id = fcp.concurrent_program_id
and fcpt.concurrent_program_id = fcp.concurrent_program_id
and fcpt.language = 'US'
and fcr.program_application_id = fcp.application_id
and fcpt.application_id = fcp.application_id
and gsrd.start_date between '01-SEP-2005' and '30-SEP-2005'
group by fcp.concurrent_program_name
,fcpt.user_concurrent_program_name

This gives output...

Program SLA miss count
FAPPT - Process Pending Transactions 1
POPDI - GEMS PDI PO Report Optio 1
RVCTP - Receiving Transaction Processor 9
APPBCF - Confirm Payment Batch 10

I want to have foll. output (for example)

Program SLA miss total %miss
FAPPT - Process Pending Transactions 1 100 1
POPDI - GEMS PDI PO Report Optio 1 90 .9
RVCTP - Receiving Transaction Processor 9 1000 .01
APPBCF - Confirm Payment Batch 10 1000 .01

total colum is a count of total requests in fnd_concurrent_requests table for particular program in the month of Sep-05. I want this column to show %miss for a parti. program.

How can I do this?

Pl. help.

thanks in adv.