Search Results held_bill_expiration_date




Overview
Explore in AI Chat

Overview

The AST_BILLING_PREFERENCES_V view is a TeleSales (AST) product database object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to retrieve the billing preferences associated with a customer account. The view consolidates billing configuration data—such as billing language, currency, media format, number of invoice copies, and hold flags—into a single denormalized result set that reporting and integration layers can consume without joining multiple base objects themselves.

Because AST (TeleSales) shares the customer model with the Oracle Receivables and Trading Community Architecture (TCA) foundations, this view is relevant whenever a customer account's preferred invoicing attributes must be surfaced. The ETRM metadata records the view with a status of VALID under the APPS schema, confirming it is a supported, queryable object rather than an obsolete or invalidated artifact.

Underlying Base Objects

The view text joins the billing preferences table against several reference and lookup objects. The documented base objects are:

The joins to FND_LANGUAGES_VL and FND_CURRENCIES_VL are outer joins (+), which means billing preference rows survive even when a language or currency code has no matching reference entry. The join to HZ_CUST_ACCOUNTS is an inner join, so only preferences tied to a valid customer account are returned. This design makes the view safe for reporting but means orphaned preference rows will be excluded.

Key Columns

The view exposes the following significant columns:

Common Use Cases and Queries

Typical scenarios include reconciling billing preferences across customer accounts, auditing hold flags, reviewing media format mix, and feeding downstream invoicing integrations. A representative query retrieving active preferences with resolved language and currency names follows:

SELECT cust_account_id,
       site_use_id,
       billing_preferences_id,
       bill_language,
       language_description,
       currency_code,
       currency_name,
       bill_type,
       media_format,
       number_of_copies,
       hold_bill_flag,
       held_bill_expiration_date
FROM   apps.ast_billing_preferences_v
WHERE  cust_account_id = :p_cust_account_id;

Because the view performs the reference lookups, callers need only filter by account or site, avoiding direct joins to HZ_BILLING_PREFERENCES and the FND reference views. It is suitable for both ad hoc reporting and programmatic integration where a flattened, presentation-ready projection of billing preferences is required.