Search Results benbv_cm_dlvry_mthd_typ_v




Overview
Explore in AI Chat

Overview

BENBV_CM_DLVRY_MTHD_TYP_V is a read-only descriptive flexfield (DFF) view owned by the APPS schema in Oracle E-Business Suite, delivered with the Advanced Benefits (BEN) product family. It exposes the delivery mechanisms that may be used to transmit compensation-related communications, such as e-mail, voicemail, postal service, and fax. The view is a business-group-secured, presentation-layer object rather than a physical table; it joins the underlying delivery method type entity to Oracle's descriptive flexfield and lookup-decoding infrastructure so that concurrent programs, OAF pages, and ad hoc reports can present user-friendly values instead of raw codes.

Because the view is created WITH READ ONLY, it cannot be used for DML. Its primary role is reporting, integration, and LOV (list of values) population for compensation communication setup. A leading _DF:BEN:BEN_CM_DLVRY_MTHD_TYP:CMT pseudo-column signals to the Oracle Forms and OAF descriptive flexfield framework that the row source participates in a DFF definition, allowing the application to resolve flexfield segments dynamically.

Underlying Base Objects

The view is defined over two documented referenced objects:

  • BEN_CM_DLVRY_MTHD_TYP (synonym) — The base table holding one row per delivery method type definition, including the short code, default flag, required flag, business group, and the parent compensation type (CM_TYP_ID).
  • HR_BIS (package) — The Human Resources Business Intelligence/decoding package. It supplies BIS_DECODE_LOOKUP for translating lookup codes into display meanings and GET_SEC_PROFILE_BG_ID for enforcing business-group security.

The WHERE clause restricts rows to NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CMT.BUSINESS_GROUP_ID), so a session sees only delivery mechanisms belonging to its secured business group; users without a security profile restriction see all business groups.

Key Columns

Common Use Cases and Queries

Typical scenarios include listing the communication channels configured for a compensation type, building LOVs for compensation communication setup, and auditing default or required delivery mechanisms per business group.

Basic listing:

SELECT CM_DLVRY_MTHD_TYP_CD_M, DFLT_FLAG_M, RQD_FLAG_M
FROM APPS.BENBV_CM_DLVRY_MTHD_TYP_V
ORDER BY CM_DLVRY_MTHD_TYP_CD_M;

Filtering by parent compensation type:

SELECT CM_DLVRY_MTHD_TYP_ID, CM_DLVRY_MTHD_TYP_CD_M
FROM APPS.BENBV_CM_DLVRY_MTHD_TYP_V
WHERE CM_TYP_ID = :p_cm_typ_id;

Auditing required mechanisms:

SELECT CM_DLVRY_MTHD_TYP_CD_M, DFLT_FLAG_M
FROM APPS.BENBV_CM_DLVRY_MTHD_TYP_V
WHERE RQD_FLAG = 'Y';

Because the object is a secured read-only view, integrations should query it directly rather than targeting the base table, ensuring business-group security and decoded meanings are consistently applied across 12.1.1 and 12.2.2 environments.