Search Results std_terms

Overview

APPS.AST_CUST_PROFILE_CREDIT_V is a credit-management reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It consolidates customer profile credit attributes from Oracle Receivables and Oracle Trading Community Architecture (TCA) into a single denormalized row per customer account profile. Its defining characteristic is the join between the customer profile record and its associated payment terms, exposure terms, and lookup-driven indicators, exposing both coded values and their translated meanings.

The view is particularly significant for users searching on std_terms, since it surfaces the profile-level standard terms identifier together with the resolved term name from RA_TERMS. This allows reporting on credit terms without requiring a separate join to the terms tables. The view is typically consumed by credit management dashboards, order management credit checking reports, and integration extracts that need a flattened credit profile record.

Underlying Base Objects

The view is defined over the following documented base objects:

• HZ_CUSTOMER_PROFILES (synonym) — the driving table, supplying risk code, credit rating, profile class, tolerance, clearing days, standard terms, collector, credit analyst, and the descriptive flexfield attribute columns.
• HZ_CUST_ACCOUNTS (synonym) — supplies write-off amounts, payment term, deposit refund method, and credit classification code.
• RA_TERMS (synonym) — aliased as std_terms; joined to the profile's standard terms. The join is outer (+) with a date-range predicate restricting to the currently effective term version.
• RA_TERMS_VL (view) — aliased as pay_terms; provides the translated name of the account-level payment term. Joined outer.
• AR_COLLECTORS (synonym) — aliased as c; provides the collector name, restricted to active collectors (status = 'A'). This is an inner join.
• FND_LOOKUPS (view) — aliased four times (lk1–lk4) to resolve meaning values for override terms, discount terms, and two further lookup-coded profile indicators.

FND_GLOBAL is referenced as a package, consistent with standard EBS views that apply organizational or user context in their definitions.

Key Columns

• cust_account_profile_id, cust_account_id, site_use_id — primary and foreign keys identifying the profile, the customer account, and the site-level context.
• risk_code, credit_rating, profile_class_id, status — core credit scoring and classification attributes.
• standard_terms — the profile-level term identifier; std_terms.name returns the effective term name from RA_TERMS.
• payment_term_id and pay_terms.name — the account-level payment term and its translated name from RA_TERMS_VL.
• restriction_limit_amount, tolerance, clearing_days — exposure and credit-checking parameters.
• credit_analyst_id, collector_id, c.name — ownership and assignment of the credit relationship.
• write_off_payment_amount, write_off_amount, deposit_refund_method, credit_classification_code — account-level financial attributes sourced from HZ_CUST_ACCOUNTS.
• lk1.meaning through lk4.meaning — decoded YES_NO and related lookup meanings for profile flags.
• attribute1 through attribute15, attribute_category — descriptive flexfield columns for customer-specific extensions.
• Audit columns — creation_date, created_by, last_update_date, last_updated_by, last_update_login.

Common Use Cases and Queries

Typical scenarios include generating credit exposure listings, reconciling profile terms against account terms, and feeding data warehouses with customer credit master data.

List active profiles with their standard and account terms:

• SELECT cust_account_id, risk_code, credit_rating, standard_terms, std_terms.name AS std_term_name, pay_terms.name AS pay_term_name FROM apps.ast_cust_profile_credit_v WHERE status = 'A';

Identify profiles whose standard terms differ from the account payment term:

• SELECT cust_account_id, standard_terms, payment_term_id FROM apps.ast_cust_profile_credit_v WHERE NVL(standard_terms,0) <> NVL(payment_term_id,0);

Retrieve profiles approaching credit review:

• SELECT cust_account_id, risk_code, next_credit_review_date, restriction_limit_amount, tolerance FROM apps.ast_cust_profile_credit_v WHERE next_credit_review_date <= SYSDATE + 30 ORDER BY next_credit_review_date;

Because the view joins HZ_CUST_ACCOUNTS and HZ_CUSTOMER_PROFILES, queries run with the privileges of the APPS schema and should be accessed via a synonym or a secured custom view rather than by direct grants to HZ tables.