fnd_lookups
2012-03-07 12:04:38| 分类： 默认分类 | 标签： |举报 |字号大中小 订阅
1，表里的数据是通过EBS的Lookups Form输入保存的。这个功能在Application Developer及各功能模组的Setup中均有菜单可进入；2，Lookup Code是用来保存值集的。在oracle中，为了保证输入值的正确性，通常会以LOV（List of Value）的方式用用户在已经预定义好的一组值集中选择，Lookup就是用于定义这组预定义值集的
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%'