Search Results plc_closed




Overview
Explore in AI Chat

Overview

APPS.POR_HEADER_V is a reporting and integration view in Oracle E-Business Suite 12.1.1 and 12.2.2 that presents purchase requisition header information in a denormalized, display-ready format. It is the header-level counterpart to requisition line views in the Oracle Procurement (POR) module and is widely referenced by Oracle Purchasing, iProcurement, and custom extensions that require requisition data without joining the underlying transactional tables manually.

Rather than exposing raw lookup codes, the view resolves code values into their human-readable descriptions through the PO_LOOKUP_CODES view. Authorization status, document state (including the closed_code column surfaced as PLC_CLOSED), cancellation flag, and requisition type are all translated into displayed_field values. The view also joins HR_EMPLOYEES to return the preparer's full name and AP_CARDS to return procurement card details where a pcard_id is present. This makes the view suitable for direct use in concurrent programs, OAF pages, BI Publisher reports, and inbound/outbound interfaces without additional lookup decoding.

The search term "plc_closed" originates in the view definition, where the alias plc_closed is one of four instances of PO_LOOKUP_CODES. It is joined on lookup_type = 'DOCUMENT STATE' and lookup_code = NVL(prh.closed_code,'OPEN'), and its displayed_field value is projected as a column in the select list.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

  • PO_REQUISITION_HEADERS (SYNONYM) — primary driving table, aliased prh; supplies segment1, type_lookup_code, authorization_status, closed_code, cancel_flag, org_id, and the attribute columns.
  • PO_REQUISITION_LINES (SYNONYM) — aliased prl, outer-joined on requisition_header_id; supplies urgent_flag and note_to_agent.
  • HR_EMPLOYEES (VIEW) — aliased hre, joined on preparer_id = employee_id; supplies full_name.
  • AP_CARDS (SYNONYM) — aliased apc, outer-joined on card_id = pcard_id; supplies card_number and description.
  • PO_LOOKUP_CODES (VIEW) — instantiated four times as plc_auth, plc_closed, plc_cancel, and plc_doctype to decode authorization status, document state, cancel flag, and requisition type respectively.
  • FND_PROFILE (PACKAGE) — fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK') controls the session date mask used for creation_date.
  • FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY (PACKAGES) — invoked indirectly through the HR_EMPLOYEES view to enforce organizational and person security.

Key Columns

  • requisition_header_id / segment1 — primary key and the user-visible requisition number.
  • preparer_id / full_name — the employee who prepared the requisition and the corresponding display name.
  • type_lookup_code / displayed_field — the requisition type code and its decoded description (for example, Purchase or Internal).
  • authorization_status / plc_auth.displayed_field — approval state; NVL defaults to 'INCOMPLETE' when null.
  • closed_code / plc_closed.displayed_field — document state; NVL defaults to 'OPEN', so the view always returns a closed status description.
  • cancel_flag / plc_cancel.displayed_field — 'Y'/'N' flag decoded against lookup_type 'YES/NO', defaulting to 'N'.
  • org_id — operating unit, essential for multi-org filtering.
  • pcard_id, card_number, description — procurement card linkage when the requisition is pcard-funded.
  • attribute1 through attribute15 — DFF columns passed through unchanged.
  • to_char(last_update_date) and to_char(creation_date) — formatted audit timestamps.

Common Use Cases and Queries

Typical uses include requisition status dashboards, closed-requisition reporting, iProcurement self-service extensions, and data extracts for downstream systems. Because the view applies HR security through HR_EMPLOYEES, results are constrained by the runtime security profile.

List open requisitions in a given operating unit:

  • SELECT segment1, full_name, type_lookup_code, authorization_status, closed_code FROM apps.por_header_v WHERE org_id = :p_org_id AND closed_code = 'OPEN';

Find requisitions converted to a fully closed state, which is the intent of a "plc_closed" search:

  • SELECT segment1, full_name, closed_code FROM apps.por_header_v WHERE closed_code = 'CLOSED';

Report procurement-card requisitions with card details:

  • SELECT segment1, card_number, description, authorization_status FROM apps.por_header_v WHERE pcard_id IS NOT NULL;

Because PO_REQUISITION_LINES is outer-joined at header level, a header with multiple lines will return duplicate header rows; queries should apply DISTINCT or aggregate on requisition_header_id where header-level uniqueness is required.