Search Results ast_installed_base_v

Overview

AST_INSTALLED_BASE_V is a TeleSales (AST) reporting view that presents the installed base of customer products — the record of items and systems a customer owns, with their serial numbers, installation dates, active status, and the originating sales order data. In Oracle EBS 12.1.1 and 12.2.2, this view is the primary read-only interface through which TeleSales, Service, and custom reporting components retrieve installed-base information without directly joining the customer products, order management, and trading community tables. It exposes both the current inventory definition of the installed item and the historical commercial context that created it.

The view is documented in ETRM as not implemented in the source database used for documentation, meaning the view text exists but the object is not deployed in that environment. This is a common condition for seeded or site-specific views distributed with the application; the definition remains authoritative for environments where the view is created.

Underlying Base Objects

The view is defined across eight base objects using outer joins to preserve installed-base rows that lack a complete order or lookup context:

• CS_CUSTOMER_PRODUCTS_ALL — the driving table, aliased CP, supplying product, serial, system, and status identifiers.
• HZ_CUST_ACCOUNTS and HZ_PARTIES — joined on CUSTOMER_ID and PARTY_ID to return the account number and party name.
• CS_CUSTOMER_PRODUCT_STATUSES — joined on CUSTOMER_PRODUCT_STATUS_ID to supply status name, cancelled flag, and terminated flag.
• OE_ORDER_LINES_ALL and OE_ORDER_HEADERS_ALL — outer-joined through ORIGINAL_ORDER_LINE_ID and HEADER_ID to provide the original order date, number, purchase order number, and line number.
• CS_SYSTEMS — outer-joined on SYSTEM_ID for the system name.
• CS_LOOKUPS — outer-joined on TYPE_CODE with LOOKUP_TYPE of 'CUSTOMER_PRODUCT_TYPE' to render the product type meaning.

Key Columns

• CUSTOMER_PRODUCT_ID — primary identifier of the installed base record.
• CUSTOMER_ID / ACCOUNT_NUMBER / CUSTOMER_NAME — the owning customer account and party.
• INVENTORY_ITEM_ID — the installed item.
• CURRENT_SERIAL_NUMBER, CP_LOT_NUMBER, REFERENCE_NUMBER — traceability attributes of the physical unit.
• ORIGINAL_ORDER_LINE_ID — the sought column; the foreign key to the order line that first created the installed base row.
• ORIGINAL_ORDER_NUMBER, ORIGINAL_ORDER_DATE, ORIGINAL_ORDER_LINE_NUMBER, ORIGINAL_LINK_TO_ORDER_LINE_ID, PURCHASE_ORDER_NUM — the full commercial origin of the installed item.
• INSTALLATION_DATE, SHIPPED_DATE, START_DATE_ACTIVE, END_DATE_ACTIVE — lifecycle dates.
• CP_STATUS, CANCELLED_FLAG, TERMINATED_FLAG — current state of the installed base record.
• SYSTEM, CP_TYPE, ORG_ID, SPLIT_FLAG — system membership, product type meaning, operating unit, and split indicator.

Common Use Cases and Queries

Typical uses include locating the sales order that generated an installed base record, reconciling installed base against order history, and reporting serialised units by customer or system.

To trace an installed base row back to its originating order line:

SELECT ib.customer_product_id, ib.current_serial_number, ib.original_order_line_id, ib.original_order_number, ib.original_order_line_number, ib.original_order_date FROM ast_installed_base_v ib WHERE ib.customer_id = :p_customer_id;

To list installed items for a given serial number with customer detail:

SELECT ib.account_number, ib.customer_name, ib.current_serial_number, ib.cp_status, ib.installation_date FROM ast_installed_base_v ib WHERE ib.current_serial_number = :p_serial;

Because ORIGINAL_ORDER_LINE_ID is outer-joined to OE_ORDER_LINES_ALL, records with no originating order return null order columns; queries expecting order data should filter on original_order_line_id IS NOT NULL.