Search Results ce_po_fc_orders_terms_temp_v




Overview
Explore in AI Chat

Overview

CE_PO_FC_ORDERS_TERMS_TEMP_V is an APPS-owned database view in Oracle E-Business Suite (validated on 12.1.1 and 12.2.2) that belongs to the Cash Management (CE) product family. Its documented purpose is to serve as a "Forecasting source - temp labor purchase orders with terms." In practice, this view consolidates open purchase order commitment data with payment term definitions, producing a flattened, forecast-ready row set that the Cash Management forecasting engine can consume.

Cash Management forecasting projects future cash inflows and outflows by aggregating open commitments, unpaid invoices, and other obligation sources. Purchase orders represent outgoing cash that is not yet invoiced, and the timing of that outflow depends on the payment terms attached to the supplier, supplier site, or PO header. This view bridges the procurement and payables domains by joining PO distributions to AP terms lines so that each distribution can be scheduled against its due date logic. The "TEMP" suffix reflects its role as an intermediate staging or source view rather than a permanent transactional table, and because it is a view, it stores no data of its own and imposes no storage overhead.

Underlying Base Objects

The view is defined over a mix of synonym-backed base tables, other views, and one package. The documented referenced objects are AP_TERMS_LINES, FINANCIALS_SYSTEM_PARAMS_ALL, GL_SETS_OF_BOOKS (view), PO_DISTRIBUTIONS_ALL, PO_DOCUMENT_TYPES_ALL, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_VENDORS (view), and PO_VENDOR_SITES_ALL (view), together with the FND_GLOBAL package.

The core join path links PO_HEADERS_ALL to PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL — the standard header-to-distribution procurement hierarchy. Each distribution provides the ordered, delivered, cancelled, and nonrecoverable tax amounts. AP_TERMS_LINES supplies the payment term detail (due amount, due percent, fixed date, due days, due months forward, and due day of month). Outer joins to PO_VENDORS and PO_VENDOR_SITES_ALL resolve payment priority and pay group, while PO_DOCUMENT_TYPES_ALL filters document categories. FINANCIALS_SYSTEM_PARAMS_ALL and GL_SETS_OF_BOOKS provide the default functional currency when neither the PO header nor the supplier carries one. FND_GLOBAL is referenced for session context such as org and user identifiers.

Key Columns

The view exposes 24 positional columns. Column 1 is SEGMENT1, the PO number. Column 2 computes the remaining open commitment value (ordered less delivered less cancelled, plus nonrecoverable tax, floored at zero) multiplied by the distribution rate or header rate. Column 3 returns the same open base amount without conversion.

Columns 4 through 11 are the payment term attributes: DUE_AMOUNT, DUE_PERCENT, START_DATE, EXPIRATION_DATE, FIXED_DATE, DUE_DAYS, DUE_MONTHS_FORWARD, and DUE_DAY_OF_MONTH. The inclusion of DUE_DAYS is directly relevant to the user search "due_days" — this column expresses the number of days after the term baseline at which payment is due and is the primary driver of forecast date calculation. Column 12 supplies the currency code. Column 13 returns AUTHORIZATION_STATUS (defaulting to 'INCOMPLETE'), and columns 14 through 16 return payment priority, vendor type, and pay group. Columns 17 to 20 carry ORG_ID, PROJECT_ID, TERM_ID, and LINE_NUM. Column 21 is a composite key concatenating distribution, term, and sequence identifiers. Columns 22 through 24 expose VALUE_BASIS, PURCHASE_BASIS, and MATCHING_BASIS from the PO line location.

Common Use Cases and Queries

Typical uses include reconciling forecasted PO outflows, reviewing term-driven due dates, and auditing open commitments by supplier. A simple listing of due timing follows.

  • SELECT SEGMENT1, DUE_DAYS, DUE_AMOUNT, START_DATE FROM CE_PO_FC_ORDERS_TERMS_TEMP_V WHERE DUE_DAYS IS NOT NULL;
  • SELECT SEGMENT1, ORG_ID, PROJECT_ID, LINE_NUM FROM CE_PO_FC_ORDERS_TERMS_TEMP_V WHERE AUTHORIZATION_STATUS = 'APPROVED';

Because DUE_DAYS is frequently the search term, analysts commonly filter or aggregate on it to project disbursement windows, then join back to PO_HEADERS_ALL using SEGMENT1 for drill-down.