Search Results period_open_flag

Overview

CST_MGD_LIFO_PERIODS_V is an APPS-owned database view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes period-level cost information maintained by the Periodic Average Cost (PAC) and LIFO costing engine. Its purpose is to retrieve period records from the PAC period table while restricting and labeling those records with a user-facing status derived from the open/closed flag. Rather than presenting the raw OPEN_FLAG value, the view joins to MFG_LOOKUPS so that the PERIOD_STATUS column returns a meaningful lookup meaning.

The status restriction is implemented with the lookup type CST_PAC_PERIOD_STATUS and a lookup code computed by DECODE(pp.open_flag,'Y',2,'N',4,3). This maps an open period to lookup code 2, a closed period to lookup code 4, and any other state to lookup code 3. The view therefore acts as a reporting and integration surface for cost periods, supplying both the period status description and the associated cost type, cost group, and legal entity context. It is registered as VALID and is part of the BOM (Bills of Material) product family, where costing periods are consumed.

Underlying Base Objects

The view is defined over a join of six documented objects. Five are accessed through synonyms in the APPS schema: CST_COST_GROUPS, CST_COST_TYPES, CST_PAC_ITEM_COSTS, CST_PAC_PERIODS, and the first-party information view XLE_FIRSTPARTY_INFORMATION_V (referenced through synonym and used to resolve the legal entity). The lookup view MFG_LOOKUPS supplies the translated status meaning. The principal driving table is CST_PAC_PERIODS, which holds period name, open flag, start and end dates, year, period number, cost type, and legal entity. CST_PAC_ITEM_COSTS links periods to cost groups, CST_COST_GROUPS resolves the cost group name and master organization, and CST_COST_TYPES provides the cost type name and description.

The joins are enforced on surrogate keys: PIC.COST_GROUP_ID = CG.COST_GROUP_ID, PP.PAC_PERIOD_ID = PIC.PAC_PERIOD_ID, CT.COST_TYPE_ID = PP.COST_TYPE_ID, and XFI.LEGAL_ENTITY_ID = PP.LEGAL_ENTITY. The DISTINCT keyword suppresses duplicate rows arising from item-cost fan-out.

Key Columns

• PAC_PERIOD_ID — primary surrogate identifier for the PAC period.
• PERIOD_NAME — the accounting/costing period label.
• PERIOD_OPEN_FLAG — the raw open flag (Y/N/other) from the period record.
• PERIOD_STATUS — the lookup meaning resolved via CST_PAC_PERIOD_STATUS, the column users search for against "period_status".
• PERIOD_START_DATE / PERIOD_END_DATE / PERIOD_YEAR / PERIOD_NUM — period temporal boundaries and sequence.
• COST_TYPE_ID, COST_TYPE_NAME, COST_TYPE_DESCRIPTION — the costing method context.
• LEGAL_ENTITY_ID / LEGAL_ENTITY_NAME — the first-party legal entity owning the period.
• COST_GROUP_ID, COST_GROUP_NAME, COST_GROUP_DESCRIPTION, MASTER_ORGANIZATION_ID — cost group identity and its master inventory organization.

Common Use Cases and Queries

Typical use cases include identifying which PAC/LIFO periods are open or closed, reporting cost period calendars by legal entity and cost type, and driving period-close reconciliations. The following retrieves all open periods for a legal entity.

• SELECT period_name, period_status, period_start_date, period_end_date, cost_type_name, legal_entity_name FROM cst_mgd_lifo_periods_v WHERE period_status = 'Open' AND legal_entity_id = :p_legal_entity;
• SELECT cost_group_name, cost_type_name, period_name, period_status FROM cst_mgd_lifo_periods_v WHERE master_organization_id = :p_org ORDER BY period_year, period_num;
• SELECT DISTINCT period_name, period_open_flag, period_status FROM cst_mgd_lifo_periods_v WHERE period_year = :p_year;

Because the view already applies the status lookup restriction, queries filter cleanly on PERIOD_STATUS without re-deriving status from OPEN_FLAG, making it well suited to both concurrent reporting and integration extracts.