Results for “appl_short_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The JL_ZZ_AR_PO_TX_FSC_CLS_V view is a Latin America Localizations (JL) object owned by the APPS schema. It exposes the valid fiscal classification codes applicable to a purchasing transaction for the currently selected manufacturing organization, filtered from the FND_LOOKUPS lookup type JLZZ_AR_TX_FISCAL_CLASS_CODE. The view derives its name from the underlying business purpose: fiscal classification for accounts receivable and purchase order transactions ("AR", "PO", "TX", "FSC_CLS").

In EBS 12.1.1 and 12.2.2, the view functions as a validated list-of-values source for fiscal classification selection during purchasing and accounts receivable processing. Rather than exposing every defined lookup value, the view limits results to those codes that (a) are currently active (START_DATE_ACTIVE / END_DATE_ACTIVE bound the current SYSDATE), (b) have ENABLED_FLAG = 'Y', and (c) are registered in the JL_ZZ_AR_TX_FSC_CLS_ALL mapping for the operating unit linked to the caller's MFG_ORGANIZATION_ID profile. The constant literal 'AR' is emitted as APPL_SHORT_NAME to signal the application context.

Underlying Base Objects

The view text is a single SELECT over FND_LOOKUPS, combined with an EXISTS sub-query against JL_ZZ_AR_TX_FSC_CLS_ALL. Documented referenced base objects include:

• FND_LOOKUPS — provides LOOKUP_CODE and MEANING for lookup type JLZZ_AR_TX_FISCAL_CLASS_CODE.
• JL_ZZ_AR_TX_FSC_CLS_ALL — the fiscal classification mapping table; the EXISTS check ties each lookup code to an enabled register row for the current operating unit.
• ORG_ORGANIZATION_DEFINITIONS — resolved via a scalar sub-query to translate ORGANIZATION_ID (from FND_PROFILE) into OPERATING_UNIT.
• FND_PROFILE — supplies the MFG_ORGANIZATION_ID session value.
• FND_GLOBAL — supporting session/context resolution functions used in the runtime environment.
• HR_GENERAL and HR_SECURITY — invoked indirectly to enforce organization security on organization references.

Because the view joins lookups with an organization-scoped mapping table, it is inherently context-sensitive: output changes with the MFG_ORGANIZATION_ID profile value at query time.

Key Columns

• FISCAL_CLASSIFICATION_CODE — the enabled lookup code; the primary filter key for downstream transactions.
• DESCRIPTION — the translated meaning (MEANING) associated with the code, displayed to end users.
• APPL_SHORT_NAME — a constant 'AR' identifying the application context in which the classification is valid.

Common Use Cases and Queries

The view is most commonly consumed by LOVs and validation APIs during PO and AR fiscal classification entry, and by reports that must list currently selectable codes for an operating unit. Organization context must be set before querying.

• List valid fiscal classifications for the current organization session.
• Validate that a user-supplied code exists and is enabled before persisting a transaction line.
• Populate a parameter LOV in a concurrent program or OAF region.

SELECT fiscal_classification_code, description
FROM   apps.jl_zz_ar_po_tx_fsc_cls_v
ORDER  BY fiscal_classification_code;

SELECT COUNT(*)
FROM   apps.jl_zz_ar_po_tx_fsc_cls_v
WHERE  fiscal_classification_code = :p_code;

For deterministic results, callers should invoke FND_PROFILE.PUT to set MFG_ORGANIZATION_ID (or initialize the session via the standard OA framework) so the EXISTS sub-query resolves the correct operating unit. In 12.2.2 the underlying security is enforced through HR security packages, so the view respects organization-level access regardless of whether the database is on the 12.1.1 or 12.2.2 code line.