Search Results ota_suppliable_resources_v




Overview
Explore in AI Chat

Overview

OTA_SUPPLIABLE_RESOURCES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OTA (Learning Management) product. Its documented purpose is to list information about suppliable resources — the external and internal suppliers, trainers, training centers, and vendor-provided materials that can be attached to a learning offering or class. In Oracle EBS 12.1.1 and 12.2.2 the object carries a status of VALID and is exposed to reporting, integration, and extension code rather than being maintained directly by end users.

The view is a denormalized presentation layer over the suppliable resources entity. It resolves surrogate keys into human-readable values by joining descriptive and lookup tables, so that a single query can return the supplier name, resource description, consumable indicator meaning, resource type meaning, and currency name alongside the base attributes. This makes it suitable for concurrent program data sources, BI Publisher reports, custom OAF or Forms regions, and inbound/outbound interface extracts.

Because the view joins multilingual and lookup objects, it is language-sensitive. The supplied resource name and special instructions are sourced from the translation table filtered by the session language, while the consumable and resource type attributes are resolved against HR_LOOKUPS.

Underlying Base Objects

The documented base objects referenced by the view are:

  • OTA_SUPPLIABLE_RESOURCES (synonym) — the primary transactional table, aliased TSR, holding supplier, cost, lead time, and descriptive flexfield columns.
  • OTA_SUPPLIABLE_RESOURCES_TL (synonym) — the translation table, aliased SRT, supplying the language-specific resource name and special instructions.
  • OTA_RESOURCE_DEFINITIONS (synonym) — aliased RES, providing the resource definition context and the ID_FLEX_NUM used to interpret descriptive flexfield segments.
  • PO_VENDORS (view) — aliased VEN, providing VENDOR_NAME; joined with an outer join (+) so that internal resources without a vendor are still returned.
  • HR_LOOKUPS (view) — aliased twice, CF_LOOK for the 'YES_NO' consumable flag and RT_LOOK for the 'RESOURCE_TYPE' lookup, converting lookup codes into meanings.
  • OTA_GENERAL (package) — supplies the FND_CURRENCY_NAME function used to derive the currency name.
  • HR_API (package) — referenced for the standard HR security and utility routines used elsewhere in the suppliable resources stack.

Key Columns

Common Use Cases and Queries

Typical scenarios include enumerating all suppliable resources for a business group, identifying vendor-supplied consumables, extracting cost and lead-time data for procurement planning, and driving class or offering scheduling where trainers and training centers must be resolved by ID.

The following query lists active vendor-supplied resources with resolved lookup meanings:

SELECT supplied_resource_id, supplied_resource_name, vendor_name, resource_type_meaning, consumable_meaning, cost, currency_code, start_date, end_date FROM ota_suppliable_resources_v WHERE business_group_id = :p_bg_id AND vendor_id IS NOT NULL AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, TRUNC(SYSDATE)+1) ORDER BY supplied_resource_name;

A second common pattern resolves trainer and center attributes for a specific offering, and a third extracts all consumable resources for a business group to feed an external cost model. Because the view embeds the outer join to PO_VENDORS, queries that must distinguish internal from external resources should test VENDOR_ID for null. Date-driven filters are advisable, since the view does not itself restrict rows to the current effective period.