Search Results pjmbv_project_mfg_orgs




Overview
Explore in AI Chat

Overview

PJMBV_PROJECT_MFG_ORGS is a read-only APPS view that exposes Project Manufacturing organization setup information in Oracle E-Business Suite 12.1.1 and 12.2.2. The view is owned by the APPS schema and is defined with the WITH READ ONLY clause, meaning it cannot be used as a DML target; it is strictly a query and reporting object. Its primary role is to present the organization-level parameters that govern how Project Manufacturing (PJM) operates within each inventory organization, including project control level, cross-project issue rules, variance accounts, and the expenditure types used when transferring specific cost components.

The view is significant for the user search term erv_expenditure_type because it exposes the column ERV_EXPENDITURE_TYPE, which stores the expenditure type applied when Expense Report Variance (ERV) amounts are transferred to projects. Because this column is surfaced through the view alongside related transfer parameters, it serves as a convenient reporting and integration gateway for project manufacturing setups involving expenditure type mapping.

Underlying Base Objects

The view is defined over a single documented base object: PJM_ORG_PARAMETERS, referenced through a synonym in the APPS schema. The view text aliases this table as POP and selects directly from it:

  • PJM_ORG_PARAMETERS POP — the sole base object, holding all Project Manufacturing organization parameters.
  • Several columns in the SELECT list are accompanied by descriptive flexfield or attribute tokens such as _DF:PJM:PJM_ORG_PARAMETERS:POP and _LA:POP.TRANSFER_ERV:FND_COMMON_LOOKUPS:YES_NO:MEANING. These tokens indicate that the view provides value-set lookup translations and DFF metadata that ETRM uses for display and documentation purposes.

Because the view maps almost one-to-one to PJM_ORG_PARAMETERS, any change to the underlying organization parameters is immediately visible through the view. No joins to other tables are documented in the view text.

Key Columns

The view exposes the following documented columns:

Common Use Cases and Queries

Typical uses include validating the ERV expenditure type configured for an organization, auditing transfer settings across organizations, and integrating project manufacturing parameters into external reporting. The following sample query retrieves the ERV expenditure type and related transfer parameters for a specific organization:

  • SELECT organization_id, erv_expenditure_type, ipv_expenditure_type, freight_expenditure_type, tax_expenditure_type, misc_expenditure_type FROM apps.pjmbv_project_mfg_orgs WHERE organization_id = :org_id;
  • SELECT organization_id, project_control_level, common_project_id, payback_mat_var_account FROM apps.pjmbv_project_mfg_orgs ORDER BY organization_id;

Because the view is read-only, it is safe to query in concurrent programs, BI Publisher reports, and integration extracts without risking data modification.