Search Results invoice_trx_status




Overview
Explore in AI Chat

Overview

The view APPS.JL_AR_AR_CUST_TRX_TYPES_V is a reporting and integration construct within Oracle E-Business Suite Receivables, exposed in the APPS schema. It presents a denormalized, translation-resolved listing of Receivables transaction types — invoices, credit memos, debit memos, deposits, and guarantees — enriched with the human-readable meanings of their associated lookup codes and the descriptive name of their default payment term. In releases 12.1.1 and 12.2.2, this view is used to drive selection lists, validation logic, and downstream integrations that must resolve a transaction type to its default transaction status, printing option, and accounting behavior without repeatedly joining to the underlying lookup and terms tables.

Because the view resolves foreign-key lookups to their meanings, it is particularly valuable for reports where a code such as the default invoice transaction status must be rendered as a description rather than a raw lookup code.

Underlying Base Objects

The view is defined over the following documented objects:

  • RA_CUST_TRX_TYPES — the primary source table, supplying transaction type identity, descriptive attributes, flags, and the default status, printing option, and term foreign keys.
  • AR_LOOKUPS — joined three times (aliases A, B, and C) to decode the printing option (INVOICE_PRINT_OPTIONS), the default transaction status (INVOICE_TRX_STATUS), and the transaction class (INV/CM).
  • RA_TERMS — outer-joined (+) to resolve the default payment term name; the outer join permits transaction types with no term to remain in the result set.

The filter clause restricts output to transaction types in DEP, GUAR, INV, CM, and DM, and excludes deposits and guarantees that do not affect accounting.

Key Columns

Common Use Cases and Queries

Typical implementations use this view for transaction type Lovs, status validation, and integration mappings. A representative query listing active invoice types with their default status is:

  • SELECT name, type, class_meaning, default_status FROM jl_ar_cust_trx_types_v WHERE type = 'INV' ORDER BY name;
  • Filtering by status: SELECT name FROM jl_ar_cust_trx_types_v WHERE default_status = 'Unpaid';
  • Effective-date filtering: SELECT * FROM jl_ar_cust_trx_types_v WHERE SYSDATE BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE+1);

Because the view resolves the INVOICE_TRX_STATUS lookup to its meaning, it is the preferred source whenever a report or interface must present or match on the default status description rather than the underlying code.