Search Results install_to_party_id




Overview
Explore in AI Chat

Overview

The CSI_CP_FORM_ADDRESS_V view is a backward-compatibility object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the CSI – Install Base product and is described in ETRM documentation as "Backward Compatible: Customer Product Form Addresses." Its function is to flatten the complex relationship between customer product instances and their associated party, account, and address information into a single queryable structure suitable for forms-based user interfaces and reporting. This view is particularly relevant to users searching for ship_to_party_id, since it exposes both SHIP_TO_PARTY_ID and INSTALL_TO_PARTY_ID columns that resolve each customer product instance to the correct trading party and address context.

Because it consolidates data from the Install Base and the Oracle Receivables/HZ party model, the view is commonly used by subledger integrations, service and order management extensions, and post-installation upgrades that must map legacy customer product records to current party and site definitions.

Underlying Base Objects

Per the documented metadata, CSI_CP_FORM_ADDRESS_V is defined over the following base objects (all exposed as synonyms): CSI_INSTALL_PARAMETERS, CSI_IPA_RELATION_TYPES, CSI_IP_ACCOUNTS, CSI_ITEM_INSTANCES, CSI_I_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, and HZ_PARTY_SITES.

The core install base data comes from CSI_ITEM_INSTANCES (CII) and CSI_I_PARTIES (CIP), which carry the instance identifier (CUSTOMER_PRODUCT_ID) and object version numbers. Instance/account relationships are resolved through CSI_IP_ACCOUNTS (CIA), while CSI_IPA_RELATION_TYPES and CSI_INSTALL_PARAMETERS support the form's relationship and parameter logic. Address and party details are gathered from the HZ tables: HZ_PARTY_SITES, HZ_PARTIES, and HZ_LOCATIONS supply names, party types, and address components, while HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL link party sites to customer accounts and site purposes such as ship-to and bill-to.

Key Columns

Common Use Cases and Queries

Typical usage involves retrieving the ship-to party and address for an installed product instance, or joining the view to order, service, or contract data. A representative query is:

  • SELECT customer_product_id, ship_to_party_id, ship_to_party_name, ship_to_address1, ship_to_city FROM csi_cp_form_address_v WHERE ship_to_party_id = :party_id;
  • SELECT customer_product_id, install_to_party_id, install_to_location_id FROM csi_cp_form_address_v WHERE customer_product_id = :instance_id;

These queries are useful for validating party/site assignments, driving address selection at order entry, reconciling legacy install base records during upgrades, and building reports that require both ship-to and install-to details for installed products.