Results for “oks_strm_type_v”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKS_STRM_TYPE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKS – Service Contracts product family. The view exposes the defined stream types used within Oracle Service Contracts. A stream represents a directional component of contract cashflow, and its type indicates the purpose or classification of that stream; a stream may represent a positive (+) or negative (−) cashflow. The view therefore provides the reference data that governs how contract lines, billing schedules, and revenue recognition events are categorized during contract authoring and downstream processing.
In EBS 12.1.1 and 12.2.2 the view is documented with a status of VALID and is treated as a reporting and integration interface over the underlying stream type definition table. Because it is a view rather than a base table, it is read-only in practice and is intended for queries, concurrent program data sources, and external integrations rather than direct DML.
Underlying Base Objects
The view is defined over a single base object, OKS_STRM_TYPE, referenced through the public synonym OKS_STRM_TYPE in the APPS schema. The view text selects from that table using the alias STY, joining no other tables. Every column in the view is a direct passthrough of a column on OKS_STRM_TYPE, with no expressions, decoding, or aggregation applied. Consequently, row counts, uniqueness of ID, and effective dating semantics are inherited unchanged from the base table.
Because the view is a thin projection, it does not add filtering for the START_DATE and END_DATE columns; consumers that require only currently effective stream types must apply date-range predicates themselves.
Key Columns
- ROW_ID – the ROWID of the underlying OKS_STRM_TYPE row, useful for identifying a specific physical row in the base table.
- ID – the primary identifier of the stream type, referenced by foreign keys elsewhere in the Service Contracts data model.
- NAME – the user-facing name of the stream type.
- DESCRIPTION – the descriptive text explaining the purpose of the stream type.
- TAXABLE_DEFAULT_YN – the default taxable flag applied when the stream type is used. This is the column most commonly investigated when determining default tax treatment on contract streams.
- ACCRUAL_YN – indicates whether the stream type is accrual-based.
- CUSTOMISATION_LEVEL_CODE – the customization level, which governs whether the seeded definition may be modified by users or is protected as Oracle-owned seed data.
- START_DATE / END_DATE – the effective dating range for the stream type definition.
- OBJECT_VERSION_NUMBER – used for optimistic locking on the base record.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – standard EBS audit columns identifying who created and last modified the row and when.
Common Use Cases and Queries
Typical uses include validating the default taxability assigned to a stream type, driving lookups in reports and interfaces, and auditing who last changed a stream type definition. Because TAXABLE_DEFAULT_YN is frequently the subject of investigation, it is common to query it directly alongside the identifying columns.
- List all stream types with their taxability and customization level:
SELECT id, name, description, taxable_default_yn, accrual_yn, customisation_level_code FROM apps.oks_strm_type_v ORDER BY name; - Retrieve only currently effective stream types:
SELECT id, name, taxable_default_yn FROM apps.oks_strm_type_v WHERE TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, TRUNC(SYSDATE)+1); - Find stream types that default to taxable:
SELECT id, name FROM apps.oks_strm_type_v WHERE taxable_default_yn = 'Y'; - Audit recent changes to stream type definitions:
SELECT id, name, last_updated_by, last_update_date FROM apps.oks_strm_type_v ORDER BY last_update_date DESC;
In all cases, querying the view is preferable to querying OKS_STRM_TYPE directly, since the view presents a stable column list and is the documented interface for the stream type reference data.
-
View: OKS_STRM_TYPE_V 12.2.2
Specifies what the stream is for. A stream may be a + or - cashflow.
-
View: OKS_STRM_TYPE_V 12.1.1
Specifies what the stream is for. A stream may be a + or - cashflow.
-
VIEW: APPS.OKS_STRM_TYPE_V 12.2.2
-
VIEW: APPS.OKS_STRM_TYPE_V 12.1.1
-
View: OKS_STREAM_V 12.1.1
This View is used to define an Object meta data in Jtf.
-
View: OKS_STREAM_V 12.2.2
This View is used to define an Object meta data in Jtf.
-
VIEW: APPS.OKS_STREAM_V 12.1.1
-
VIEW: APPS.OKS_STREAM_V 12.2.2
-
SYNONYM: APPS.OKS_STRM_TYPE 12.1.1
-
SYNONYM: APPS.OKS_STRM_TYPE 12.2.2
-
VIEW: APPS.OKS_STREAM_V 12.2.2
-
VIEW: APPS.OKS_STREAM_V 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKS Tables and Views 12.1.1
Stores the template set information.
-
eTRM - OKS Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - OKS Tables and Views 12.2.2
-
eTRM - OKS Tables and Views 12.1.1
Stores the template set information.