SELECT
x.process_type "Name",
decode((
SELECT
'1'
FROM
apps.fnd_concurrent_requests cr, apps.fnd_concurrent_programs_vl cp, apps.fnd_application a
WHERE
cp.concurrent_program_id = cr.concurrent_program_id
AND cp.concurrent_program_name = x.process_name
AND cp.application_id = a.application_id
AND a.application_short_name = x.process_app_short_name
AND phase_code != 'C'
AND ROWNUM = 1
),
'1',
'Active',
'Inactive') "Status",
x.worker_rows "Worker Rows",
x.timeout_hours "Timeout Hours",
x.timeout_minutes "Timeout Minutes",
x.process_hours "Process Interval Hours",
x.process_minutes "Process Interval Minutes",
x.process_seconds "Process Interval Seconds"
FROM
(
SELECT
mipc.process_code,
mipc.process_status,
mipc.process_interval,
mipc.manager_priority,
mipc.worker_priority,
mipc.worker_rows,
mipc.processing_timeout,
mipc.process_name,
mipc.process_app_short_name,
a.meaning process_type,
floor(mipc.process_interval / 3600) process_hours,
floor((mipc.process_interval -(floor(mipc.process_interval / 3600) * 3600)) / 60) process_minutes,
( mipc.process_interval - ( floor(mipc.process_interval / 3600) * 3600 ) - ( floor((mipc.process_interval -(floor(mipc.
process_interval / 3600) * 3600)) / 60) * 60 ) ) process_seconds,
floor(mipc.processing_timeout / 3600) timeout_hours,
floor((mipc.processing_timeout - floor(mipc.processing_timeout / 3600) * 3600) / 60) timeout_minutes
FROM
apps.mtl_interface_proc_controls mipc,
apps.mfg_lookups a
WHERE
a.lookup_type = 'PROCESS_TYPE'
AND a.lookup_code = mipc.process_code
) x
-- WHERE x.PROCESS_TYPE = 'Cost Manager' -- uncomment this to display only the cost manager; Possible Values: Cost Manager; Lot Move Transaction; Material transaction; Move transaction
ORDER BY
1;