Results for “bomfv_std_opratn_resources”

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

Overview

BOMFV_STD_OPRATN_RESOURCES is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered under the Bills of Material (BOM) product family. It presents the resource assignments attached to standard operations, joining resource definitions, operation headers, inventory organization parameters, activity codes, and resource rate information into a single denormalized reporting surface. The view is defined WITH READ ONLY, meaning it cannot be used for DML; it exists purely as a query and integration interface.

The view is particularly relevant to users investigating the inverse_rate_or_amount attribute. The base column ORE.USAGE_RATE_OR_AMOUNT_INVERSE is exposed through the alias INVERSE_RATE_OR_AMOUNT, sitting alongside USAGE_RATE_OR_AMOUNT and ASSIGNED_UNITS. This pairing allows reporting on both the direct usage rate and its reciprocal form, which is significant when interpreting resource consumption in either "amount per unit" or "units per amount" terms.

Underlying Base Objects

The view is constructed over six documented base objects, all referenced as synonyms in the APPS schema:

• BOM_STD_OP_RESOURCES (ORE) — The driving table holding resource assignments per standard operation, including the usage and inverse rate columns.
• BOM_RESOURCES (RE) — Provides the resource code via RESOURCE_ID.
• BOM_STANDARD_OPERATIONS (OP) — Supplies the operation code and organization linkage.
• CST_ACTIVITIES (AC) — Supplies the activity name; joined with an outer join (ACTIVITY_ID(+)), so rows without an activity are retained.
• MTL_PARAMETERS (PA) — Provides the inventory organization code.
• HR_ALL_ORGANIZATION_UNITS (AL) — Provides the organization name.

Joins are keyed on RESOURCE_ID, ACTIVITY_ID, STANDARD_OPERATION_ID, and ORGANIZATION_ID. A security predicate, '_SEC:OP.ORGANIZATION_ID' IS NOT NULL, enforces organization-level access control at runtime.

Key Columns

• USAGE_RATE_OR_AMOUNT — The resource usage rate or amount for the operation.
• INVERSE_RATE_OR_AMOUNT — The inverse of the usage rate, exposed from USAGE_RATE_OR_AMOUNT_INVERSE; the column most associated with the "inverse_rate_or_amount" search term.
• ASSIGNED_UNITS — The units associated with the assignment.
• ORGANIZATION_CODE / ORGANIZATION_NAME — The inventory organization identity.
• OPERATION_CODE — The standard operation code.
• RESOURCE_CODE — The resource identifier.
• ACTIVITY — The costing activity name.
• RESOURCE_SEQUENCE_NUMBER, STANDARD_OPERATION_ID, RESOURCE_ID, ACTIVITY_ID — Keys supporting joins and ordering.
• _LA:AUTOCHARGE_TYPE / BASIS_TYPE / SCHEDULE_FLAG / STANDARD_RATE_FLAG — Lookup-encoded attributes resolving via MFG_LOOKUPS.
• UPDATED_ON / UPDATED_BY / CREATED_ON / CREATED_BY — Audit columns.

Common Use Cases and Queries

Typical uses include validating resource rates against standard operations, reconciling inverse rate values, and extracting operation-resource data for costing or integration. A representative query:

SELECT organization_code, operation_code, resource_code, usage_rate_or_amount, inverse_rate_or_amount, assigned_units, activity FROM apps.bomfv_std_opratn_resources WHERE organization_code = :org AND resource_code = :resource ORDER BY operation_code, resource_sequence_number;

Because the view enforces organization security and returns only readable rows, it is well suited for ad hoc reporting, custom concurrent programs, and BI Publisher data sources built on top of standard BOM configuration.