Maintain Report List Queries#

The Maintain Report List (IMLQ) form is used to maintain the query selection criteria used to create report lists within Personality.

The data is maintained on the P2K_AM_LOV_QUERIES and P2K_AM_LOV_QUERY_COLUMNS tables.

List of Values
This field will provide the name of the list of values associated with the query being defined. It MUST start with IMPV_ and then the function name that it is for.
Title
This field provides the title of the LOV. Information purposes only.
DESCRIPTION
This field holds a brief description of the report list including any details other than the code.
QUERY TEXT
This field contains the SQL select statement used by the system to determine the values to be reported in the report list.

Notes #

Click to create a new notes page