Results for “invoice_currency_code”

50+ results




Overview
Explore in AI Chat

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

Overview

AP_SLA_INVOICES_TRANSACTION_V is a Subledger Accounting (SLA) oriented reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Payables (AP) product family and presents invoice header information joined to supplier party, party site, payment status, and payment terms data. The view is marked VALID in the ETRM repository and is intended primarily to expose Payables invoice transactions to SLA-related reporting, reconciliation, and extraction processes.

The view consolidates descriptive invoice attributes — invoice number, invoice date, invoice type, currency, cancellation data, and supplier identity — into a single flattened structure, removing the need for consumers to repeatedly re-implement the same join logic against AP_INVOICES_ALL, HZ_PARTIES, HZ_PARTY_SITES, and AP_SUPPLIERS.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: AP_INVOICES_ALL (synonym), AP_LOOKUP_CODES (view), AP_SUPPLIERS (synonym), AP_TERMS_LINES (synonym), FND_GLOBAL (package), HZ_PARTIES (synonym), and HZ_PARTY_SITES (synonym).

  • AP_INVOICES_ALL — the driving table, aliased AI, supplying invoice header columns such as INVOICE_ID, INVOICE_NUM, INVOICE_AMOUNT, INVOICE_DATE, TERMS_ID, and PAYMENT_STATUS_FLAG.
  • AP_SUPPLIERS — outer-joined (VENDOR_ID) to support employee-type suppliers, with logic introduced under Bug 7019211 and Bug 6150175.
  • HZ_PARTIES — inner-joined on PARTY_ID for the supplier party name; HZ_PARTY_SITES is outer-joined on PARTY_SITE_ID for the party site name.
  • AP_LOOKUP_CODES — outer-joined on lookup type 'INVOICE PAYMENT STATUS' to translate PAYMENT_STATUS_FLAG into a displayed payment status (Bug 7039815).
  • AP_TERMS_LINES — accessed via a scalar subquery to derive DUE_DAYS from the invoice's TERMS_ID.
  • FND_GLOBAL — referenced indirectly by the underlying AP_LOOKUP_CODES view for session-based language/org context.

Key Columns

  • INVOICE_ID — primary identifier of the invoice header; used for joins back to AP_INVOICES_ALL.
  • PARTY_NAME / PARTY_SITE_NAME — supplier party and site names resolved from HZ_PARTIES and HZ_PARTY_SITES.
  • INVOICE_NUM, INVOICE_DATE, INVOICE_TYPE_LOOKUP_CODE — identifying and classifying attributes of the invoice.
  • ORIGINAL_INVOICE_AMOUNT — a DECODE that returns INVOICE_AMOUNT when CANCELLED_DATE is null, otherwise CANCELLED_AMOUNT.
  • INVOICE_AMOUNT / BASE_AMOUNT — the entered amount and, per Bug 8770808, NVL(BASE_AMOUNT, INVOICE_AMOUNT).
  • PAYMENT_STATUS — the decoded payment status description (Bug 7039815).
  • DUE_DAYS — retrieved from AP_TERMS_LINES via a scalar subquery keyed on TERMS_ID with ROWNUM = 1. This is the column most directly associated with the user search term "due_days", indicating that the view was located because it exposes a derived DUE_DAYS value for payment-terms analysis.
  • TERMS_DATE, CANCELLED_DATE, DESCRIPTION, INVOICE_CURRENCY_CODE — supporting descriptive and date-tracking columns.

Common Use Cases and Queries

Typical uses include SLA invoice transaction reporting, supplier invoice extracts, and payment-terms aging analysis. A basic extract follows:

  • SELECT INVOICE_NUM, PARTY_NAME, INVOICE_AMOUNT, DUE_DAYS FROM APPS.AP_SLA_INVOICES_TRANSACTION_V WHERE INVOICE_DATE >= SYSDATE - 30;
  • SELECT INVOICE_NUM, PAYMENT_STATUS, ORIGINAL_INVOICE_AMOUNT FROM APPS.AP_SLA_INVOICES_TRANSACTION_V WHERE INVOICE_CURRENCY_CODE = 'USD';

Because DUE_DAYS is derived via a correlated subquery with ROWNUM = 1, callers should treat it as a single representative value from AP_TERMS_LINES when a term has multiple lines. Queries filtering heavily on DUE_DAYS are best limited by INVOICE_DATE or TERMS_ID to constrain the driving set.