Results for “rqd_flag_m”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The BENBV_CM_DLVRY_MED_TYP_V view is a descriptive flexfield-enabled, business-group-secured database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the BEN — Advanced Benefits product family and identifies the material or medium used to create a communication. In the Benefits configuration model, a communication delivery method (for example, print, email, or web) is further qualified by the delivery medium type, which distinguishes the physical or electronic carrier used to render and transmit the communication.
The view does not store data itself. It is a reporting and integration facade over the underlying delivery-medium-type table, exposing decoded, user-facing values alongside their raw code values and surrogate identifiers. Because the view is defined with the WITH READ ONLY clause, it is intended strictly for query and extraction purposes and cannot be used as a DML target. This makes it suitable for concurrent programs, BI Publisher data templates, OAF/ADF lookups, and integration extracts that must respect Oracle EBS security conventions.
Underlying Base Objects
According to the documented ETRM metadata, the view is defined over the following referenced base objects:
- BEN_CM_DLVRY_MED_TYP (SYNONYM) — the base Advanced Benefits table holding delivery medium type definitions, referenced in the view text through the alias
CMD. - HR_BIS (PACKAGE) — the HR Business Intelligence/security package supplying the
BIS_DECODE_LOOKUPfunction used for code-to-meaning decoding, andGET_SEC_PROFILE_BG_IDused for business group security filtering.
The view joins the base table to the HR_BIS package functions to translate stored lookup codes into descriptive meanings. A security predicate restricts rows to the business group returned by HR_BIS.GET_SEC_PROFILE_BG_ID; when that function returns no value, the NVL expression falls back to the row's own BUSINESS_GROUP_ID.
Key Columns
- "_DF:CMD" — the descriptive flexfield context marker (
_DF:BEN:BEN_CM_DLVRY_MED_TYP:CMD), enabling DFF segment exposure. - CM_DLVRY_MED_TYP_CD — the delivery medium type code, the primary user-visible identifier for the medium.
- CM_DLVRY_MED_TYP_CD_M — the decoded meaning of the medium type code, resolved via
HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MED', ...). - RQD_FLAG / RQD_FLAG_M — the required indicator and its decoded Yes/No meaning.
- DFLT_FLAG / DFLT_FLAG_M — the default indicator and its decoded Yes/No meaning.
- CM_DLVRY_MED_TYP_ID — the surrogate primary key of the delivery medium type.
- BUSINESS_GROUP_ID — the owning business group, used for security and multi-organization filtering.
- CM_DLVRY_MTHD_TYP_ID — foreign key to the related communication delivery method type.
- WHO columns —
LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY, andCREATION_DATEfor audit tracking.
Common Use Cases and Queries
Typical scenarios include validating available medium types, populating LOVs, and extracting communication setup for audit or migration. A representative query retrieving active medium types for the current security context:
SELECT CM_DLVRY_MED_TYP_CD, CM_DLVRY_MED_TYP_CD_M, RQD_FLAG_M, DFLT_FLAG_M FROM BENBV_CM_DLVRY_MED_TYP_V;SELECT CM_DLVRY_MED_TYP_ID, CM_DLVRY_MED_TYP_CD, DFLT_FLAG FROM BENBV_CM_DLVRY_MED_TYP_V WHERE RQD_FLAG = 'Y' ORDER BY CM_DLVRY_MED_TYP_CD;- Joining the view to delivery method definitions via
CM_DLVRY_MTHD_TYP_IDto report the medium types associated with each communication method.
Because the view enforces read-only access and business group security, it is the recommended access path for reporting on delivery medium types rather than querying BEN_CM_DLVRY_MED_TYP directly.
-
This view identifies the material used to create the communication.
APPS.BENBV_CM_DLVRY_MED_TYP_V·↳ BEN_CM_DLVRY_MED_TYP·↳ HR_BIS·Explore BEN module →
-
View: BENBV_LER_ENRT_CTFN_V 12.2.2
This view identifies the types of certifications that may be required in order to enroll in a plan as a result of a specified life event.
APPS.BENBV_LER_ENRT_CTFN_V·↳ BEN_LER_ENRT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies certifications that may be required if a person elects to enroll in a plan, option or benefit
APPS.BENBV_ELCTBL_CHC_CTFN_V·↳ BEN_ELCTBL_CHC_CTFN·↳ HR_BIS·Explore BEN module →
-
This view identifies the certifications that may be required as a result of a life event that allows a participant to add or remove dependents.
APPS.BENBV_LER_CHG_DPNT_CVG_CTFN_V·↳ BEN_LER_CHG_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies what certification may be required to substantiate a reimbursement claim for the plan.
APPS.BENBV_PL_GD_R_SVC_CTFN_V·↳ BEN_PL_GD_R_SVC_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification(s) that may be required for a standard rate.
APPS.BENBV_ACTY_BASE_RT_CTFN_V·↳ BEN_ACTY_BASE_RT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the material used to create the communication.
APPS.BENBV_CM_DLVRY_MED_TYP_V·↳ BEN_CM_DLVRY_MED_TYP·↳ HR_BIS·Explore BEN module →
-
View: BENBV_LER_ENRT_CTFN_V 12.1.1
This view identifies the types of certifications that may be required in order to enroll in a plan as a result of a specified life event.
APPS.BENBV_LER_ENRT_CTFN_V·↳ BEN_LER_ENRT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification(s) that may be required when a restriction has been placed on the levels of benefits or coverage, such as life insurance.
APPS.BENBV_BNFT_RSTRN_CTFN_V·↳ BEN_BNFT_RSTRN_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certifications that may be required as a result of a life event that allows a participant to add or remove dependents.
APPS.BENBV_LER_CHG_DPNT_CVG_CTFN_V·↳ BEN_LER_CHG_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies what certification may be required to substantiate a reimbursement claim for the plan.
APPS.BENBV_PL_GD_R_SVC_CTFN_V·↳ BEN_PL_GD_R_SVC_CTFN_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_ENRT_CTFN_V 12.2.2
This view identifies the certification which may be required in order for any person to substantiate their enrollment in a plan as a result of a life event reason
APPS.BENBV_ENRT_CTFN_V·↳ BEN_ENRT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the delivery mechanisms available to transmit compensation-related communications, for example, e-mail, voicemail, postal service and fax.
APPS.BENBV_CM_DLVRY_MTHD_TYP_V·↳ BEN_CM_DLVRY_MTHD_TYP·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification that may be required in order to designate a person as a dependent when dependent designation is defined at the plan level.
APPS.BENBV_PL_DPNT_CVG_CTFN_V·↳ BEN_PL_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view specifies the certifications that may be required when a person designates dependents under the terms of the program.
APPS.BENBV_PGM_DPNT_CVG_CTFN_V·↳ BEN_PGM_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification that may be required when a person waives coverage in a plan for a specified reason as opposed to actively electing a waive plan.
APPS.BENBV_WV_PRTN_RSN_CTFN_PL_V·↳ BEN_WV_PRTN_RSN_CTFN_PL_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification that may be required when a person waives coverage in a plan for a specified reason as opposed to actively electing a waive plan.
APPS.BENBV_WV_PRTN_RSN_CTFN_PL_V·↳ BEN_WV_PRTN_RSN_CTFN_PL_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PRTT_ENRT_ACTN_V 12.1.1
This view identifies any outstanding enrollment action items required of a person in order for elections or life events to be unsuspended or, at a minimum, considered complete.
APPS.BENBV_PRTT_ENRT_ACTN_V·↳ BEN_PRTT_ENRT_ACTN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification that may be required in order to designate a person as a dependent when dependent designation is defined at the plan level.
APPS.BENBV_PL_DPNT_CVG_CTFN_V·↳ BEN_PL_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the delivery mechanisms available to transmit compensation-related communications, for example, e-mail, voicemail, postal service and fax.
APPS.BENBV_CM_DLVRY_MTHD_TYP_V·↳ BEN_CM_DLVRY_MTHD_TYP·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification(s) that may be required for a standard rate.
APPS.BENBV_ACTY_BASE_RT_CTFN_V·↳ BEN_ACTY_BASE_RT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certification(s) that may be required when a restriction has been placed on the levels of benefits or coverage, such as life insurance.
APPS.BENBV_BNFT_RSTRN_CTFN_V·↳ BEN_BNFT_RSTRN_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certifications that may be required when a person elects to enroll in a benefit where the enrollment opportunity is the result of a specific life event.
APPS.BENBV_LER_BNFT_RSTRN_CTFN_V·↳ BEN_LER_BNFT_RSTRN_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the certifications that may be required when a person elects to enroll in a benefit where the enrollment opportunity is the result of a specific life event.
APPS.BENBV_LER_BNFT_RSTRN_CTFN_V·↳ BEN_LER_BNFT_RSTRN_CTFN_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_ENRT_CTFN_V 12.1.1
This view identifies the certification which may be required in order for any person to substantiate their enrollment in a plan as a result of a life event reason
APPS.BENBV_ENRT_CTFN_V·↳ BEN_ENRT_CTFN_F·↳ HR_BIS·Explore BEN module →
-
This view identifies certifications that may be required if a person elects to enroll in a plan, option or benefit
APPS.BENBV_ELCTBL_CHC_CTFN_V·↳ BEN_ELCTBL_CHC_CTFN·↳ HR_BIS·Explore BEN module →
-
This view specifies the certifications that may be required when a person designates dependents under the terms of the program.
APPS.BENBV_PGM_DPNT_CVG_CTFN_V·↳ BEN_PGM_DPNT_CVG_CTFN_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PRTT_ENRT_ACTN_V 12.2.2
This view identifies any outstanding enrollment action items required of a person in order for elections or life events to be unsuspended or, at a minimum, considered complete.
APPS.BENBV_PRTT_ENRT_ACTN_V·↳ BEN_PRTT_ENRT_ACTN_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PL_BNF_CTFN_V 12.2.2
This view identifies the certifications that may be required of a participant designating beneficiaries for a plan.
APPS.BENBV_PL_BNF_CTFN_V·↳ BEN_PL_BNF_CTFN_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PL_BNF_CTFN_V 12.1.1
This view identifies the certifications that may be required of a participant designating beneficiaries for a plan.
APPS.BENBV_PL_BNF_CTFN_V·↳ BEN_PL_BNF_CTFN_F·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.BENBV_ENRT_CTFN_V 12.1.1
-
VIEW: APPS.BENBV_ENRT_CTFN_V 12.2.2