Results for “due_days”
50+ results
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.
-
APPS.AP_SLA_INVOICES_TRANSACTION_V·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIERS·Explore AP module →
-
Detail information about payment terms
-
APPS.AP_SLA_INVOICES_TRANSACTION_V·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIERS·Explore AP module →
-
Forecasting source - temp labor purchase orders with terms
APPS.CE_PO_FC_ORDERS_TERMS_TEMP_V·↳ AP_TERMS_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore CE module →
-
Line information for Payment Terms
-
Forecasting source - goods and services purchase orders with terms
APPS.CE_PO_FC_ORDERS_TERMS_V·↳ AP_TERMS_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_SETS_OF_BOOKS·Explore CE module →
-
Forecasting source - goods and services purchase orders with terms
APPS.CE_PO_FC_ORDERS_TERMS_V·↳ AP_INVOICE_LINES_ALL·↳ AP_TERMS_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·Explore CE module →
-
Forecasting source - temp labor purchase orders with terms
APPS.CE_PO_FC_ORDERS_TERMS_TEMP_V·↳ AP_TERMS_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_SETS_OF_BOOKS·Explore CE 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 →
-
Line information for Payment Terms
-
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: 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 →
-
Detail information about payment terms
-
APPS.AR_PAYMENT_SCHEDULES_TRX2_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV_ALL·Explore AR module →
-
VIEW: AR.RA_TERMS_LINES# 12.2.2
-
VIEW: AP.AP_TERMS_LINES# 12.2.2
-
VIEW: AR.RA_TERMS_LINES# 12.2.2
-
VIEW: AP.AP_TERMS_LINES# 12.2.2
-
TABLE: AR.RA_TERMS_LINES 12.1.1
-
TABLE: AR.RA_TERMS_LINES 12.2.2
-
TABLE: AP.AP_TERMS_LINES 12.1.1
-
TABLE: AP.AP_TERMS_LINES 12.2.2