Results for “product_org_id”

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

Overview

JTF_RS_PRODUCTS_V is an Oracle E-Business Suite view owned by the APPS schema and registered under the JTF – CRM Foundation product family. As documented in the ETRM metadata for Release 12.1.1 and 12.2.2, the view "stores all valid products for which resource skills can be assigned." Its role is therefore to provide a consolidated, query-ready list of service items or products that can be associated with resource skills in Oracle CRM applications such as Oracle Field Service, TeleService, and the Resource Manager.

Functionally, the view acts as a filtered presentation layer over the item master. It restricts the underlying item definitions to those flagged as non-service items, ensuring that only products eligible for skill mapping are exposed. For reporting and integration purposes, JTF_RS_PRODUCTS_V offers a simplified column set (product identifier, organization, concatenated name, description, and enabled status) that insulates downstream queries and interfaces from the complexity of the full item master key flexfield structure. Developers and report authors searching on "product_name" will typically find this column here, presented as the concatenated segment string of the inventory item.

Underlying Base Objects

According to the documented view text, JTF_RS_PRODUCTS_V is defined entirely over a single base object: MTL_SYSTEM_ITEMS_KFV. Within the APPS schema, this base object is referenced as a synonym, which in turn points to the key flexfield view maintained in the Oracle Inventory module.

• MTL_SYSTEM_ITEMS_KFV – the key flexfield view that concatenates the item number segments into a single display value and exposes descriptive attributes of the item.
• Filter condition – rows are included only where NVL(MSIK.SERVICE_ITEM_FLAG, 'N') = 'N', meaning items explicitly flagged as service items are excluded, and items with a null service flag are treated as products.

Because the view joins no additional tables, its performance and freshness depend directly on the underlying item master. No DML is possible against this view; it is read-only by construction.

Key Columns

• PRODUCT_ID – maps to MSIK.INVENTORY_ITEM_ID, the unique identifier of the inventory item used as the product.
• PRODUCT_ORG_ID – maps to MSIK.ORGANIZATION_ID, identifying the inventory organization in which the product is defined.
• PRODUCT_NAME – maps to MSIK.CONCATENATED_SEGMENTS, the concatenated item number string presented to users as the product name.
• DESCRIPTION – maps to MSIK.DESCRIPTION, the descriptive text of the item.
• ENABLED_FLAG – maps to MSIK.ENABLED_FLAG, indicating whether the item is currently active (Y) or disabled (N).

Common Use Cases and Queries

Typical scenarios include validating which products are available for resource skill assignment, populating LOVs in CRM skill setup, and driving reports that resolve a product ID to a readable product name.

• Listing all enabled products for a given organization.
• Resolving an internal PRODUCT_ID to its PRODUCT_NAME for display.
• Filtering skill-related data by product description or name pattern.

Sample SQL:

• SELECT product_id, product_org_id, product_name, description FROM apps.jtf_rs_products_v WHERE enabled_flag = 'Y' ORDER BY product_name;
• SELECT product_id, product_name FROM apps.jtf_rs_products_v WHERE UPPER(product_name) LIKE '%PUMP%';

These queries illustrate the view's principal value: a clean, skill-eligible product list keyed by organization and item, ready for reporting and integration within the CRM Foundation layer.