`
wsql
  • 浏览: 11819818 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
文章分类
社区版块
存档分类
最新评论

The scripts to find Folder details

 
阅读更多

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.

分享到:
评论

相关推荐

    the scripts to create Windows usb bootable disk

    a tool to create USB bootable disk

    calendar

    folder above and chmod all the 3 scripts to 755.5) Create a sub-folder "data" under the "calpublisher" folder and chmod to 777. In some servers, you need to leave it at 755. This ...

    Collection of support scripts to readwriteprocess light field

    Collection of support scripts to readwriteprocess light field data.zip

    Matlab scripts to read and write MIDI files.zip

    Matlab scripts to read and write MIDI files

    开源。net博客

    If you wish to use SQL Server to store all your blog data, this folder has all the information you'll likely need. The scripts included here are for SQL Server 2008 and up. They could be modified to ...

    Ixchariot 默认脚本使用说明

    Application scripts are the key to measuring network performance. They model the real applications you use between computers in a network. IxChariot uses application scripts to make the same API calls...

    unix shell scripts used to collect OS and network metrics

    unix shell scripts used to collect OS and network metrics

    Pro SAP Scripts, Smartforms, and Data Migration

    The present book Pro SAP Scripts, Smart forms, and Data Migration, is a sequel to our earlier book SAP ABAP—Hands-On Test Projects with Business Scenarios. It is perceived by enterprises or ...

    vm安装macos补丁_unlock-all-v111

    ESXi has to be patched using the scripts, as the unlocker is used to overlay the ESXi firmware at runtime. You will need to transfer the files to the ESXi host either using vSphere client or SCP. ...

    Reflector+1.5.0+PC反射倒影

    1- Find the folder called Reflector Updater Script. 2- Drag or copy the Reflector Updater Script folder into the After Effects Scripts folder (Adobe > Adobe After Effects > Scripts) Using the ...

    Web Security Testing Cookbook: Systematic Techniques to Find Problems Fast

    cross-site scripting, and manipulating hidden form fields Make your tests repeatable by using the scripts and examples in the recipes as starting points for automated testsDon’t live in dread of the...

    Windows script

    The scripts included in this help file are likely to appear in the forthcoming System Administration Scripting Guide, which will ship as part of the Windows .NET Server Resource Kit. In the Scripting ...

    Windows 脚本大全

    The scripts included in this help file are likely to appear in the forthcoming System Administration Scripting Guide, which will ship as part of the Windows .NET Server Resource Kit. In the Scripting ...

    VMware Unlocker for OS X 1.1.0

    ESXi has to be patched using the scripts, as the unlocker is used to overlay the ESXi firmware at runtime. You will need to transfer the files to the ESXi host either using vSphere client or SCP. ...

    vmware8 mac补丁

    ESXi has to be patched using the scripts, as the unlocker is used to overlay the ESXi firmware at runtime. You will need to transfer the files to the ESXi host either using vSphere client or SCP. ...

    the linux command line

    and process management * Use standard input and output, redirection, and pipelines * Edit files with Vi, the world's most popular text editor * Write shell scripts to automate common or boring tasks ...

    The Matlab scripts for five positioning algorithms regarding

    The Matlab scripts for five positioning algorithms regarding UWB localization.zip

    生物信息学处理相关代码

    The "speedy" folder relates to Chapter 27 and contains code relevant to the binding of fast functions written in the C or Cython languages, including any files required for compilation. Many of the ...

    PHP CLI: Create Command Line Interface Scripts with PHP

    Learn to quickly create useful and effective Command Line software and scripts using the world's most popular native web scripting language, PHP. Enjoy the benefits of writing CLI scripts in ...

    db2-正则表达式.zip

    1- Save attached db2_regex.zip file to a new folder on the hard disk for example to C:\avalanche 2- Extract all files from the zip file to C:\avalanche\db2_regex 3- Open C:\avalanche\db2_regex\...

Global site tag (gtag.js) - Google Analytics