Results for “aso_i_agreements_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO_I_AGREEMENTS_V is a public, valid view owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the ASO (Order Capture) product family and is catalogued under the description "Customer Agreements." The view presents a narrow, integration-oriented projection of customer agreement header data: the agreement identifiers, descriptive attributes, the sold-to organization, and the pricing and rule references associated with the agreement. Its name prefix ("I") indicates that it is intended primarily for inbound or interface-style access, and its column set is deliberately restricted to the fields most commonly needed when other modules or external systems must resolve an agreement and its associated pricing list, invoicing rule, and accounting rule.

Because the view filters nothing and applies no transformations beyond a simple column projection, it behaves as a stable, read-only facade over the underlying agreements entity. This makes it suitable for concurrent programs, PL/SQL packages, and reporting tools that require a low-risk read path to agreement data without depending on the full column set of the base agreements object.

Underlying Base Objects

The documented ETRM metadata records a single referenced base object: OE_AGREEMENTS_VL, which is itself a view in the same APPS schema. ASO_I_AGREEMENTS_V is therefore defined as a direct SELECT from OE_AGREEMENTS_VL, with no joins, unions, or aggregations introduced at this layer. The "_VL" suffix on the base object denotes a translated (multi-language) view, meaning the NAME column exposed through ASO_I_AGREEMENTS_V resolves to the language-appropriate value for the session's language setting.

Consequently, all filtering, security, and multi-organization behavior inherited by this view originates in OE_AGREEMENTS_VL and its own underlying agreement tables. Report authors should be aware that the view adds no additional row-level restrictions; any access control applied elsewhere in the agreements stack is either inherited or must be applied by the consuming query.

Key Columns

• AGREEMENT_ID — The primary key of the agreement record. Used to join to agreement lines, price list lines, and other agreement-related entities.
• NAME — The descriptive name of the customer agreement, sourced from the translated base view.
• AGREEMENT_NUM — The user-visible agreement number assigned during agreement creation.
• SOLD_TO_ORG_ID — The identifier of the customer organization the agreement applies to. This is the primary filter used when resolving agreements for a specific customer.
• PRICE_LIST_ID — The price list associated with the agreement, used to drive pricing during order capture.
• INVOICING_RULE_ID — The invoicing rule reference attached to the agreement. This column is the direct answer to searches on "invoicing_rule_id" and links the agreement to the receivables invoicing rule that governs how invoices are generated and dated for transactions under the agreement.
• ACCOUNTING_RULE_ID — The accounting rule reference, which governs revenue recognition and the creation of accounting entries for the agreement.

Common Use Cases and Queries

The view is typically used to resolve the pricing, invoicing, and accounting defaults that apply to a customer before an order is entered, or to validate that those rule references have been maintained.

• Retrieve the invoicing rule for a given agreement:

  SELECT agreement_id, agreement_num, name, invoicing_rule_id
  FROM   aso_i_agreements_v
  WHERE  agreement_id = :p_agreement_id;

• List all agreements for a customer, with their pricing and rules:

  SELECT agreement_num, name, price_list_id,
         invoicing_rule_id, accounting_rule_id
  FROM   aso_i_agreements_v
  WHERE  sold_to_org_id = :p_sold_to_org_id;

• Identify agreements missing a rule, for data-cleansing reports:

  SELECT agreement_num, name
  FROM   aso_i_agreements_v
  WHERE  invoicing_rule_id IS NULL
  OR     accounting_rule_id IS NULL;

• Join to agreement lines to report which line items fall under agreements carrying a specific invoicing rule.

All queries should qualify the view with APPS or use a synonym, and results remain subject to the language and security behavior inherited from OE_AGREEMENTS_VL.