Search Results cft_code




Overview
Explore in AI Chat

Overview

The OKL_CASH_FLOWS table resides in the OKL schema and is owned by the Oracle Leasing and Finance Management (OKL) module. It stores the header-level details of cash flows generated and managed within the OKL application. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this table functions as the master record for individual cash flow definitions, capturing the parametrization required to schedule, project, or calculate periodic payment and receipt streams associated with lease and finance contracts.

From a heuristic Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table carries descriptive and qualifying attributes (status codes, dates, type codes, and descriptive flexfield columns) that hang off the parent cash flow object and stream type references, rather than acting purely as an associative link between two hubs. Its surrogate primary key, OKL_CASH_FLOWS_PK on the ID column, uniquely identifies each cash flow header row.

Key Information Stored

The table contains 32 documented columns. The most significant are summarized below.

Common Use Cases and Queries

Typical reporting scenarios involve reconciling cash flow headers against their line-level detail and stream definitions, or auditing status distributions across cash flow objects.

  • Retrieve headers for a given cash flow object: SELECT * FROM OKL_CASH_FLOWS WHERE CFO_ID = :p_cfo_id;
  • Join to stream type for descriptive reporting: SELECT cf.ID, st.NAME, cf.START_DATE FROM OKL_CASH_FLOWS cf, OKL_STRM_TYPE_B st WHERE cf.STY_ID = st.ID;
  • Aggregate by status: SELECT STS_CODE, COUNT(*) FROM OKL_CASH_FLOWS GROUP BY STS_CODE;
  • Drill into line-level detail using OKL_CASH_FLOW_LEVELS.CAF_ID = OKL_CASH_FLOWS.ID.

Related Objects

  • OKL_CASH_FLOW_OBJECTS — Parent object referenced via OKL_CASH_FLOWS.CFO_ID.
  • OKL_STRM_TYPE_B — Stream type base table referenced via OKL_CASH_FLOWS.STY_ID.
  • OKL_CASH_FLOW_LEVELS — Child table referencing this header through CAF_ID.