Search Results rlm_schedule_interface_hdr_v




Overview
Explore in AI Chat

Overview

RLM_SCHEDULE_INTERFACE_HDR_V is a view in the APPS schema belonging to the Release Management (RLM) product within Oracle E-Business Suite. It exposes schedule header records that have not yet been moved into the interface staging area, presenting them in the format expected by the downstream schedule interface. The view is intended to feed interface processing and reporting logic within the Release Management scheduling flow, allowing header-level schedule data to be consumed by EDI or other external integration points before it is formally staged in RLM_INTERFACE_HEADERS. Because it filters on the absence of a corresponding interface header record, the view effectively represents the "pending" schedule headers awaiting interface generation.

Underlying Base Objects

The view is defined primarily over RLM_SCHEDULE_HEADERS, which supplies the core schedule header columns. The WHERE clause uses a NOT EXISTS subquery against RLM_INTERFACE_HEADERS (documented with its _ALL variant; both appear as synonyms in the referenced objects list), ensuring only schedule headers lacking an interface header record are returned. The literal 'SCHEDULE' is projected as ORIGIN_TABLE, and INTERFACE_HEADER_ID is selected from the interface header context. Referenced base objects include RLM_INTERFACE_HEADERS (synonym), RLM_INTERFACE_HEADERS_ALL (synonym), and RLM_SCHEDULE_HEADERS (synonym).

Key Columns

Common Use Cases and Queries

The view is commonly used to identify schedule headers that have not yet been interfaced, to report external address and EDI attributes, and to validate records before interface generation. A typical query lists pending headers with customer and horizon details:

SELECT header_id, customer_id, schedule_type, sched_horizon_start_date, sched_horizon_end_date, schedule_source, schedule_purpose FROM apps.rlm_schedule_interface_hdr_v WHERE process_status = <status> ORDER BY sched_horizon_start_date;

Another common pattern joins the view to external customer attributes for EDI reporting, selecting CUSTOMER_EXT, EDI_CONTROL_NUM_1, and ECE_TP_TRANSLATOR_CODE. Because the view already excludes headers with existing interface records, it supports reconciliation queries that confirm the completeness of schedule interface generation within Release Management.