Results for “user_defined_rate”

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

Overview

EAM_ASSET_METERS_V is a public Oracle E-Business Suite view owned by the APPS schema and classified as VALID in the Enterprise Asset Management (EAM) product family. Its documented purpose is to present all information about a meter that is associated with an asset. In practice, the view flattens the relationship between a counter (meter) definition and a specific asset instance into a single denormalized row, exposing operational attributes such as reading type, unit of measure, direction of value change, scheduling usage, effective dates, and descriptive flexfield segments. This makes the view well suited to reporting, discovery, and integration scenarios where an external system or a custom concurrent program needs a stable, readable projection of asset-to-meter assignments without joining the underlying CSI and MTL tables directly.

Underlying Base Objects

The view is defined over a mix of EAM and Inventory synonyms: CSI_COUNTERS_B and CSI_COUNTERS_TL (counter definition and its translated name/description), CSI_COUNTER_ASSOCIATIONS (the link between an asset instance and a counter), CSI_COUNTER_RELATIONSHIPS, CSI_COUNTER_TEMPLATE_B and CSI_COUNTER_TEMPLATE_TL, CSI_CTR_ITEM_ASSOCIATIONS, CSI_ITEM_INSTANCES (the asset instance itself), MTL_PARAMETERS (organization/inventory parameters), and MTL_SYSTEM_ITEMS_B_KFV (the concatenated key flexfield view for item segments). The dominant driving table is CSI_COUNTER_ASSOCIATIONS (aliased CCA), which supplies the association identifier, primary failure flag, source object identifier, maintenance organization, audit columns, and the ATTRIBUTE1 through ATTRIBUTE15 flexfield columns. CII.LAST_VLD_ORGANIZATION_ID supplies ORGANIZATION_ID, while MP.ORGANIZATION_CODE and MSIK.CONCATENATED_SEGMENTS provide human-readable context.

Key Columns

IDENTIFIER columns include ASSOCIATION_ID (from CCA.INSTANCE_ASSOCIATION_ID), METER_ID (CCA.COUNTER_ID), ASSET_GROUP_ID (CII.INVENTORY_ITEM_ID), ASSET_NUMBER (CII.INSTANCE_NUMBER), and MAINTENANCE_OBJECT_ID (CCA.SOURCE_OBJECT_ID). Descriptive columns include METER_NAME and DESCRIPTION from CCT, ASSET_GROUP from the KFF-concatenated segments, ASSET_DESCRIPTION, ORGANIZATION_CODE, and SOURCE_METER_NAME. Behavioral attributes include METER_TYPE (READING_TYPE), METER_UOM, VALUE_CHANGE_DIR, EAM_REQUIRED_FLAG, PRIMARY_FAILURE_FLAG, USED_IN_SCHEDULING, USER_DEFINED_RATE, USE_PAST_READING, INITIAL_READING, INITIAL_READING_DATE, and the FROM/TO_EFFECTIVE_DATE pair. Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and ATTRIBUTE1–15 are carried through from CCA.

Regarding the user's search term, CREATION_ORGANIZATION_ID is present in the view text as a literal expression, TO_NUMBER(NULL) CREATION_ORGANIZATION_ID. It is therefore a placeholder column that is always NULL, not a populated value sourced from an underlying table. Queries filtering or grouping on CREATION_ORGANIZATION_ID will return no meaningful results; ORGANIZATION_ID and MAINT_ORGANIZATION_ID should be used instead. Similarly, TMPL_FLAG is a constant 'N' and MAINTENANCE_OBJECT_TYPE is a constant 3.

Common Use Cases and Queries

Typical uses include asset meter listings for maintenance workbenches, feeding meter readings into condition-based maintenance, and integration extracts that synchronize EAM meters with external asset registries. A basic listing of active meters for an organization:

• SELECT association_id, asset_number, asset_description, meter_name, meter_type, meter_uom, value_change_dir FROM eam_asset_meters_v WHERE organization_code = :org AND eam_required_flag = 'Y';
• SELECT meter_id, COUNT(*) asset_count FROM eam_asset_meters_v GROUP BY meter_id ORDER BY asset_count DESC;
• SELECT asset_number, meter_name, from_effective_date, to_effective_date FROM eam_asset_meters_v WHERE SYSDATE BETWEEN from_effective_date AND NVL(to_effective_date, SYSDATE + 1);
• SELECT association_id, attribute1, attribute2 FROM eam_asset_meters_v WHERE attribute_category = :cat;

Because the view is a read-only projection, it should not be used for DML; inserts and updates belong to CSI_COUNTER_ASSOCIATIONS and CSI_COUNTERS_B.