Key Flexfield Structure View
For a key flexfield, Oracle Applications generates a separate view for each structure of your key flexfield. You specify the view name for your structure in the Key Flexfield Segments form when you define your key flexfield structure. You must specify a name for each structure for which you want to create a view. If you do not specify a view name, Oracle Applications does not generate a view for that structure.
The key flexfield structure view contains a column for each segment in your flexfield structure, and it uses the segment names, not the segment prompts, as view column names. In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Segment Value" becomes "SEGMENT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".
If the code combinations table contains columns for segment qualifiers, the segment qualifier columns will use the segment qualifier names as view column names, for example GL_ACCOUNT_TYPE.
In addition to the segment and qualifier columns, the view also contains the code combination ID column, START_DATE_ACTIVE, END_DATE_ACTIVE, SUMMARY_FLAG, ENABLED_FLAG, ROW_ID (not ROWID), and all other columns in the code combination table that are not enabled as flexfield columns. The Structure view does not have the structure defining column as all the information in this view pertains to one structure of the flexfield.
See Also
Overview of Reporting on Flexfields Data
Overview of Flexfield Views
Key Flexfield Concatenated Segment View
Descriptive Flexfield View
Creating a Flexfield View
Segment Naming Conventions
Using Flexfield Views to Write a Report
Key Flexfield Views Examples
