Results for “minimum_transfer_quantity”

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

Overview

BOMFV_STANDARD_RTG_OPERATIONS is an APPS-owned, read-only view in the Oracle E-Business Suite Bills of Material (BOM) module. It presents standard routing operations defined at the organization level, combining operation attributes with department and organization descriptive information. The view is documented as "Retrofitted," indicating it was ported forward to support Oracle EBS 12.1.1 and 12.2.2 functionality while preserving a stable interface for reporting and integration consumers.

A defining characteristic is the filter condition OP.LINE_ID IS NULL, which restricts output to header-level standard operations rather than operation-line assignments. A second predicate, '_SEC:OP.ORGANIZATION_ID' IS NOT NULL, enforces operating-unit (organization) security, so a query returns only operations for organizations to which the executing user has access. The view is declared WITH READ ONLY, preventing DML through the view.

The view is significant for users searching on minimum_transfer_quantity: that attribute is exposed directly as the MINIMUM_TRANSFER_QUANTITY column, allowing operational minimums to be reported alongside operation code, department, and organization context.

Underlying Base Objects

The view is defined over four referenced objects, all accessed through APPS synonyms:

• BOM_STANDARD_OPERATIONS (alias OP) — the primary driver, supplying operation code, description, minimum transfer quantity, count point, backflush and option-dependent flags, standard operation ID, department and organization identifiers, and audit columns.
• BOM_DEPARTMENTS (alias DE) — joined on DEPARTMENT_ID to supply the department code.
• MTL_PARAMETERS (alias PA) — joined on ORGANIZATION_ID to supply the organization code.
• HR_ALL_ORGANIZATION_UNITS (alias AL) — joined on ORGANIZATION_ID to supply the organization name.

All joins are inner joins on ORGANIZATION_ID and DEPARTMENT_ID, so an operation appears only when matching organization and department records exist.

Key Columns

• OPERATION_CODE, DESCRIPTION — Identifier and description of the standard operation.
• MINIMUM_TRANSFER_QUANTITY — The minimum quantity that may be transferred between operations; the attribute at the center of user searches on this view.
• ORGANIZATION_CODE, ORGANIZATION_NAME, ORGANIZATION_ID — Organizational context from MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS.
• DEPARTMENT_CODE, DEPARTMENT_ID — Owning department of the operation.
• STANDARD_OPERATION_ID — Primary key reference to the underlying standard operation.
• COUNT_POINT_TYPE, BACKFLUSH_FLAG, OPTION_DEPENDENT_FLAG — Exposed through lookup-translation aliases (_LA:) resolving MFG_LOOKUPS meanings for BOM_COUNT_POINT_TYPE and SYS_YES_NO.
• UPDATED_ON, UPDATED_BY, CREATED_ON, CREATED_BY — Audit columns mapped from LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY.

Common Use Cases and Queries

Typical uses include routing operation reports, organization-level operation comparisons, and integrations requiring minimum transfer quantity values by department.

Listing operations for a restricted set of organizations:

• SELECT operation_code, organization_code, department_code, minimum_transfer_quantity FROM apps.bomfv_standard_rtg_operations WHERE organization_code = :org;

Identifying operations with a defined transfer minimum:

• SELECT operation_code, description, minimum_transfer_quantity FROM apps.bomfv_standard_rtg_operations WHERE minimum_transfer_quantity IS NOT NULL ORDER BY organization_code, operation_code;

Joining to BOM_OPERATION_SEQUENCES or routing data via STANDARD_OPERATION_ID supports routing analysis and audit reporting on recent changes using UPDATED_ON.