Search Results current_excess_quantity

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, the view APPS.CSP_EXCESS_LISTS_V belongs to the Spares Management (CSP) product. It presents surplus or excess spare parts identified and tracked within an organization, joining transaction-level excess records to descriptive item, organization, requisition, and inter-org shipping attributes. The view exists primarily to support reporting and integration, providing a denormalized, human-readable projection of data stored in the base table CSP_EXCESS_LISTS. Because it resolves foreign keys into concatenated item numbers, organization names, lookup meanings, and revision values, the view is well suited for operational dashboards, requisition generation, and external system integration that would otherwise require complex multi-table joins.

The ETRM metadata describes the view's status as VALID and its owner as APPS. The search term "intransit_type" is directly relevant: the view exposes the column MIP.INTRANSIT_TYPE sourced from MTL_INTERORG_PARAMETERS, reflecting the in-transit inventory accounting behavior applicable to the shipping organization.

Underlying Base Objects

The view is defined over the following documented base objects (as listed for release 12.2.2): CSP_EXCESS_LISTS (synonym), CSP_SEC_INVENTORIES (synonym), FND_GLOBAL (package), FND_LOOKUPS (view), HR_GENERAL (package), HR_SECURITY (package), MTL_INTERORG_PARAMETERS (synonym), MTL_ITEM_SUB_INVENTORIES (synonym), MTL_SYSTEM_ITEMS_B_KFV (view), ORG_ORGANIZATION_DEFINITIONS (view), PO_REQUISITION_HEADERS_ALL (synonym), and PO_REQUISITION_LINES_ALL (synonym).

• CSP_EXCESS_LISTS — the driving transaction table holding the excess line records, attributes, and quantities.
• MTL_SYSTEM_ITEMS_B_KFV — supplies the concatenated item number (ITEM_NUMBER) and item description, along with primary UOM and UOM code.
• ORG_ORGANIZATION_DEFINITIONS and MTL_ITEM_SUB_INVENTORIES — supply organization name and, in the case of a subinventory-specific record, the max/min quantity.
• PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL — provide the requisition number, revision, need-by date, and deliver-to location.
• CSP_SEC_INVENTORIES — supplies ownership and return organization/subinventory details for the excess stock.
• MTL_INTERORG_PARAMETERS — provides INTRANSIT_TYPE for inter-org shipping.
• FND_LOOKUPS — resolves coded status and condition values into descriptive meanings.
• FND_GLOBAL, HR_GENERAL, HR_SECURITY — support organizational security and access context at runtime.

Key Columns

• EXCESS_LINE_ID — primary identifier for each excess spare-part line.
• ORGANIZATION_ID / ORGANIZATION_NAME — the owning inventory organization.
• EXCESS_STATUS / FL.MEANING — status code and its descriptive lookup meaning.
• SUBINVENTORY_CODE, CONDITION_CODE — stocking location and condition of the excess item.
• INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, ITEM_REVISION — item identity and description.
• PRIMARY_UNIT_OF_MEASURE, PRIMARY_UOM_CODE — unit of measure for quantities.
• EXCESS_QUANTITY, RETURNED_QUANTITY, CURRENT_RETURN_QTY, CURRENT_EXCESS_QUANTITY — quantities tracking original excess, amounts returned, and the computed current excess (EXCESS_QUANTITY minus RETURNED_QUANTITY).
• REQUISITION_HEADER_ID, REQUISITION_NUMBER, REQUISITION_LINE_ID, NEED_BY_DATE, DELIVER_TO_LOCATION_ID — requisition context for the excess part.
• OWNER_RESOURCE_TYPE, OWNER_RESOURCE_ID, RETURN_ORGANIZATION_ID, RETURN_SUBINVENTORY_NAME — ownership and return routing.
• INTRANSIT_TYPE — the inter-org in-transit accounting type from MTL_INTERORG_PARAMETERS.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — flexfield segments for extensible reporting.

Common Use Cases and Queries

Typical scenarios include identifying current excess spare-parts inventory, monitoring quantities returned against excess records, and joining excess parts to their associated requisitions. The INTRANSIT_TYPE column supports analysis of how excess stock moves between organizations.

• List current excess quantities per organization and item.
• Filter excess lines by EXCESS_STATUS meaning or CONDITION_CODE.
• Report requisition-linked excess lines using REQUISITION_NUMBER and NEED_BY_DATE.
• Inspect INTRANSIT_TYPE for inter-org shipping behavior.

Sample query:

• SELECT ORGANIZATION_NAME, ITEM_NUMBER, EXCESS_QUANTITY, CURRENT_EXCESS_QUANTITY, EXCESS_STATUS, INTRANSIT_TYPE FROM APPS.CSP_EXCESS_LISTS_V WHERE ORGANIZATION_ID = :org_id;
• SELECT REQUISITION_NUMBER, ITEM_NUMBER, NEED_BY_DATE FROM APPS.CSP_EXCESS_LISTS_V WHERE EXCESS_STATUS = 'APPROVED';