Results for “al_class_meaning”

50+ results




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

Overview

IGI_AR_PAYMENT_SCHEDULES_V is an APPS-owned database view within the IGI – Public Sector Financials International product family, delivered as part of Oracle E-Business Suite 12.1.1 and 12.2.2. The view holds payment term schedules for a selected invoice, presenting installment-level detail for customer transactions processed through Oracle Receivables. Its purpose is to expose the transactional schedule information required by the IGI (Public Sector Financials International) subsystem, which services government and public sector accounting requirements such as budgetary control, funds reservation, and subledger accounting for receivables activity.

Because the view is a thin projection over AR_PAYMENT_SCHEDULES_V, it inherits the Receivables payment schedule semantics while supplying a controlled column list oriented to the IGI reporting and integration layer. Report authors, concurrent program developers, and interfaces that must retrieve invoice installment data in an IGI-enabled environment reference this view rather than the underlying Receivables object directly, ensuring a stable, documented column contract. The view is registered in ETRM with status VALID and is owned by the APPS schema, consistent with the standard Oracle EBS convention for cross-application data access.

Underlying Base Objects

The ETRM metadata documents three referenced base objects supporting this view:

  • AR_PAYMENT_SCHEDULES_V — the parent view from which every column is selected. IGI_AR_PAYMENT_SCHEDULES_V performs a straightforward SELECT over this Receivables view with no additional filtering, joins, or aggregation.
  • ARPT_SQL_FUNC_UTIL — a package that supplies SQL utility functions used in the underlying Receivables view definition, typically for context-sensitive or value-set-driven SQL fragments.
  • ARP_VIEW_CONSTANTS — a package providing constant definitions referenced by AR_PAYMENT_SCHEDULES_V.

Physically, AR_PAYMENT_SCHEDULES_V draws on the Receivables base tables RA_CUSTOMER_TRX_ALL, AR_PAYMENT_SCHEDULES_ALL, and RA_CUSTOMERS, combined through the Receivables security and lookup framework. The IGI view adds no independent persistence and therefore reflects changes to payment terms, adjustments, and receipts as soon as those transactions are committed in Receivables.

Key Columns

Common Use Cases and Queries

Typical usage includes installment-level aging reports, dispute exposure analysis, and integration extracts that must map an invoice's terms into budgetary or funds-checking logic. A common query retrieves all installments for a transaction ordered by terms sequence:

  • Select installments for one invoice: SELECT terms_sequence_number, due_date, amount_due_original, amount_due_remaining, al_status_meaning FROM igi_ar_payment_schedules_v WHERE trx_number = :p_trx_number ORDER BY terms_sequence_number;
  • Identify overdue installments: SELECT trx_number, terms_sequence_number, due_date, amount_due_remaining, days_past_due FROM igi_ar_payment_schedules_v WHERE days_past_due > 0 AND amount_due_remaining > 0 ORDER BY days_past_due DESC;
  • Aggregate open balances by transaction: SELECT trx_number, SUM(amount_due_remaining) FROM igi_ar_payment_schedules_v WHERE al_status_meaning = 'Open' GROUP BY trx_number;

All queries execute against current Receivables data and are subject to the standard AR security rules embedded in AR_PAYMENT_SCHEDULES_V. Because no IGI-specific predicates are applied, results align exactly with the Receivables payment schedule view for the same operating unit context.