Results for “ce_po_fc_requisitions_temp_v”

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

Overview

CE_PO_FC_REQUISITIONS_TEMP_V is an APPS-owned database view within the Cash Management (CE) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented purpose is to serve as a forecasting source for temp labor purchase order requisitions. In the ETRM framework, forecasting views such as this expose transactional commitments that feed cash forecasting engines, allowing treasury users to project future cash outflows arising from approved purchasing activity. This particular view isolates requisitions whose purchase basis is "TEMP LABOR," distinguishing contingent or temporary labor spend from other procurement commitments. The view is read-only and intended for reporting and integration, not for data maintenance.

Underlying Base Objects

The view text joins six documented objects: PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS_ALL, PO_DOCUMENT_TYPES_ALL, FINANCIALS_SYSTEM_PARAMS_ALL, and GL_SETS_OF_BOOKS. The first four are PO synonyms; FINANCIALS_SYSTEM_PARAMS_ALL is a synonym and GL_SETS_OF_BOOKS is a view. Header, line, and distribution records are correlated on REQUISITION_HEADER_ID, REQUISITION_LINE_ID, and ORG_ID, while set-of-books context is derived through FSP and SOB joined on SET_OF_BOOKS_ID. Document type validation is enforced via PO_DOCUMENT_TYPES_ALL. The WHERE clause restricts output to purchase-type requisitions with AUTHORIZATION_STATUS not in ('CANCELLED','REJECTED'), line CLOSED_CODE not in ('CANCELLED','FROZEN','FINALLY CLOSED'), SOURCE_TYPE_CODE of 'VENDOR', null LINE_LOCATION_ID, unmodified agent flag, uncancelled lines, and PURCHASE_BASIS = 'TEMP LABOR'.

Key Columns

• REQ_NUM — requisition header segment1 identifier.
• BASE_AMOUNT — NVL of REQ_LINE_AMOUNT, the line amount in the transaction currency.
• AMOUNT — REQ_LINE_CURRENCY_AMOUNT plus non-recoverable tax, representing the forecastable cash amount.
• CURRENCY_CODE — derived from requisition line currency, falling back to invoice currency, then ledger currency.
• START_DATE / END_DATE — assignment start and end dates for the temp labor line.
• STATUS — authorization status of the requisition header, defaulting to 'INCOMPLETE'.
• ORG_ID, PROJECT_ID, LINE_NUMBER, REFERENCE_ID — organizational, project, line, and distribution identifiers.
• ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, MATCHING_BASIS — purchasing attributes carried for classification and matching.

Common Use Cases and Queries

This view is typically consumed by cash forecasting and treasury reporting processes that need to project temp labor commitments by currency and period. A representative query projects open temp labor requisitions by organization:

SELECT req_num, amount, currency_code, start_date, end_date, status, org_id FROM apps.ce_po_fc_requisitions_temp_v WHERE status = 'APPROVED' ORDER BY start_date;

Analysts may aggregate forecasted spend by currency or ledger for liquidity planning, or join PROJECT_ID to project reporting for capital and labor tracking. Because the view excludes cancelled, rejected, frozen, and finally closed records, results reflect only active temp labor commitments suitable for forward-looking cash projections.