Search Results csp_subinv_default_use_type

Overview

APPS.CSP_RS_SUBINVENTORIES_V is a reporting and integration view within the Oracle E-Business Suite service (Field Service / depot repair) schema. It presents a consolidated, denormalized picture of subinventory assignments to resources (technicians, groups, or parties) as defined in the CSP inventory location assignment model. In Oracle EBS 12.1.1 and 12.2.2, this view is commonly consumed by Oracle Service, depot repair, and third-party or custom integrations that need to resolve which subinventories are associated with a given resource, along with the default usage semantics of each assignment.

The view joins location assignment rows to secondary inventory setup, inventory organization parameters, JTF resource group translations, and FND lookup meanings. This makes it suitable for both transactional lookups and business-intelligence style reporting without the need to hand-code the multiple outer joins that underpin the CSP assignment schema.

Underlying Base Objects

The documented base objects referenced by the view are: CSP_INV_LOC_ASSIGNMENTS (synonym), CSP_PICK_UTILS (package), CSP_SEC_INVENTORIES (synonym), FND_GLOBAL (package), FND_LOOKUPS (view), JTF_RS_GROUPS_TL (synonym), and MTL_PARAMETERS (synonym). The view is defined with an outer-join pattern (+) that originates from CSP_INV_LOC_ASSIGNMENTS, so a row is returned for each location assignment even when matching secondary inventory, return inventory, resource group translation, or lookup rows are absent.

• CSP_INV_LOC_ASSIGNMENTS supplies the assignment identity, resource identity, organization, subinventory code, locator, default code, and effective dates.
• CSP_SEC_INVENTORIES supplies secondary inventory attributes such as the secondary inventory identifier, condition type, group, owner resource, and return organization/subinventory.
• MTL_PARAMETERS provides organization codes for both the primary and return organizations.
• FND_LOOKUPS resolves lookup meanings for the condition type (CSP_CONDITION_TYPE) and the subinventory default use type (CSP_SUBINV_DEFAULT_USE_TYPE).
• JTF_RS_GROUPS_TL supplies the resource group name in the session language via FND_GLOBAL's userenv('LANG').
• CSP_PICK_UTILS is invoked to translate a resource type/id pair into a display name.

Key Columns

The view exposes assignment, inventory, and lookup-derived attributes. Notable columns include CSP_INV_LOC_ASSIGNMENT_ID as the primary assignment key; RESOURCE_TYPE and RESOURCE_ID identifying the assigned resource; ORGANIZATION_ID and ORGANIZATION_CODE for the owning inventory organization; SUBINVENTORY_CODE; and the CSP_PICK_UTILS.get_object_name derived resource name. Locator and condition information are surfaced through LOCATOR_ID, CONDITION_TYPE, and CONDITION_TYPE_MEANING.

The DEFAULT_CODE column is decoded into a flag column that returns 'Y' or 'N'. Its meaning is resolved from FND_LOOKUPS using the lookup type 'CSP_SUBINV_DEFAULT_USE_TYPE', which directly corresponds to the user's search term csp_subinv_default_use_type. This confirms that the view is the documented access point for interpreting subinventory default-use semantics. Effective dating is provided by EFFECTIVE_DATE_START and EFFECTIVE_DATE_END. An OWNER_FLAG is derived by comparing the assignment's resource against the secondary inventory's owner resource, and the return path is exposed via RETURN_ORGANIZATION_ID, RETURN_ORGANIZATION_CODE, and RETURN_SUBINVENTORY_NAME.

Common Use Cases and Queries

Typical uses include resolving the default use type of a resource's subinventory assignment, listing assignments per organization, and filtering by effective dates or resource groups.

• Reporting subinventory defaults by organization and resource, joining the DEFAULT_CODE_MEANING populated from CSP_SUBINV_DEFAULT_USE_TYPE.
• Reconciling return organization and return subinventory for depot or repair transactions.
• Identifying owned versus non-owned assignments via OWNER_FLAG.
• Feeding downstream integrations that require organization codes and resource names.

Sample query:

SELECT organization_code, subinventory_code, default_code, default_code_meaning, effective_date_start, effective_date_end, owner_flag, group_name FROM apps.csp_rs_subinventories_v WHERE organization_id = :p_org AND (effective_date_end IS NULL OR effective_date_end >= SYSDATE);

Because the view relies on session language and outer joins, queries should constrain by organization or resource to limit cardinality, and must be run with FND_GLOBAL context initialized for accurate lookup meanings and group names.