Search Results i_rates_cost_type_id

Overview

PROJECT_MFG is a material and manufacturing costing utility package owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its documented purpose is to resolve the expenditure type associated with the material sub-element of a manufactured or purchased item, given an item, a cost type, and a manufacturing organization. The package header carries the internal version tag CSTPJCMB.pls 115.3 dated 2002/11/11, indicating a long-standing component of the Cost Management (CST) product family that has remained stable across releases. Functionally, PROJECT_MFG acts as a bridge between project costing and manufacturing costing: it inspects the costed resources on an item and returns the expenditure type code that downstream Oracle Projects and Cost Management processes use to classify material transactions. The package is registered in the ETRM registry with an API classification of OTHER, meaning it is not a formally published open interface but an internal helper that may be referenced by other cost packages.

Key Procedures and Functions

A single documented function is exposed by this package body:

• MATL_SUBELEMENT — Returns a VARCHAR2 expenditure type value for the material cost sub-element. It accepts an item identifier, a rates cost type identifier, and an organization identifier. The function first attempts to derive the expenditure type by joining costed item cost details to BOM resources, restricted to the material cost element and the specified organization. If no row is found, it falls back to the organization's default material cost resource as defined in MTL_PARAMETERS. If that also fails, the literal 'NO Val' is returned; an unexpected error returns '-999'. Parameter lists are not reproduced here because the documentation should not invent or restate them beyond the documented interface.

Tables Accessed

The function reads three tables through APPS synonyms, all in read-only mode:

• CST_ITEM_COST_DETAILS — The primary cost source. It supplies the costed resource identifiers for the item and cost type, filtered to the material cost element (cost_element_id = 1).
• BOM_RESOURCES — Provides the expenditure type attribute of the resource, and also serves as the lookup for the organization's default material cost resource.
• MTL_PARAMETERS — Supplies the organization-level default material cost identifier used in the fallback path when no costed material resource is found.

Usage Notes

PROJECT_MFG is invoked internally by other cost and project manufacturing packages rather than from a standard concurrent program or form. The ETRM registry records it as referenced by one other package, consistent with its role as a shared helper. Typical invocation contexts include:

• Cost rollup and cost update routines that need to classify a material sub-element for project-related expenditure.
• Project manufacturing transaction processing where material costs must be mapped to a valid expenditure type before being charged to a project or task.
• Custom cost extensions that require the same resource-to-expenditure-type resolution logic used by standard Oracle costing.

Because the function performs NVL and ROWNUM-based lookups and returns sentinel values rather than raising exceptions, callers should test for 'NO Val' and '-999' explicitly. No user-facing navigation exists; access is through supported APIs or custom PL/SQL in the APPS schema. The user search reference to "PREMIUM POWER MFG CO" is unrelated to the package definition and does not appear in the documented metadata.