ebs fnd_lookups

select * from  FND_CONCURRENT_PROCESSORS; ---并发处理器
select * from  fnd_concurrent_processes fnd order by process_status_code;--并发进程
select * from  fnd_concurrent_queues fcq order by fcq.concurrent_queue_name;--
select * from  fnd_concurrent_requests;--并发请求并发管理器队列
select * from  dba_data_files;
exit;

select * from dba_col_comments dcc where dcc.table_name=‘FND_CONCURRENT_QUEUES‘;

select fcq.concurrent_queue_name
       ,fcq.concurrent_processor_id      
        from fnd_concurrent_queues fcq
       ,FND_CONCURRENT_PROCESSORS   fcp
 where  fcq.concurrent_processor_id=fcp.concurrent_processor_id;

select * from FND_CONCURRENT_QUEUES

SELECT APPLICATION_ID
,      CONCURRENT_PROCESSOR_ID
,      CONCURRENT_PROCESSOR_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      LAST_REBUILT
,      LIBRARY_TYPE
FROM APPLSYS.FND_CONCURRENT_PROCESSORS;

select * from FND_LOOKUP_VALUES

SELECT *
  FROM fnd_lookups
 WHERE lookup_type LIKE ‘%PROCESS_STATUS_CODE%‘