Search Results filere_name

Overview

APPS.PQH_CORPS_FILERES_V is an Oracle E-Business Suite view owned by the APPS schema that presents a filtered, decoded projection of the PQH_CORPS_EXTRA_INFO table. Its purpose is to expose the "FILERE" category of extra information records associated with a corporate (CORPS) definition, converting the raw numeric code stored in the INFORMATION4 column into a human-readable FILERE_NAME. In Oracle EBS 12.1.1 and 12.2.2, this view belongs to the Public Sector / Human Resources (PQH) family of objects that support position, budget, and organizational corporate definitions. The view is non-key-preserving with respect to its base table because it restricts rows with a fixed INFORMATION_TYPE predicate and applies a scalar decoding function, so it is intended for read-only reporting and integration use rather than for direct data manipulation. Because the user searched on "corps_definition_id," this view is commonly reached when reporting on corporate definitions and their associated FILERE (a legislative file/reference code) attributes.

Underlying Base Objects

The view is defined over the synonym PQH_CORPS_EXTRA_INFO, which resolves to the corporate-definition extra information table. Three referenced objects are documented in the ETRM 12.2.2 metadata: the PQH_CORPS_EXTRA_INFO synonym (the primary source of rows), the HR_GENERAL package (used for the DECODE_SHARED_TYPE lookup), and the FND_NUMBER package (used for the CANONICAL_TO_NUMBER conversion). The SELECT statement projects CORPS_DEFINITION_ID, CORPS_EXTRA_INFO_ID, OBJECT_VERSION_NUMBER, INFORMATION_TYPE, the derived FILERE_NAME, and the raw INFORMATION4 value aliased as FILERE_CD. The WHERE clause fixes INFORMATION_TYPE equal to 'FILERE', so every row returned by the view represents a FILERE-class extra information record tied back to a corporate definition through CORPS_DEFINITION_ID.

Key Columns

• CORPS_DEFINITION_ID — The foreign key linking the extra information row to the corporate definition. This is the column a user searching "corps_definition_id" would join or filter on.
• CORPS_EXTRA_INFO_ID — The primary identifier of the underlying extra information row.
• OBJECT_VERSION_NUMBER — The optimistic locking version number carried over from the base table.
• INFORMATION_TYPE — Always 'FILERE' in this view, as enforced by the WHERE clause.
• FILERE_NAME — The decoded, user-facing name derived from INFORMATION4 via HR_GENERAL.DECODE_SHARED_TYPE(FND_NUMBER.CANONICAL_TO_NUMBER(...)).
• FILERE_CD — The raw INFORMATION4 value, preserved as the underlying FILERE code.

Common Use Cases and Queries

This view is typically used to list or join FILERE information against corporate definitions in reports, extracts, and interfaces. A straightforward query returns the decoded names for a given corporate definition:

SELECT corps_definition_id, corps_extra_info_id, filere_cd, filere_name
FROM   apps.pqh_corps_fileres_v
WHERE  corps_definition_id = :p_corps_definition_id;

The view can also be joined to the corporate definition header to enrich reporting, for example:

SELECT v.corps_definition_id, v.filere_cd, v.filere_name
FROM   apps.pqh_corps_fileres_v v
WHERE  v.filere_cd IS NOT NULL;

Because FILERE_NAME depends on the HR_GENERAL and FND_NUMBER packages, queries should be run in an environment where those packages are valid and the shared-type lookup data is populated; otherwise the decoded name may return null while the raw FILERE_CD remains available. The view is read-only in practice, and updates to FILERE information must be performed against the underlying PQH_CORPS_EXTRA_INFO table.