Results for “bis_activity_versions_v”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIS_ACTIVITY_VERSIONS_V is a seeded Oracle E-Business Suite view owned by the APPS schema and classified under the BIS (Applications BIS) product family. It exposes activity version definitions originating from Oracle Time and Labor (OTA) and joins them to the PER business group model, producing a flattened, security-conscious list of activity versions with their associated business group context. In Oracle EBS 12.1.1 and 12.2.2, the object is documented with a status of VALID and is delivered as part of the standard Applications schema rather than as a customer-defined artifact.
The view is primarily used as a value-set or lookup source. Its ID/VALUE column pair — ID derived from ACTIVITY_VERSION_ID and VALUE derived from VERSION_NAME — is characteristic of an Oracle Forms LOV or concurrent program parameter list of values. Reporting and integration layers that need to resolve an internal activity_version identifier into a human-readable version name, scoped to a business group, consume this view rather than querying the OTA base tables directly.
Underlying Base Objects
The view text documents three referenced base objects:
- OTA_ACTIVITY_VERSIONS (alias AVR) — the driving table containing the activity version identifier, version name, owning activity, and effective dates.
- OTA_ACTIVITY_DEFINITIONS (alias ADF) — the parent activity definition, supplying the ACTIVITY_ID and BUSINESS_GROUP_ID linkage.
- PER_BUSINESS_GROUPS (alias BGR) — the HR business group master, supplying BUSINESS_GROUP_NAME and BUSINESS_GROUP_ID.
Joins are established as ADF.BUSINESS_GROUP_ID = BGR.BUSINESS_GROUP_ID and AVR.ACTIVITY_ID = ADF.ACTIVITY_ID. A restrictive predicate, NVL(AVR.END_DATE, SYSDATE) > TRUNC(ADD_MONTHS(SYSDATE, -12)), limits results to activity versions that are either currently open or ended within the last twelve months. This rolling-window filter keeps the list of values operationally relevant while retaining recently retired versions for reference. The ETRM metadata records no additional documented base objects beyond these three.
Key Columns
- ID — the ACTIVITY_VERSION_ID converted to character, used as the lookup key value.
- VALUE — the VERSION_NAME, presented as the display value in list-of-values contexts.
- ACTIVITY_VERSION_ID — numeric primary identifier of the activity version in OTA_ACTIVITY_VERSIONS.
- ACTIVITY_VERSION — the descriptive version name, duplicated from VALUE for convenience.
- BUSINESS_GROUP_NAME — the human-readable name of the owning business group from PER_BUSINESS_GROUPS.
- BUSINESS_GROUP_ID — the numeric business group identifier, exposed for filtering and joining.
Common Use Cases and Queries
Typical usage includes parameter LOVs for Time and Labor concurrent programs, reconciliation reports mapping activity versions to business groups, and integration extracts where a stable identifier-to-name mapping is required.
Listing all currently visible activity versions:
SELECT id, value, activity_version, business_group_name
FROM apps.bis_activity_versions_v;
Restricting to a single business group:
SELECT activity_version_id, activity_version
FROM apps.bis_activity_versions_v
WHERE business_group_id = :p_business_group_id;
Joining to a fact table on the numeric identifier:
SELECT f.*, v.activity_version, v.business_group_name
FROM my_activity_facts f, apps.bis_activity_versions_v v
WHERE f.activity_version_id = v.activity_version_id;
Because the view applies an effective-date filter relative to SYSDATE, results change over time; consumers should not treat the output as a complete historical archive of activity versions. Oracle Proprietary, Confidential Information — Legal Notices apply to this object and its documentation.
-
APPS.BIS_ACTIVITY_VERSIONS_V·↳ OTA_ACTIVITY_DEFINITIONS·↳ OTA_ACTIVITY_VERSIONS·↳ PER_BUSINESS_GROUPS·Explore BIS module →
-
Not implemented in this database·Explore BIS module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - BIS Tables and Views 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - BIS Tables and Views 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person