Search Results kit_name




Overview
Explore in AI Chat

Overview

AST_COLL_REVIEW_KITS_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered under the FND design data path AST.AST_COLL_REVIEW_KITS_V. It belongs to the Oracle Advanced Supply Chain / Enterprise Asset Management family of objects associated with the AST product code and is classified in the ETRM documentation as a "supplementary view used to simplify forms coding." Its purpose is to present a denormalised, forms-friendly result set that joins deliverable kit definitions, kit line items, item master attributes, and on-hand inventory availability. Because it is an internal supplementary view, Oracle explicitly warns that it is for internal use only and that querying or altering its data is not recommended; its definition may change substantially between minor or major releases.

The view is most relevant when users search for the KIT_NAME column, since this is the descriptive identifier that surfaces a kit to application forms and ad hoc reports. In practice, the view exposes the relationship between a deliverable kit and the individual inventory items that comprise it, including whether each item can be fulfilled electronically, can be fulfilled physically, and what chargeback unit of measure applies.

Underlying Base Objects

The ETRM metadata documents four referenced objects:

The view is not referenced by any other database object, confirming its role as a terminal, presentation-layer convenience view rather than a reusable data source within the application schema.

Key Columns

  • DELIVERABLE_KIT_PART_ID (NUMBER) — identifier of the kit part record.
  • DELIVERABLE_KIT_ID (NUMBER) — links each row to its parent deliverable kit.
  • DELIVERABLE_NAME (VARCHAR2 240) — descriptive name of the deliverable.
  • DELIVERABLE_KIT_ITEM_ID (NUMBER) — identifier of the individual kit component line.
  • KIT_NAME (VARCHAR2 240) — the kit's display name, the attribute most commonly searched and reported.
  • QUANTITY (NUMBER) — quantity of the component required per kit.
  • INVENTORY_ITEM (VARCHAR2 40) — concatenated inventory item identifier.
  • CAN_FULFILL_ELECTRONIC_FLAG / CAN_FULFILL_PHYSICAL_FLAG (VARCHAR2) — flags indicating whether the component can be satisfied electronically or physically.
  • CHARGEBACK_UOM (VARCHAR2) — unit of measure for chargeback processing.
  • ORGANIZATION_ID (NUMBER) — inventory organisation context for the component.

Common Use Cases and Queries

Typical scenarios include kit component reporting, availability checks prior to fulfilment, and chargeback analysis by organisation. A representative query listing kit contents follows:

  • SELECT KIT_NAME, DELIVERABLE_NAME, INVENTORY_ITEM, QUANTITY, CHARGEBACK_UOM FROM APPS.AST_COLL_REVIEW_KITS_V WHERE KIT_NAME = :p_kit_name;
  • SELECT KIT_NAME, INVENTORY_ITEM, CAN_FULFILL_ELECTRONIC_FLAG, CAN_FULFILL_PHYSICAL_FLAG FROM APPS.AST_COLL_REVIEW_KITS_V ORDER BY KIT_NAME;

Because the view is documented as internal and unsupported for direct data access, custom code should treat it as read-only and be prepared for structural changes during patching or upgrades.