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
- ROW_ID — the pseudo-column identifier used by Oracle Forms and OAF to address individual schedule rows.
- TRX_NUMBER — the transaction (invoice, debit memo, credit memo, or chargeback) number.
- TERMS_SEQUENCE_NUMBER — the sequence number identifying each installment within the payment term schedule; the value the searching user asked about. It distinguishes multiple due dates generated by split or multi-installment payment terms.
- INVOICE_CURRENCY_CODE — the currency of the transaction, governing all amount columns.
- CUSTOMER_TRX_ID — the foreign key to the transaction header, useful for joins to RA_CUSTOMER_TRX_ALL.
- AL_CLASS_MEANING — the meaning of the transaction class (for example, Invoice, Credit Memo, Debit Memo).
- DUE_DATE — the due date of the installment.
- AMOUNT_DUE_ORIGINAL and AMOUNT_DUE_REMAINING — the original and open amounts for the installment.
- AL_STATUS_MEANING — the open or closed status of the schedule line.
- AMOUNT_IN_DISPUTE and DISPUTE_DATE — dispute tracking values.
- DAYS_PAST_DUE — rounded days past due, derived at query time.
- BILLING_NUMBER — the customer purchase order or billing reference.
- Audit columns — LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.
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.
-
Holds payment term schedules for the selected invoice
APPS.IGI_AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_PAYMENT_SCHEDULES_V·Explore IGI module →
-
(Release 115)
APPS.RA_CUST_TRX_LINE_GL_DIST_V·↳ AR_LOOKUPS·↳ RA_CUSTOMER_TRX_LINES·↳ RA_CUST_TRX_LINE_GL_DIST·Explore AR module →
-
View: AR_OEX_INVOICE_VIEW 12.2.2
(Invoice view for Oracle Exchange Invoices)
APPS.AR_OEX_INVOICE_VIEW·↳ AR_LOOKUPS·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore AR module →
-
Holds payment term schedules for the selected invoice
APPS.IGI_AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_PAYMENT_SCHEDULES_V·Explore IGI module →
-
View: AR_OEX_INVOICE_VIEW 12.1.1
(Invoice view for Oracle Exchange Invoices)
APPS.AR_OEX_INVOICE_VIEW·↳ AR_LOOKUPS·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore AR module →
-
(Release 115)
APPS.RA_CUST_TRX_LINE_GL_DIST_RA_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_REVENUE_ADJUSTMENTS·↳ RA_CUSTOMER_TRX_LINES·Explore AR module →
-
(Release 115)
APPS.RA_CUST_TRX_LINE_GL_DIST_RA_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_REVENUE_ADJUSTMENTS·↳ RA_CUSTOMER_TRX_LINES·Explore AR module →
-
(Release 115)
APPS.RA_CUST_TRX_LINE_GL_DIST_V·↳ AR_LOOKUPS·↳ RA_CUSTOMER_TRX_LINES·↳ RA_CUST_TRX_LINE_GL_DIST·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_TRX2_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV_ALL·Explore AR module →
-
View: AR_PAYMENT_SCHEDULES_V 12.2.2
APPS.AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
View: AR_PAYMENT_SCHEDULES_V 12.1.1
APPS.AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
(Release 115 Only )
APPS.AR_PAYMENT_SCHEDULES_PMT_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_TRX2_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV_ALL·Explore AR module →
-
(Release 115 Only )
APPS.AR_PAYMENT_SCHEDULES_PMT_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
View: IBE_RA_CUSTOMER_TRX_V 12.2.2
This view is used to get the Invoice header details in Post sales interaction with Customer in iStore, this view is bases on ra_customrer_trx
Not implemented in this database·Explore IBE module →
-
View: IBE_RA_CUSTOMER_TRX_V 12.1.1
This view is used to get the Invoice header details in Post sales interaction with Customer in iStore, this view is bases on ra_customrer_trx
Not implemented in this database·Explore IBE module →
-
View: ICX_RA_CUSTOMER_TRX_V 12.2.2
Customer Transactions Header View
Not implemented in this database·Explore ICX module →
-
Not implemented in this database·Explore IBE module →
-
View: ICX_RA_CUSTOMER_TRX_V 12.1.1
Customer Transactions Header View
Not implemented in this database·Explore ICX module →
-
Not implemented in this database·Explore IBE module →
-
Invoice and Debit Memos Payment Schedules View
Not implemented in this database·Explore ICX module →
-
Payment Schedules View
Not implemented in this database·Explore ICX module →
-
Invoice and Debit Memos Payment Schedules View
Not implemented in this database·Explore ICX module →
-
Payment Schedules View
Not implemented in this database·Explore ICX module →
-
Credit Memo Payment Schedules View
Not implemented in this database·Explore ICX module →
-
Credit Memo Payment Schedules View
Not implemented in this database·Explore ICX module →