SELECT *
FROM FND_FOLDERS
WHERE object = 'INVTVTXN_RESULTS';
SELECT *
FROM FND_FOLDER_COLUMNS
WHERE folder_id in
(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.