The scripts to find Folder details

本文介绍如何使用 Oracle E-Business Suite (EBS) 中的 FND_FOLDERS 和 FND_FOLDER_COLUMNS 表来查询定制文件夹及其显示字段的信息。每个定制文件夹的信息包括标识符、名称、对象(唯一确定表单字段集)、屏幕宽度及是否允许除所有者外的用户打开等。同时介绍了如何获取文件夹内所显示字段的具体细节。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

SELECT *
FROM FND_FOLDERS
WHERE object = 'INVTVTXN_RESULTS';

SELECT *
FROM FND_FOLDER_COLUMNS
WHERE folder_id =
(SELECT folder_id
FROM FND_FOLDERS
WHERE object = 'INVTVTXN_RESULTS');


Tables

FND_FOLDERS stores information about customized folders. Each row includes the folder identifier, the name of the folder, the object (which uniquely identifies the set of fields in the form), the screen width in inches, and the flag that determines whether the folder can be opened by users other than the folder owner. Each row also includes a flag that indicates whether the window region perform query upon opening the folder, a where clause, and a order by clause. One row is inserted into this table every time a folder
is customized and saved. You need one row for each folder customization.


FND_FOLDER_COLUMNS stores information about displayed fields in folders. Each row includes the folder identifier, the name of the displayed field, the sequence in which the columns are to be rendered from left to right, the display width for the field (in inches), and the prompt for the field. DISPLAY_MODE is always 'N' for this table. You need one row for each displayed field in each folder. For single-row folders, this table keeps track of the screen position of the field when the user last saved the folder.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值