Search Results bs_look

Overview

APPS.OTA_RESOURCE_BOOKINGS_V is a reporting and integration view within the Oracle E-Business Suite OTA (Oracle Training Administration / ETRM) module. It presents a consolidated, denormalized picture of resource bookings made against suppliable training resources such as vendors, trainers, venues, and consumable materials. Rather than requiring report authors and integrators to navigate the normalized OTA_RESOURCE_BOOKINGS table together with supplier, event, finance, and lookup tables, the view joins these sources and translates internal codes into human-readable meanings.

The view is owned by the APPS schema and is exposed as a synonym accessible from PL/SQL packages, Oracle Reports, BI Publisher data templates, and custom concurrent programs. Its role is primarily read-only: it surfaces booking status, resource cost, event scheduling details, vendor identification, financial transfer lines, and descriptive flexfield context in a single queryable row per resource booking.

Underlying Base Objects

The view is defined over a mixture of base tables, translation tables, synonyms, lookups, and API packages:

• OTA_RESOURCE_BOOKINGS — the driving table (aliased TRB), supplying booking identity, quantities, dates, status, contacts, and the TRB_INFORMATION descriptive flexfield columns.
• OTA_SUPPLIABLE_RESOURCES and OTA_SUPPLIABLE_RESOURCES_TL — the resource (TSR) and its translated name (SRT).
• OTA_EVENTS and OTA_EVENTS_TL — event scheduling data (EVT/ENT) including start/end dates, times, centre, and location.
• OTA_ACTIVITY_VERSIONS_TL — the offering version (TAV) associated with the booking.
• OTA_OFFERINGS — the offering record tied to the event.
• OTA_FINANCE_LINES — financial transfer lines (TFL) such as money amount, currency, and transfer status.
• PO_VENDORS — vendor name (VEN) for externally supplied resources.
• HR_LOOKUPS — meaning values for resource type and booking status.
• HR_GENERAL (package) — used via hr_general.decode_fnd_comm_lookup to decode lookup codes such as TRAINING_CENTRE and TRAINER_PARTICIPATION.
• FND_USER — resolves the booking person into a username.
• HR_API (package) — referenced by the view definition for HR-related derivations.

Key Columns

Identification columns include RESOURCE_BOOKING_ID, SUPPLIED_RESOURCE_ID, RESOURCE_DEFINITION_ID, EVENT_ID, and ACTIVITY_VERSION_ID. Resource attributes are exposed as RESOURCE_TYPE with its decoded meaning, the translated SRT.NAME, CONSUMABLE_FLAG, CURRENCY_CODE, COST, and COST_UNIT. Scheduling attributes include REQUIRED_DATE_FROM, REQUIRED_DATE_TO, REQUIRED_START_TIME, and REQUIRED_END_TIME, alongside event-level COURSE_START_DATE, COURSE_END_DATE, and COURSE_START_TIME/COURSE_END_TIME. Booking lifecycle fields include DATE_BOOKING_PLACED, STATUS with its BS_LOOK.MEANING decode, and OBJECT_VERSION_NUMBER for optimistic locking awareness. Commercial and administrative fields include ABSOLUTE_PRICE, QUANTITY, DELEGATES_PER_UNIT, PRIMARY_VENUE_FLAG, ROLE_TO_PLAY, BOOKING_PERSON_ID with FND.USER_NAME, COMMENTS, CONTACT_NAME, and CONTACT_PHONE_NUMBER. The financial side exposes MONEY_AMOUNT, FINANCE_HEADER_ID, FINANCE_LINE_ID, and TRANSFER_STATUS.

Common Use Cases and Queries

Typical scenarios include training resource cost reporting, vendor booking registers, venue utilization analysis, and audit extracts of booking status. A representative query filtering on the status meaning (the term the user searched, "bs_look", refers to the BS_LOOK alias that supplies TRB.STATUS meanings) might read:

• SELECT resource_booking_id, srt_name, vendor_name, meaning status, cost, quantity FROM apps.ota_resource_bookings_v WHERE meaning = 'Confirmed';
• SELECT event_id, title, course_start_date, vendor_name, money_amount FROM apps.ota_resource_bookings_v WHERE course_start_date BETWEEN :from_date AND :to_date;
• SELECT resource_booking_id, contact_name, contact_phone_number, required_date_from FROM apps.ota_resource_bookings_v WHERE vendor_id = :vendor_id;

When no explicit alias is present for the status decode in a custom query, joining or substring-filtering on BS_LOOK.MEANING returns the booking status text used throughout Resource Booking forms.