Please help me write a query
Pl. help me write a query.
I have a foll. qry.
select fcp.concurrent_program_name||' - '||
,count(*) "SLA miss count"
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
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?
thanks in adv.