column action format a10
column manager format a20
column object format a20
column type format a10
set pages 0
set lines 400
select q.application_id, q.concurrent_queue_name,
q.user_concurrent_queue_name "Manager", l1.meaning "Action",
l2.meaning "Type", p.user_concurrent_program_name "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q,
apps.fnd_concurrent_programs_vl p, apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'P'
and c.type_id = p.concurrent_program_id
and c.type_application_id = p.application_id
and l1.lookup_code = c.include_flag
and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = 'P' and l2.lookup_type = 'CP_SPECIAL_RULES'
UNION ALL
select q.application_id, q.concurrent_queue_name,
q.user_concurrent_queue_name "Manager", l1.meaning "Action",
'Application' "Type", a.application_name "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q,
apps.fnd_application_vl a, apps.fnd_lookups l1
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'P'
and c.type_id is null
and c.type_application_id = a.application_id
and l1.lookup_code = c.include_flag
and l1.lookup_type = 'INCLUDE_EXCLUDE'
UNION ALL
select q.application_id, q.concurrent_queue_name,
q.user_concurrent_queue_name "Manager", l1.meaning "Action",
l2.meaning "Type", x.complex_rule_name "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q,
apps.fnd_concurrent_complex_rules x,
apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'C'
and c.type_id = x.complex_rule_id
and c.type_application_id = x.application_id
and l1.lookup_code = c.include_flag and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = 'C'
and l2.lookup_type = 'CP_SPECIAL_RULES'
UNION ALL
select q.application_id, q.concurrent_queue_name,
q.user_concurrent_queue_name "Manager", l1.meaning "Action", l2.meaning "Type", r.request_class_name "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q, apps.fnd_concurrent_request_class r,
apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'R'
and c.type_id = r.request_class_id
and c.type_application_id = r.application_id
and l1.lookup_code = c.include_flag and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = 'R'
and l2.lookup_type = 'CP_SPECIAL_RULES'
UNION ALL
select q.application_id, q.concurrent_queue_name,q.user_concurrent_queue_name "Manager", l1.meaning "Action", l2.meaning "Type", o.oracle_username "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q, apps.fnd_oracle_userid o,
apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'O'
and c.type_id = o.oracle_id
and l1.lookup_code = c.include_flag and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = 'O'
and l2.lookup_type = 'CP_SPECIAL_RULES'
UNION ALL
select q.application_id, q.concurrent_queue_name,q.user_concurrent_queue_name "Manager", l1.meaning "Action", l2.meaning "Type", u.user_name "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q, apps.FND_OAM_FNDUSER_VL u,
apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code = 'U'
and c.type_id = u.user_id
and l1.lookup_code = c.include_flag and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = 'U'
and l2.lookup_type = 'CP_SPECIAL_RULES'
UNION ALL
select q.application_id, q.concurrent_queue_name,q.user_concurrent_queue_name "Manager", l1.meaning "Action", l2.meaning "Type", to_char(c.type_id) "Object"
from apps.fnd_concurrent_queue_content c, apps.fnd_concurrent_queues_vl q,
apps.fnd_lookups l1, apps.fnd_lookups l2
where q.concurrent_queue_id = c.concurrent_queue_id
and q.application_id = c.queue_application_id
and c.type_code not in ('C','P','O','R', 'U')
and l1.lookup_code = c.include_flag and l1.lookup_type = 'INCLUDE_EXCLUDE'
and l2.lookup_code = c.type_code and l2.lookup_type = 'CP_SPECIAL_RULES';