Search Results open_receivables_flag

Overview

JL_AR_AR_CUST_TRX_TYPES_V is an APPS-owned database view within the JL – Latin America Localizations product module of Oracle E-Business Suite (validated in 12.1.1 and 12.2.2). It exposes a curated, reporting-friendly projection of the Receivables transaction type definitions maintained in RA_CUST_TRX_TYPES, augmented with decoded lookup meanings and default payment term descriptions. The view is designed to present customer transaction types that are relevant to Latin American localization processing, specifically those whose TYPE falls within the set DEP, GUAR, INV, CM, and DM.

The view's principal role is to convert coded foreign keys — transaction type classification, default status, default printing option, and default term identifier — into human-readable values. This makes it suitable for concurrent program report queries, localization validation, and integration extracts where consumers require descriptions rather than internal codes. Note that its filter excludes deposit (DEP) and guarantee (GUAR) rows unless ACCOUNTING_AFFECT_FLAG equals 'Y', so refundable and non-accounting document types are deliberately pruned.

Underlying Base Objects

The view is defined over four documented base objects:

• RA_CUST_TRX_TYPES (synonym; base table in the AR schema) — aliased E. Provides the core transaction type attributes and the primary key CUST_TRX_TYPE_ID.
• AR_LOOKUPS (view; aliased A, B, and C) — joined three times to resolve the default printing option, default status, and class (INV/CM) meanings respectively.
• RA_TERMS (synonym) — aliased D, joined via an outer join on TERM_ID to supply the default payment term name.

The joins are driven by hard-coded lookup types: 'INVOICE_PRINT_OPTIONS' (A), 'INVOICE_TRX_STATUS' (B), and 'INV/CM' (C). The RA_TERMS join is non-mandatory (D.TERM_ID(+)), permitting transaction types with no default term to remain in the result set. No localization-specific table is referenced, so the view is functionally a filtered, decoded presentation layer over standard Receivables configuration.

Key Columns

Column names are aliased for clarity:

• CUST_TRX_TYPE_ID, NAME, DESCRIPTION — identifiers and descriptive text for the transaction type.
• TYPE — the transaction type classification code (DEP, GUAR, INV, CM, DM).
• CLASS_MEANING — the decoded meaning of TYPE, sourced from AR_LOOKUPS with LOOKUP_TYPE = 'INV/CM'. This is the column most commonly referenced in ad hoc user searches.
• OPEN_RECEIVABLES_FLAG — aliased from ACCOUNTING_AFFECT_FLAG; indicates whether the document affects receivables balances.
• POST_TO_GL_FLAG, ALLOW_FREIGHT_FLAG, CREATION_SIGN, ALLOW_OVERAPPLICATION_FLAG, NATURAL_APPLICATION_ONLY_FLAG, TAX_CALCULATION_FLAG — configuration flags governing accounting, freight, sign, application, and tax behavior.
• DEFAULT_STATUS, DEFAULT_PRINTING_OPTION, DEFAULT_TERM — decoded defaults for status, printing, and the joined payment term name.
• START_DATE, END_DATE — effective-date bounds for the transaction type definition.

Common Use Cases and Queries

Typical consumption includes localization reporting on receivable activity, validation of Latin American document classes, and integration extracts for downstream fiscal reporting. A common query retrieves all INV and CM types with their class and posting behavior:

• SELECT name, class_meaning, open_receivables_flag, default_term FROM jl_ar_cust_trx_types_v WHERE type IN ('INV','CM') AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE+1);
• SELECT type, class_meaning, COUNT(*) FROM jl_ar_cust_trx_types_v GROUP BY type, class_meaning; — distribution of transaction types by decoded class.
• SELECT name, default_status, default_printing_option, post_to_gl_flag FROM jl_ar_cust_trx_types_v WHERE open_receivables_flag = 'Y'; — accounting-relevant types only.

Because the view embeds the DEP/GUAR accounting filter, queries need not reapply it, though TYPE-based predicates remain the most selective access path in the absence of a dedicated index on the underlying projection.