Results for “designator_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The MRP_SRS_FCST_LOAD_SOURCE_V view is a public Oracle E-Business Suite dictionary object owned by the APPS schema and registered under the MRP (Master Scheduling/MRP) product family. Its documented purpose is to expose the set of "sources for the forecast load process." In practical terms, the view presents a unified, query-friendly list of the selection criteria that the forecast load concurrent program can use to determine which set of forecast data should be loaded into the planning engine.

The view returns one row for each candidate forecast load source, distinguished by a SOURCE_TYPE indicator. Source type 2 represents an individual forecast designator, while source type 5 represents a saved forecast selection list. By normalizing these two independent tables into a single shape, the view gives report authors, integration developers, and concurrent-program logic a single query point rather than requiring them to union the underlying tables themselves.

Because it is a view rather than a table, it carries no storage of its own and always reflects the current state of its base objects. It is commonly consumed by forecast-load reporting, custom extensions, and troubleshooting of forecast load failures, since it shows what the load process can "see" as valid sources at any point in time.

Underlying Base Objects

Per the documented metadata, the view is defined over two synonym-referenced base objects: MRP_FORECAST_DESIGNATORS and MRP_LOAD_SELECTIONS. The view text performs an explicit UNION ALL between the two:

• The first branch selects from MRP_LOAD_SELECTIONS where SELECTION_LIST_TYPE = 2, tagging those rows with SOURCE_TYPE = 5, and using SELECTION_LIST_NAME and DESCRIPTION as the display attributes.
• The second branch selects from MRP_FORECAST_DESIGNATORS, tagging those rows with SOURCE_TYPE = 2, and using FORECAST_DESIGNATOR and DESCRIPTION as the display attributes. This branch is filtered so that only designators whose DISABLE_DATE is null or later than the current date (TRUNC(SYSDATE)) are returned.

Both branches also carry the ORGANIZATION_ID, scoping each source to a specific inventory organization. The result is an organization-aware list of active forecast load sources.

Key Columns

• ORGANIZATION_ID – The inventory organization to which the forecast source belongs; primary scoping key for any query.
• SOURCE_TYPE – Numeric discriminator identifying the origin of the row: 2 = forecast designator, 5 = load selection list.
• NAME – The display name of the source, populated from SELECTION_LIST_NAME (type 5) or FORECAST_DESIGNATOR (type 2).
• DESCRIPTION – Descriptive text for the source, sourced from the corresponding base record.
• DESIGNATOR_TYPE – The column you searched for; exposed here as a positional attribute (documented in the view definition as a NULL placeholder in the current text) representing the designator categorization associated with the forecast source.

Common Use Cases and Queries

Typical uses include validating available forecast load sources before submission, building LOVs for custom forecast-load pages, and diagnosing why a forecast load did not recognize an expected designator. The following sample lists all active sources for an organization:

SELECT organization_id, source_type, name, description, designator_type FROM apps.mrp_srs_fcst_load_source_v WHERE organization_id = :p_org_id ORDER BY source_type, name;

To isolate only forecast designators (type 2) or only selection lists (type 5), filter on SOURCE_TYPE. Note that the designator branch already suppresses disabled designators, so no additional disable-date predicate is required when querying the view.